TUIUIUIUIUL VIEW FIUUICN le text hapter 8: Applying Excel: Exercise (Part 2 of 2) equirement 2: he company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the s rice from $8 to $7. The marketing manager would like to use the following projections in the budget: Year 2 Quarter Year 3 Quarter 15.000 home ? Data Budgeted unit sales Selling price per unit 45,000 15,000 55,000 110.00 65,000 110,000 75,000 85,000 100,000 Budgeted unit salen $7 1 Chapter 8: Applying Excel Year 3 Quarter Data 65,000 45,000 110.000 85,000 75.000 5 Budgeted unit sales Onine Courses zoomuslauncher Preschool.15... Show ACC225.Bus...doc tional Websi... IF IslamicFinder: Acc... Shane Koyczan: '... National Bullying... P Bullying Fin Saved Required information a. What are the total expected cash collections for the year under this revised budget? Expected cash collections for the year b. What is the total required production for the year under this revised budget? Total required production for the year 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 xes Online Course S.. zoomus Launcher.zip Preschoolt 15. A | # | $ % & * 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 Book Print rences e. After seeing this revised budget, the production manager cautioned that due to the current production constraint, a complex mill machine, the plant can produce no more than 80,000 units in any one quarter. Is this a potential problem? No Yes