Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need help on the spread sheet and the right option to choose What is the Break Even value in units for the Baseline Data? O
need help on the spread sheet and the right option to choose
What is the Break Even value in units for the Baseline Data? O A) 2,010 units OB) 2,135 units C) 2,040 units OD) 2,036 units A25 B D E G H Hi there! I've been playing with the numbers here, just wondering what would happen. Unfortunately, I've forgotten the original values. :( You saved these somewhere, right? Man, hope so... - Bob Inputs (Assumptions) 4 5 Selling Price $ 63.00 / widget 6 Unit Variable Cost S 19.80 /widget 7 Shipping Cost $ 0.25 / widget 8 Billboard Advertising $ 450 gr 9 Total Fixed Cost $ 17,500 /qtr 10 11 Target Quantity 2.700 widgets/qtr 12 13 14 15 16 17 18 19 Outputs (Results) Contribution Per Unit Margin $ 42.95 68.2% Break-Even Per Quarter In Units In $ Sales 418 21 22 23 Quartery Results at Target Sales of 2,700 widgets Revenue 5 170.100 Variable Cost $ 54,135 Fixed Cost 17.500 Billbord Ads 450 Total Cost $ 72,085 28 29 30 3 Net Income s 98,015Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started