Question nine through 21 please

Data Table 1 Month These he cells may be used for calculation Labor Hoon 123 February March 1,3 12 92 1.188 1.114 1 April May une 20 fully 11 Ant 12 September 23 October 14 November 15 December 16 Total Machine Hours 1.7525 125 2.2345 2.2005 20135 22055 LES 5 1.7735 1,6415 1.913 1.7525 2.2195 22.956 $ OH Costa Unit Migd 221.104 3.2 18,758 LON 6714 2333 6,615 214,621 219,848 6615 2952 3.535 204,00 5319 217,754 4,923 221.267 5.913 1996 4,50 198 559 2.56313 65.900 1.344 16 760 712 13164 Use the light Mecellowbove to show the results of running a linear regression 2.2355 MAX 10 MIN 344 760 584 230,335 1875 40577 6,714 OM 2.628 8765 21 V 22 FC 20 These lile cele may be ned for calculation 25 Use Data Table 1 tower the following Question The following awumption apply unless an alternative specifically given in a question The Pri Questo Data Hefore you are the required questions that you go to the Duta worksheet of data that is related butterent to the data displayed in the son warlier wax Yate that inades a trendline It is always a good idea to start your data analysis by looking at the ruw data to check to also to if there are anys trends You can change the value of the displayed scatter graph by electing the ach and Menu Data Chart Source Data This will bring up a pop up window. Select the box and then pick new range plot will update automatically since the plot up to include a trendline and the trendline you will see the results of amples region of the form 75278 LE Open record boost Your ont changes were and Do you want to you Options Ce weet 167 ves 5 75.75 2075 15.95 plot wilt rende interne place trendline the plan of the mens the form 5 with the youth woh between Condor hour machine 2156 the towing mumption apply este specifically in questo 29 The Sales O Direct material and direct labore per unit. Variable General and Administratives per I)e General and Administrative costs anth Marginal hurt. Awww these question by apply the ich wwwthod that the Overhead costs are estimated in labor Wut the estimated recuperor hour! What is the estimated monthly fed overhead Forecast monthly overhead costs for a month when there are equal to 9.651 Q1 These wewed for at 09 L100 011 1939 04 What is the number of labor hours per il What is your estimate of the variable overhead cont per unit What your estimate of the contribution marginperit! What is your estimate of total found cost per month 5 30 05 3 27 5 4. What your estimate of totale con per year 5 SON How many tits are required to heak-even 09 entre Question 1 09 $ 750,000 1774 Q10 4 How many units are required to break-event 55 56 How many units are required to earn an annual before tax profit equal to 37 se What is the after tax profit required to earn a before tax proof 53 60 How many units are required to earn an alte tax rolit equal to $ 750,000 750,000 Q11 $ 750.000 Q12 2271967) Q13 (2.889.674) Q14 (83,382) 015 62 What is the before tax profit if the number of its manufactured and all 150,000 6 4 What is the before tax profit in the manber of its manufactured and will ILOCOS GS 66 What is the before tax profia the number of units mamafactured and sold 210.000 67 Part 2 a in order to complete the remaining questions to the regression capabilities of Excel to estimate the following cost equation Monthly OH-bobl x labor hours b2x machine hours 70 71 Based on the results, what is the estimate of monthly fixed manufacturing OH costs? 72 73 What is the estimate of variable OH costs per labor hour? 016 017 What is the estimate of variable OH costs per machine hour? Q15 77 What are the estimated total OH costs for an average month based on the cost modell 019 If output where 10% higher than average what is your estimate of total Mig OH Costs? 920 11 If output where 15% higher than average what is your estimate of the contribution margin per unit? 021 Data Table 1 Month These he cells may be used for calculation Labor Hoon 123 February March 1,3 12 92 1.188 1.114 1 April May une 20 fully 11 Ant 12 September 23 October 14 November 15 December 16 Total Machine Hours 1.7525 125 2.2345 2.2005 20135 22055 LES 5 1.7735 1,6415 1.913 1.7525 2.2195 22.956 $ OH Costa Unit Migd 221.104 3.2 18,758 LON 6714 2333 6,615 214,621 219,848 6615 2952 3.535 204,00 5319 217,754 4,923 221.267 5.913 1996 4,50 198 559 2.56313 65.900 1.344 16 760 712 13164 Use the light Mecellowbove to show the results of running a linear regression 2.2355 MAX 10 MIN 344 760 584 230,335 1875 40577 6,714 OM 2.628 8765 21 V 22 FC 20 These lile cele may be ned for calculation 25 Use Data Table 1 tower the following Question The following awumption apply unless an alternative specifically given in a question The Pri Questo Data Hefore you are the required questions that you go to the Duta worksheet of data that is related butterent to the data displayed in the son warlier wax Yate that inades a trendline It is always a good idea to start your data analysis by looking at the ruw data to check to also to if there are anys trends You can change the value of the displayed scatter graph by electing the ach and Menu Data Chart Source Data This will bring up a pop up window. Select the box and then pick new range plot will update automatically since the plot up to include a trendline and the trendline you will see the results of amples region of the form 75278 LE Open record boost Your ont changes were and Do you want to you Options Ce weet 167 ves 5 75.75 2075 15.95 plot wilt rende interne place trendline the plan of the mens the form 5 with the youth woh between Condor hour machine 2156 the towing mumption apply este specifically in questo 29 The Sales O Direct material and direct labore per unit. Variable General and Administratives per I)e General and Administrative costs anth Marginal hurt. Awww these question by apply the ich wwwthod that the Overhead costs are estimated in labor Wut the estimated recuperor hour! What is the estimated monthly fed overhead Forecast monthly overhead costs for a month when there are equal to 9.651 Q1 These wewed for at 09 L100 011 1939 04 What is the number of labor hours per il What is your estimate of the variable overhead cont per unit What your estimate of the contribution marginperit! What is your estimate of total found cost per month 5 30 05 3 27 5 4. What your estimate of totale con per year 5 SON How many tits are required to heak-even 09 entre Question 1 09 $ 750,000 1774 Q10 4 How many units are required to break-event 55 56 How many units are required to earn an annual before tax profit equal to 37 se What is the after tax profit required to earn a before tax proof 53 60 How many units are required to earn an alte tax rolit equal to $ 750,000 750,000 Q11 $ 750.000 Q12 2271967) Q13 (2.889.674) Q14 (83,382) 015 62 What is the before tax profit if the number of its manufactured and all 150,000 6 4 What is the before tax profit in the manber of its manufactured and will ILOCOS GS 66 What is the before tax profia the number of units mamafactured and sold 210.000 67 Part 2 a in order to complete the remaining questions to the regression capabilities of Excel to estimate the following cost equation Monthly OH-bobl x labor hours b2x machine hours 70 71 Based on the results, what is the estimate of monthly fixed manufacturing OH costs? 72 73 What is the estimate of variable OH costs per labor hour? 016 017 What is the estimate of variable OH costs per machine hour? Q15 77 What are the estimated total OH costs for an average month based on the cost modell 019 If output where 10% higher than average what is your estimate of total Mig OH Costs? 920 11 If output where 15% higher than average what is your estimate of the contribution margin per unit? 021