ab - M3 A Directions v Search References Mailings Review View Help a- O 0 E Normal No Spacing Heading 1 Editing Dictate 24 Paragraph Styles Voice Expenses column. 12. Enter a formula in cell K7 that subtracts the lowest Cleaning Expenses value from the highest Cleaning Expenses value. 13. Copy cell K7 and paste it into cell L7 such that only the formula is pasted without any of the formats from cell K7 14. Enter a formula in cell L9 that divides the Cleaning Expenses High Low Difference (cell K7) by the Actual Occupancy High Low Difference (cell L7). The output of this formula shows the variable cost per occupancy day portion of the cleaning expenses per month. As mentioned in the description for this exercise, the cleaning expense is a mixed cost, which means it is comprised of both a variable and fixed cost. 15. Enter a formula in cell L10 that calculates the fixed cost portion for the cleaning expenses per month. Since we have calculated the variable cost per occupancy day, we can use it to calculate the fixed expense. First calculate the total variable expense by multiplying the variable expense per occupancy day in cell L9 by the High Actual Occupancy days in cell L5. Then, subtract this amount from the High Cleaning Expense in cell K5. Hint: You will have to put the calculation for the total variable expense in parentheses. 16. Enter the number 3500 in cell K12. Notice this cell is shaded yellow. Shading a cell is sometimes used to indicate a value that needs to be entered in order to produce an output. In this case, the value of 3,500 will be used to estimate the cleaning expenses. 17. Enter a formula in cell L13 that calculates the estimated cleaning expenses given the number that was entered into cell K12. Since the variable cost per occupancy day and the fixed cost is calculated in cells L9 and L10, these results can be used to estimate the cleaning expenses. The formula to estimate this mixed cost can be expressed as: Y=A+BX On 12 Accessibility: Good to go Q Seare P 19 144 10 11 DDI 12AutoSave On Fg ~ ~ = Excel Lab M3 Part A - Chapter 4_DA_Exercise_... . Saved V Search File Home Insert Page Layout Christensen, James K. C Formulas Data X Review View Automate Help Arial - 12 ) A" A " = Comments Custom Share lil Conditional Formatting Paste Insert B I U - - S- A - ~ % " E- AP O E Format as Table ~ Delete Sort & Find & Analyze Sensitivity Clipboard Font Cell Styles Format ~ Add-ins ~ Filter * Select Data Alignment Number Styles Cells 1 10 v : X V fx Editing Analysis Sensitivity Add-ins D E G H M N 2 Number of Rooms 45 Hotel Cost Analysis 3 Occupants per Room 45.925 $ 88,295 (High - Low Method) Days in Hotel Actual Cleaning Cleaning Actual 4 Year Month Month Capacity Occupancy Capacity Expenses Expenses Occupancy 2019 January 31 5,580 4,370 0.78 $ 8, 118 High $ 9,577 5,412 2019 February 28 5,040 3, 715 0.74 $ 7,201 Low $ 1,887 2,062 10 00 - 1 UT 2019 March 31 5,580 2,062 0.37 $ 4,887 High Low Difference $ 4,690 $ 3,350 2019 April 30 5,400 3,350 0.62 $ 6,690 2019 May 31 5,580 4, 124 0.74 $ 7,774 Variable Cost per Occupancy Day $ 1.40 10 2019 June 30 5,400 5,412 1.00 $ 9,577 Fixed Cost 11 2019 July 31 5,580 4,218 0.76 $ 7,905 12 2019 August 31 5,580 4,640 0.83 $ 8,496 Plan Occupancy Days 3,500 13 2019 September 30 5,400 3,866 0.72 $ 7,412 Estimated Cleaning Expense 14 2019 October 31 5,580 2,513 0.45 $ 5 , 518 15 2019 November 30 5,400 2, 513 0.47 $ 5 , 518 16 2019 December 31 5.580 5,142 0.92 $ 9, 199 Months of Data 12 17 18 Dominate 19 Cost Analytics + Sunday, September 3, 2023 Enter Accessibility: Investigate 5:47 PM 9/3/2023 88 F Q Search X Mostly sunny hp pre sc delete Insert 10144 10 - 11