Solution 1:
Computation of Collection from Customer | |||
Particulars | May | June | July |
Collection for March Sales | $18,000.00 | ||
Collection for April Sales | $50,400.00 | $21,600.00 | |
Collection for May Sales | $54,180.00 | $23,220.00 | |
Collection for June Sales | $56,700.00 | ||
Total cash collections | $68,400.00 | $75,780.00 | $79,920.00 |
Computation of Cash payment of manufacturing costs | |||
Particulars | May | June | July |
Payment for April Manufacturing cost | $6,000.00 | ||
Payment for May Manufacturing cost | $24,400.00 | $6,100.00 | |
Payment for June Manufacturing cost | $28,400.00 | $7,100.00 | |
Payment for July Manufacturing cost | $32,400.00 | ||
Total cash disbursements | $30,400.00 | $34,500.00 | $39,500.00 |
Sonoma Housewares Inc. | |||
Cash Budget | |||
For the Three Months Ending July 31 | |||
Particulars | May | June | July |
Estimated cash receipts from: | |||
Cash sales | $8,600.00 | $9,000.00 | $9,500.00 |
Collection of accounts receivable | $68,400.00 | $75,780.00 | $79,920.00 |
Total cash receipts | $77,000.00 | $84,780.00 | $89,420.00 |
Less estimated cash payments for: | |||
Manufacturing costs | $30,400.00 | $34,500.00 | $39,500.00 |
Selling and administrative expenses | $15,000.00 | $16,000.00 | $22,000.00 |
Capital expenditures | $80,000.00 | ||
Other purposes: | |||
Income tax | $14,000.00 | ||
Dividends | $5,000.00 | ||
Total cash payments | $45,400.00 | $64,500.00 | $146,500.00 |
Cash increase or (decrease) | $31,600.00 | $20,280.00 | -$57,080.00 |
Plus cash balance at beginning of month | $33,000.00 | $64,600.00 | $84,880.00 |
Cash balance at end of month | $64,600.00 | $84,880.00 | $27,800.00 |
Less minimum cash balance | $30,000.00 | $30,000.00 | $30,000.00 |
Excess or (deficiency) | $34,600.00 | $54,880.00 | -$2,200.00 |
Cash Budget The controller of Sonoma Housewares Inc. Instructs you to prepare a monthly cash budget for the next t...
Cash Budget The controller of Sonoma Housewares Inc. Instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget Information: May June July Sales Manufacturing costs $86,000 34,000 15,000 $90,000 39,000 16,000 $95,000 44,000 22,000 Selling and administrative expenses Capital expenditures - 80,000 The company expects to sell about 10% of its merchandise for cash of sales on account, 70% are expected to be collected in the month following the sale...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $86,000 $90,000 $95,000 Manufacturing costs 34,000 39,000 44,000 Selling and administrative expenses 15,000 16,000 22,000 Capital expenditures _ _ 80,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
PR 22-4A Cash budget OBJ. 5 The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash bud- get for the next three months. You are presented with the following budget information: May June July Sales .................................... ......******* $86,000 $90,000 $95,000 Manufacturing costs........ 34,000 39,000 44,000 Selling and administrative expenses...... 15,000 16,000 22,000 Capital expenditures ...... 80,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be...
Cash Budget The controller of Sonoma Housewares Inc. Instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $88,000 $106,000 $147,000 Manufacturing costs 37,000 46,000 53,000 Selling and administrative expenses 26,000 29,000 32,000 Capital expenditures - - 35,000 The company expects to sell about 12% of its merchandise for cash. Of sales on account, 65% we expected to be collected in the month following the...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $112,000 $138,000 $186,000 Manufacturing costs 47,000 59,000 67,000 Selling and administrative expenses 32,000 37,000 41,000 Capital expenditures _ _ 45,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $134,000 $159,000 $216,000 Manufacturing costs 56,000 68,000 78,000 Selling and administrative expenses 39,000 43,000 48,000 Capital expenditures _ _ 52,000 The company expects to sell about 12% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and...
Cash Budget The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $130,000 $156,000 $213,000 Manufacturing costs 55,000 67,000 77,000 Selling and administrative expenses 38,000 42,000 47,000 Capital expenditures 51,000 The company expects to sell about 15 % of its merchandise for cash.Of sales on account, 70 % are expected to be collected in the month following the sale...
Cash Budget The controller of Sonoma Housewares Inc. Instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $123,000 $153,000 $204,000 Manufacturing costs 52,000 66,000 73,000 Selling and administrative expenses 36,000 41,000 45,000 Capital expenditures 49,000 The company expects to sell about 12% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and...
The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $107,000 $135,000 $181,000 Manufacturing costs 45,000 58,000 65,000 Selling and administrative expenses 31,000 36,000 40,000 Capital expenditures _ _ 43,000 The company expects to sell about 15% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and...
The controller of Sonoma Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: May June July Sales $116,000 $143,000 $191,000 Manufacturing costs 49,000 61,000 69,000 Selling and administrative expenses 34,000 39,000 42,000 Capital expenditures _ _ 46,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and...