A bakery shop MeltingFat wants to expand its business. MeltingFat already purchased 3 factories for its...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A bakery shop MeltingFat wants to expand its business. MeltingFat already purchased 3 factories for its main product, Buttery Croissant. Table 1 shows the production capacity and unit production cost for the factories in the three cities. Factory 1 2 3 Units Ordered لها Capacity (Unit Week) 90 120 120 150 Table 1 Four restaurants have made orders for the coming month. Table 2 shows their orders. Restaurants 1 3 70 2 60 Unit Production Cost ($/Unit) $20 $20 $18 Table 2 4 80 The per-unit shipping costs from factories to restaurants are as shown in Table 3 Unit shipping costs to Restaurants Restaurant 3 $7 $6 $12 Factory 1 Factory 2 Factory 3 Restaurant 1 $8 $9 $14] Restaurant 2 $6 $ 12 $9 Table 3 a) Formulate a Linear Programming model that minimizes the cost. b) Solve the model using Excel Solver. Restaurant 4 $10 $ 13 $ 16 A bakery shop MeltingFat wants to expand its business. MeltingFat already purchased 3 factories for its main product, Buttery Croissant. Table 1 shows the production capacity and unit production cost for the factories in the three cities. Factory 1 2 3 Units Ordered لها Capacity (Unit Week) 90 120 120 150 Table 1 Four restaurants have made orders for the coming month. Table 2 shows their orders. Restaurants 1 3 70 2 60 Unit Production Cost ($/Unit) $20 $20 $18 Table 2 4 80 The per-unit shipping costs from factories to restaurants are as shown in Table 3 Unit shipping costs to Restaurants Restaurant 3 $7 $6 $12 Factory 1 Factory 2 Factory 3 Restaurant 1 $8 $9 $14] Restaurant 2 $6 $ 12 $9 Table 3 a) Formulate a Linear Programming model that minimizes the cost. b) Solve the model using Excel Solver. Restaurant 4 $10 $ 13 $ 16
Expert Answer:
Answer rating: 100% (QA)
To formulate a linear programming model that minimizes the cost for MeltingFats expansion we need to ... View the full answer
Related Book For
Financial Reporting Financial Statement Analysis and Valuation a strategic perspective
ISBN: 978-1285190907
8th edition
Authors: James M. Wahlen, Stephen P. Baginski, Mark Bradshaw
Posted Date:
Students also viewed these general management questions
-
1. How strong are the competitive forces confronting J. Crew in the market for specialty retail? Do a [Michael Porter] five-forces analysis to support your answer. (see chapter 3 in the textfor...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Measure each amount given in Problems 1721. a. Container C in ounces b. Container C in milliliters mL 500- 400- 300 200- 100 cups 2 1 -16-ez -14 oz -12 oz -110 oz 8 oz -16 oz -4 oz 2 oz Container C...
-
The basic accounting equation is: Assets 5 Liabilities 1 Stockholders' Equity. Replacing the words in that equation with dollar amounts, what is The Coca-Cola Company's accounting equation at...
-
Describe the fast pace and frenetic activity of first-line managers.
-
Use the relationship between force and impulse to explain how padded boxing gloves protect a boxer's hands.
-
GreenLawns provides a lawn fertilizer and weed control service. The company is adding a special aeration treatment as a low-cost extra service option, which it hopes will help attract new customers....
-
(a) Identify and explain the various ways through which government can intervene and assist upcoming Small entrepreneurs to grow and sustain their enterprises. (b) Explain the rationale behind SWOT...
-
Repeat Example 3.3, but assume that the ammonia, air, and water are brought into contact in a closed container. There is $10.0 \mathrm{~m}^{3}$ of gas space over the liquid. Assuming that the...
-
You start saving to buy a house ten years from today. The average house in your town sells today for $135.000. Housing prices are expected to increase 2.5 percent a year. When you buy your house ten...
-
What methodologies and research approaches are commonly employed within social constructionist inquiries, and how do they facilitate the deconstruction of taken-for-granted assumptions and societal...
-
Two parallel, metal plates with separation distance d = 1.00 cm carry charges of equal magnitude but opposite sign. The plates are oriented horizontally. Assume the electric field between the plates...
-
How does social constructionism elucidate the intricacies of knowledge production and the formation of subjective realities within diverse sociocultural contexts?
-
How do subcultural theories elucidate the formation and perpetuation of deviant behavior within marginalized or countercultural groups, and what insights do they offer into the relationship between...
-
Can deviance be understood purely through a psychological lens, or does it necessitate a broader sociological analysis encompassing factors such as socialization, inequality, and institutional...
-
Oriole Company earns 11% on an investment that will return $360,000 8 years from now. Click here to view the factor table. (For calculation purposes, use 5 decimal places as displayed in the factor...
-
For what reason might an exporter use standard international trade documentation (letter of credit, draft, order bill of lading) on an intrafirm export to its parent or sister subsidiary?
-
Most economists describe three determinants of the interest rates on a borrower's debt: a real interest rate, which is a charge for using capital; an adjustment for expected inflation to insure that...
-
Diviney Company wants to raise $50 million cash but for various reasons does not want to do so in a way that results in a newly recorded liability. The firm is sufficiently solvent and profitable, so...
-
Prime Contractors (Prime) is a privately owned company that contracts with the U.S. government to provide various services under multiyear (usually five-year) contracts. Its principal services are as...
-
Two residents of California filed a lawsuit against Hertz Corporation on behalf of a group of people arguing that the companys labor practices were illegal. The corporation was labeling workers as...
-
What stakeholder affected by their behavior was Gilead weighting very lightly when it decided what to tell the FDA about the medicines it wished to have permission to sell?
-
In 2014, political consulting firm Cambridge Analytica developed an app designed to create digital profiles of individuals via their information. Cambridge Analytica collected the data by inviting...
Study smarter with the SolutionInn App