E3.9 - Using Excel to Determine High and Low Points PROBLEM "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 Machine Hours Power Cost 1 28,000 $36,400 2 35,000 53,200 3 42,000 59,500 4 30,800 51,800 5 29,400 47,600 6 25,200 40,600 7 33,600 50,400 8 39,200 53,400 9 37,000 52,000 10 34,500 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 activities now, as the new supervisor is running a tight ship