B Health Source Hospital (HSH) has a standing contract with an air charter service to deliver critical medications throughout its service network. The contract calls for a fixed monthly payment plus a set of variable charges based on each flight's specific characteristics. The first table below includes information about total monthly cost and the number of flights. Below the table is a computational aid for estimating the fixed and variable cost components via the high-low method. Use the pick lists associated with each boxed area to select the high and low volumes. The remainder of the tables will automatically complete based on your selections. After correctly making each selection, the variable and fixed cost amounts will turn green. Carefully review the underlying logic of the calculations. 2 3 Flights Cost January 4 7 $ 23,180 February 5 14 43,780 March 6 11 29,880 7 April 18 48,600 8 May 21 55,200 June 9 16 46,410 10 July 8 26,600 August Problem 12 36,108 File Home Insert Draw Page Layout Formulas Data Review View Help 94 D 2 3 Flights Cost January 7 4 S 23.180 February 14 43.780 March 11 6 29,880 7 April 18 48,600 May 8 21 55,200 June 16 9 46,410 July 8 10 26,600 11 August 12 36,108 6 September 22,200 12 October 18 13 47.628 November 15 14 37.800 December 9 28,800 16 17 Flights Cost Highest level $ 18 19 Lowest level 20 21 Problem B D TH Flights Cost Highest level $ 3 9 Lowest level 0 1 Difference $ 22 23 Variable cost per flight (cost difference divided by flight difference) >>>> #DIV/0! 24 25 HIGH LOW 26 Total cost 27 #DIV/0! #DIV/0! Less: Variable cost (variable cost per flight X flights) 28 Fixed cost #DIV/0! #DIV/0! 29 30