Inputs (Assumptions) $ Selling Price Unit Variable Cost $ Shipping Cost $ Billboard Advertising $ Total Fixed Cost 63.00 /widget 19.80 /widget 0.25 /widget 450 /qtr 17,500 /qtr 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, I hope so... Bob Target Quantity 2,700 widgets/qtr Outputs (Results) Contribution Per Unit Margin S 42.95 68.2% Break-Even Per Quarter In Units In $ Sales 418 Quartery Results at Target Sales of 2,700 widgets What If Vlookup F Multiple Worksheets North South East West Bonus Questi 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 $ 98,015 East North West South Bonus Questi... F hat If Vg 048 Multiple Worksheets o * s. RI here to search The following section uses the What IF worksheet on the Exam File. The CEO, Bob, has been messing with your model (AGAIN!) and he wants you to restore the Baseline Data values to the input cells. Using the Scenario Manager, show the Baseline Data input values. Answer the following questions: Question 1 (1 point) What is the Break Even value in units for the Baseline Data? A) 2.010 units B) 2,040 units C) 2.036 units D 2165 units Question 2 (1 point) What is the Net Income value for the Baseline Data? A) -$2,340 B) -$2,010 C) $2,340 D) $2,010 Question 3 (1 point) displayed, what i Question 3 (1 point) Using Goal Seek with the Baseline Data values displayed, what is the Selling Price value needed to obtain a Break Even value of 1,950 units? A) $30.44 B) $30.18 C) $31.00 D) $30.71 Question 4 (1 point) Make sure you are using the Baseline Data, and then set the Selling Price value to wat is the Marsin that results from this price? Question 4 (1 point) Make sure you are using the Baseline Data, and then set the Selling Price value to $31.00. What is the Margin that results from this price? A) 33.6% B) 35.3% OC) 34.7% (D) 34.1% Question 5 (2 points) RESET the model to the Baseline Data BEFORE completing this step. Bob decides that they can change the model (AGAIN!). Instead of advertising on billboards, they will add suiden itibilight the products on the shelf Question 5 (2 points) RESET the model to the Baseline Data BEFORE completing this step. Bob decides that they can change the model (AGAIN!). Instead of advertising on billboards, they will add stickers to highlight the products on the shelf. He asks you to REMOVE the Billboard advertising cost from the model, and instead change to an additional per Widget cost for Stickers of $0.30 / widget. Make the changes in the model to remove the Billboards (a fixed cost) and add the Stickers (a per widget cost). You will need to identify and modify all formulae that use these inputs. What is the resulting Net Profit of the model, assuming nothing else changes? OA) -$1,860 OB) - $2,040 C) -$2,130 Inputs (Assumptions) $ Selling Price Unit Variable Cost $ Shipping Cost $ Billboard Advertising $ Total Fixed Cost 63.00 /widget 19.80 /widget 0.25 /widget 450 /qtr 17,500 /qtr 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, I hope so... Bob Target Quantity 2,700 widgets/qtr Outputs (Results) Contribution Per Unit Margin S 42.95 68.2% Break-Even Per Quarter In Units In $ Sales 418 Quartery Results at Target Sales of 2,700 widgets What If Vlookup F Multiple Worksheets North South East West Bonus Questi 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 $ 98,015 East North West South Bonus Questi... F hat If Vg 048 Multiple Worksheets o * s. RI here to search The following section uses the What IF worksheet on the Exam File. The CEO, Bob, has been messing with your model (AGAIN!) and he wants you to restore the Baseline Data values to the input cells. Using the Scenario Manager, show the Baseline Data input values. Answer the following questions: Question 1 (1 point) What is the Break Even value in units for the Baseline Data? A) 2.010 units B) 2,040 units C) 2.036 units D 2165 units Question 2 (1 point) What is the Net Income value for the Baseline Data? A) -$2,340 B) -$2,010 C) $2,340 D) $2,010 Question 3 (1 point) displayed, what i Question 3 (1 point) Using Goal Seek with the Baseline Data values displayed, what is the Selling Price value needed to obtain a Break Even value of 1,950 units? A) $30.44 B) $30.18 C) $31.00 D) $30.71 Question 4 (1 point) Make sure you are using the Baseline Data, and then set the Selling Price value to wat is the Marsin that results from this price? Question 4 (1 point) Make sure you are using the Baseline Data, and then set the Selling Price value to $31.00. What is the Margin that results from this price? A) 33.6% B) 35.3% OC) 34.7% (D) 34.1% Question 5 (2 points) RESET the model to the Baseline Data BEFORE completing this step. Bob decides that they can change the model (AGAIN!). Instead of advertising on billboards, they will add suiden itibilight the products on the shelf Question 5 (2 points) RESET the model to the Baseline Data BEFORE completing this step. Bob decides that they can change the model (AGAIN!). Instead of advertising on billboards, they will add stickers to highlight the products on the shelf. He asks you to REMOVE the Billboard advertising cost from the model, and instead change to an additional per Widget cost for Stickers of $0.30 / widget. Make the changes in the model to remove the Billboards (a fixed cost) and add the Stickers (a per widget cost). You will need to identify and modify all formulae that use these inputs. What is the resulting Net Profit of the model, assuming nothing else changes? OA) -$1,860 OB) - $2,040 C) -$2,130