Cash receipts, disbursements and summary budgets Lós costs 9ener Income before ta Less income taxes Net income s Hats manufactures and distributes hats for Hailey’ imaginable house three occasion. Henrietta Hailey started the company in her ee years ago and has been surprised at her success She ing an expansion of her business apt needs to prepare eting information for presertatign to Second National Cash asked you to help her with preparing the necet so she National Accounts receiva teports. Hailey’s Hats began the month with a bank balance of $ Property, plant a accumulated The budgeted sales for March to June are as follo Total assets March April M $14000 $16500 $15500 $17500 Accounts payab Retained earnir Common stock Total liabilities May June Cash sales Sales on account 29000 30000 40000 50000 Total sales $43000 $46500 S55500 $67500 Henrietta has found that she generally collects payment for credit sales over a two month period.Typically collected in the month of sale and the remainder is collected in hent the next month. Her policy is to purchase inventory each month moth equivalent to 60 per cent of that month’s budgeted sales. She thinks this provides her sufficient inventory levels to manage unanticipated changes in demand. Hailey’s Hats pays for inventory purchases in the month following purchaee and administrative expenses are budgeted to be30 per cent of each month’s sales. One-half of the selling and adn Sales budg DY.First qua 20 per cent is o ch s sales Third qu Fourth . Sales are the quart the sale ve expenses is accounted for by depreciation on Henrietta’s manufacturing equipment. The company purchased additional manufacturing equipment in April at a cost of $24000) Henrietta does not receive a salary, but she does pay herself dividends as company performance allows.The first quarter of the year was very profitable, so Henrietta paid herself a dividend of€ 1250) n 2011, rela The cost in 2012.I sale Eig quarter c followin The acc to inven Selling g to $225 is depr The in The co . of $10000 and has established a line of credit so she can borrow enough money to make up any shortfall If the company has excess cash on hand at the end of a month (in excess of $10000) the line of credit will be paid back.Interest on the line of credit Henrietta wants to maintain a minimum cash ngs) will not be paid until the end of the year. (gnore any interest payments that the company would make on their borrow Chapter Twelve 1 Fixed and rolling
Expert Answer
Solution:
a) Cash Receipts Budget
Cash Receipts Budget | ||||
For April, May, June | ||||
April | May | June | Quarter | |
Cash sales | $16,500 | $15,500 | $17,500 | |
Sales on account: | ||||
March | $8,700
(29000*30%) |
|||
April | $21,000
(30000*70%) |
$9,000
(30000*30%) |
||
May | $28,000
(40,000*70%) |
$12,000
(40000*30%) |
||
June | $35,000
(50,000*70%) |
|||
Total cash receipts | $46,200 | $52,500 | $64,500 | $163,200 |
b) Cash Disbursement Budget
Cash Disbursement Budget for April, May and June | |||
April | May | June | |
Purchases (60% of Total Sales) | $27,900 | $33,300 | $40,500 |
Cash disbursement for purchases | |||
March Purchases (43000*60%) | $25,800 | ||
April Purchases | $27,900 | ||
May Purchases | $33,300 | ||
June Purchases | |||
Total Cash Payments for purchases (A) | $25,800 | $27,900 | $53,700 |
Administrative Expenses (excluding depreciation) | $6,975 | $8,325 | $10,125 |
Equipment | $24,000 | ||
Dividend | $12,500 | ||
Total Cash Disbursements | $69,275 | $36,225 | $63,825 |
c) Cash Budget
April | May | June | |
Beginning Cash | $10,000 | $10,000 | $10,000 |
Total Cash Receipts (refer part a) | $46,200 | 52500 | $64,500 |
Total Cash Available | $56,200 | $62,500 | $74,500 |
Less: Cash Disbursements (Refer part b) | $69,275 | $36,225 | $63,825 |
Surplus or (Defficiency) of Cash | -$13,075 | $26,275 | $10,675 |
Borrowings | $23,075 | ||
Repayment of Borrowings | $16,275 | $675 | |
Ending Balance | $10,000 | $10,000 | $10,000 |