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
icon
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 + 5x≤ 25 (flour, lb.)

2x1 + 4x≤ 16 (sugar, lb.)

x≤ 5 (demand, cakes)

x1 , x≥ 0

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=
Transcribed Image Text: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.
Transcribed Image Text: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.
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,