the assumptions presented, prepare the following schedules (showing quarterly and annual amounts where applicable) Budget Suction Budget ct Materials Purchases Budget ect Labor Budget nufacturing Overhead Budget Tes Revenue e Eastern Technology Company manufactures Weather Radios for sale to retailers such as Wal-Mart, Target, etc me 2016 quarterly unit sales estimates and projected sales prices per unit are as follows: Quarter 3 Our Quarter 2 500 0200 9.200 $90 Also, note that that projected sales and projected production) for Quarter 1 of 2017 is 10,000 units Sales units Product Cost Assumptions The company's product requires two raw materials, resistors and switches Cost parameters are as folloca per Number of Components/Unit Switches @ 54/switch Resistors @ switch Number of minutes reguleed to complete Eished at Drechs unit Machine wants per unit Hour rates used Direct labor rates $10/hour Estem applies manufacturing overhead using two cost drivers direct labor hours and machine hours Manufacturing overhead rates (ie, the Ending Inventories PDOHRs to use to apply overhead) The desired ending inventories for each of the two direct materials is 10% of the next quarter's respective a quarter's budgeted sales nits Beginning inventory for direct materials and finished goods are assumed to Labor related $25/hour Machine related $40/hour Total Sales Budgeting project Production Budget Sales units Desired Ending Beg TG Units to produce Direct Materials Budget Suitches LILI DM per unit Med Desired Ending DM BOM Mets to purchase CopOM Direct Materials Budget Resistor OM Total OM required BegOM Cover OM Perkasa DM Cort per un peu OL Copertured Budgeting project Total OH costs OH Cost per unit produced X2 Total Product Cost per Unit Cost of Goods Sold S $ 1 S tal-Mart, Target, etc. Quarter 1 10 units Quarter 2 Quarter 3 9.300 19,500 $90 $90 Quarter 4 9400 S90 Sales units $90 are as follo Price per unit Number of Components/Unit Switches @ S4/switch Resistors @ $8/switch 2 Number of minutes required to complete finished unit Direct labor minutes per unit Machine minutes per unit Hour rates used Direct labor rates $10/hour machine hours. Manufacturing overhead rates (i.e., the PDOHRs to use in apply overhead) quarter's respective a pods are assumed to Labor-related $25 hour Machine-related $40/hour Sired finished goods ending inve 22 Q3 NG your answers in the spaces provided below. Be sure to show how you arrived at your answers, with Excel formulas or calculations by and Sumit your a g ent to the stage in Canvas project involves creating a s ence of budgets based on particular sales production, and cost data. You will be asked to create a Sales Budget Production Budget and Budgets for Direct Materials, Direct Labor and anufacturing Overhead as part of this project. The budgets need to be created in the correct sequences one leads to the next. The overarching goal of this exercise is to see the value of the budgeting process sing the sumptions presented, prepare the following schedules showing quarterly and w o unts where applicable les Budget roduction Budget rect Materials Purchases Budget Direct Labor Budget Manufacturing Overhead Budget Sales Revenge The Easter Technology Company manufactures Weather Radios for sale to rea c h awal Mart, Target The 2016 quarterly s e s and projected sale price per units follows As note that that projected sales and projected production for Quarter of 2017 is 10,000 units Product Cost Assumptions The company's product requires two materials, resistors and switches Cost parameters are as follo Quis 2000 40 mer of Come Un estors En het verhoudhon water bute e gtory for direct mandh e d Sales Budget of Units Price per Unit Total Sales $ Budgeting project Desired Ending Beg G units to produce Direct Matca Budget Production units DM per T OM required Desired Ending OM Seg OM cost per DM unit the assumptions presented, prepare the following schedules (showing quarterly and annual amounts where applicable) Budget Suction Budget ct Materials Purchases Budget ect Labor Budget nufacturing Overhead Budget Tes Revenue e Eastern Technology Company manufactures Weather Radios for sale to retailers such as Wal-Mart, Target, etc me 2016 quarterly unit sales estimates and projected sales prices per unit are as follows: Quarter 3 Our Quarter 2 500 0200 9.200 $90 Also, note that that projected sales and projected production) for Quarter 1 of 2017 is 10,000 units Sales units Product Cost Assumptions The company's product requires two raw materials, resistors and switches Cost parameters are as folloca per Number of Components/Unit Switches @ 54/switch Resistors @ switch Number of minutes reguleed to complete Eished at Drechs unit Machine wants per unit Hour rates used Direct labor rates $10/hour Estem applies manufacturing overhead using two cost drivers direct labor hours and machine hours Manufacturing overhead rates (ie, the Ending Inventories PDOHRs to use to apply overhead) The desired ending inventories for each of the two direct materials is 10% of the next quarter's respective a quarter's budgeted sales nits Beginning inventory for direct materials and finished goods are assumed to Labor related $25/hour Machine related $40/hour Total Sales Budgeting project Production Budget Sales units Desired Ending Beg TG Units to produce Direct Materials Budget Suitches LILI DM per unit Med Desired Ending DM BOM Mets to purchase CopOM Direct Materials Budget Resistor OM Total OM required BegOM Cover OM Perkasa DM Cort per un peu OL Copertured Budgeting project Total OH costs OH Cost per unit produced X2 Total Product Cost per Unit Cost of Goods Sold S $ 1 S tal-Mart, Target, etc. Quarter 1 10 units Quarter 2 Quarter 3 9.300 19,500 $90 $90 Quarter 4 9400 S90 Sales units $90 are as follo Price per unit Number of Components/Unit Switches @ S4/switch Resistors @ $8/switch 2 Number of minutes required to complete finished unit Direct labor minutes per unit Machine minutes per unit Hour rates used Direct labor rates $10/hour machine hours. Manufacturing overhead rates (i.e., the PDOHRs to use in apply overhead) quarter's respective a pods are assumed to Labor-related $25 hour Machine-related $40/hour Sired finished goods ending inve 22 Q3 NG your answers in the spaces provided below. Be sure to show how you arrived at your answers, with Excel formulas or calculations by and Sumit your a g ent to the stage in Canvas project involves creating a s ence of budgets based on particular sales production, and cost data. You will be asked to create a Sales Budget Production Budget and Budgets for Direct Materials, Direct Labor and anufacturing Overhead as part of this project. The budgets need to be created in the correct sequences one leads to the next. The overarching goal of this exercise is to see the value of the budgeting process sing the sumptions presented, prepare the following schedules showing quarterly and w o unts where applicable les Budget roduction Budget rect Materials Purchases Budget Direct Labor Budget Manufacturing Overhead Budget Sales Revenge The Easter Technology Company manufactures Weather Radios for sale to rea c h awal Mart, Target The 2016 quarterly s e s and projected sale price per units follows As note that that projected sales and projected production for Quarter of 2017 is 10,000 units Product Cost Assumptions The company's product requires two materials, resistors and switches Cost parameters are as follo Quis 2000 40 mer of Come Un estors En het verhoudhon water bute e gtory for direct mandh e d Sales Budget of Units Price per Unit Total Sales $ Budgeting project Desired Ending Beg G units to produce Direct Matca Budget Production units DM per T OM required Desired Ending OM Seg OM cost per DM unit