Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
Sonoma | ||||
Collection Budget | May | June | July | |
Budgeted Sales Revenue | 88,000.00 | 106,000.00 | 147,000.00 | A |
Cash sale @ 12% | 10,560.00 | 12,720.00 | 17,640.00 | B=A*12% |
Collections of accounts receivable | ||||
Credit sale @ 88% | 77,440.00 | 93,280.00 | 129,360.00 | C= A*88% |
65% of Credit sale in the next month | 50,336.00 | 60,632.00 | D= 65% of C of previous month. | |
35% of Credit sale in the 2nd month | 27,104.00 | E= 35% of C of May. | ||
Collection of March | 24,500.00 | This is the remaining 35% if credit sales of March which will be collected in May. | ||
Collection of April | 50,050.00 | 26,950.00 | 65% of $ 77000 will be collected in June and remaining 35% in July. | |
Total Scheduled Collections | 24,500.00 | 100,386.00 | 114,686.00 | |
Payment of Manufacturing costs | May | June | July | |
Manufacturing costs | 37,000.00 | 46,000.00 | 53,000.00 | |
Less: Depreciation, Insurance and property tax | 8,000.00 | 8,000.00 | 8,000.00 | |
Manufacturing costs payable | 29,000.00 | 38,000.00 | 45,000.00 | F |
80% paid in same month | 23,200.00 | 30,400.00 | 36,000.00 | G= F*80% |
20% paid in next month | 5,800.00 | 7,600.00 | H= 20% of G of previous month. | |
Payment for April | 15,000.00 | |||
Manufacturing costs payment | 38,200.00 | 36,200.00 | 43,600.00 | |
Cash budget | May | June | July | |
Cash sales | 10,560.00 | 12,720.00 | 17,640.00 | |
Collections of accounts receivable | 24,500.00 | 100,386.00 | 114,686.00 | |
Total Cash Receipts | 35,060.00 | 113,106.00 | 132,326.00 | |
Estimated cash payments for | ||||
Manufacturing costs | 38,200.00 | 36,200.00 | 43,600.00 | |
Selling & admin expenses | 26,000.00 | 29,000.00 | 32,000.00 | |
Capital Expenditure | 35,000.00 | |||
Other Purposes | ||||
Income Tax | 13,000.00 | |||
Dividends | 8,000.00 | |||
Total cash payments | 64,200.00 | 78,200.00 | 118,600.00 | |
Cash increase or (decrease) | (29,140.00) | 34,906.00 | 13,726.00 | |
Cash Balance at the beginning of month | 33,000.00 | 3,860.00 | 38,766.00 | |
Cash Balance at the end of month | 3,860.00 | 38,766.00 | 52,492.00 | |
Minimum cash balance | 26,000.00 | 26,000.00 | 26,000.00 | |
Excess deficiency | (22,140.00) | 12,766.00 | 26,492.00 | |
Answer 2 | ||||
For this please provide options in comments. I will reply for sure. | ||||
Cash Budget The controller of Sonoma Housewares Inc. Instructs you to prepare a monthly cash budget...
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...
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...
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...
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...
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 $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...
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...
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 $106,000 $134,000 $170,000 Manufacturing costs 45,000 58,000 61,000 Selling and administrative expenses 31,000 36,000 37,000 Capital expenditures _ _ 41,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 65% are 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 $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...