Need Help

Module/Week 2 Homework: Introduction to Optimization Modeling MGMT 5260: Decision-Making Techniques for Managers Please create a single Excel file with each problem on a separate worksheet tab. The problem description for Problem 1 can be found on page 127 of your Practical Management Science textbook, and the problem description for the optional extra-credit question can be found on page 125. Tom's Restaurant has an iee cream counter where it sells two main products, iee cream and frosen yogurt. each in saricty of llavors. The restaurant makes one order for ice eream and yogurt each weck. and the store has cnough freeser space for 115 gallons of both products. A gallon of ice cream costs 50.93 and a gallon of froren yogurt costs $0.75, and the restaurant budgets 590 cach week for these products. The manager estimates that each week the restaurant sells at least twice as much ice cream as frozen yogurt. Profit per gallon of ice cream is $4.15 and profit per gallon of yogurt is $3.60 How many gallons of ice cream and frozen yogurt should restaurant order to "OPTIONAL Problem 3.26(a) Manufacturing Desks and Chairs (p. 125) - No template will be provided for this optional, extra credit problem. Please use the problem description from page 125 of your texibook to create the spreadsheet model. - If you provide a correct solution then you will be awardeb 7 extra bouns points for this homework assignment. - There will be no partial benus points awarded for a partial solution. Your answet must be filly correct to receite exira credit. Module/Week 2 Homework: Introduction to Optimization Modeling MGMT 5260: Decision-Making Techniques for Managers Please create a single Excel file with each problem on a separate worksheet tab. The problem description for Problem 1 can be found on page 127 of your Practical Management Science textbook, and the problem description for the optional extra-credit question can be found on page 125. Tom's Restaurant has an iee cream counter where it sells two main products, iee cream and frosen yogurt. each in saricty of llavors. The restaurant makes one order for ice eream and yogurt each weck. and the store has cnough freeser space for 115 gallons of both products. A gallon of ice cream costs 50.93 and a gallon of froren yogurt costs $0.75, and the restaurant budgets 590 cach week for these products. The manager estimates that each week the restaurant sells at least twice as much ice cream as frozen yogurt. Profit per gallon of ice cream is $4.15 and profit per gallon of yogurt is $3.60 How many gallons of ice cream and frozen yogurt should restaurant order to "OPTIONAL Problem 3.26(a) Manufacturing Desks and Chairs (p. 125) - No template will be provided for this optional, extra credit problem. Please use the problem description from page 125 of your texibook to create the spreadsheet model. - If you provide a correct solution then you will be awardeb 7 extra bouns points for this homework assignment. - There will be no partial benus points awarded for a partial solution. Your answet must be filly correct to receite exira credit