Question: Please answer using excel and please dont use image/screenshoot Question 4 (20 points} A company produce a single product. Data relating to the product for
Please answer using excel and please dont use image/screenshoot

Question 4 (20 points} A company produce a single product. Data relating to the product for year 2020 were as follows: Annual sales volume was 34,000 units. Selling price per unit was $140. Variable manufacturing cost per unit 565 Annual Fixed Manufacturing cost: $420,000 Annual Fixed non Manufacturing cost : $250,000 Variable marketing and distribution cost per unit: 325 Required: Calculate the break even point in units and in dollar value for the year 2020 {5 points} Calculate the margin of safety in both units and sales dollars {4 points} Calculate the profit achieved in 2020 given the annual volume of 34,000 units (5 points) Changes in marketing strategy are planned for year 2021. This would increase variable :LPD'P'I marketing and distribution costs by $10 per unit, and reduce fixed nonmanufacturing cost by
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
