Question

Cash Budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget for the next three months. You are pre

0 0
Add a comment Improve this question Transcribed image text
Answer #1
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

Add a comment
Know the answer?
Add Answer to:
Cash Budget The controller of Shoe Mart Inc. asks you to prepare a monthly cash budget...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 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...

    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...

    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 thr...

    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...

    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...

    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...

    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...

    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...

    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...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT