URGENT!!!!

Excel File Edit View Insert Format Tools Data window Help a 80 O Wed Apr 6 4:26 PM O AutoSave OFF 2 ... Book 3 a 8 Home Insert Draw Page Layout Formulas Data Review View Tell me Share W Comments Calibri (Body) 12 AFA = = General ' 12800 F) Insert PX Delete v Format me Paste B TU CA = = + + v $ % ) Conditional Format Cell . Formatting as Table Styles HI Sort & Filter Find & Select Tasks - Sensitivity Analyze Data A1 x fx A 3 D E F F G H 1 K M N a MyEducator Tasks X 1 13 Trail Mix Solver Ingredients Chacalate Chips Granola Peanuts Sunflower Seeds Not Nutts 1 1 1 0 1 Trail Mix Varieties Delace Traditional 1 0 1 1 1 1 1 1 1 Sweet Tooth 1 1 0 D Cost $0.30 $ $0.30 $0.40 $0.30 Demand Total to Make 4,000,000 1 5,000,000 1 1 2,000,000 1 1 2,000,000 1 Price/Bag Cost/Bag Gross Profit/Bag $2.99 $0.90 $2.09 $2.99 $1.30 $ $1.69 $2.99 $1.00 $1.99 $2.99 $0.60 $2.39 Gross Profit/Type $2 $2 $2 $2 Total Profit $8 3 hol 4 5 6 7 9 10 11 12 13 14 15 16 12 18 19 20 21 22 23 24 25 26 27 29 29 30 31 32 33 34 35 Material Totals Used 3 You are in charge of manufacturing for a trail mix production plant. Your facility manufactures four varieties of trail mixes (Not Nutts, Deluxe, Traditional, and Sweet Tooth). You must maximize the profit for your facility by making the your facility optimal number of each type of trail mix. There are four main ingredients in the musicholate used in the mixes: chocolate chips, granola, nuts, and sunflower seeds. You have created a spreadsheet model on the "Trail" worksheet to help you in your decision-making. The table at the top of the "Trail worksheet details how many units of each ingredient are used in making each type of trail mix and the costs for these ingredients. The demand and prices you can charge for each type of mix are also listed in the spreadsheet model. Finally, the model calculates the ingredients used and total profit for the combination of mixes you plan to make. Use solver to complete the assignment Ingredients Chocolate Granola Peanuts Sunflower Seeds ... Available 12,000,000 14,000,000 5,000,000 11,000,000 F 2 3 Average Attendance Total Merch Sales Sporting Events Goncerts Food Sales Trail Past Events Event Profit + tasks. Ready Add-ins loaded successfully -! 0 -- + 100% 45 APR 6 tv a SA w SA Excel File Edit View Insert Format Tools Data window Help a 80 O Wed Apr 6 4:26 PM O AutoSave OFF 2 ... Book 3 a 8 Home Insert Draw Page Layout Formulas Data Review View Tell me Share W Comments Calibri (Body) 12 AFA = = General WE Insert PX Delete v Format 12800 TO) me Paste B TU CA = = + + v $ % ) Conditional Format Cell . Formatting as Table Styles Sort & Filter HI Find & Select Analyze Data Sensitivity Tasks A1 x fx A 3 D E F F G H 1 K M N a 1 Ingredients Chacalate Chips Granola Peanuts Sunflower Seeds Not Nutts 1 1 1 0 1 Trail Mix Varieties Delace Traditional 1 0 1 1 1 1 1 1 1 Sweet Tooth 1 1 0 D Cost $0.30 $ $0.30 $0.40 $0.30 MyEducator Tasks 13.1 Set up solver to determine how many of each variety of trail mix to make to maximize total profit subject to the following constraints: a. The number of bags of trail mix made (range C10:F10) should not exceed the demand (range 09:F9)) for that type of mix. b. You must make at least 1 million of Demand Total to Make 4,000,000 1 5,000,000 1 1 2,000,000 1 1 2,000,000 1 Price/Bag Cost/Bag Gross Profit/Bag $2.99 $0.90 $2.09 $2.99 $1.30 $ $1.69 $2.99 $1.00 $1.99 $2.99 $0.60 $2.39 each type of trail mix. Gross Profit/Type $2 $2 $2 $2 Total Profit $8 3 hol 4 5 6 7 9 10 11 12 13 14 15 16 12 18 19 20 21 22 23 24 25 26 27 29 29 30 31 32 33 34 35 Material Totals Used 3 Ingredients Chocolate Granola Peanuts Sunflower Seeds ... Available 12,000,000 14,000,000 5,000,000 11,000,000 F 2 3 C. Note that you should not use the comma separator when you create this constraint (use 1000000 instead of 1,000,000) 000 d. The ingredients consumed in making the mixes (range C22:025)) should not exceed what is available (range D22:D25). e. There is a national nut shortage and they are expensive. To avoid nuts spoiling, you must use all of the nuts. f. Make only whole number amounts of mixes g. Before solving make the solving method Simplex LP and checkmark Add-ins loaded successfully 3 0 0 + 100% Average Attendance Total Merch Sales Sporting Events Goncerts Food Sales Trail Past Events Event Profit + Ready 45 APR 6 tv SA w Excel File Edit View Insert Format Tools Data window Help a 80 O Wed Apr 6 4:26 PM O AutoSave OFF 2 ... Book 3 a 8 Home Insert Draw Page Layout Formulas Data Review View Tell me Share W Comments Calibri (Body) 12 AFA = = General WE Insert PX Delete v Format 12800 TO) me Paste B TU CA = = + + v $ % ) Conditional Format Cell . Formatting as Table Styles Sort & Filter HI Find & Select Analyze Data Sensitivity Tasks A1 x fx A 3 D E F F G H 1 K M N a 1 Ingredients Chacalate Chips Granola Peanuts Sunflower Seeds Not Nutts 1 1 1 0 1 Trail Mix Varieties Delace Traditional 1 0 1 1 1 1 1 1 1 Sweet Tooth 1 1 0 D Cost $0.30 $ $0.30 $0.40 $0.30 MyEducator Tasks 13.1 Set up solver to determine how many of each variety of trail mix to make to maximize total profit subject to the following constraints: a. The number of bags of trail mix made (range C10:F10) should not exceed the demand (range 09:F9)) for that type of mix. b. You must make at least 1 million of Demand Total to Make 4,000,000 1 5,000,000 1 1 2,000,000 1 1 2,000,000 1 Price/Bag Cost/Bag Gross Profit/Bag $2.99 $0.90 $2.09 $2.99 $1.30 $ $1.69 $2.99 $1.00 $1.99 $2.99 $0.60 $2.39 each type of trail mix. Gross Profit/Type $2 $2 $2 $2 Total Profit $8 3 hol 4 5 6 7 9 10 11 12 13 14 15 16 12 18 19 20 21 22 23 24 25 26 27 29 29 30 31 32 33 34 35 Material Totals Used 3 Ingredients Chocolate Granola Peanuts Sunflower Seeds ... Available 12,000,000 14,000,000 5,000,000 11,000,000 F 2 3 C. Note that you should not use the comma separator when you create this constraint (use 1000000 instead of 1,000,000) 000 d. The ingredients consumed in making the mixes (range C22:025)) should not exceed what is available (range D22:D25). e. There is a national nut shortage and they are expensive. To avoid nuts spoiling, you must use all of the nuts. f. Make only whole number amounts of mixes g. Before solving make the solving method Simplex LP and checkmark Add-ins loaded successfully ? OU Average Attendance Total Merch Sales Sporting Events Goncerts Food Sales Trail Past Events Event Profit + Ready + 100% 45 APR 6 tv s A w Excel File Edit View Insert Format Tools Data window Help a 80 O Wed Apr 6 4:26 PM O AutoSave OFF 2 ... Book 3 a 8 Home Insert Draw Page Layout Formulas Data Review View Tell me Share W Comments Calibri (Body) 12 AFA = = General ' I) 12800 me [ Insert PX Delete Format Paste B TU CA = v = Sensitivity + + Tasks $ % ) Find & Select Conditional Format Cell . Formatting as Table Styles Sort & Filter Analyze Data A1 x fx A 3 D E F F G H 1 K M N a 1 Ingredients Chacalate Chips Granola Peanuts Sunflower Seeds Not Nutts 1 1 1 0 1 Trail Mix Varieties Delace Traditional 1 0 1 1 1 1 1 1 1 Sweet Tooth 1 1 0 D Cost $0.30 $ $0.30 $0.40 $0.30 MyEducator Tasks x (range D22:025)). e. There is a national nut shortage and they are expensive. To avoid nuts spoiling, you must use all of the nuts. f. Make only whole number amounts of mixes. g. Before solving make the solving method Simplex LP and checkmark the Make Unconstrained variables Non-negative option. Demand Total to Make 4,000,000 1 5,000,000 1 1 2,000,000 1 1 2,000,000 1 Price/Bag Cost/Bag Gross Profit/Bag $2.99 $0.90 $2.09 $2.99 $1.30 $ $1.69 $2.99 $1.00 $1.99 $2.99 $0.60 $2.39 Gross Profit/Type $2 $2 $2 $2 Total Profit $8 3 hol 4 5 6 7 9 10 11 12 13 14 15 16 12 18 19 20 21 22 23 24 25 26 27 29 29 30 31 32 33 34 35 = 45 Material Totals Used 3 Ingredients Chocolate Granola Peanuts Sunflower Seeds ... Available 12,000,000 14,000,000 5,000,000 11,000,000 F 2 3 14) Given the problem constraints, which Gross Profit amount is closest to the maximum profit possible for this problem? $22,800,000 $23,700,000 $24,600,000 $25.500.000 O Average Attendance Total Merch Sales Sporting Events Goncerts Food Sales Trail Past Events Event Profit + Ready Add-ins loaded successfully + 100% 45 APR 6 tv s A w Excel File Edit View Insert Format Tools Data window Help a 80 O Wed Apr 6 4:26 PM O AutoSave OFF 2 ... Book 3 a 8 Home Insert Draw Page Layout Formulas Data Review View Tell me Share W Comments Calibri (Body) 12 AFA = = General ' 12800 F) Insert Tax Delete v Format me Paste B TU CA = = v + + Tasks $ % ) Conditional Format Cell . Formatting as Table Styles Find & Select Sort & Filter Analyze Data Sensitivity A1 x fx A 3 D E F F G H 1 K M N a 1 Ingredients Chacalate Chips Granola Peanuts Sunflower Seeds Not Nutts 1 1 1 0 1 Trail Mix Varieties Delace Traditional 1 0 1 1 1 1 1 1 1 Sweet Tooth 1 1 0 D Cost $0.30 $ $0.30 $0.40 $0.30 MyEducator Tasks 14) Given the problem constraints, which Gross Profit amount is closest to the maximum profit possible for this problem? Demand Total to Make 4,000,000 1 5,000,000 1 1 2,000,000 1 1 2,000,000 1 Price/Bag Cost/Bag Gross Profit/Bag $2.99 $0.90 $2.09 $2.99 $1.30 $ $1.69 $2.99 $1.00 $1.99 $2.99 $0.60 $2.39 $22,800,000 $23,700,000 $24,600,000 O $25,500,000 $26,400,000 O $27,300,000 Gross Profit/Type $2 $2 $2 $2 Total Profit 3 hol 4 5 6 7 9 10 11 12 13 14 15 16 12 18 19 20 21 22 23 24 25 26 27 29 29 30 31 32 33 34 35 $8 Material Totals Used 3 Ingredients Chocolate Granola Peanuts Sunflower Seeds ... Available 12,000,000 14,000,000 5,000,000 11,000,000 F 2 3 15) Production would fall short of demand for which variety of trail mix? OOOO O Not Nutts O Deluxe O Traditional O Sweet Tooth Average Attendance Total Merch Sales Sporting Events Goncerts Food Sales Trail Past Events Event Profit + Ready Add-ins loaded successfully - -- + 100% 45 APR 6 tv SA w Excel File Edit View Insert Format Tools Data window Help a 80 O Wed Apr 6 4:26 PM O AutoSave OFF 2 ... Book 3 a 8 Home Insert Draw Page Layout Formulas Data Review View Tell me Share W Comments Calibri (Body) 12 AFA = = General ' 12800 F) Insert PX Delete v Format me Paste B TU CA = = + + v $ % ) Conditional Format Cell . Formatting as Table Styles HI Sort & Filter Find & Select Tasks - Sensitivity Analyze Data A1 x fx A 3 D E F F G H 1 K M N a MyEducator Tasks X 1 13 Trail Mix Solver Ingredients Chacalate Chips Granola Peanuts Sunflower Seeds Not Nutts 1 1 1 0 1 Trail Mix Varieties Delace Traditional 1 0 1 1 1 1 1 1 1 Sweet Tooth 1 1 0 D Cost $0.30 $ $0.30 $0.40 $0.30 Demand Total to Make 4,000,000 1 5,000,000 1 1 2,000,000 1 1 2,000,000 1 Price/Bag Cost/Bag Gross Profit/Bag $2.99 $0.90 $2.09 $2.99 $1.30 $ $1.69 $2.99 $1.00 $1.99 $2.99 $0.60 $2.39 Gross Profit/Type $2 $2 $2 $2 Total Profit $8 3 hol 4 5 6 7 9 10 11 12 13 14 15 16 12 18 19 20 21 22 23 24 25 26 27 29 29 30 31 32 33 34 35 Material Totals Used 3 You are in charge of manufacturing for a trail mix production plant. Your facility manufactures four varieties of trail mixes (Not Nutts, Deluxe, Traditional, and Sweet Tooth). You must maximize the profit for your facility by making the your facility optimal number of each type of trail mix. There are four main ingredients in the musicholate used in the mixes: chocolate chips, granola, nuts, and sunflower seeds. You have created a spreadsheet model on the "Trail" worksheet to help you in your decision-making. The table at the top of the "Trail worksheet details how many units of each ingredient are used in making each type of trail mix and the costs for these ingredients. The demand and prices you can charge for each type of mix are also listed in the spreadsheet model. Finally, the model calculates the ingredients used and total profit for the combination of mixes you plan to make. Use solver to complete the assignment Ingredients Chocolate Granola Peanuts Sunflower Seeds ... Available 12,000,000 14,000,000 5,000,000 11,000,000 F 2 3 Average Attendance Total Merch Sales Sporting Events Goncerts Food Sales Trail Past Events Event Profit + tasks. Ready Add-ins loaded successfully -! 0 -- + 100% 45 APR 6 tv a SA w SA Excel File Edit View Insert Format Tools Data window Help a 80 O Wed Apr 6 4:26 PM O AutoSave OFF 2 ... Book 3 a 8 Home Insert Draw Page Layout Formulas Data Review View Tell me Share W Comments Calibri (Body) 12 AFA = = General WE Insert PX Delete v Format 12800 TO) me Paste B TU CA = = + + v $ % ) Conditional Format Cell . Formatting as Table Styles Sort & Filter HI Find & Select Analyze Data Sensitivity Tasks A1 x fx A 3 D E F F G H 1 K M N a 1 Ingredients Chacalate Chips Granola Peanuts Sunflower Seeds Not Nutts 1 1 1 0 1 Trail Mix Varieties Delace Traditional 1 0 1 1 1 1 1 1 1 Sweet Tooth 1 1 0 D Cost $0.30 $ $0.30 $0.40 $0.30 MyEducator Tasks 13.1 Set up solver to determine how many of each variety of trail mix to make to maximize total profit subject to the following constraints: a. The number of bags of trail mix made (range C10:F10) should not exceed the demand (range 09:F9)) for that type of mix. b. You must make at least 1 million of Demand Total to Make 4,000,000 1 5,000,000 1 1 2,000,000 1 1 2,000,000 1 Price/Bag Cost/Bag Gross Profit/Bag $2.99 $0.90 $2.09 $2.99 $1.30 $ $1.69 $2.99 $1.00 $1.99 $2.99 $0.60 $2.39 each type of trail mix. Gross Profit/Type $2 $2 $2 $2 Total Profit $8 3 hol 4 5 6 7 9 10 11 12 13 14 15 16 12 18 19 20 21 22 23 24 25 26 27 29 29 30 31 32 33 34 35 Material Totals Used 3 Ingredients Chocolate Granola Peanuts Sunflower Seeds ... Available 12,000,000 14,000,000 5,000,000 11,000,000 F 2 3 C. Note that you should not use the comma separator when you create this constraint (use 1000000 instead of 1,000,000) 000 d. The ingredients consumed in making the mixes (range C22:025)) should not exceed what is available (range D22:D25). e. There is a national nut shortage and they are expensive. To avoid nuts spoiling, you must use all of the nuts. f. Make only whole number amounts of mixes g. Before solving make the solving method Simplex LP and checkmark Add-ins loaded successfully 3 0 0 + 100% Average Attendance Total Merch Sales Sporting Events Goncerts Food Sales Trail Past Events Event Profit + Ready 45 APR 6 tv SA w Excel File Edit View Insert Format Tools Data window Help a 80 O Wed Apr 6 4:26 PM O AutoSave OFF 2 ... Book 3 a 8 Home Insert Draw Page Layout Formulas Data Review View Tell me Share W Comments Calibri (Body) 12 AFA = = General WE Insert PX Delete v Format 12800 TO) me Paste B TU CA = = + + v $ % ) Conditional Format Cell . Formatting as Table Styles Sort & Filter HI Find & Select Analyze Data Sensitivity Tasks A1 x fx A 3 D E F F G H 1 K M N a 1 Ingredients Chacalate Chips Granola Peanuts Sunflower Seeds Not Nutts 1 1 1 0 1 Trail Mix Varieties Delace Traditional 1 0 1 1 1 1 1 1 1 Sweet Tooth 1 1 0 D Cost $0.30 $ $0.30 $0.40 $0.30 MyEducator Tasks 13.1 Set up solver to determine how many of each variety of trail mix to make to maximize total profit subject to the following constraints: a. The number of bags of trail mix made (range C10:F10) should not exceed the demand (range 09:F9)) for that type of mix. b. You must make at least 1 million of Demand Total to Make 4,000,000 1 5,000,000 1 1 2,000,000 1 1 2,000,000 1 Price/Bag Cost/Bag Gross Profit/Bag $2.99 $0.90 $2.09 $2.99 $1.30 $ $1.69 $2.99 $1.00 $1.99 $2.99 $0.60 $2.39 each type of trail mix. Gross Profit/Type $2 $2 $2 $2 Total Profit $8 3 hol 4 5 6 7 9 10 11 12 13 14 15 16 12 18 19 20 21 22 23 24 25 26 27 29 29 30 31 32 33 34 35 Material Totals Used 3 Ingredients Chocolate Granola Peanuts Sunflower Seeds ... Available 12,000,000 14,000,000 5,000,000 11,000,000 F 2 3 C. Note that you should not use the comma separator when you create this constraint (use 1000000 instead of 1,000,000) 000 d. The ingredients consumed in making the mixes (range C22:025)) should not exceed what is available (range D22:D25). e. There is a national nut shortage and they are expensive. To avoid nuts spoiling, you must use all of the nuts. f. Make only whole number amounts of mixes g. Before solving make the solving method Simplex LP and checkmark Add-ins loaded successfully ? OU Average Attendance Total Merch Sales Sporting Events Goncerts Food Sales Trail Past Events Event Profit + Ready + 100% 45 APR 6 tv s A w Excel File Edit View Insert Format Tools Data window Help a 80 O Wed Apr 6 4:26 PM O AutoSave OFF 2 ... Book 3 a 8 Home Insert Draw Page Layout Formulas Data Review View Tell me Share W Comments Calibri (Body) 12 AFA = = General ' I) 12800 me [ Insert PX Delete Format Paste B TU CA = v = Sensitivity + + Tasks $ % ) Find & Select Conditional Format Cell . Formatting as Table Styles Sort & Filter Analyze Data A1 x fx A 3 D E F F G H 1 K M N a 1 Ingredients Chacalate Chips Granola Peanuts Sunflower Seeds Not Nutts 1 1 1 0 1 Trail Mix Varieties Delace Traditional 1 0 1 1 1 1 1 1 1 Sweet Tooth 1 1 0 D Cost $0.30 $ $0.30 $0.40 $0.30 MyEducator Tasks x (range D22:025)). e. There is a national nut shortage and they are expensive. To avoid nuts spoiling, you must use all of the nuts. f. Make only whole number amounts of mixes. g. Before solving make the solving method Simplex LP and checkmark the Make Unconstrained variables Non-negative option. Demand Total to Make 4,000,000 1 5,000,000 1 1 2,000,000 1 1 2,000,000 1 Price/Bag Cost/Bag Gross Profit/Bag $2.99 $0.90 $2.09 $2.99 $1.30 $ $1.69 $2.99 $1.00 $1.99 $2.99 $0.60 $2.39 Gross Profit/Type $2 $2 $2 $2 Total Profit $8 3 hol 4 5 6 7 9 10 11 12 13 14 15 16 12 18 19 20 21 22 23 24 25 26 27 29 29 30 31 32 33 34 35 = 45 Material Totals Used 3 Ingredients Chocolate Granola Peanuts Sunflower Seeds ... Available 12,000,000 14,000,000 5,000,000 11,000,000 F 2 3 14) Given the problem constraints, which Gross Profit amount is closest to the maximum profit possible for this problem? $22,800,000 $23,700,000 $24,600,000 $25.500.000 O Average Attendance Total Merch Sales Sporting Events Goncerts Food Sales Trail Past Events Event Profit + Ready Add-ins loaded successfully + 100% 45 APR 6 tv s A w Excel File Edit View Insert Format Tools Data window Help a 80 O Wed Apr 6 4:26 PM O AutoSave OFF 2 ... Book 3 a 8 Home Insert Draw Page Layout Formulas Data Review View Tell me Share W Comments Calibri (Body) 12 AFA = = General ' 12800 F) Insert Tax Delete v Format me Paste B TU CA = = v + + Tasks $ % ) Conditional Format Cell . Formatting as Table Styles Find & Select Sort & Filter Analyze Data Sensitivity A1 x fx A 3 D E F F G H 1 K M N a 1 Ingredients Chacalate Chips Granola Peanuts Sunflower Seeds Not Nutts 1 1 1 0 1 Trail Mix Varieties Delace Traditional 1 0 1 1 1 1 1 1 1 Sweet Tooth 1 1 0 D Cost $0.30 $ $0.30 $0.40 $0.30 MyEducator Tasks 14) Given the problem constraints, which Gross Profit amount is closest to the maximum profit possible for this problem? Demand Total to Make 4,000,000 1 5,000,000 1 1 2,000,000 1 1 2,000,000 1 Price/Bag Cost/Bag Gross Profit/Bag $2.99 $0.90 $2.09 $2.99 $1.30 $ $1.69 $2.99 $1.00 $1.99 $2.99 $0.60 $2.39 $22,800,000 $23,700,000 $24,600,000 O $25,500,000 $26,400,000 O $27,300,000 Gross Profit/Type $2 $2 $2 $2 Total Profit 3 hol 4 5 6 7 9 10 11 12 13 14 15 16 12 18 19 20 21 22 23 24 25 26 27 29 29 30 31 32 33 34 35 $8 Material Totals Used 3 Ingredients Chocolate Granola Peanuts Sunflower Seeds ... Available 12,000,000 14,000,000 5,000,000 11,000,000 F 2 3 15) Production would fall short of demand for which variety of trail mix? OOOO O Not Nutts O Deluxe O Traditional O Sweet Tooth Average Attendance Total Merch Sales Sporting Events Goncerts Food Sales Trail Past Events Event Profit + Ready Add-ins loaded successfully - -- + 100% 45 APR 6 tv SA w