Halsey Corporation manufactures products that have variable costs of $60 per unit. Its fixed cost amounts...

 

Transcribed Image Text:

Halsey Corporation manufactures products that have variable costs of $60 per unit. Its fixed cost amounts to $360,000. It sells the products for $90 each. Conduct a sensitivity analysis on an excel file, on the first sheet manually, (fixed cost and variable cost being on the vertical axis and sales volume being on the horizontal axis) considering: . 4 levels of fixed cost: 300,000-360,000-430,000-500,000. 5 levels of variable cost: 50-55-60-65-70 5 levels of sales volume: 8,000-10,000-12,000-14,000-16,000. ● ● Then conduct the same sensitivity analysis, on the second sheet using what if analysis, (sales volume being on the horizontal axis and variable cost being on the vertical axis) considering: Halsey Corporation manufactures products that have variable costs of $60 per unit. Its fixed cost amounts to $360,000. It sells the products for $90 each. Conduct a sensitivity analysis on an excel file, on the first sheet manually, (fixed cost and variable cost being on the vertical axis and sales volume being on the horizontal axis) considering: . 4 levels of fixed cost: 300,000-360,000-430,000-500,000. 5 levels of variable cost: 50-55-60-65-70 5 levels of sales volume: 8,000-10,000-12,000-14,000-16,000. ● ● Then conduct the same sensitivity analysis, on the second sheet using what if analysis, (sales volume being on the horizontal axis and variable cost being on the vertical axis) considering:

Answer rating: 100% (QA)

Manual Sensitivity Analysis 1 Open a new Excel spreadsheet and create a table with the following str... View the full answer