Create a new Coast Jewelers' Cost Analysis a. Using the ch7-02 file to start your work, create

Question:

Create a new Coast Jewelers' 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 550 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 550 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 displayed 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 in Value view.
d. Print the resulting worksheet in Formula view.