What are the constraints A soft drink manufacturing company has three factories—one in Orlando, one in Tampa, and one in Port St. Lucie—that supply soft drink bottles to three warehouses located in the city of Miami. The associated per-unit transportation cost between the factories and the warehouses is provided in the table below.**Transportation Costs ($)**| Factories/Warehouse (W) | W1 | W2 | W3 ||-------------------------|----|----|----|| Orlando | 7 | 4 | 5 || Tampa | 7 | 6 | 4 || Port St. Lucie | 5 | 5 | 6 |- The factory in Orlando has a capacity of 14,000 units.- The factory in Tampa has a capacity of 25,000 units.- The factory in Port St. Lucie has a capacity of 23,000 units.The requirements of the warehouses are:| Warehouse | Requirement (Bottles) ||-----------|-----------------------|| W1 | 18,000 || W2 | 19,000 || W3 | 22,000 |Determine how much of the company’s production should be shipped from each factory to each warehouse in order to minimize the total transportation cost. The image shows a spreadsheet aimed at optimizing a transportation problem involving three factories and three warehouses. Here's a detailed transcription:### Transportation Costs ($)- **Factories/Warehouse (W)** - Costco Warehouses: W1, W2, W3 - **Orlando** - Costs: W1 - $7, W2 - $4, W3 - $5 - **Tampa** - Costs: W1 - $7, W2 - $6, W3 - $4 - **Port St. Lucie** - Costs: W1 - $5, W2 - $5, W3 - $6- **Warehouse Requirement (Bottles)** - W1: 18,000 bottles - W2: 19,000 bottles - W3: 22,000 bottles### Model- **Production to be Shipped** - Factories: Orlando, Tampa, Port St. Lucie - Each factory's shipments are initially set to 0 for W1, W2, and W3.### Capacity- **Orlando** - 14,000 bottles- **Tampa** - 25,000 bottles- **Port St. Lucie** - 23,000 bottles### Constraints- The grid for "Constraints" does not have any specified constraints yet.### Formula for Outcome- The outcome is calculated using the formula: - `C11*B10+C21*C10+C31*D10+C12*B11+C22*D11+C32*D12+C13*B12+C23*C12+C33*D12` This formula likely represents the total transportation cost, calculated by summing the products of shipment quantities and respective costs.### Minimum- The column titled "Minimum" is adjacent but currently without data.This setup is typical for modeling transportation or supply chain problems where the goal is to minimize costs while meeting production and demand constraints.

This is a transportation problem. As from the excel image, let's consider each decision variable as…

Answered: What are the constraints

Business

Operations Management

What are the constraints

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Decision Under Uncertainty The digital television service company TV-más is facing a significant problem of customer loss in recent months, in particular, customers of the Home plan, which consists of an annual subscription whose value is $200 and that allows you to watch more than 40 high definition television channels. The company has prepared a list of clients who have decided that once the subscription has ended, they will not contract the service again, since, among several reasons , they maintain that the company does not treat its clients well. Considering customer opinions, the company has thought of a plan so that customers who have decided not to renew can reverse their decision and subscribe to the service for one more year. The plan consists of giving a gift to customers who have decided not to renew in order to show concern for them. The gift consists of a set of kitchen pots, with the company logo, which costs the company $50. According to information from a pilot plan…
State and explain the role of logistixsy in aviation industry ?
Subject: Procurement & sourcing Q): What is procurement & sourcing in supply chain?
Need d and e
Define facility management. Include reference
What is resource levelling, and how does it work?
Question A During the year ended 30 Jun 2022, Cecilia, a resident of Australia, has received rents of S50,000 and salary of $27799. She also receives a fully franked dividend of $30,000 from a Company that pays tax at the 30% tax rate Har allowable deductions for the year are $12977. Required Calculate her taxable income. Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line
Module 5 Question 8 Mayborn Enterprises, LLC runs a number of sporting goods businesses and is currently analyzing a new T-shirt printing business. Specifically, the company is evaluating the feasibility of this business based on its estimates of the unit sales, price per unit, variable cost per unit, and fixed costs. The company's initial estimates of annual sales and other critical variables are shown here: Base CaseUnit sales 7,500Price per unit $16.00Variable cost per unit $10.00Fixed cash expense per year $10,000Depreciation expense $4,000 a. Calculate the accounting and cash break-even annual sales volume in units. b. Bill Mayborn is the grandson of the founder of the company and is currently enrolled in his junior year at the local state university. After reviewing the accounting break-even calculation done in part a, Bill wondered if the depreciation expense should be included in the calculation. Bill had just completed his first finance class…
nity College | Pima x B Module 12 Practice Assignment 6 Question 1- Module 12 Practice x A ezto.mheducation.com/ext/map/index.html?_con=con&external_browser=D0&launchUrl=https%253A%252F%252Flms.mheducation.com%252Fmghmiddleware%252Fr ediStay v4 E New Scorpion O Redistay - (Unknown) U Ulitpro -New e Scorpion (UAT) 5) Springfield - Home inContact Dashboards RediStay v4 (UAT) -... lodule 12 Practice Assignment_Ch.17 i Saved 1 Challenge Problem 17-25 (Static) [LU 17-2 (2)] A delivered price (including attachments) of a crawler dozer tractor is $135,000 with a residual value of 35%. The useful life of the tractor is 7,700 hours eBook Print a. What is total amount of depreciation allowed? References Total amount b. What is the amount of depreciation per hour? (Round your answer to the nearest cent.) Amount of depreciation per hour
8 write a contract to manufacturing company to marketing company?
Do it with refrences
Q: Final Reduced Objective Allowable Allowable Cell Name Value Cost Coefficient Increase Decrease $B$5 consider Cake (C) 0 -0.5 4.5 0.5 1E+30 $C$5 consider Dozen Cookies (D) 10 0 10 1E+30 1 what does the value minus .5 for the reduced cost of C mean (other than it is the change in thevalue of the coefficient in the objective function so that the solution includes a positive amountof C)?