A B C D E 1 Module 1 Spreadsheet Assignment 2 3 Linear Program Model: Crumb and Custard Bakery 4 FL G H 5 Products Cakes Danishes 6 Profit per item: 1 5 7 Resources: Usage Constraint Available Left over 8 Flour (lb) 5 5 < 25 9 Sugar (lb) 2 4 16 10 Demand (cakes) 1 0 5 11 12 Production: 13 Cakes= 14 Danishes= 15 Profit= The Crumb and Custard Bakery makes coffee cakes and Danish pastries in large pans. The main ingredients are flour and sugar. There are 25 pounds of flour and 16 pounds of sugar available, and the demand for coffee cakes is 5. Five pounds of flour and 4 pounds of sugar are required to make a pan of Danish. A pan of coffee cakes has a profit of $1, and a pan of Danish has a profit of $5. Determine the number of pans of cakes and Danish to produce each day so that profit will be maximized. Formulate a linear programming model for this problem. Solve this model by using Excel and Solver.
A B C D E 1 Module 1 Spreadsheet Assignment 2 3 Linear Program Model: Crumb and Custard Bakery 4 FL G H 5 Products Cakes Danishes 6 Profit per item: 1 5 7 Resources: Usage Constraint Available Left over 8 Flour (lb) 5 5 < 25 9 Sugar (lb) 2 4 16 10 Demand (cakes) 1 0 5 11 12 Production: 13 Cakes= 14 Danishes= 15 Profit= The Crumb and Custard Bakery makes coffee cakes and Danish pastries in large pans. The main ingredients are flour and sugar. There are 25 pounds of flour and 16 pounds of sugar available, and the demand for coffee cakes is 5. Five pounds of flour and 4 pounds of sugar are required to make a pan of Danish. A pan of coffee cakes has a profit of $1, and a pan of Danish has a profit of $5. Determine the number of pans of cakes and Danish to produce each day so that profit will be maximized. Formulate a linear programming model for this problem. Solve this model by using Excel and Solver.
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter7: Nonlinear Optimization Models
Section7.3: Pricing Models
Problem 2P
Related questions
Question
I have little experience in Excel with formulas and have never used Solver before. How can the attached information be entered into Solver in Excel? I have added information to help.
Decision Variables
Cakes (x1)
Danishes (x2)
Objective Function
Max Z = $1x1 + 5x2
Constraints
5x1 + 5x2 ≤ 25 (flour, lb.)
2x1 + 4x2 ≤ 16 (sugar, lb.)
x1 ≤ 5 (demand, cakes)
x1 , x2 ≥ 0
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,