Question: Pleaseeee do in excel :) Problem 1: CVP Analysis (50 points) DATA: Selling Price Per Unit 200.00 Per Unit Variable Costs: Variable Factory overhead 10.00


Pleaseeee do in excel :)
Problem 1: CVP Analysis (50 points) DATA: Selling Price Per Unit 200.00 Per Unit Variable Costs: Variable Factory overhead 10.00 Variable Marketing 20.00 Direct Materials 40.00 Total Variable Cost Per Unit 70.000 Fixed Cost Per Year: 150,000 Advertising 80,000 Salaries 20,000 Depreciation 250,000 Total Fixed Cost 35% Tax Rate REQUIREMENTS: For each of the following, calculate the answers and sHow YoUR WORK! Don't forget to round up the number of units when needed- can't have partial units at breakeven. 2) Calculate breakeven point in units. 3) Calculate the contribution margin ratio
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
