Please answer the questions.

CVP Case with Mixed Costs Morrison Corporation is a small company that sells digital thermometers and other supplies to hospitals in the Phoenix, AZ area. The company employs one sales agent who earns both a salary and commission. Last year, Morrison Corporation purchased a new Subaru Impreza for $25,000 for the sales agent to use for 100% business transportation. The company controller estimated that the Impreza would have a five-year life and a residual value of S6,000. The company uses straight-line depreciation for all plant assets. The costs for this year specifically related to the Impreza are insurance for $1,000, fuel for $5,000 and other costs. The controller estimates that with the increase in fuel costs, that the amount next year for fuel will increase by 5%. The controller believes that the insurance cost will stay constant. The other costs include maintenance, fixing flat tires, oil changes, tickets, parking, car washes/detailing, etc. The other costs for the Impreza for each month of last year is below. Miles Driven Total Other Cost January 3,367 330 February 3,453 March 1256 140 April 4,892 490 May 1,629 400 June 5,478 518 July 5381 506 August 6.933 549 September 3.983 319 October 3,630 343 November 4.762 482 December 2815 261 Total 47578 The controller had prepared a Budgeted Income Statement for next year, but didn't include the costs for the Impreza. The Budgeted Income Statement is below: Morrison Corporation Budgeted Income Statement Sales 1,500,000 Commissions 75,000 Other Variable Costs 500.000 575.000 Contribution Margin 925,000 Fixed selling costs Fixed administrative costs Net Operating Income 400,000 300,000 700,000 225.000 Required: 1. Using the high-low method, determine the portion of "Other costs that are fixed (rounded to the nearest dollar) and the variable costs per mile (rounded two decimal places). 2. Prepare a budgeted contribution format income statement with the costs related to the Impreza included. It is estimated that the sales agent will drive 50,000 miles next year. 3. Using your budged contribution format income statement, calculate break even in sales. 4. The owner of the company would like to have profit of $250,000 next year, what volume of sales would be necessary to meet this target? 5. Write a memo to the owner of Morrison Corporation briefly explaining your work and giving recommendations as to how Morrison might achieve the $250,000 target profit. Deliverables Excel workbook using formulas for all required calculations. The workbook must be easy to follow and professionally formatted. The memo must be in the Excel workbook as a textbox. You must first post your good faith individual attempt at this case in your group discussion forum. You will then collaborate with your group to adjust and your group leader will post the Group Excel Workbook