please also include the formulas used to get to each answer. Thank you.

BASE DATA: Foundation Data for Solving questions 1, 2 and 3: 15.00 Budueled Direct Materials Cost Per UNIT Bucureted Dieet Manufacturing Labor Per UNT Budueled Manufacturing Overhead' Per UNT f 5.00 IN ADDITION TO ABOVE USE THE FOLLOWING: This is Next Year's Budgeted Data for XYZ Budgeted Sales Price Per UNIT $ 20.00 Budgeted Sales - UNITS 36,786 Units 24,286 Units 23,636 Units Target Ending Finished Goods Inventory in UNITS Target Beginning Finished Goods Inventory in UNITS Target Ending Direct Materials Inventory in UNITS Target Beginning Direct Materials Inventory in UNITS 30,286 Units 28,286 Units Note: It takes one unit of direct materials to make one production unit. WITH THE ABOVE DATA SOLVE THE FOLLOWING QUESTIONS REGARDING YOUR PRODUCT: 11 How many units should be produced next year? Record your answer using excel formulas, here 21 What is the dollar amount budgeted for direct material purchased for next year? Record your answer using excel formulas, here 31 What is the Budgeted Revenues for next year. Record your ansver, using excel formulas, here 21 What is the dollar amount budgeted for direct material purchased for next year? Record your answer using excel formulas, here 31 What is the Budgeted Revenues for next year. Record your answer using excel formulas, here USE ONLY THE FOLLOWING INFORMATION TO ANSWER THIS QUESTION. DO NOT USE ANY INFORMATION FROM ABOVE. Gamble Company has the following sales budget for the last six months: January $ 53,572 April February $ 55,572 May March $ 47,572 June $ $ 4 51,072 58,572 46,072 + Historically, the cash collection of sales has been as follows: The X of sales collected in the month of sale is 50% The X of sales collected in the month following the sal 30% The X of sales collected in the second month following 15% The X of sales that are uncollectible 5% 41 What are the budgeted Cash collections for the month of May? Record your ansver, using excel formulas, here Check the order of your formula calculations For example, if cell al is 15 and cell b1is 4 and cell chis 2. You want to add cells al and b1 and then divide that sum by cell c1 If your excel formula is al+b1/c1 then your calculation result is 16.333 If your excel formula is (al+b1}/c1 then your calculation result is 9.5 The result 9.5 vould be the correct answer. Case Part 3 Grading: Possible Poi Earned Points 3 points for each correct answer 12 2 points for use of excel formulas to support ans 8 Total points for case part 3 0 Not following ALL of the directions will result in a 5 point reduction in the student's earned score. 20