Please complete in excel

Cost Estimation & CVP It is budget season and Margo, Inc is planning for next year and requires a breakdown of the factory overhead cost into the fixed and variable elements. The following data on the OH cost and machine hours are available for the past six months: Month January February March April May June Total OH Cost Machine Hours $ 23,910 1,800 $ 23,397 1,230 $ 24,153 2,070 $ 23,964 1,860 $ 23,732 1,602 $ 23,559 1,410 $ 142,715 9,972 Required: 1. Assume that Mago uses the high-low method of analysis, determine the variable OH cost per machine hour and monthly fixed cost Additional Sales & Cost information for Margo's Sales Price $ Machine Hours Per unit Direct Labor Hours Per Unit Direct labor cost per unit $ Direct Material cost per unit $ 75.30 2 2.5 40.00 18.50 2. How many units do they need to sell to breakeven in one month 3. How many units do they need to sell to earn a pre-tax profit of $52,410 in one month 4. Create a contribution margin income statement for the pre-tax profit of $52,410