please do it asap

M 12.0 marks The Majic Carpet Co. manufactures area rugs as well as various grades of carpet. The assistant controller is analyzing operating results over the past weeks to estimate indirect manufacturing costs at its main plant Previously the company had forecasted overhead costs using direct labour manufacturing hours, but with recent changes including equipment upgrades and automation this is under review. Data for the past weeks is listed below: 5 2 B 9 10 11 week week 2 Week 3 we weeks week o week? DML hours Mach hour costs 10 11000 $31.500 112 7500 S16,000 112 10400 $20.000 160 14200 $27.000 101 9700 $17.000 120 362.000 118 13200 $3250 $19.500 1 14 15 16 133 20000 Required: 50 1 Complete a regression analysis using his DML hours as independent variable and then she une machine hours an independent variable Develop a cost formula for each independent variable and determine the 2 (goodness of t) for each. Based on these calculations explain which coul driver should be used to forecast indirect manufacturing costs 20 21 OOOO READY SONY 14 35 2 Now using your preferred cost formula, forecast the Indirect mandacturing costs for week 12 20 mars 39 40 1 40 20 marts 3 Based on the regression results, complete the following tablet Economie plausibility Goodness off 55 50 4 The assistant controller decided to run a multiple regression on the data using both DML hours and Machine hours, which produced the following output 3 SUMMARY OUTPUT 102 04 RENDY SONY M 32 33 34 55 56 37 4 The assistant controller decided to run a multiple regression on the data using both DML hours and Machine hours, which produced the following output ANOVA df 53 100 61 SUMMARY OUTPUT Regression States Multiple 123801041827 Rsque 157292707596 Adjusted Square102097906343 Standard Ener 190376677519 Obitions Regression Residual SS MS sono 26102028334526241 79730393111397427 31094751850618950 79177 intercept DML hours Mach houn Core Standard Pro Star FOR LOW SNUDOS LOS 10267182671801236235131005835558 0752530767612412176361058103051741210.36165 56798400111175582705094940190041507017117217763075016625828842177410760146250288 195.201220121242748375178667288564150115893189290291067764210201310658747756 a) Using this information, prepare a cost formula with both labour hours and machine hours as cost drivers b) Does the simple regression or multiple repression provide a more accurate forecast? Explain 20 mare 71 LADY SONY 067 4 The assistant controller decided to run a multiple regression on the data ning both DML hours and Machine hours, which produced the following output ME SUMMARY OUTPUT Regreso M 09101023 0.99517221010 Adjusted R 0917900706143 Standard 9049190176679319 Oh SS 2876241/2002 SOCOSLO SETTSTEDEGA TOOTSCHOEBET Region Residual Total SUTSE T25GOS 934.661855030 7 17107 JOSE SESEOSEST SOSET DML hours Math hon DES Storer LON US URSS 150.17 211.6021410151263908835 SOPUST 5000.01230124GL17016505601 SOLLT 521250750400 2463817559270509264676936940190000450825079827111 LM27727 128 500186 187131142143135404 15.00 D132060712672857 3.00168114151152 B3818379104 LTS a) Using this information, prepare cost formula with both labeur hours and machine heurs cost drivers b) Does the simple renon or multe regression provide a more at foresat? Explain LOY SONY M 12.0 marks The Majic Carpet Co. manufactures area rugs as well as various grades of carpet. The assistant controller is analyzing operating results over the past weeks to estimate indirect manufacturing costs at its main plant Previously the company had forecasted overhead costs using direct labour manufacturing hours, but with recent changes including equipment upgrades and automation this is under review. Data for the past weeks is listed below: 5 2 B 9 10 11 week week 2 Week 3 we weeks week o week? DML hours Mach hour costs 10 11000 $31.500 112 7500 S16,000 112 10400 $20.000 160 14200 $27.000 101 9700 $17.000 120 362.000 118 13200 $3250 $19.500 1 14 15 16 133 20000 Required: 50 1 Complete a regression analysis using his DML hours as independent variable and then she une machine hours an independent variable Develop a cost formula for each independent variable and determine the 2 (goodness of t) for each. Based on these calculations explain which coul driver should be used to forecast indirect manufacturing costs 20 21 OOOO READY SONY 14 35 2 Now using your preferred cost formula, forecast the Indirect mandacturing costs for week 12 20 mars 39 40 1 40 20 marts 3 Based on the regression results, complete the following tablet Economie plausibility Goodness off 55 50 4 The assistant controller decided to run a multiple regression on the data using both DML hours and Machine hours, which produced the following output 3 SUMMARY OUTPUT 102 04 RENDY SONY M 32 33 34 55 56 37 4 The assistant controller decided to run a multiple regression on the data using both DML hours and Machine hours, which produced the following output ANOVA df 53 100 61 SUMMARY OUTPUT Regression States Multiple 123801041827 Rsque 157292707596 Adjusted Square102097906343 Standard Ener 190376677519 Obitions Regression Residual SS MS sono 26102028334526241 79730393111397427 31094751850618950 79177 intercept DML hours Mach houn Core Standard Pro Star FOR LOW SNUDOS LOS 10267182671801236235131005835558 0752530767612412176361058103051741210.36165 56798400111175582705094940190041507017117217763075016625828842177410760146250288 195.201220121242748375178667288564150115893189290291067764210201310658747756 a) Using this information, prepare a cost formula with both labour hours and machine hours as cost drivers b) Does the simple regression or multiple repression provide a more accurate forecast? Explain 20 mare 71 LADY SONY 067 4 The assistant controller decided to run a multiple regression on the data ning both DML hours and Machine hours, which produced the following output ME SUMMARY OUTPUT Regreso M 09101023 0.99517221010 Adjusted R 0917900706143 Standard 9049190176679319 Oh SS 2876241/2002 SOCOSLO SETTSTEDEGA TOOTSCHOEBET Region Residual Total SUTSE T25GOS 934.661855030 7 17107 JOSE SESEOSEST SOSET DML hours Math hon DES Storer LON US URSS 150.17 211.6021410151263908835 SOPUST 5000.01230124GL17016505601 SOLLT 521250750400 2463817559270509264676936940190000450825079827111 LM27727 128 500186 187131142143135404 15.00 D132060712672857 3.00168114151152 B3818379104 LTS a) Using this information, prepare cost formula with both labeur hours and machine heurs cost drivers b) Does the simple renon or multe regression provide a more at foresat? Explain LOY SONY