Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

How To Audit ISO 9001 2015 A Handbook For Auditors

Authors: Chad Kymal

1st Edition

087389927X, 978-0873899277

More Books

Students also viewed these Accounting questions

Question

5. How would you describe your typical day at work?

Answered: 1 week ago

Question

7. What qualities do you see as necessary for your line of work?

Answered: 1 week ago