11 BASE DATA: 12 Foundation Data for Solving questions 1, 2 and 3: 14 Budgeted Direct Materials Cost Per UNIT 15.00 16 Budgeted Direct Manufacturing Labor Per UNIT 10.00 18 Budgeted Manufacturing Overhead Per UNIT 5.00 21 IN ADDITION TO ABOVE USE THE FOLLOWING: 24 This is Next Year's Budgeted Data for XYZ 26 Budgeted Sales Price Per UNIT 20.00 28 Budgeted Sales - UNITS 20,133 Units 30 Target Ending Finished Goods Inventory in UNITS 7,633 Units 32 Target Beginning Finished Goods Inventory in UNITS 6,983 Units 34 Target Ending Direct Materials Inventory in UNITS 13,633 Units 11,633 Units 36 Target Beginning Direct Materials Inventory in UNITS Sheet1 + Enter 13,633 Units 34 Target Ending Direct Materials Inventory in UNITS 35 36 Target Beginning Direct Materials Inventory in UNITS 11,633 Units 38 Note: It takes one unit of direct materials to make one production unit. 40 WITH THE ABOVE DATA SOLVE THE FOLLOWING QUESTIONS REGARDING YOUR PRODUCT: 421) How many units should be produced next year? 44 Record your answer, using excel formulas, here 46 2) What is the dollar amount budgeted for direct material purchased for next year? 47 48 Record your answer, using excel formulas, here 50 3) What is the Budgeted Revenues for next year. 52 Record your answer, using excel formulas, here 55 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 20.266 February 22.866 May March 14.266 June April Sheet1 Type here to search o i Record your answer, using excel formulas, here 55 USE ONLY THE FOLLOWING INFORMATION TO ANSWER THIS QUESTION. DO NOT USE ANY INFORMATION FROM ABOVE. Gambie Company has the following sales budget for the last six months January 20,266 April February 22,266 May March 14.166 17,766 25.266 12.760 June 62 Historicalls the cash collection of sales as follows 63 The ofsales collected in the month of sales 64 The ofsales collected in the month following the sale is 65 The ofsales collected in the second the following the sale 66 The ofsales that are uncollectible 50% 30% 58 4 What are the budgeted Cash collections for the month of May? 70 Record your answer, using dicel formulas, here 72 Check the order of your formula calculates 73 Freumple feel als 15 and cell bis e llel is 2 74 Yeowatt cells and and then die that sumbellel 75 If your cel formula is al bl/el then your calculation result is 16.333 76 If your excel formula is (al+b)/cl then your calculation result is 9.5 77 The result 9.5 would be the correct