excel

Bagels ) Croissants Solution Total profil 5 Objective RS CHE Constraints Flour Yeast suga Demand for Magel 6 1 2 1 4 11 13 Scroll down to all the questions A local pel shop produces apels) and cross daily. Each bagel requires ounces of four, igram of yeast, and 2 fable pont of Acant requires ounces of our gram of yeast and tablespoons of a The company has ces of flour, 1400 grams of yeast and tablespoons of valable for today's blanc et profits ww30 cants each and cromato e 30 cents each. The shop wishes to manimise profit. There is a minimum daily demand of 500 bagels that has to be met The line or model to determine the optimal number of bagel and croissants the shop should produce to nesimies pruit is given below: Bumber of bagel. number of crosants Objective function Marimotal pront-2000 futject to 6.30 0600 Constraint for floor) 1400 Constraint for east) 28.4cc constraint for suw) B500 ROO in the template to the right complete the speachheet model for this problem and solve it using Selver According to your optimal solution how many should the shop produce 1) According to your optimal solution how many tissants should the shop produce I What is the maximum profit that can be obtened? 10 How many ounces of flour will be left? 1 200 tablespoons of sugar are added to the available amount will that change the optimal solution? 1121 Change the available amount of back to the original data. Then check if the optimal solution changes when the available amount of yeast becomes 1500 gram. How many bagels should they produce now! Bagels ) Croissants Solution Total profil 5 Objective RS CHE Constraints Flour Yeast suga Demand for Magel 6 1 2 1 4 11 13 Scroll down to all the questions A local pel shop produces apels) and cross daily. Each bagel requires ounces of four, igram of yeast, and 2 fable pont of Acant requires ounces of our gram of yeast and tablespoons of a The company has ces of flour, 1400 grams of yeast and tablespoons of valable for today's blanc et profits ww30 cants each and cromato e 30 cents each. The shop wishes to manimise profit. There is a minimum daily demand of 500 bagels that has to be met The line or model to determine the optimal number of bagel and croissants the shop should produce to nesimies pruit is given below: Bumber of bagel. number of crosants Objective function Marimotal pront-2000 futject to 6.30 0600 Constraint for floor) 1400 Constraint for east) 28.4cc constraint for suw) B500 ROO in the template to the right complete the speachheet model for this problem and solve it using Selver According to your optimal solution how many should the shop produce 1) According to your optimal solution how many tissants should the shop produce I What is the maximum profit that can be obtened? 10 How many ounces of flour will be left? 1 200 tablespoons of sugar are added to the available amount will that change the optimal solution? 1121 Change the available amount of back to the original data. Then check if the optimal solution changes when the available amount of yeast becomes 1500 gram. How many bagels should they produce now