Excel #$1($i$)$

Help

Save

Excel #$1($i$)$

Help

Save

Excel #$1($i$)$

Help

Save

Excel #$1($i$)$

Help

Save

Requirement $2$:

The company just hired a new marketing manager who insists 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,$Quarter,Year $3,$Quarter$],[$Data$,1,2,3,4,1,2],[$Budgeted unit sales,$45,000,65,000,120,000,60,000,80,000,90,000],[$Selling price per unit,$$7,,,,,]]$

$\backslash$table$[[1,$A$,$B$,$C$,$D$,$E$,$F$,$G$],[2,$Chapter $8$: Applying Excel,,,,,,$],[,,,,,,,],[3,$Data,,,,,Year $3$ Quarter$],[4,,1,2,3,4],[,$Budgeted unit sales,$45,000,65,000,120,000,60,000,80,000,],[6,,,,,,,],[7,-$ Selling price per unit,$ $7,$per unit,,,,$]]$

Prev

$1$ of $1$

Next

Search

Rudmatad

$15$ aaa

$!$

Required information

$\backslash$table$[[1,$A$,$B$,$C$,$D$,,,],[,$Chapter $8$: Applying Excel,,,,E$,$F$,],[2,,,,,,,],[3,$Data,,,,,,$],[4,,,,,,$Year $3$ Quarter,$],[5,$Budgeted unit sales,$1,2,3,4,1,2],[6,,45,000,65,000,120,000,60,000,80,000,],[7,-$ Selling price per unit,$ $7,,,,,],[8,-$ Accounts receivable, beginning balance,,per unit,,,,$],[9,-$ Sales collected in the quarter sales are made,$ $65,000,,,,,],[10,-$ Sales collected in the quarter after sales are made,$75\%,,,,,],[11,-$ Desired ending finished goods inventory is$,30\%,25\%,,,,],[12,-$ Finished goods inventory, beginning,,of the budgeted unit sales of the next quarter,,,,$],[13,-$ Raw materials required to produce one unit,$12,000,$units,,,,$],[14,,5,$pounds,,,, Desired ending inventory of raw materials is$,10\%,$of the next quarter's production needs,,,,$]]$

Prev

$1$ of $1$

Next

Search

Help

Required information

$\backslash$table$[[!,$Required information,$4$v$,$uvu,uv$,$uvu,$1\mathrm{.}4$v$,$vuv,uv$,$uve,UV$,],[,$sunyeted units sales,,,,,$],[6,,$$$,7,,,],[7,-$ Selling price per unit,,,,,$],[8,-$ Accounts receivable, beginning balance,$$,65,000,,,],[9,-$ Sales collected in the quarter sales are made,$75\%,,,,],[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,,12,000,$units,,,$],[13,-$ Finished goods inventory, beginning,$5,$of the next quarter's production needs$],[14,-$ Raw materials required to produce one unit,$10\%],[15,-$ Desired ending inventory of raw materials is$,3,23,000,,,],[16,-$ Raw materials inventory, beginning,$$,$in the quarter the purchases are made$],[17,-$ Raw material costs,$60\%],[18,-$ Raw materials purchases are paid,$40\%,,,,],[19,-$ Accounts payable for raw materials, beginning balance,$$,81,500,,,]]$

Prev.

$1$ of $1$

Next

Search

Required information

$\backslash$table$[[$A$,$B$,$C$,$D$,$E$,$F$,$G$],[$el$,,,,,,],[,,,,,,],[,,,,,$Year $3$ Quarter$],[,1,2,3,4,1,2],[,45,000,65,000,120,000,60,000,80,000,90,000],[,,,,,,],[,$$ $7,$per unit,,,,$],[$ inning balance,$ $65,000,,,,,],[$arter sales are made,$75\%,,,,,],[$arter after sales are made,$25\%,,,,,],[$yoods inventory is$,30\%,$of the budgeted unit sales of the next quarter$],[,$ beginning,$12,000],[$o produce one unit,$5,$pounds,,,,$],[-$ of raw materials is$,10\%,$of the next quarter's production needs$],[$beginning$,23,000]]$

Prev

$1$ of $1$

Next

Search

Required information

$\backslash$table$[[$A$,$B$,$C$,$D$,$E$,$F$,$G$],[$el$,,,,,,],[,,,,,,],[,,,,,$Year $3$ Quarter$],[,1,2,3,4,1,2],[,45,000,65,000,120,000,60,000,80,000,90,000],[,,,,,,],[,$$ $7,$per unit,,,,$],[$ inning balance,$ $65,000,,,,,],[$arter sales are made,$75\%,,,,,],[$arter after sales are made,$25\%,,,,,],[$yoods inventory is$,30\%,$of the budgeted unit sales of the next quarter$],[,$ beginning,$12,000],[$o produce one unit,$5,$pounds,,,,$],[-$ of raw materials is$,10\%,$of the next quarter's production needs$],[$beginning$,23,000]]$

Prev

$1$ of $1$

Next

Search

Required information

$\backslash$table$[[$A$,$B$,$C$,$D$,$E$,$F$,$G$],[$el$,,,,,,],[,,,,,,],[,,,,,$Year $3$ Quarter$],[,1,2,3,4,1,2],[,45,000,65,000,120,000,60,000,80,000,90,000],[,,,,,,],[,$$ $7,$per unit,,,,$],[$ inning balance,$ $65,000,,,,,],[$arter sales are made,$75\%,,,,,],[$arter after sales are made,$25\%,,,,,],[$yoods inventory is$,30\%,$of the budgeted unit sales of the next quarter$],[,$ beginning,$12,000],[$o produce one unit,$5,$pounds,,,,$],[-$ of raw materials is$,10\%,$of the next quarter's production needs$],[$beginning$,23,000]]$

Prev

$1$ of $1$

Next

Search

Required information

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,904,000$

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 yeas $$1,085,116$

e$.$ After seeing this revised budget, the production manager cautioned that due to the limited availability of a com the nlant can produce no more than $90000$ units in anv one cusarter is this a notential nroblem?

Prev

$1$ of $1$

Next

Search