Question & Answer: Cash receipts, disbursements and summary budgets Lós costs 9ener Income before ta Less income taxes Net inco…..

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. Haileys 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 months budgeted sales. She thinks this provides her sufficient inventory levels to manage unanticipated changes in demand. Haileys Hats pays for inventory purchases in the month following purchaee and administrative expenses are budgeted to be30 per cent of each months 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 Henriettas 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
media%2Fa79%2Fa795411f-c14b-494a-b6aa-95

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

Don't use plagiarized sources. Get Your Custom Essay on
Question & Answer: Cash receipts, disbursements and summary budgets Lós costs 9ener Income before ta Less income taxes Net inco…..
GET AN ESSAY WRITTEN FOR YOU FROM AS LOW AS $13/PAGE
Order Essay
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

Still stressed from student homework?
Get quality assistance from academic writers!