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 associatedper-unit transportation cost between the factories and the warehouses is provided in the table below.Factories/Warehouse (W)OrlandoTampaPort St. LucieTransportation Costs ($)WarehouseW1W2W3W1775The 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:Requirement(Bottles)W2418,00019,00022,00065W3546Determine how much of the company's production should be shipped from each factory to each warehouse in order to minimize the total transportation cost? ABTransportation Costs ($)W112 Factories/Warehouse (W)3 Orlando4 Tampa5 Port St. Lucie6 Warehouse Requirement (Bottles)78 Model9 Production to be shipped10 Orlando11 Tampa12 Port St. Lucie131415 Constraints161718W17718000OOO000W2W2C4W35645619000 22000ܘܘܘDW30OOO00ECapacity140002500023000shipped004FGTransportation Costs ($)W1C11C12C13Factories/Warehouse (W)OutcomeOrlandoTampaPort St. LucieWarehouse Requirement (Bottles)H18000W2C21C22C23C11*B10+C21*C10+C31*D10+c12*B11+c22*d11+c13*B12+c23*C12+c33*D1219000W3C31C32C33J22000Minimum

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

Related questions

Q: Using the FCFS rule for scheduling, the sequence is 1-2-3 3-2-1 1-3-2 2-1-3 2-3-1 3-1-2 Sunny Park…

A: FCFS: FCFS stands for First Come and First Serve. As per the FCFS rule, the process…

Q: A copier store has four pieces of automatic equipment, but sometimes they are down because they need…

A: There are four pieces that need maintenance. Hence, this is a finite calling population queue.…

Q: Identify the objectives of Nike

A: Nike Inc. fights against competition while pursuing global market supremacy. Competitive rivalry…

Q: Given the following product structure, master production schedule, and inventory status below and…

A: Given information is Period 8 9 10 11 12 Gross req of A 100 60 160 Gross req of H 90…

Q: Using a 95% confidence level, the upper and lower control limits are: Upper control limit…

A: Formulae used: σp =P -+ (1-P)n For control limit: UCLp =P + Z×σp

Q: Hart Manufacturing makes three products. Each product requires manufacturing operations in three…

A: Objective Functions and Constraints: Based on the given details, the objective…

Q: Develop a minimum makespan schedule using Johnson's rule. The schedule using Johnson's rule is - -…

A: Sequencing is an appropriate order of plan as per which the process of operations works. It defines…

Q: What is the initial total cost of the given transportation model if an Intuitive Approach method is…

A: Given the data stated below, Here, I would apply the intuitive approach method to determine the…

Q: A contractor, Susan Meyer, has to haul gravel to three building sites. She can purchase as much as…

A: Objective functions and constraints: Objective functions: Minimize C = (100+300) X11…

Q: Explain the role of TPS in Supply chain management

A: TPS stands for transaction processing system. This is an information system that is commonly used by…

Q: discuss what a baseline budget is and its relevance using the scenario.

A: In order to set up a baseline budget, it’s important to know what your company can afford to spend…

Q: Discuss solutions to high production Cost

A: A company that produces goods or merchandise is considered a manufacturer. Putting together various…

Q: What is the service rate for the service technician? minutes/unit What is the labor utilization…

A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…

Q: Product A is an end item and is made from two units of B and four of C. B is made of three units of…

A: Ans) Product Tree:

Q: 2.13 Consider a simple three-step manufacturing process as illustrated in the given figure. Assuming…

A: Given data: Defect rate for Process-1 (d1) = 3% Defect rate for Process-2 (d2) = 5%Defect rate for…

Q: The demand for subassembly S is 100 units in week 7. Each unit of S requires 1 unit of T and 2 units…

A: Product structure- shows the hierarchy-based decomposition of the product, It is generally called…

Q: The Fruits&Nuts Blending Problem Fruits & Nuts produces Yummix, a snack that is a mixture of dried…

A: Let dried fruits composition be a nuts be b cereal be c Objective is to minimize the cost Objective…

Q: The Ace Manufacturing Company has orders for three similar products. Product A B C 1 2 Machine 3 A A…

