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

See similar textbooks

Decision Variables

Cakes (x₁)

Danishes (x₂)

Objective Function

Max Z = $1x₁ + 5x₂

Constraints

5x₁ + 5x₂≤ 25 (flour, lb.)

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

x₁≤ 5 (demand, cakes)

x₁ , 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=

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

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

An airline studied the data from their passenger records and noted that their customers turn up only about 95% of the time. A flight can accommodate 40 passengers and each seat costs 4,000 Php. Suppose each passenger books a ticket independently and the airline decides to sell 42 tickets for the flight. If more than 40 show up for the flight , then the extra passengers will be compensated PhP10,000 for rebooking and other expenses. 5. If Profit = Ticket sales-Compensation of Bumped passenger(s). What is the profit if 42 customers show up?
The local supermarket buys lettuce each day to ensure very fresh produce. Each morning, any lettuce that is left from the previous day is sold to a dealer that resells it to farmers who use it to feed their animals. This week, the supermarket can buy fresh lettuce for $4 a box. The lettuce is sold for $10 a box and the dealer that sells old lettuce is willing to pay $1.50 a box. Past history says that tomorrow’s demand for lettuce averages 250 boxes, with a standard deviation of 34 boxes. How many boxes of lettuce should the supermarket purchase tomorrow?
Pane 3. Assume a company receives cash from different geographic areas of $500,000 daily. The average float of the cash receipt is 4 days. Interest rate on savings is 6% per year. If the company institutes a lock-box system, it will reduce the float to two days. It will cost $80,000 to install the lock-box system and an additional monthly fee of $1,000 to operate it. Should the company install the lock-box system?
49 The local supermarket buys lettuce each day to ensure really fresh produce. Each morning, any lettuce that is left from the previous day is sold to a dealer that resells it to farmers who use it to feed their animals. This week, the supermarket can buy fresh lettuce for $7.00 a box. The lettuce is sold for $18.00 a box and the dealer that sells old lettuce is willing to pay $2.00 a box. Past history says that tomorrow's demand for lettuce averages 255 boxes with a standard deviation of 40 boxes.
Joint Products Choi Company manufactures two skin care lotions, Smooth Skin and Silken Skin,from a joint process. The joint costs incurred are $420,000 for a standard production run that generates 180,000 pints of Smooth Skin and 120,000 pints of Silken Skin. Smooth Skin sells for $2.40 perpint, while Silken Skin sells for $3.90 per pint.Required1. Assuming that both products are sold at the split-off point, how much of the joint cost of each production run is allocated to Smooth Skin using the relative sales value method?2. If no separable costs are incurred after the split-off point, how much of the joint cost of each productionrun is allocated to Silken Skin using the physical measure method method?3. If separable processing costs beyond the split-off point are $1.40 per pint for Smooth Skin and $0.90 perpint for Silken Skin, how much of the joint cost of each production run is allocated to Silken Skin usinga net realizable value method?4. If separable processing costs beyond the…
2.28 A foundry produces castings to order. An order for 20 special castings has been re- ceived. Since the casting process is highly variable, not all castings produced are good. The cost of producing each casting is $550; the additional cost of finishing a good casting is $125. If a casting is not good, it is recycled at a value of $75; excess good castings are not finished but are recycled at a value of $75. The customer has agreed to accept 15, 16, 17, 18, 19, or 20 castings at a price of $1250 each. If fewer than 15 good castings are produced, none will be purchased by the customer. Prob- ability distributions for the number of good castings produced in a batch of varying sizes are given below. How many castings should be scheduled in order to maximize expected profit? #Good Castings 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 79 2 PRODUCT, PROCESS, AND SCHEDULE DESIGN Number of Castings Scheduled 15 16 17 0.05 0.00 0.00 0.00 0.00 0.00 0.05 0.05 0.00…
The GIIC -Company must determine a policy for ordering coal to operate 15 smelters. Each smelter requires exactly 5 tons of coal per day to operate, and the firm operates 360 days per year. The purchasing manager has negotiated a contract to obtain the coal for 5 BD per ton for the coming year. The purchasing manager has determined that the ordering cost is 40 BD per order, and the cost of holding coal is 20% per ton of its value. i. Determine the optimal quantity of coal to receive in each order. ii. Determine the total inventory-related costs associated with the optimal ordering policy (do not include the cost ii. If five days' lead time is required to receive an order of coal, how much coal should be on hand when an iv. Optimal quantity 1837.11 Tons, Total cost 1837.11 BD, Inventory during LT 275 Tons of the coal). order is placed? i. Optimal quantity 1469.694 Tons, Total cost 1469.694 BD, Inventory during LT 375 Tons ii. Optimal quantity 734.85 Tons, Total cost 1649.694 BD,…
4
As a potential owner of a club known as Club Salida, you are interested in determining the necessary volume of sales in dollars to reach the breakeven next year. You decided to break down the club's sales into. four categories, where beer is the first. Your estimate of the sale of beer is that it will serve 30,000 servings. The selling price per unit will average $ 1.50; its cost is $ .75. The second category is food, of which you expect sell 10,000 units with an average unit price of $ 10.00 and a cost of $ 5.00. The third category is desserts and wine, of which you also hope to sell 10,000 units, but with an average unit price of $ 2.50 and a cost of $ 1.00. The last category is inexpensive lunches and sandwiches, of which you expect sell a total of 20,000 units with an average price of $ 6.75 and a cost per unit of $ 3.25. Your fixed costs (i.e. rent, utilities, etc.) are $ 1,800 a month plus $ 2,000 a month for entertainment. a) What is your breakeven point in dollars per month? b)…
A company produces electrical circuit boatds .each circuit board has a raw material input of P60 and labour inout that cost P20 the company intemds to produce 1000 circuit boards per week.the company must also pay yh rent of the factory totalling P20 000 per annum.busines ratrs of 4000 per annum and the production directors salary of P24 000.what is the fixed cost of the business
A manufacturer has a production facility that requires 15,604 units of component JY21 per year. Following a long-term contract, the manufacturer purchases component JY21 from a supplier with a lead time of 7 days. The unit purchase cost is $25.6 per unit. The cost to place and process an order from the supplier is $121 per order. The unit inventory carrying cost per year is 10.5 percent of the unit purchase cost. The manufacturer operates 250 days a year. Assume EOQ model is appropriate. If the manufacturer uses a constant order quantity of 2,640 units per order, what is the annual holding cost? Use at least 4 decimal places.
A manufacturer that produces 100 different products is considering building a new warehouse because there is no room in raw material and product warehouses. Because although some products are more than in the warehouse, some demands that come due to the fact that the ban products are not enough in the warehouse are avoided. For this reason, it plans not to miss any demand by producing and storing enough of all its products, and of course it is considering building a new and larger warehouse to store more products. What can you suggest to this company, taking into account what is described in the course, describe your proposal in maximum detail with the concepts described in the course, as applicable activities.