Acc561 Introduction to Management Accounting: 7-37 Cash Budget (Botanica Company)

Acc561 Introduction to Management Accounting

7-37 Cash Budget
Prepare a statement of estimated cash receipts and disbursements for October 20X7 for the Botanica Company, which sells one products, herbal soap, by the case. On October 1, 20X7, part of the trial balance showed
Dr Cr
Cash 4,800
Accounts receivable 15,600
Allowance for bad debts 1,900
Merchandise inventory 9,000
Accounts payable, merchandise 6,600

The company pays for its purchases within 10 day of purchase so assume that one-third of the purchases of any month are due and paid for in the following month.

The cost of the merchandise purchased is $12 per case. At the end of each month, it is desired to have an inventory equal in units to 50% of the following month’s sales in units.
Sales terms include a 15 discount if payment is made by the end of the calendar month. Past experience indicates that 60% of sales will be collected during the month of the sale, 30% in the following calendar month, 6% in the next following calendar month, and the remaining 4% will be uncollectible. The company’s fiscal year begins August 1.
Unit selling price $20
August actual sales $12,000
September actual sales 36,000
October estimated sales 30,000
November estimated sales 22,000
Total sales expected in the fiscal year 360,000

Exclusive of bad debts, total budgeted selling and general administrative expenses for the fiscal year are estimated at $61,500, of which $24,000 is fixed expense (which includes a $13,200 annual depreciation charge). The Botanica Company incurs these fixed expenses uniformly throughout the year. The balance of the selling and general administrative expenses varies with the sales. Expenses are paid in incurred.
Powered by