Please complete all requirements of questions E21-30 & E21-31 in excel sheet.

thank you!

Learning Objective 1 3. 54,300 E21-30 Determining mixed costs the high-low method The manager of Quick Car Inspection reviewed the monthly operating costs for the past year. The costs ranged from $4,400 for 1.400 inspections to $4,200 for 1,000 inspections. Requirements 1. Calculate the variable cost per inspection 2. Calculate the total fixed costs. 3. Write the equation and calculate the operating costs for 1,200 inspections. 4. Draw a graph illustrating the total cost under this plan. Label the axes, and show the costs at 1,000,1,200, and 1,400 inspections. E21-31 Calculating contribution margin ratio, preparing contribution margin income statements For its top managers, Global Travel formats its income statement as follows: Learning Objective 2 2. $250,000 sales level, VC 587,500 X GLOBAL TRAVEL Contribution Margin Income Statement Three Months Ended March 31, 2016 Sales Revenue Verable Costa Contribution Margin Fie costs Operato come 5 318,500 111,475 207.025 175,000 5 32.025 Global's relevant range is between sales of $250,000 and $360,000. Requirements 1. Calculate the contribution margin ratio 2. Prepare two contribution margin income statements: one at the $250.000 sales level and one at the $360,000 sales level. (Hin The proportion of each sales dollar that goes toward variable costs is constant within the relevant range.) MacBook Air