Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
Bridgeport Housewares Inc. | ||||
Collection Budget | September | October | November | Note |
Budgeted Sales Revenue | 250,000.00 | 300,000.00 | 315,000.00 | A |
Cash sale @ 10% | 25,000.00 | 30,000.00 | 31,500.00 | B=A*10% |
Collections of accounts receivable | ||||
Credit sale @ 90% | 225,000.00 | 270,000.00 | 283,500.00 | C= A*90% |
70% of Credit sale in the next month | 157,500.00 | 189,000.00 | D= 70% of C of previous month. | |
30% of Credit sale in the 2nd month | 67,500.00 | E= 30% of C of September. | ||
Collection of July | 60,000.00 | This is the remaining 30% of credit sales of July which is collected in September. | ||
Collection of August | 168,000.00 | 72,000.00 | 70% of $ 240000 is collected in October and remaining 30% in November. | |
Total Scheduled Collections | 60,000.00 | 325,500.00 | 328,500.00 | |
Payment of Manufacturing costs | September | October | November | |
Manufacturing costs | 150,000.00 | 180,000.00 | 185,000.00 | |
Less: Depreciation, Insurance and property tax | 50,000.00 | 50,000.00 | 50,000.00 | |
Manufacturing costs payable | 100,000.00 | 130,000.00 | 135,000.00 | F |
80% paid in same month | 80,000.00 | 104,000.00 | 108,000.00 | G= F*80% |
20% paid in next month | 20,000.00 | 26,000.00 | H= 20% of G of previous month. | |
Payment for August | 40,000.00 | |||
Manufacturing costs payment | 120,000.00 | 124,000.00 | 134,000.00 | |
Cash budget | September | October | November | |
Cash sales | 25,000.00 | 30,000.00 | 31,500.00 | |
Collections of accounts receivable | 60,000.00 | 325,500.00 | 328,500.00 | |
Total Cash Receipts | 85,000.00 | 355,500.00 | 360,000.00 | |
Estimated cash payments for | ||||
Manufacturing costs | 120,000.00 | 124,000.00 | 134,000.00 | |
Selling & admin expenses | 42,000.00 | 48,000.00 | 51,000.00 | |
Capital Expenditure | 200,000.00 | |||
Other Purposes | ||||
Income Tax | 55,000.00 | |||
Dividends | 25,000.00 | |||
Total cash payments | 162,000.00 | 227,000.00 | 410,000.00 | |
Cash increase or (decrease) | (77,000.00) | 128,500.00 | (50,000.00) | |
Cash Balance at the beginning of month | 40,000.00 | (37,000.00) | 91,500.00 | |
Cash Balance at the end of month | (37,000.00) | 91,500.00 | 41,500.00 | |
Minimum cash balance | 50,000.00 | 50,000.00 | 50,000.00 | |
Excess or (deficiency) | (87,000.00) | 41,500.00 | (8,500.00) | |
Answer 2 | ||||
For this please provide options in comments. I will reply for sure. | ||||
updated photo! Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November $250,000 $300,000 $315,000 Sales 150,000 185,000 180,000 Manufacturing costs Selling and administrative 51,000 42,000 48,000 expenses 200,000 Capital expenditures 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 Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $114,000 $140,000 $189,000 Manufacturing costs 48,000 60,000 68,000 Selling and administrative expenses 40,000 42,000 72,000 Capital expenditures _ _ 45,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...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $137,000 58,000 $173,000 74,000 $226,000 81,000 Manufacturing costs Selling and administrative expenses 48,000 52,000 86,000 Capital expenditures 54,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...
PR 22-5A Cash Budget Obj. 5 The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: October Sales Manufacturing costs Selling and administrative expenses Capital expenditures September $250,000 150,000 42,000 $300,000 180,000 48,000 November $315,000 185,000 51,000 200,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...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $121,000 $155,000 $201,000 Manufacturing costs 51,000 67,000 72,000 Selling and administrative 42,000 47,000 76,000 expenses Capital expenditures 48,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...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $130,000 $161,000 $211,000 Manufacturing costs 55,000 69,000 76,000 Selling and administrative expenses 46,000 48,000 80,000 Capital expenditures _ _ 51,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 Bridgeport Housewares Inc. Instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $142,000 $178,000 $231,000 Manufacturing costs 60,000 77,000 83,000 Selling and administrative 50,000 $3,000 88,000 expenses Capital expenditures 55,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...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $141,000 $176,000 $ $241,000 Manufacturing costs 59,000 76,000 87,000 49,000 53,000 92,000 Capital expenditures ------------------------------------------------------------ ------------------------------------------------------------------------- 58,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...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $136,000 $166,000 $227,000 Manufacturing costs 57,000 71,000 82,000 Selling and administrative expenses 48,000 50,000 86,000 Capital expenditures _ _ 54,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 Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $137,000 $173,000 $223,000 Manufacturing costs 58,000 74,000 80,000 Selling and administrative expenses 48,000 52,000 85,000 Capital expenditures _ _ 54,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...