undefined

Excel File Edit View Insert Format Tools Data Window Window Help * 90% 90% ] Mon 11:33 PM Q Q Search Shoot O AutoSave OFF LAB 1 EXCEL Home Insert Page Layout Formulas Data Review View Share Insert - A- A General ST) Wrap Text 49 Calibrl (Body) 11 B IV - Delete - Paste 00 ++ Merge & Center $ % 0 .00 Conditional Format Formatting as Table Cell Styles C Format Sort & Filter Check for Updates Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. A14 Xfx Profits A B c D F F G H 1 K M N O 0 P Q B S u V w 1 2 3 3 Your business has a modest profit of 25,000. You've set yourself a new profit Goal of 35,000. At the moment, you're selling 1000 items at 25 each. Assume that you'll still sell 1000 items. The question is, to hit your new profit of 35,000, by how much do you have to raise your prices? 5 7 8 9 9 10 11 Current Scenario 12 Units sold 13 Pricer Per Unit 14 Profits 15 16 1000 25 25000 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Business Goal Test Scores Cost Scenario Product Revenue Portfolio + Ready 100% 10347 16 15 X (WIPO Excel File Edit View Insert Format Tools Data Window Help * 90% 90% ] Mon 11:33 PM Q Q Search Sheet O AutoSave OFF LAB 1 EXCEL Home Insert Page Layout Formulas Data Review View Share Insert - A- A General ST) Wrap Text 49 Calibrl (Body) 11 BI Paste 00 ++ Merge & Center % 0 .00 Conditional Format Formatting as Table Cell Styles - Delete - Format Sort & Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates B17 A 8 D E F H ! 1 1 N 0 P Q R S S T U V W 1 Z 3 3 4 3) A professor that teaches Management Science assigns the final grade based on three examinations. To earn an A, the overall average on the three exams must be at least 89%. Suppose that you score 80% and 79% on exams 1 and 2, respectively. Using Goal Seek, what is the minimum score that you need to earn on exam 3 to get an A? 5 7 9 10 11 12 Current Scenario 13 Exam 1 80 14 Exam 2 79 15 Exam 3 3 0 16 Average 53 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 Business Goal Test Scores Cost Scenario Product Revenue Portfolio + Ready + 100% LC347 TEN a 15 X W P Excel File Edit View Insert Format Tools Data Data Window Help * 90% 90% ] Mon 11:33 PM Q Q Search Shoot O AutoSave OFF LAB 1 EXCEL Home Insert Page Layout Formulas Data Review View Share Insert - A- A General T> Wrap Text 49 Calibrl (Body) 11 BIU Paste ++ & Merge & Center % 0 .00 00 . Conditional Format Formatting as Table Cell Styles - Delete - Format Sort & Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates G23 A B C D E G H 1 1 K L M N 0 Q R S T Begin with the intial scenario assumptions. Use Excel Goals Seekta Adjust the following: 1. Change the Price to a break-even scenario 2. Change the units sold to reflect a break-even scenario 3. Change the fixed cost to refect a break-even scenario Note: All actions are conducted via Goal Seek. Be sure to recognize the a break-even value should be set to zero. We need to eliminate the current loss scenario. Optimize with your revisions! 1 2 Current Scenario 3 Selling Price $2.25 4 Units Sold $15,000.00 5 Revenue $33,750.00 6 Cost/Unit $1.00 7 Variable Costs $15,000.00 8 Fixed Cost $20,000.00 9 Profit $1,250.00 10 11 12 Change Price 13 Selling Price 14 Units Sold 15 Revenue 16 Cost/Unit 17 Variable Costs 18 Fixed Cost 19 Profit 20 21 We need to break even 22 Set Profit to zero by changing selling price 23 24 25 26 27 28 29 30 31 Business Goal Test Scores Change Units Sold Selling Price Units Sold Revenue Cost/Unit Variable Costs Fixed Cost Profit Change Fixed Cost Selling Price Units sold Revenue Cost/Unit Variable Costs Fixed Cost Profit Cannot change selling price 50 we cahgne units sold Can only changed fixed cost due to budget Cost Scenario Product Revenue Portfolio + Ready 100% LC347 g 15 X (BWI PO Excel File Edit View Insert Format Tools Data Window Help * 90% 90% ] Mon 11:33 PM Q Q Search Sheet O AutoSave OFF LAB 1 EXCEL Home Insert Page Layout Formulas Data Review View Share Insert - A- A General ST) Wrap Text 49 Calibrl (Body) 11 BIU - Delete - Paste ++ Merge & Center % 0 .00 00 . Conditional Format Formatting as Table Cell Styles C Format Sort & Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates F17 A e C D E F G H 1 K L M N O P Q R S T Goal Seek Cell: Contains set cell, to value, by changing cell. The set cell value MUST contatin a formula ar Goal seek will not work To begin the lab: Copy and paste the data and formulas to Problem #1. Upon completion, copy and paste the data and formulas from Problem 112 to problem 13, etc. For each scenario, copy and paste the previous scenario to generate cumulative changes. Initial Mode Apply Goal Seek to the following scenarios: 1. Increase Projected revenue to 1,500,000 by changing phone devices What is the new projected revenue for phone devices: 2. Increase projected revenue to 925,000 by changing wireless devices What is the new projected revenue for wireless devices: Problem 1 1 Your Product Portfolio 2 3 Product Current Revenue Projected Goal Revenue 4 Streaming Services 55,000 75,000 5 Web Services 25,000 30,000 6 Wireless Devices 70,000 85,000 7 Tablet Devices 150,000 165,000 8 Phone Devices 500,000 545,000 9 800,000 1,000,000 10 11 12 13 Product Current Revenue Projected Goal Revenue 14 Streaming Services 15 Web Services 16 Wireless Devices 17 Tablet Devices 18 Phone Devices 19 20 21 22 23 Product Current Revenue Projected Goal Revenue 24 Streaming Services 25 Web Services 26 Wireless Devices 27 Tablet Devices 28 Phone Devices 29 30 31 Business Goal Test Scores Cost Scenario 3. Increase projected revenue to 945,000 by changing streaming services What is the new projected revenue for streaming services: 4. Increase projected revenue to 910,000 by changing web services What is the new projected revenue for web services 5. Increase projected revenue to 1,100,000 by changing tablet devices What is the new projected revenue for tablet services Problem 2 Product Revenue Portfolio + Ready O 100% LC347 TER While 15 X (1 WT PO Excel File Edit View Insert Format Tools Data Window Help * 90% 90% Mon 11:33 PM Q Q Search Sheet O AutoSave OFF LAB 1 EXCEL Home Insert Page Layout Formulas Data Review View Share Insert - A A General ST) Wrap Text 49 Calibrl (Body) 11 BIJ - Delete - Paste + + Merge & Center % 0 .00 00 . Conditional Format Formatting as Table Cell Styles Format Sort & Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates F17 A C D E F H 1 K L M N O P Q R s T www Current Revenue Projected Goal Revenue Problem #3 31 32 Product 33 Streaming Services 34 Web Services 35 Wireless Devices 36 Tablet Devices 37 Phone Devices 38 39 40 Problem trablem ** Current Revenue Projected Goal Revenue 55,000 95,000 25,000 5,000 70,000 10,000 150,000 165,000 500,000 545,000 800,000 910,000 41 42 Product 43 Streaming Services 44 Web Services 45 Wireless Devices 46 Tablet Devices 47 Phone Devices 48 49 50 51 52 Product 53 Streaming Services 54 Web Services 55 Wireless Devices 56 Tablet Devices 57 Phone Devices 58 59 60 Problem #5 Current Revenue Projected Goal Revenue 55,000 95,000 25,000 -5,000 70,000 10,000 150,000 355,000 500,000 545,000 800,000 1,100,000 Business Goal Test Scores Cost Scenario Product Revenue Portfolio + Ready O 100% 00147 15 15 X (1 WT PO