Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need help on the spread sheet and the right option to choose Make sure you are using the Baseline Data, and then set the Selling
need help on the spread sheet and the right option to choose
Make sure you are using the Baseline Data, and then set the Selling Price value to $30.18. What is the Margin that results from this price? OA) 34.1% B) 33.6% C) 34.7% D) 35.3% 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... Us - Bob Outputs (Results) 2 Inputs (Assumptions) 4 5 Selling Price $ 63.00 / widget 6 Unit Variable Cost $ 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 20 21 22 23 24 21 26 27 28 29 30 31 Contribution Per Unit Margin $ 42.95 68.2% Break-Even Per Quarter in Units In $ Sales 418 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