N$13$

Functions: SLOPE, WTERCEPT; Cell Referencing

E$3\mathrm{.}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.

$\backslash$table$[[$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.

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.

Conditional Format

Cell

Delete

Forme