Question about budgeting accounting

Joined
Apr 25, 2020
Messages
4
Reaction score
0
Country
Hong Kong
A Company supplies chemicals to industry. Data regarding the store's operations follow:

- Sales are budgeted at $330,000 for November, $300,000 for December, and
$320,000 for January.
- Collections are expected to be 85% in the month of sale, 14% in the month
following the sale, and 1% uncollectible.
- The cost of goods sold is 60% of sales.
- The company purchases 80% of its merchandise in the month prior to the month
of sale and 20% in the month of sale. Payment for merchandise is made in the
month following the purchase.
- Other monthly expenses to be paid in cash are $21,200.
- Monthly depreciation is $21,000.
- Ignore taxes.

balance sheet.PNG


Required:

a. Prepare a Schedule of Expected Cash Collections for November and December.
b. Prepare a Merchandise Purchases Budget for November and December.
c. Prepare Cash Budgets for November and December.
d. Prepare Budgeted Income Statements for November and December.
e. Prepare a Budgeted Balance Sheet for the end of December.

Answer:

answer.PNG


My question is: In part C, do I not need to add back the beginning cash balance of Oct cash $22,000 to November? the answer hasn't included the beginning cash balance. if yes then the ending cash balance of November should be $22,000 + $146,300 = 168,300

Thanks a lot!
 

kirby

VIP Member
Joined
May 12, 2011
Messages
2,460
Reaction score
334
Country
United States
Adding the beginning cash is needed if you really want the correct amount of excess of cash AVAILABLE over disbursements. If the title was excess of cash COLLECTED then you would exclude the $22,000.
 
Joined
Apr 25, 2020
Messages
4
Reaction score
0
Country
Hong Kong
Adding the beginning cash is needed if you really want the correct amount of excess of cash AVAILABLE over disbursements. If the title was excess of cash COLLECTED then you would exclude the $22,000.
Hi Kirby,

Thanks a lot for your quick reply! the question asked "Prepare Cash Budgets for November and December" so I think i should include the $22,000 cash from October to be the "ending cash balance right?
 

kirby

VIP Member
Joined
May 12, 2011
Messages
2,460
Reaction score
334
Country
United States
Yes. In particular, the answer uses the term "Excess of cash available" and available cash would include the $22,000 unless it magically disappeared! But note that textbooks sometimes contain uncorrected errors which some teachers follow without question.
 
Last edited:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Members online

No members online now.

Forum statistics

Threads
11,782
Messages
27,851
Members
21,793
Latest member
nextgenaccountant

Latest Threads

Top