Share
Explore BrainMass

Cash Budgeting

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.

Solution Summary

The solution explains how to prepare a cash budget

$2.19