B D G M N O P O A S T V 1 Functions: SLOPE, INTERCEPT; Cell Referencing 2 3 E3.9- Using Excel to Determine High and Low Points 4 PROBLEM 5 For the past 2 years, Teagan has worked in a machining 6 facility, helping the company track and record its wide variety 7 of costs. She has organized the data quarterly, to correspond 8 with the quarterly budget/actual meetings, with the following 9 data obtained for power costs. Quarter Machine Hours Student Work Area Required: Provide input into cells shaded in yellow in this template. Input the required mathematical formulas or functions with cell references to the Problem area or work area as indicated.. Calculate the variable and fixed components of power costs using the SLOPE and INTERCEPT functions in Excel. 10 11 Power Cost 12 1 28,000 $ 36,400 Slope 13 2 35,000 53,200 14 3 42,000 59,500 Intercept 15 4 30,800 51,800 16 5 29,400 47,600 Complete the cost equation. 17 6 25,200 40,600 18 7 33,600 50,400 Total cost= X + 19 8 39,200 53,400 20 9 37,000 52,000 21 10 34,500 48,500 22 23 Power costs used to be a mystery to the company before 24 the new production supervisor came on board, just 6 months 25 after Teagan started. Teagan heard through the grapevine 26 that employees and management in the factory used to leave 27 equipment running even when there was not an active 28 production run in process. In other cases, they shut everything 29 down right in the middle of a shift to celebrate employee 30 milestones with cake. There are no such activities now, as the 31 new supervisor is running a tight ship. 32 33 34 35 Enter Answer necessibility Investigate 1