Please review/correct issues with excel assignment attached. Specifically with the anaylsis & breakeven:
In requirement 1, fixed costs should include BOTH fixed manufacturing and admin costs.
In requirement 2, Contribution Margin Ration should be calculated on unit costs, not total costs.
In requirement 3, Fixed costs should match those calculated in Req 1.
*full assignment guidelines included for context – please ignore prompt for any essay