Function USOU B1 4 * fx D 1 Enter tits and accounts in the green cells 2 Enter Numbers in the blue cells Enter your calculations in the yellow cells Unit 2 Cost Volume Profit Problem 4 High-Low Method Kalizmazoo Truck Rentals has a flat daily fee of $19.95, plus 39 cents per mile. Below is a table of Costs that Kalimazoo has incurred. Cost Miles January 22,500 6,000 February 20,000 5,000 March 19,500 4,000 April 19,000 3,800 May 21,500 5,500 23,200 6,200 June Calculate the expected overhead cost in July using the High-Iwo Method. 1 Determine the highest and lowest activities: Month Activity High Low Resources Problem 1 Problem 2 Problem 3 Proble4 Ready Create From Section Insert Function Lookup & Math & Reference Trig More Functions Remove Arrows Formulas 852 AutoSum Recently Financial Logical Text Date & Used Time x fx B C D EF A Low Amount 2 Calculate the Variable cost per unit High VC per unit Cost Activity per unit 3 Calculate fixed Costs Month Fixed Costs = Cost (vc x units) - Fixed costs 4 Calculate Variable costs for July Kalimazoo estimates that July will be a very busy month and expects that it will incur 7000 miles on its truck 7000 Variable Cost * Units Total Varible Costs = 4 Calculate Total Costs Variable Cost + Fixed Costs Total Costs Resources Problem 1 Problem 2 Problem 3 Proble4 Ready 9000981@HOTOOMAG MacBook Pro