Working: Sales | |||
Particular | January | February | March |
Sales | 88000 | 110000 | 150000 |
Cash Sales | 10560 | 13200 | 18000 |
Credit Sales | 77440 | 96800 | 132000 |
Working: Receivable | |||
Collection of account receivable (70%) | 54208 | 67760 | |
Collection of account receivable (30%) | 23232 | ||
For Nov | 21000 | ||
For December | 53900 | 23100 | |
Total Receivables | 74900 | 77308 | 90992 |
Working: Cash payment for manufacturing cost | |||
Total Manufacturing cost | 37000 | 47000 | 54000 |
Less: Depreciation insurance property tax | 6000 | 6000 | 6000 |
31000 | 41000 | 48000 | |
Payment of manufacturing cost (75%) in month of incurred | 23250 | 30750 | 36000 |
Payment of manufacturing cost (25%) in following month | 6000 | 7750 | 10250 |
Cash payment for manufacturing cost | 29250 | 38500 | 46250 |
Working: Notes payable | |||
Principal Amount | 44000 | ||
Interest Amount | 1320 | ||
Total Notes payable | 45320 | ||
Cash Budget | |||
Particular | January | February | March |
Estimate cash receipts from: | |||
Cash Sales 12% | 10560 | 13200 | 18000 |
Total Receivables | 74900 | 77308 | 90992 |
Dividend | 2600 | ||
Total cash receipts | 88060 | 90508 | 108992 |
Estimated cash payment for: | |||
Manufacturing cost | 29250 | 38500 | 46250 |
Selling and administrative expenses | 26000 | 30000 | 33000 |
Capital Expenditure | 36000 | ||
Other Purpose | |||
Notes payable (including interest) | 45320 | ||
Income Tax | 13000 | ||
Dividends | 6000 | ||
Total Cash payment | 55250 | 81500 | 166570 |
Cash Increase and decrease | 32810 | 9008 | -57578 |
Cash balance at beginning of month | 33000 | 65810 | 74818 |
Cash balance at end of month | 65810 | 74818 | 17240 |
Minimum cash balance | 26000 | 26000 | 26000 |
Excess/(Deficit) | 39810 | 48818 | -8760 |
2.
Minimum cash balance not maintained because of
a. Capital Expenditure
b. Notes Repayment
Cash Budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget...
Cash Budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: January February March Sales $100,000 $122,000 $166,000 Manufacturing costs 42,000 52,000 60,000 Selling and administrative expenses 29,000 33,000 37,000 Capital expenditures _ _ 40,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 65% are expected to be collected in full 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 $96,000 $114,000 $153,000 Manufacturing costs 40,000 49,000 55,000 Selling and administrative expenses 34,000 34,000 58,000 Capital expenditures _ _ 37,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 $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...
The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budgetinformation: March April May Sales $129,000 $156,000 $206,000 Manufacturing costs 54,000 67,000 74,000 Selling and administrative expenses 37,000 42,000 45,000 Capital expenditures _ _ 49,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 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 $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 $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 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 $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 Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: June July August Sales $160,000 $185,000 $200,000 Manufacturing costs 66,000 82,000 105,000 Selling and administrative expenses 40,000 46,000 51,000 Capital expenditures 120,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% 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 $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...