Please show work so I can see formulas to use in excel. Thank you. I need help with Questions 7-15. I completed Question 13.

Diego Company manufactures one product that is sold for $76 per unit in two geographic regions--the East and West regions. The following information pertains to the company's first year of operations in which it produced 47,000 units and sold 42,000 units Variable costs per unit: Manufacturing Direct naterials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year Fixed manufacturing overhead Fixed selling and administrative expense $ 26 $10 52 $ 987,000 $ 475,000 The company sold 32,000 units in the East region and 10,000 units in the West region. It determined that $210,000 of its fixed selling and administrative expense is traceable to the West region, $160.000 is traceable to the East region and the remaining $105,000 is a common fixed expense. The company will continue to incur the total amount of its fixed manufacturing overhead costs as long as it continues to produce any amount of its only product F G H B D E Diego Company Cost Structure 3 Price/unit $76 East Sales Growth 4 DM $26 West Sales Growth SDL $10 West Advertising Increase 6 VMOH $2 MS8%AE $4 8 FMOH $987,000 9 10 East West Common Total 11 FS&AE $425,000 12 Units Produced 47,000 13 Units Sold 32,000 10,000 42,000 14 15 #1 16 What is the unit product cost under variable costing? 17 OM $26 18 DL $10 19 VMOH $2 20 Unit Product Cost $38 21 02 22 What is the unit product cost under absorption costing? 23 DM $26,00 24 DL $10.00 25 VMOH $2.00 26 FMOH $987,000.00 27 Unit Product Cost 559.00 E94 Jx A B 28 29 #3 30 What is the company's total contribution margin under variable costing? 31 Sales Price $76 32 Unit Product Cost $59 33 VS8 AE $4 34 CM/Unit $13 35 Units Sold 42,000 36 Total Contribution Margin $546,000 CM Ratio 37 #4 38 What is the company's net income (loss) under variable costing? 39 Total Contribution Margin $546,000 40 FMOH $987,000 41 FS&AE $475,000 42 Net Income (Loss) ($916,000) 43 #5 44 What is the company's gross margin under absorption costing? 45 Sales Price $76 46 Units Sold 42,000 47 Total Sales $3,192,000 48. COGS $2,773,000 49 Gross Margin $419,000 SO 6 51 What is the company's net income (loss) under absorption costing? 52. Gross Margin $419,000 53 S&AL $643,000 54 Net Income (Loss) $224,000 Sheet1 Ready 194 G H H A B D E F 5S #2 56. What is the amount of difference between the variable costing and absorption costing net operation incomes (losses) 57 Variable Costing Net Income (Loss) (5224,000) 58 Difference in inventory under absorption costing 59 Absorption Costing Net Income (loss) 6038 61 What is the company's break even point in unit sales 62 FMOH $987,000 63 FS&AE $475,000 64 Total Fixed Costs $ 1462,000 65 CM/Unit $34 66 BEV 43,000 67 9 68 What if sales volume is reversed, what is the break even point? 69 BEV 70 #10 71 What would the compari's variable costing net income if the company produced and sold 38,000 units? 72 Net Income (Loss) 73 #11 74 What would the company's absorption costine net income if the company produced and sold 38,000 units? 75 Net Income (Loss) 7612 77 Absorption costing will be lower because we add the deferred inventory and second year's fixed manufacturing cost 7813 79 Income Statement 80 Contribution format segmented income statement 81 Total Company East West Sheet1 G H E94 X B D E F 77 Absorption costing will be lower because we add the deferred inventory and second year's fixed manufacturing cost 78 #13 79 Income Statement 80 Contribution format segmented Income statement 81 Total Company East West 82 Sales $ 3,192,000 $2,432,000 $760,000 83 Variable expenses S 1.764,000 $1,344,000 $420,000 84 Contribution margin $ 1,428,000 $1,088,000 $ 340,000 85 Traceable fixed expense S 370,000 160,000 $ 210,000 86 Segment margin s 1,058,000 S 928,000 $ 130,000 87 common fixed expense $ 1,092,000 88 Net operating loss (34,000) 89 W14 90 East region sales growth in Year 2 0% 91 92 Forgone segment margin of West region 93 Increase contribtion margin of East region 94 Decrease in Diego's net operating income 95 #15 96 West region unit sales increase in Year 2 0% 97 98 Addition advertising campaign 99 Increase contribtion margin of West region 100 Increase in profit Sheet1 $