please use excel formulas to find the answer

2 Wrap Text til lille Patte Custom Merge & Center $ %) Conditions Formu Formatting as Table Style A B G Student Work Area Required: Provide input into cells shaded in yellow in this temple. Use the MAX, MIN, SLOPE, and INTERCEPT functions with cell references to the Problem or work, and mathematical formulas with cell references to the Problem of work areas indicated Liberation Sans 12 "" BIU A AA29 Xfx D 2 3 12.10 - Using Excel to Use the High-Low Method PROBLEM 5 Aller graduating from dental school two years ago, Dr. Lauren Parish 6 purchased the dental practice of a long-time dentist who was retiring. She 7 purchased the practice in January of this year and immediately had to replace the Boutdated autoclave equipment she inherited from the previous dentist. Now, as 9 she is preparing her budget for next year, she is concerned about understanding 10 how her cost for sterling her dental instruments has changed. She has 11 gathered the following information from her records 12 13 14 15 Number of Instruments Total Autoclave 16 Month Used Cost 17 January 8SOS 7,600 18 February 750 6,800 19 March 920 8,200 20 April 950 8,600 May 1,150 9.900 22 June 900 8,100 23 July 1,050 9.600 August 975 8,700 25 26 27 23 29 30 21 12 Use Excel MAX and MIN functions to ideally the high and low data point to be used with the high-low method. Then use the SLOPE function to determine the variable cost per unit of sterilizing an instrument using the new equipment Activity Love Cost High activity level Low activity level Variable cost per unit Use Excel INTERCEPT function to determine the fixed cost of the wolve equipment? Total fixed costs What is the cost formula that Dr Farish should use for estimating autoclave lition costs for next year's budget? Total cost ) Dr Farish is estimating instruments for next month, what cost should be include in het budget for instrumenter for the following estimate 34 15 Nurse of instruments 900 Budgeted cost Enter Answer + 2 Wrap Text til lille Patte Custom Merge & Center $ %) Conditions Formu Formatting as Table Style A B G Student Work Area Required: Provide input into cells shaded in yellow in this temple. Use the MAX, MIN, SLOPE, and INTERCEPT functions with cell references to the Problem or work, and mathematical formulas with cell references to the Problem of work areas indicated Liberation Sans 12 "" BIU A AA29 Xfx D 2 3 12.10 - Using Excel to Use the High-Low Method PROBLEM 5 Aller graduating from dental school two years ago, Dr. Lauren Parish 6 purchased the dental practice of a long-time dentist who was retiring. She 7 purchased the practice in January of this year and immediately had to replace the Boutdated autoclave equipment she inherited from the previous dentist. Now, as 9 she is preparing her budget for next year, she is concerned about understanding 10 how her cost for sterling her dental instruments has changed. She has 11 gathered the following information from her records 12 13 14 15 Number of Instruments Total Autoclave 16 Month Used Cost 17 January 8SOS 7,600 18 February 750 6,800 19 March 920 8,200 20 April 950 8,600 May 1,150 9.900 22 June 900 8,100 23 July 1,050 9.600 August 975 8,700 25 26 27 23 29 30 21 12 Use Excel MAX and MIN functions to ideally the high and low data point to be used with the high-low method. Then use the SLOPE function to determine the variable cost per unit of sterilizing an instrument using the new equipment Activity Love Cost High activity level Low activity level Variable cost per unit Use Excel INTERCEPT function to determine the fixed cost of the wolve equipment? Total fixed costs What is the cost formula that Dr Farish should use for estimating autoclave lition costs for next year's budget? Total cost ) Dr Farish is estimating instruments for next month, what cost should be include in het budget for instrumenter for the following estimate 34 15 Nurse of instruments 900 Budgeted cost Enter Answer + Student Work Area Required: Provide input into cells shaded in yellow in this template. Use the MAX, MIN, SLOPE, and INTERCEPT functions with cell references to the Problem area or work area, and mathematical formulas with cell references to the Problem or work area as indicated. a. Use Excel's MAX and MIN functions to identify the high and low data points to be used with the high-low method. Then use the SLOPE function to determine the variable cost per unit of sterilizing an instrument using the new equipment. Activity Level Cost High activity level Low activity level Variable cost per unit b. Use Excel's INTERCEPT function to determine the fixed cost of the autoclave equipment? Total fixed costs c. What is the cost formula that Dr. Farish should use for estimating autoclave sterilization costs for next year's budger? Total cost ) + d. Dr. Farish is estimating instruments for next month, what cost should she include in her budget for instrument sterilization for the following estimate? Number of instruments 900 Budgeted cost