Create a new What SUP Cost Analysis
a. Using the ch7-02 file to start your work, create a worksheet to do the following:
i. Calculate the Hi-Lo Method variable cost/hour open and fixed cost.
ii. Predicted expense under the Hi-Lo Method assuming 2,000 open hours.
iii. Calculate the Least Squares/Regression Method variable cost/hour open and fixed cost.
iv. Predicted expense under the Least Squares/Regression Method assuming 2,000 open hours.
v. Display a chart of Expense/Hours Open with a trend line. (be sure to modify each axis so your scatter diagram is better dis-played as you did in the chapter)
b. Save the file as ch7-02_student_name (replacing student_name with your name).
c. Print the resulting worksheet.