You should proceed to the requirements below only after completing your worksheet. Required 1Check your worksheet by changing the budgeted unit sales in aaner 2 of Year 2 in cel C5 to 75.000 units. The total expected cash collections for the year should now be $2.085,000. If you do not get this answer, find the errors in your worksheet and comect them. Have the total cash disbursements for the year changed? Why or why not? 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 S8 to $7. The markening manager would ike to use the following projections in the budget What are the total expected cash coloctions for the ycar under this tevised & What is the sotal required peoduction for the year under this revised budget? e What is the total cost of raw materials to be purchased for the year under this revised bedget? d What are the lotal expected cash disbursements foe raw materials fothe year under this revised budpet? Afler seeing this revised budget, the production manip produce no more than 90,000 units in any one quarter Is this a potential e. cautioned problem? If so, what can be done about it? You should proceed to the requirements below only after completing your worksheet. Required 1Check your worksheet by changing the budgeted unit sales in aaner 2 of Year 2 in cel C5 to 75.000 units. The total expected cash collections for the year should now be $2.085,000. If you do not get this answer, find the errors in your worksheet and comect them. Have the total cash disbursements for the year changed? Why or why not? 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 S8 to $7. The markening manager would ike to use the following projections in the budget What are the total expected cash coloctions for the ycar under this tevised & What is the sotal required peoduction for the year under this revised budget? e What is the total cost of raw materials to be purchased for the year under this revised bedget? d What are the lotal expected cash disbursements foe raw materials fothe year under this revised budpet? Afler seeing this revised budget, the production manip produce no more than 90,000 units in any one quarter Is this a potential e. cautioned problem? If so, what can be done about it