A: (a)

Q: The Open Science Framework has developed different badges to recognize ethical and transparent…

A: The open science framework (OSF) is a strategic tool used by companies to promote stabilized…

Q: The Dulac Box plant works two 8-hour shifts each day. In the past, 500 cypress packing boxes were…

A: Productivity is analysis of a efficient of company's performance that compare the product and…

Q: What is meant by "Fordism"? explain briefly and give an example.

A: The term "Fordism" refers to a way of economic development and progress where mass production of…

Q: 1. Draw a network diagram representing the project. Put the node numbers in circles and draw arrows…

A: A table consisting of activity names, initial node, final node and estimated duration is given in…

Q: What are the disadvantages of the supply management

A: The act of locating, obtaining, and managing resources, including suppliers, that seem to be crucial…

Q: Brooks Development Corporation (BDC) faces the following capital budgeting decision. Six real estate…

A: Given data is Project 1 2 3 4 5 6 NPV ($ millions) 19 9 17 18 24 13 Expenditure ($ millions)…

Q: , schedule, and control a wide variety of projects. List the four projects according as they appear…

A: In essence, CPM and PERT are project management methodologies that were developed by Western…

Q: Suppose a certain manufacturing company produces connecting rods for 4- and 6-cylinder automobile…

A: Decision variable: Suppose-x4 = the number of 4-cylinder connecting rods produced next week.x6 = the…

Q: A company manufactures x units of Product A and y units of Product B, on two machines, I and II. It…

A: Linear programming is a mathematical technique that is also used in operations management…

Q: The Scottsville Textile Mill produces several different fabrics on eight dobby looms that operate 24…

A: There are 8 dobby looms. Each Dobby loom turns 4.62 yards of fabric per hour. The looms operate 24…

Q: Using samples of 197 credit card statements, an auditor found the following: Sample 1 3 errors…

A: Find the Calculation methods below: Fraction Defectives = Number with Errors Credit Card…

Q: What is meant by bench marking? Explain the benefits a firm derives from benchmarking

A: By comparing your company's success to that of other comparable businesses, you may determine…

Q: Mattress Wholesalers, Inc. is constantly trying to reduce inventory in its supply chain. Last…

A: Given, Last year: COGS = $7.48 million Inventory = $1.48 million This year: COGS = $8.56 million…

Q: Topic: Problems and Concerns in Retail Business Operations These are the concerns of business…

A: Retail business operations are the activities that are directly occurring between the seller and the…

Q: Answer each of the following two problems (1) using regression analysis (easiest way is using the…

A: Given data is

Q: Good Project management software provides features helpful in successfully managing the project.…

A: Project management includes the planning and organizing of the resources related to the task or…

Q: f JIT (Just-In-Time) means both a technical solution to the scheduling task and a managerial…

A: Just-In-Time (JIT) is a manufacturing philosophy that emphasizes the efficient use of manufacturing…

Q: The Economic Order Quantity (EOQ) model is a classical model used for controlling inventory and…

A: Economic order quantity (EOQ) is the optimal quantity that helps in minimizing the total annual cost…

Q: California Gardens, Inc., prewashes, shreds, and distributes a variety of salad mixes in 2-pound…

A: The crossover point is the point at which the total of the fixed and variable costs for any two…

Q: a) How many tires should Rocky Mountain order each time it places an order? Rocky Mountain's optimal…

A: EOQ = √(2DS/H) Annual Holding cost = (Q*H)/2 Annual Setup cost = (D*S)/Q Annual purchase cost =…

Q: Activity A can start as soon as the project starts, and set the earliest start time for activity an…

A: Given: Duration of activity A (D) = 5 Early start of activity A (ES) = 0

Q: Supply chain configuration represents how the participating company members relate to each other to…

A: Companies may usually desire or expect to have complete control over their entire supply chain…

Q: Cycle Time and Velocity, MCE Computador has a manufacturing plant in Des Moines that has the…

A: Theoretical capacity = 182,250 Actual capacity = 72,900 Conversion cost = $7,290,000 Available…

Q: Radovilsky Manufacturing Company, in Hayward, California, makes flashing lights for toys. The…

