The treasure of Unisyms Company has accumulated the following budget information for the first two months of the coming year:
March April
Sales $450,000 $520,000
Manufacturing $290,000 $350,000
Selling &Admin. expenses $41,000 $46,4000
Capital additions $250,000 -------
The company expects to sell about 35% of its merchandise for cash of sales on account 80% are expected to be collected in full in the month of the sale andremainder in the month following the sale. One-fourth of the manufacturing costs are expected to be paid in the month in which they are incurred and the otherthree-fourth in the following month. Depreciation, insurance, and property taxes represents $64,400 of the probable monthly selling and administrative expenses.Insurance is paid in April. Of the remainder of the selling and administrative expenses, one-half are expected to be paid in the month in which they are incurred,with the balance paid in the following month. Capital additions of $250,000 are expected to be paid in March. Current assets of March 1 are composed of accountspayable of $121,500($102,2000 for materials purchases and $19,5000 for operating expenses). Management desires to maintain a minimum cash balance of $20,000.
Prepare a monthly cash budget for March and April
Monthly cash budget for March and April.
============================================
MarchApril
Budgeted Cash Receipts :
Cash Sales
$450,000 x35%$157,500
$520,000 x35%$182,000
Collections of A/R
($450,000x65%x80%) + $51,000$285,000
($520,000x65%x80%) +
($450,000x65%x20%)$328,900
TotalReceipts$442,500 $510,900
Budgeted Cash Payments
Manufacturing costs
($290,000 x1/4)+$102,000 $174,500
($350,000x1/4)+($290,000x3/4)$305,000
Selling &Administrative expenses
($41,400-$6,400)/2 + $19,500 $37,000
($46,400-$6,400)/2 +$19,500$37,500
Capitaladditions$250,000 ----
IncomeTaxes---- $40,000
Total Cash payments$461,500$382,500
Cash Increase / (decrease) ($19,000)$128,400
Beginning cash balance$45,000 $26,000
Ending cashbalance$26,000$154,400
Minimum Cash balance required $20,000 $20,000
Excess /(deficiency)$6,000$134,400
The treasurer of Calico Dreams Company has accumulated the following budget information for the first two months of the coming fiscal year: March $450,000 290,000 41,400 250,000 April Sales Manufacturing costs Selling and administrative expenses Capital additions $520,000 350,000 46,400 The company expects to sell about 35% of its merchandise for cash. Of sales on account, 80% are collected in full in the month of the sale, and the remainder in the month following the sale. One-fourth of the manufacturing...
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...
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 $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...
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
$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 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 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...
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...