Explore BrainMass
Share

Cash Budgeting

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Medical Supplies, Inc., purchases first-aid items from large wholesalers. Medical Supplies
then assembles and sells first-aid kits to businesses and contracts to maintain the first-aid
kits. You have been asked to prepare a cash budget for January. The following information
is provided:
a. Cash in the bank on January 1 is $33,000.
b. Actual sales for October, November, December, and projected sales for January are as
follows:
1054 Part 6 E O C Planning
Exercise 19-13
Exercise 19-14
October November December January
Cash . . . . . . . . . . . . . . . . . . . . . $12,000 $11,500 $ 8,200 $12,500
Credit . . . . . . . . . . . . . . . . . . . . 31,000 29,400 32,000 28,000
Payments on credit sales are received 50% in the month of sale, 31% in the month following
the sale, and 15% and 4% in the second and third months, respectively, following the
sale.
c. Total administrative and selling expenses (all cash) are $25,000.
d. Purchases are always paid 30 days after delivery. Purchases for October, November, and December
were $28,000, $39,000, and $29,500, respectively.
e. Cash dividends of $22,000 are paid.
f. Any cash excess is used to purchase 30-day government securities, and any cash deficiency is
compensated by short-term borrowing.
g. Management desires a minimum balance of $9,000 in the bank.
Prepare a cash budget for the month of January.

© BrainMass Inc. brainmass.com October 16, 2018, 8:18 pm ad1c9bdddf
https://brainmass.com/economics/personal-finance-savings/cash-budgeting-144927

Solution Summary

The solution explains how to prepare a cash budget

$2.19
Similar Posting

Importance of Cash Budgets in the master budgeting process

What is the main reason for preparing a cash budget in the master budgeting process?

What additional steps need to be taken for seasonal businesses to ensure an optimal outcome?

What are the risks associated with inaccuracies in preparing the pro forma income statement and cash budget?

View Full Posting Details