Attached is what I am needing assistance with. Thank you.

Managerial Accounting - Final exam Part 2 - Excel Part (70 points) Name: Complete and put in drop box. Show all work! There are 7 problems! Problem 1 (4 points each = 8 points) Using the High-Low Method, Please determine the amount of Variable Cost per unit and the total Fixed Cost. Show your work. Total costs $ 100,000 $ 80,000 High Month Low Month Total Miles 6,000 4,000 A. Variable Cost per unit: B. Fixed Cost per month: Problem 2 (4 points each = 16 points) Given the following Income statement for ABC company, answer the following questions. Show your work. Sales (10,000 units sold) $150,000 Less V.C. 80,000 CM 70,000 Less F.C. 50,000 Net Income (profit) $20,000 A. What is the Contribution Margin per unit? B. What is the Contribution Margin ratio? (take to nearest %) C. What is the Break even point in units? (take to nearest unit) D. How many units would need to be sold to make a total net income of $120,000? (take to nearest unit) Problem 3 (4 points each = 8 points) Using the following Information, determine the overhead to be applied to each activity and in total. Activity Inspection hours Setup hours Machine hours Product A 100 40 50 Product B 200 20 150 A. What is the MOH applied to each activity and in total for Product A? Product A Inspection hours Setup hours Machine hours Total MOH Applied B. What is the MOH applied to each activity and in total for Product B? Product B Inspection hours Setup hours Machine hours Total MOH Applied MOH Application rate $20 per hour $10 per set up $30 per hour Problem 4 (5 points each = 10 points) Using the following information, answer the questions below. Direct Materials $10 Direct Labor $8 Variable MOH $5 Fixed MOH $100,000 Variable Selling & Administrative $4 Fixed Selling & Administrative $200,000 Units Produced 50,000 A. What is the cost per unit under the absorption method? Show your work. B. What is the cost per unit under the variable method? Show your work. Problem 5 (10 points) Complete the production Budget. Desired ending inventory is 20% of next month's sales. Assume this was met for March and carried to April's beginning inventory. July sales are expected to be 7,000 units. Sales (Units) Desired ending Inv. Total needs Less Beg. Inv. Units to produce April 4,000 May 5,000 June 6,000 Total Problem 6 (6 points each = 12 points) Direct material Price Variance is (AQ * AP) - (AQ * SP) or (AP - SP)AQ. A company developed the following per-unit standard for its product: direct materials at $5 per pound. Last month, 2,000 pounds of direct materials were actually purchased for $10,400. The direct materials price variance for last month was: Please show work. Direct material Quantity Variance is (AQ * SP) - (SQ * SP) or (AQ - SQ)SP. The per-unit standards for direct materials are 2 gallons at $5 per gallon. Last month, 11,000 gallons of direct materials was actually used to produce 6,100 units of product. The direct materials usage (quantity) variance for last month was: Please show work. . Problem 7 (6 points) Use the following Table for this question. Present Value of an Annuity Periods 1 2 3 8% 0.926 1.783 2.577 9% 0.917 1.759 2.531 10% 0.909 1.736 2.487 A company has a minimum required rate of return of 9% and is considering investing in a project that costs $160,000 and is expected to generate cash inflows of $60,000 at the end of each year for three years. The net present value of this project is: Please show work