In excel form

Please answer all thank you

Required information [The following information applies to the questions displayed below) Diego Company manufactures one product that is sold for $70 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 41,000 units and sold 36,000 units Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expense $ 20 $ 10 $ 2 $.4 $984,000 $ 308,000 The company sold 26,000 units in the East region and 10,000 units in the West region. It determined that $150,000 of its fixed selling and administrative expense is traceable to the West region, $100,000 is traceable to the East region, and the remaining $58,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 Required: 1. What is the unit product cost under variable costing? Unit product cost Diego Company manufactures one product that is sold for $70 per regions. The following information pertains to the company's first ye sold 36,000 units. Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expense $ 2 $ 16 $ 2 $ 4 $ 984,000 $ 308,000 The company sold 26,000 units in the East region and 10,000 units in fixed selling and administrative expense is traceable to the West region remaining $58,000 is a common fixed expense. The company will con manufacturing overhead costs as long as it continues to produce any a 2. What is the unit product cost under absorption costing? Unit product cost Diego Company manufactures one product that is sold for $70 per un regions. The following information pertains to the company's first year sold 36,000 units. Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expense $ 20 $ 10 $ 2 $ 4 $ 984,000 $ 308,000 The company sold 26,000 units in the East region and 10,000 units in th fixed selling and administrative expense is traceable to the West region, remaining $58,000 is a common fixed expense. The company will contin manufacturing overhead costs as long as it continues to produce any am 3. What is the company's total contribution margin under variable costing? Total contribution margin Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expense $ 20 $ 10 $ 2 $ 4 $ 984,000 $ 308,000 The company sold 26,000 units in the East region and 10,000 units in the WE fixed selling and administrative expense is traceable to the West region, $100 remaining $58,000 is a common fixed expense. The company will continue to manufacturing overhead costs as long as it continues to produce any amount 4. What is the company's net operating income (loss) under variable costing? Diego Company manufactures one product that is sold for $70 per unit in two regions. The following information pertains to the company's first year of opera sold 36,000 units. Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expense $ 20 $ 10 $ 2 $ 4 $ 984,000 $ 308,000 The company sold 26,000 units in the East region and 10,000 units in the West fixed selling and administrative expense is traceable to the West region, $100,00 remaining $58,000 is a common fixed expense. The company will continue to in manufacturing overhead costs as long as it continues to produce any amount of 5. What is the company's total gross margin under absorption costing? Total gross margin Diego Company manufactures one product that is sold for $70 per unit in two g regions. The following information pertains to the company's first year of operat sold 36,000 units. Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expense $ 20 $ 10 $ 2 $ 4 $ 984,000 $ 308,000 The company sold 26,000 units in the East region and 10,000 units in the West re fixed selling and administrative expense is traceable to the West region, $100,000 remaining $58,000 is a common fixed expense. The company will continue to inc manufacturing overhead costs as long as it continues to produce any amount of it 6. What is the company's net operating income (loss) under absorption costing? Diego Company manufactures one product that is sold for $70 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 41,000 units sold 36,000 units. Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expense $ 20 $ 10 $ 2 $ 4 $984,000 $ 38,000 The company sold 26,000 units in the East region and 10,000 units in the West region. It determined that $150,000 of it fixed selling and administrative expense is traceable to the West region, $100,000 is traceable to the East region, and tt remaining $58,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. 7. What is the amount of the difference between the variable costing and absorption costing net operating incomes (losses)? Difference of Variable Costing and Absorption Costing Net Operating Income (Losses) Variable costing net operating income (loss) Absorption costing net operating income (loss) costs per year: Fixed manufacturing overhead Fixed selling and administrative expense $ 984,000 $ 308,000 The company sold 26,000 units in the East region and 10,000 units in fixed selling and administrative expense is traceable to the West regio remaining $58,000 is a common fixed expense. The company will cont manufacturing overhead costs as long as it continues to produce any a a. What is the company's break-even point in unit sales? Break even point units b. Is it above or below the actual unit sales? Below Above Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expense $ 20 $ 10 $ 2 $ 4 $984,000 $ 388,000 The company sold 26,000 units in the East region and 10,000 units in the West region. It determined that $150,000 of its fixed selling and administrative expense is traceable to the West region, $100,000 is traceable to the East region, and the remaining $58,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 9. If the sales volumes in the East and West regions had been reversed, what would be the company's overall break-even point in unit sales? Break even point units Diego Company manufactures one product that is sold for $70 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 41,000 units and sold 36,000 units. Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expense $ 20 $ 10 $ 2 $ 4 $984,000 $ 308,000 The company sold 26,000 units in the East region and 10,000 units in the West region. It determined that $150,000 of its fixed selling and administrative expense is traceable to the West region, $100,000 is traceable to the East region, and the remaining $58,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. 10. What would have been the company's variable costing net operating income (loss) if it had produced and sold 36,000 units? Diego Company manufactures one product that is sold for $70 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 41,000 units and sold 36,000 units. Variable costs per unit: Manufacturing: Direct materials $ 20 Direct labor $ 10 Variable manufacturing overhead $ 2 Variable selling and administrative Fixed costs per year: $4 Fixed manufacturing overhead $984,000 Fixed selling and administrative expense $ 308,000 The company sold 26,000 units in the East region and 10,000 units in the West region. It determined that $150,000 of its fixed selling and administrative expense is traceable to the West region, $100,000 is traceable to the East region, and the remaining $58,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. 11. What would have been the company's absorption costing net operating income (loss) if it had produced and sold 36,000 units? in which it produced 41,000 units and Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expense $ 20 $ 10 $ 2 $4 $984,000 $ 308,000 The company sold 26,000 units in the East region and 10,000 units in the West region. It determined that $150,000 of its fixed selling and administrative expense is traceable to the West region, $100,000 is traceable to the East region, and the remaining $58,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. 12. If the company produces 5,000 fewer units than it sells in its second year of operations, will absorption costing net operating Income be higher or lower than variable costing net operating income in Year 2? Lower Higher The company sold 26,000 units in the East region and 10,000 units in the West region. It determined that $150,000 of its fixed selling and administrative expense is traceable to the West region, $100,000 is traceable to the East region, and the remaining $58,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. 13. Prepare a contribution format segmented income statement that includes a Total column and columns for the East and West regions Income Statement Total Company East West Net operating Income Net operating loss The company sold 26.000 units in the East region and 10,000 units in the West region. It determined that $150,000 of its fixed selling and administrative expense is traceable to the West region, $100,000 is traceable to the East region, and the remaining $58,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. 14. Diego is considering eliminating the West region because an internally generated report suggests the region's total gross margin in the first year of operations was $10,000 less than its traceable fixed selling and administrative expenses. Diego believes that if it drops the West region, the East region's sales will grow by 6% in Year 2. Using the contribution approach for analyzing segment profitability and assuming all else remains constant in Year 2, what would be the profit impact of dropping the West region in Year 2? Profit will by Variable costs per unit: Manufacturing: Direct materials Direct labor Variable manufacturing overhead Variable selling and administrative Fixed costs per year: Fixed manufacturing overhead Fixed selling and administrative expense $ 20 $ 10 $ 2 $4 $984,800 $ 308,000 The company sold 26,000 units in the East region and 10,000 units in the West region. It determined that $150,000 of its fixed selling and administrative expense is traceable to the West region, $100,000 is traceable to the East region, and the remaining $58,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. 15. Assume the West region invests $31.000 in a new advertising campaign in Year 2 that increases its unit sales by 20%. If all else remains constant, what would be the profit impact of pursuing the advertising campaign? Profit will by