Unit 2 Assignment - Cost Volume Profit Submi Assignment ents Due Sunday by 11:59pm Points 80 Submitting a text entry box or a file upload Instructions In this assignment we will explore Cost-Volume-Profit (CVP) which examines how costs behave Specifically, we will look at fixed and variable costs to see how changes in each affect profitability. Download the assignment template and complete the problems on each tab. In this assignment Problem 1 - Basic CVP problem Problem 2 - Intermediate CVP Problem Problem 3 - Advanced CPV Problem Problem 4 - Mixed Cost problem Assignment Objectives Differentiate between the available costing methods. Deliverables When you have finished, rename the file using your first initial, last name, course number and assignment number (for example "Doe_AC306_A2.xlsx"). Estimated time to complete: 4 hours Assignment File(s) B1 x vfx 1 Enter tits and accounts in the green cells 2 Enter Numbers in the blue cells 3 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 5,000 March 19,500 4,000 April 19,000 3,800 May 21,500 5,500 June 23,200 6,200 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 Problem 4 Ready Paste Merge & Conter $ % ) Condition Formattin B54 F G H I L N fx E 2 Calculate the Variable cost per unit High VC per unit = Cost Activity - Low Amount 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 X Units Total Varible Costs = 4 Calculate Total Costs Variable Cost + Fixed Costs Total Costs Resources Problem 1 Problem 2 Problem 3 Problem 4 Ready