A: Total anuual cost is the sum of Average holding cost , Average setup cost and purchase cost of the…

Q: You have developed the following simple product structure of items needed for your gift bag for a…

A: Given data: Requirement of end item (J) = 200 (Forecast) units of K= 1 units of L = 5 units of M =…

Q: Briefly describethe bottom of the pyramid (BOP) process for developing business specifications.

A: The phrase "bottom of the pyramid" (BOP), sometimes known as "base of the pyramid," is used in…

Q: Customers arrive at a store randomly, following a Poisson distribution at an average rate of 20 per…

A: The parameter value, meaning average rate of arrivals, lambda, entirely describes the behaviour of…

Q: Disscus the possbile causes of the following production waste 4.1.2 Overproduction waste

A: Overproduction waste is a type of waste that can happen in any organization. It is when the company…

Q: SAMPLE NUMBER 1 -2345678 3 10 11 12 13 14 15 READINGS (IN OHMS) 976 1014 1019 1018 989 1009 995 984…

A: Formulae used: Mean (X) =X1+X2+X3........XnNRange = X (largest value) - X (smallest value) Xbar…

Q: The MRP gross requirements for Item A are shown here for the next 10 weeks. Lead time for A is three…

A: Gross requirements are the entire amount of a good or service required to satisfy customer demand.…

Q: What term is used to describe the checkpoints (Go/No-go decision points) that occur during a project…

A: A project's worth and viability are determined by a go/no-go decision, which decides whether to move…

Q: anges to the Change Authorit on Management Approach

A: The project manager is the person in charge of managing the project. Therefore, a project's driving…

Question

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.
Factories/Warehouse (W)
Orlando
Tampa
Port St. Lucie
Transportation Costs ($)
Warehouse
W1
W2
W3
W1
7
7
5
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:
Requirement
(Bottles)
W2
4
18,000
19,000
22,000
6
5
W3
5
4
6
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?

A
B
Transportation Costs ($)
W1
1
2 Factories/Warehouse (W)
3 Orlando
4 Tampa
5 Port St. Lucie
6 Warehouse Requirement (Bottles)
7
8 Model
9 Production to be shipped
10 Orlando
11 Tampa
12 Port St. Lucie
13
14
15 Constraints
16
17
18
W1
7
7
18000
OOO
0
0
0
W2
W2
C
4
W3
5
6
4
5
6
19000 22000
ܘ
ܘ
ܘ
D
W3
0
OOO
0
0
E
Capacity
14000
25000
23000
shipped
0
0
4
F
G
Transportation Costs ($)
W1
C11
C12
C13
Factories/Warehouse (W)
Outcome
Orlando
Tampa
Port St. Lucie
Warehouse Requirement (Bottles)
H
18000
W2
C21
C22
C23
C11*B10+C21*C10+C31*D10+c12*B11+c22*d11+c13*B12+c23*C12+c33*D12
19000
W3
C31
C32
C33
J
22000
Minimum

Expert Solution

This question has been solved!

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

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Similar questions

