Question: Generate and compare high-low and regression models. E3.9 (LO 2, 3), AN An icon reads, Excel. For the past 2 years, Teagan has worked in
Generate and compare high-low and regression models. E3.9 (LO 2, 3), AN An icon reads, Excel. 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. An excel spreadsheet displays three columns, and the column headers are: Quarter, Machine Hours, and Power Cost. The data are as follows:Quarter, 1; Machine Hours, 28,000; Power Cost, $36,400;Quarter, 2; Machine Hours, 35,000; Power Cost, 53,200;Quarter, 3; Machine Hours, 42,000; Power Cost, 59,500;Quarter, 4; Machine Hours, 30,800; Power Cost, 51,800;Quarter, 5; Machine Hours, 29,400; Power Cost, 47,600;Quarter, 6; Machine Hours, 25,200; Power Cost, 40,600;Quarter, 7; Machine Hours, 33,600; Power Cost, 50,400;Quarter, 8; Machine Hours, 39,200; Power Cost, 53,400;Quarter, 9; Machine Hours, 37,000; Power Cost, 52,000;Quarter, 10; Machine Hours, 34,500; Power Cost, 48,500. 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 activit
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
