Question: need help on the spread sheet and the right option to choose What is the Net Income value for the Baseline Data? O A) -$2,340


need help on the spread sheet and the right option to choose
What is the Net Income value for the Baseline Data? O A) -$2,340 B) $2,010 OC) -$2,010 OD) $2,340 Font IN Alignment Number Clipboard Styles 25 fx B C E F 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 3 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 /qtr 9 Total Fixed Cost $ 17,500 /qtr 10 11 Target Quantity 2,700 widgets/qtr 12 13 14 15 16 Outputs (Results) Contribution Per Unit Margin $ 42.95 68.2% 18 19 20 21 22 23 24 Break-Even Per Quarter In Units In $ Sales 418 Quartery Results at Target Sales of 2,700 widgets Revenue Variable Cost Fixed Cost Billbord Ads Total Cost $ $ $ 170.100 54,135 17,500 450 72,085 26 27 28 29 30 31 32 Net Income $ 98,015 What If Vlookup IF Me Worksheets North South Bonus Question Type here to search
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
