a$.$ What are the total expected cash collections for the year under this revised budget?

Expected cash collections for the year $ $$1,981,250$

b$.$ What is the total required production for the year under this revised budget?

Total required production for the year $,303,500$

c$.$ What is the total cost of raw materials to be purchased for the year under this revised budget?

Total cost of raw materials to be purchased for the year $$1,242,800$

d$.$ What are the total expected cash disbursements for raw materials for the year under this revised budget?

Total expected cash disbursements for raw materials for the year $$1,205,900$

e$.$ After seeing this revised budget, the production manager cautioned that due to the current production constraint, a complex milling machine. the plant can produce no more than $80\mathrm{.}000$ units in anv one quarter. Is this a potential problem?

Prev

$2$ of $2$

Next

Chapter $8$: $($Algo$)$ Applying Excel: Exercise $($Part $2$ of $2)$

Requirement $2$:

The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $$8$ to $$7.$ The marketing manager would like to use the following projections in the budget:

$\backslash$table$[[,$Year $2,,$Year $3$ Quarter,$],[$Data$,1,2,3,4,,1,2],[$Budgeted unit sales,$45,000,70,000,110,000,65,000,,85,000,95,000],[$Selling price per unit,$$7,,,,,,]]$

$\backslash$table$[[,$A$,,$B$,$C$,$D$,$E$,$F$,$G$],[1,$Chapter $8$: Applying Excel f$,,,,,,,],[2],[3,$Data,,,,,,Year $3$ Quarter$],[4,,,1,2,3,4,1,2],[5,$Budgeted unit sales,,$45,000,70,000,110,000,65,000,85,000,95,000],[6,,,,,,,,],[7,-$ Selling price per unit,$$,7,$per unit,,,,$],[8,-$ Accounts receivable, beginning balance,$$,65,000,,,,,],[9,-$ Sales collected in the quarter sales are made,,$75\%,,,,$z$,],[10,-$ Sales collected in the quarter after sales are made,,$25\%,,,,,],[11,-$ Desired ending finished goods inventory is$,,30\%,$of the budgeted unit sales of the next quarter$],[12,-$ Finished goods inventory, beginning,,$12,000,$units,,,,$],[13,-$ Raw materials required to produce one unit,,$5,$pounds,,,,$],[14,-$ Desired ending inventory of raw materials is$,,10\%,$of the next quarter's production needs$],[\frac{15}{16},-$ Raw materials inventory, beginning,,$23,000,$pounds,,,,$],[\backslash$table$[[16],[17]],-$ Raw material costs,$$,0\mathrm{.}80,$per pound,,,,$],[18,-$ Raw materials purchases are paid,,$60\%,$in the quarter the purchases are made$],[19,$and,,$40\%,$in the quarter following purchase$],[,-$ Accounts payable for raw materials, beginning balance,$$,81,500,,,,,]]$

a$.$ What are the total expected cash collections for the year under this revised budget?

Expected cash collections for the year $$1,981,250$

b$.$ What is the total required production for the year under this revised budget?

Total required production for the year $303,500$

c$.$ What is the total cost of raw materials to be purchased for the year under this revised budget?

Total cost of raw materials to be purchased for the year $$1,242,800$

d$.$ What are the total expected cash disbursements for raw materials for the year under this revised budget?

Total expected cash disbursements for raw materials for the year $$1,205,900$