• VOOM has four warehouses 1, 2,3, and 4. VOOM needs to supply 200 Tons to Retailer P, 200 Tons to Retailer Q, and 200 tons to Retailer R. The cost of delivery from each warehouse to retailers is provided in the following table. While each warehouse has an inventory of 500 tons they can supply, R requires that every warehouse supplies at least 25 tons to R. There is a special arrangement between Warehouse 4 and R which requires that Warehouse 4 has to supply exactly 55 tons to R. On the other hand, P can take up to 150 tons each from warehouses 1 and 2. • •Use linear programming to provide VOOM with a plan to keep their transportation cost minimal.
Subject: Logistic management Q): calculate inventory turn over ratio, Where sales is 2,000,000COGS is 65% of sales And average inventory is 125,435 What will be inventory ratio in days and weeks
Initial Inventory 20 units Regular-time cost per unit R100 Overtime cost per unit R150 Subcontract cost per unit R200 Carrying cost per unit R4 Period Regular Time Overtime Sub-contract Demand Forecast 1 30 10 5 40 2 35 12 5 50 3 30 10 5 40 From the Table 1.1 provided rate the four European cities under consideration and determine which one should be selected by Oliver Munday.
Q3. Discuss Material and Capacity Requirements Planning and scope or function of Material Management
Define reorder point (ROP) system?
1. Osprey Machine Works has the following demand requirements and other data for the upcoming four quarters. Quarter 1 2 Previous quarter's output 2500 units Beginning inventory Stockout (backorder) cost $50 per unit Inventory holding cost Hiring workers Laying off workers What is the total cost of pursuing a level aggregate plan over the coming year? Demand 2300 2400 2600 2100 200 units 13 14 $10 per unit at end of quarter $4 per unit $8 per unit 2. Golden Eagle Machine Works has the following demand requirements and other data for th upcoming four quarters. Previous quarter's output 2500 units Beginning inventory Stockout (backorder) cost $50 per unit Inventory holding cost Hiring workers Laying off workers What is the total cost of pursuing a chase aggregate plan over the coming year? Demand 2300 2400 2600 2100 Quarter 1 200 units $10 per unit at end of quarter $4 per unit S8 per unit
Question 2 - Rohe (Hong Kong) Ltd is a pharmaceutical company which manufactures and supplies various drugs for drug stores in Asia. Currently, Rohe (Hong Kong) Ltd has four factories A, B, C and D. Management has decided to build a new factory at a location central to these factories. Information regarding the yearly demands and the map coordinates for the four factories are shown in below table. Factories e Demand e x-coord- 9,000- y-coorde A- 20e 130e Be 3,000 60- 404 Ce 5,000- 70- 100- De 16,000- 90 30 (a) Determine the map coordinates of the new factory. (b) Suggest and elaborate TWO other factors that need to consider in the selection of location. e
Question 2 Rohe (Hong Kong) Ltd is a pharmaceutical company which manufactures and supplies various drugs for drug stores in Asia. Currently, Rohe (Hong Kong) Ltd has four factories A, B, C and D. Management has decided to build a new factory at a location central to these factories. Information regarding the yearly demands and the map coordinates for the four factories are shown in below table. Factories Demand - x-coord 9,000- 3,000- 5,000 y-coord 130 40 A Be 20 60 Ce 70 100 De 16,000- 90 30 (a) Determine the map coordinates of the new factory. (b) Suggest and elaborate TWO other factors that need to consider in the selection of location. «
Pls help me answer the items here. Thank you.
D Question 20 Perform an ABC analysis on the following set of products and identify the A Class items. Item A211 B390 C003 D100 E707 F660 G473 H921 Annual Demand 1200 1000 4500 400 35 250 10 100 O B390, E707, D100 O C003, A211, B390 O E707, F660, C003 O E707, D100, F660 O F660, C003, A211 Unit Cost $9 $90 $6 $150 $2000 $120 $90 $75
↑ Develop a lot-for-lot solution and calculate total relevant costs for the gross requirements in the following table*. Period 1 Gross requirements 20 2 3 40 Period Gross requirements On-hand at haninning of period 40 4 Develop a lot-for-lot solution (enter your responses as whole numbers). 1 20 2 5 6 7 30 70 30 *Holding cost = $3.50/unit/week; setup cost = $200; lead time = 1 week; beginning inventory = 40. 3 40 4 5 30 8 6 70 9 10 70 7 30 8 11 9 10 10 12 60 70 11 12 60 T
16. Complete the following schedule and then answer Problems 16 and 17. Forecast requirements In transit On Hand 1 35 50 Projected available balance 30 Planned Shipments Shipping quantity = 50, Lead time = 1, Safety stock = 25 2 30 Period 3 45 What will the planned shipments be for periods 2, 3, and 4? a) 25 units for each period b) 50 units for periods 2 and 4; zero units for period 3 4 65 c) 50 units for each period d) 100 units in period 2, zero units in period 3, and 50 units in period 4 e) 75 units in period 2, 35 units in period 3, 20 units in period 4 17. What is the projected available balance for period 4? a) 50 units b) 55 units c) 60 units d) 65 units e) 75 units 5 30