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 ilke to use the following prolections in the budget

$\backslash$table$[[$WH$,,19,B,$C$,$D$,$E$,$F$,$G$],[1,$Chapter $8$ Applying Excel,,,,$7,,,],[2,$TWWWWWWWH$",,,,7,,,],[3,,,$in$,$tir,$7,$The,Year $3$ Quarter,$5],[4,,,11,2,3,4,1,2],[5,$Budgeted unit sales,,$150,000,85\mathrm{.}000,105,000,60000,90,000,95,000],[16,,1,15,4,,,,],[7,-$ S$$lling price per unt WW$.,$S$,7,$perunit,,,,$],[8,-$ Accounts receivable beginning balance,$5,85,000,,4,,,],[19,1$ Sales collected in the quarter sales are made,,$75\%,,,,,],[,-$ Sales collected in the quarter atter sales are made,,$25\%,,,,,],[\frac{10}{111},-$ Desired ending finished goods inventory is$,,30\%,$of the budgeted,es of the $n,$Jarer,,$],[\frac{1121}{412},$Finished goods inventory beginning,,$12,000,$units,,,,$],[12,-$ Raw matenals required to produce one unit,,$5,$pounds,,,,$],[13,1.$ Desired enging inventory of raw materials is$,,10\%,$of the next quart,duction ne$,,,],[14,-$ Raw matenals inventory beg inning,,$23,000,$pounds,,,,$],[15,1.$ Raw material costs,$5,0\mathrm{.}80,$per pound,,,,$],[16,-$Raw miterials purchases are paid,,$60\%,$in the quarter the,ases aren,,,$],[17,,,40\%,$in the quarter fol,purchase,,,$],[18,-$ Accounts paybble for raw materials, beginnipg bsiance,,$81,500,,,,,]]$

$$ What are the total expected cash collectlons for the year under thls revised budget?

Explected casth collections for the year

b$.$ What is the tota required producton for the year under thrs revlsed budget?

Total required production For the year

$$ what is the toral cost of eaw materials to be purchasrd for the uear ynder this revised budget?

Total cost of raw materials to be purchased for the year

$$ what are the total expected cash disbursments for raw materials for the uear under this revised budget?