Wo Morgan and Jesse Managerial eventing This assignment is w ho During 2019, se Potion will be de rsday, April 14,2030 recorded the following Man g Overdos Huilding Produced Lahat 7.2005 HONE FOR G A Leta $ Indirect Mas 263,100 264,900 267,500 271,300 372000 36.000 175.000 379.000 5 S 273.700 5 Paviy 729.400 5 307.000 391.000 281,400 279.900 51.400 $ November December 402,000 403.000 288.600 292.200 $ $ 747.300 5 751.000 5 763,00 5 765,100 $ 54 OS 56.400 $ Instructions Analyze the data using a combination of observation technis che Excel plate that is provided on-line and rated in class. As you observe the data consider whether the recorded cuts seem to project avane a fixed cost, or a semi-variable cost. Note that ariable d i able costs with a linea con progression show indicate a high correlation coefficient. If the cor n is high should not sure that the cost is predictable using the formulas generated by the Excel plate. Ale note the following additional data The company had to expand their facility when production reached 400,000 units during 2019. No cal expansions are expected until production reaches 480.000 units es charges include both Gas & Electric usage. The yas usage is primarily for heating the production facility. During 2019, the Gas portion of the electric bill was as follows: January 56.000 February & December - 55.000 March & November - $4,000. April & October - $2.000, and May & September -51.000. No gas was wed wuring the months of June, July & August. Mo Retter Production expects that gas charges will be up by 2016 2020 020, while electric charges will be up by 10. Please note: you are strongly encouraged to separate the gas and electric costs to see if the cost behaviors become more predictable. s expected that Indirect Materials costs will be unchanged, but Indirect Labor will cost 5% more than in 2019 analyzing the data, describe the nature of each cost and provide a model (either an algebraic formula of a Predicted value with a description of the expected changes) for predicting 2020 values for each on the cost After analyzing the data, deser Based upon these analyses, pred on these analyses, predict the 2020 overhead cost for each type of manufacturing overhead cost, and the acturing overhead budget, assuming each of the following monthly production levels a. 408,000 units for January b. 412,000 units for February c. 456,000 units for October suming further that 1.5 hours of direct lahor will be used to produce each unit, what would be the peace overhead rate, based upon direct labor hours, for each of the 3 months indicated above! Wo Morgan and Jesse Managerial eventing This assignment is w ho During 2019, se Potion will be de rsday, April 14,2030 recorded the following Man g Overdos Huilding Produced Lahat 7.2005 HONE FOR G A Leta $ Indirect Mas 263,100 264,900 267,500 271,300 372000 36.000 175.000 379.000 5 S 273.700 5 Paviy 729.400 5 307.000 391.000 281,400 279.900 51.400 $ November December 402,000 403.000 288.600 292.200 $ $ 747.300 5 751.000 5 763,00 5 765,100 $ 54 OS 56.400 $ Instructions Analyze the data using a combination of observation technis che Excel plate that is provided on-line and rated in class. As you observe the data consider whether the recorded cuts seem to project avane a fixed cost, or a semi-variable cost. Note that ariable d i able costs with a linea con progression show indicate a high correlation coefficient. If the cor n is high should not sure that the cost is predictable using the formulas generated by the Excel plate. Ale note the following additional data The company had to expand their facility when production reached 400,000 units during 2019. No cal expansions are expected until production reaches 480.000 units es charges include both Gas & Electric usage. The yas usage is primarily for heating the production facility. During 2019, the Gas portion of the electric bill was as follows: January 56.000 February & December - 55.000 March & November - $4,000. April & October - $2.000, and May & September -51.000. No gas was wed wuring the months of June, July & August. Mo Retter Production expects that gas charges will be up by 2016 2020 020, while electric charges will be up by 10. Please note: you are strongly encouraged to separate the gas and electric costs to see if the cost behaviors become more predictable. s expected that Indirect Materials costs will be unchanged, but Indirect Labor will cost 5% more than in 2019 analyzing the data, describe the nature of each cost and provide a model (either an algebraic formula of a Predicted value with a description of the expected changes) for predicting 2020 values for each on the cost After analyzing the data, deser Based upon these analyses, pred on these analyses, predict the 2020 overhead cost for each type of manufacturing overhead cost, and the acturing overhead budget, assuming each of the following monthly production levels a. 408,000 units for January b. 412,000 units for February c. 456,000 units for October suming further that 1.5 hours of direct lahor will be used to produce each unit, what would be the peace overhead rate, based upon direct labor hours, for each of the 3 months indicated above