2 a. Create a new What SUP Cost Analysis 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) Print the resulting worksheet. c. What SUP Ch 07-02 Predicting Costs Quarter 1st 2nd 3rd 4th Hours Open 1200 1800 1500 Expense 16,000 22,000 19,000 20,000 1400 High Expense Low Expense Difference Prediction of expense if open 2,000 hours = Hi-Lo Method Variable cost/hour open Fixed cost Least Squares / Regression Method Variable cost/hour open Fixed cost