For the past 2 years, Teagan has worked in a machining facility, helping the company track...

Transcribed Image Text:

For the past 2 years, Teagan has worked in a machining facility, helping the company track and record its wide variety of costs. She has organized the data quarterly, to correspond with the quarterly budget/actual meetings, with the following data obtained for power costs. Quarter 1 2 3 4 5 6 7 8 Machine Hours 28.000 35.000 42,000 30,800 29,400 25,200 33,600 39.200 Power Cost $36,400 53.200 59,500 51,800 47,600 40,600 50,400 53.400 10 37,000 34.500 Y=S Power costs used to be a mystery to the company before the new production supervisor came on board, just 6 months after Teagan started. Teagan heard through the grapevine that employees and management in the factory used to leave equipment running even when there was not an active production run in process. In other cases, they shut everything down right in the middle of a shift to celebrate employee milestones with cake. There are no such activities now, as the new supervisor is running a tight ship. 52,000 48,500 (c) Using regression analysis within Excel, run the regression model and generate the output. From the output, write out the full cost function in Y = m(X) + b format. (Round variable cost per unit to 3 decimal places, e.g. 15.256 and fixed cost to 2 decimal places, e.g. 15.25.) X+ $ For the past 2 years, Teagan has worked in a machining facility, helping the company track and record its wide variety of costs. She has organized the data quarterly, to correspond with the quarterly budget/actual meetings, with the following data obtained for power costs. Quarter 1 2 3 4 5 6 7 8 Machine Hours 28.000 35.000 42,000 30,800 29,400 25,200 33,600 39.200 Power Cost $36,400 53.200 59,500 51,800 47,600 40,600 50,400 53.400 10 37,000 34.500 Y=S Power costs used to be a mystery to the company before the new production supervisor came on board, just 6 months after Teagan started. Teagan heard through the grapevine that employees and management in the factory used to leave equipment running even when there was not an active production run in process. In other cases, they shut everything down right in the middle of a shift to celebrate employee milestones with cake. There are no such activities now, as the new supervisor is running a tight ship. 52,000 48,500 (c) Using regression analysis within Excel, run the regression model and generate the output. From the output, write out the full cost function in Y = m(X) + b format. (Round variable cost per unit to 3 decimal places, e.g. 15.256 and fixed cost to 2 decimal places, e.g. 15.25.) X+ $