The project involves creating a sequence 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 Manufacturing Overhead as part of this project. The budgets need to be created in the correct sequence as one leads to the next. The over-arching goal of this exercise is to see the value of the budgeting process. Will someone check my work for me please?

Instructions The project involves creating a sequence 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 Manufacturing Overhead as part of this project. The budgets need to be created in the correct sequence as one leads to the next. The over-arching goal of this exercise is to see the value of the budgeting process. Using the assumptions presented, prepare the following schedules (showing quarterly and annual amounts where applicable): a. Sales Budget b. Production Budget c. Direct Materials Purchases Budget d. Direct Labor Budget e Manufacturing Overhead Budget Sales Revenue The Eastern Technology Company manufactures Weather Radios for sale to retailers such as Wal-Mart, Target, etc. The 2016 quarterly unit sales estimates and projected sales prices per unit areas follows: Sales units Price per unit Quarter 1 Quarter 2 Quarter 3 Quarter 4 9,200 9,300 9,500 9.400 $90 $90 S90 $90 Also, note that that projected sales (and projected production) for Quarter 1 of 2017 is 10,000 units Product Cost Assumptions The company's product requires two raw materials, resistors and switches. Cost parameters are as follows: Number of Components/Unit Switches @ $4/switch 3 Resistors @ $8/switch 2 Number of minutes required to complete finished unit Direct labor minutes per unit 30 Machine minutes per unit 12 Hour rates used Direct labor rate= $10/hour Manufacturing overhead rates (i.e., the PDOHRs to use to apply overhead) Labor-related= $25/hour Machine-related=$40/hour Eastern applies manufacturing overhead using two cost drivers: direct-labor hours and machine hours. Ending Inventories The desired ending inventories for each of the two direct materials is 10% of the next quarter's respective amount of direct materials needed for production. The desired finished goods ending inventory is 5% of the next quarter's budgeted sales units. Beginning inventory for direct materials and finished goods are assumed to be zero as of 1/1/2016. a) Sales Budget Q1 Q1 Q2 Q3 Q4 # of Units Price per Unit Total Sales $ 9,200 $90 $828,000 9,300 $90 $837,000 9,500 $90 $855,000 9,400 $90 $846,000 b) Production Budget 9,200 465 Sales units Desired Ending FG Beg FG Units to produce 9,300 475 465 9,310 9,500 470 475 9,495 9,400 500 470 9,430 0 9,665 c) Direct Materials Budget - Switches 9,495 m 9,665 3 28,995 2,793 Production units DM per unit Total DM required Desired Ending DM Beg DM Units to purchase Cost per DM unit DM Purchases 9,310 3 27,930 2,849 2,793 27,986 4 111,944 28,485 2,828 2,849 28,464 4 9,430 3 28,290 3,000 2,828 28,462 4 113,848 31,788 4 127,152 113,856 Direct Materials Budget - Resistors 9,310 9,495 2 9,665 2 19,330 1,862 Production units DM per unit Total DM required Desired Ending DM Beg DM Units to purchase Cost per DM unit DM Purchases 18,620 1,899 1,862 18,657 18,990 1,886 1,899 18,977 9,430 2 18,860 2,000 1,886 18,974 8 151,792.00 $ 21,192 8 169,536.00 $ 8 8 $ 149,256.00 $ 151,816.00 $ 622,400.00 Total DM Purchases Cost DM Cost per unit produced $ $ 296,688.00 30.70 $ $ 261,200.00 $ 28.06 $ 265,672.00 $ 27.98 $ 265,640.00 $ 1,089,200.00 28.17 d) Direct Labor Budget Production units DL Hours per unit DL Hours required DL Rate per Hour Total DL Cost DL Cost per unit produced 9,665 0.50 4,832.50 10.00 48,325.00 5.00 9,310 0.50 4,655.00 10.00 $ 46,550.00 $ 5.00 $ 9,495 0.50 4,747.50 10.00 $ 47,475.00 $ 5.00 $ 9,430 0.50 4,715.00 10.00 $ 47,150.00 $ 5.00 $ $ $ $ $ $ 40.00 189,500.00 e) Manufacturing Overhead Budget 25 25 Labor-related rate per hour DL hours required Labor-related OH cost 4,832.50 120,812.50 $ 25 4,655.00 116,375.00 $ 25 4,747.50 118,687.50 $ 4,715.00 117,875.00 $ 40 40 Machine-related rate per hour Machine hours required Machine-related OH cost 40 1,933 77,320.00 $ 40 1,862 74,480.00 $ 1,899 75,960.00 $ 1,886 75,440.00 $ Total OH costs OH Cost per unit produced $ $ 198,132.50 $ 20.50 190,855.00 $ 20.50 $ 194,647.50 $ 20.50 193,315.00 20.50 $ Total Product Cost per Unit Cost of Goods Sold $ $ 56.20 $ 543,173.00 53.56 $ 498,643.60 $ 53.48 $ 507,792.60 53.67 506,108.10 $