Answered step by step
Verified Expert Solution
Question
1 Approved Answer
e need help on the spread sheet and the right option to choose Using Goal Seek with the Baseline Data values displayed, what is the
e
need help on the spread sheet and the right option to choose
Using Goal Seek with the Baseline Data values displayed, what is the Selling Price value needed to obtain a Break Even value of 1,900 units? O A) $30.18 OB) $30.44 C) $30.71 OD) $31.00 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... Inputs (Assumptions) 4 5 Selling Price S 63.00 /widget 6 Unit Variable Cost $ 19.80 /widget 7 Shipping Cost S 0.25 /widget 8 Billboard Advertising S 450 /qtr 9 Total Fixed Cost $ 17,500 /qtr 10 11 Target Quantity 2.700 widgets/qtr 12 13 - Bob Outputs (Results) Contribution Per Unit Margin S 42.95 68.2% Break-Even Per Quarter In Units In $ Sales 418 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Quartery Results at Target Sales of 2,700 widgets Revenue $ 170,100 Variable Cost 54,135 Fixed Cost 17.500 Billbord Ads $ 450 Total Cost $ 72,085 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