PLEASE SHOW HOW TO DO THIS WITH EXCEL. Construct and solve a linear optimization model that defies the supply chain strategy that meets the demand of each retail outlet at minimum total shipping cost. PlantDenverJacksonvilleWarehouseDavenportCincinnatiDemand (numberof bracelets)Shipping Costs ($ per bracelet)WarehouseDavenport$2.00$3.00Chicago$3.00$5.00Shipping Costs ($ per bracelet)Retail Outlet200Orlando$7.00$5.00Cincinnati150$3.00$1.00Houston$4.00$7.00350Supply (number ofbracelets)700400Little Rock$7.00$6.00300 Fitness Bracelet Distribution. Orion Fitness produces bracelets with an embedded chip thattracks its wearer's activities. Orion has plants in Denver and Jacksonville. Bracelets produced aeither plant may be shipped to either of the firm's two regional warehouses, which are locatedDavenport and Cincinnati. These regional warehouses subsequently supply retail outlets inChicago, Orlando, Houston, and Little Rock. The file Orion contains data on each plant's supply(number of bracelets), each retail outlet's demand (number of bracelets), and the shipping costsper bracelet) for the shipping channels.

PLEASE SHOW HOW TO DO THIS WITH EXCEL. Construct and solve a linear optimization model that defies the supply chain strategy that meets the demand of each retail outlet at minimum total shipping cost.

PLEASE SHOW HOW TO DO THIS WITH EXCEL. Construct and solve a linear optimization model that defies the supply chain strategy that meets the demand of each retail outlet at minimum total shipping cost.

Purchasing and Supply Chain Management

6th Edition

ISBN:9781285869681

Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

ChapterC: Cases

Section: Chapter Questions

Problem 5.1SC: Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing...

See similar textbooks

Related questions

Q: Assuming Normal Distribution, what would the optimal (s,Q) policy be for the given parameters below?…

A: This is called a continuous review policy. In this ordering policy, the order quantity is constant…

Q: What Is the Connection between ERP and EDI? ERP systems often use EDI technology to facilitate…

A: Electronic Data Interchange or EDI is a concept used in modern business to pass on information…

Q: urrently, the store places orders to the supplier, weeks, fixed order cost per order is $100, each…

A: Safety stock is the amount of inventory that a company will hold in order to account for uncertainty…

Q: how did you find the A2

A: Given data is

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: ABC INVENTORY CLASSIFICATION A company trades with a number of items and the management is…

A: A' items – items account for 85% of the annual consumption value of the items (asked 82% so taken up…

Q: Compute the slack time for all non-critical activities. 5) What is the latest possible start…

A: Here, I have been given the table data, and for each activity, I have been given the time data and…

Q: In an M/M/1 queueing system, the arrival rate is 5 customers per hour and the service rate is 7…

A: Given data: In an M/M/1 queueing system Arrival rate ( λ) = 5 customer per hour Service rate (μ) =…

Q: 2x + 3y + 3z = 2 4x – 3y – 6z = 2 10x – 6y + 3z = 0 1. Given values – 144, -192, and 96 for Dx,…

A: Ans) Given Data: Dx = -144 Dy = -192 Dz = 96 D = 144 = Determinant

Q: What is the probability that the boat dock will be idle? (b) What is the average number of boats…

A: Queueing theory is a branch of mathematics that studies the behavior of queues. Queueing theory…

Q: If 50 errors occurred per 20,000 tax applications, what are the defects per unit (DPU)? During…

A: DPU = Total defects/Total units inspected DPO = Total defects/(Total units inspected *…

Q: Discusses design and innovation at Dyson Appliances Limited (DAL). As a purchasing manager, advice…

A: A purchasing manager has very high responsibility that s/he must take very seriously. The job is…

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: Which of the following is true regarding the linear programming formulation of a transportation…

A: Transporting goods from a set of sources to a set of destinations while minimising the overall cost…

Q: 2. Mountain Mouse makes freeze-dried meals for hikers. One of Mountain Mouse's biggest customers is…

A: Given data: Review period R = 5 daysLead time LT=2 days Average demand =100 mealsThe standard…

Q: The Talbot Company uses electrical assemblies to produce an array of small appliances. One of the…

A: Given Data: Annual demand (D) = 11000 units Ordering cost (S) =$500 Holding Cost (H)=$20 per year…

Q: a) The cycle time for the production of a PDA= 20 seconds (round your response to two decimal…

A: Project schedule helps in calculating different values all related to the production cycle like the…

Q: Over what range of output is location A the most preferred location? 2. Over what range of output…

A: (1) From the given table, Location A seems to be lowest cost at 2000 units. And it is not the…

Q: Pizza Hut, with more than 25,000 outlets in the U.S., is planning a new restaurant in Lubbock,…

A: Given data:

Q: EXAMPLE 6.10 A duplicating machine maintained for office use is operated by office assistant. The…

A: Service time = 6 minutes Service rate (mu) = 606=10 per hour Arrival rate (lambda) = 5 per hour…

Q: e order quantity to the supplier is fixed at 5,00 holding cost is 25% per year. es the approximate…

A: Safety stock is a buffer of inventory that is held in reserve to protect against the risk of running…

Q: a) What is the economic production quantity? 690.88 units (round your response to two decimal…

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

Q: a) What is the economic order quantity? 306 units (round your response to the nearest whole number).…

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

Q: Spencer Enterprises is attempting to choose among a series of new Investment alternatives. The…

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

Q: The Mach 10 is a one-person sailboat manufactured by Creative Leisure. The final assembly plant is…

A: Precedence Diagram - is a pictorial representation method that shows the activities concerned in the…

Q: WK Qu. 7-14 A manufacturer produces both widgets... A manufacturer produces both widgets and…

A: Decision variable: Suppose-W = No. of widgets to be manufacturedG = No. of gadgets to be…

Q: lity in errors.

A: The bias is the average mistake over time. In other words, will your predictions generally be…

Q: (a) Reformulate this problem as a general linear programming problem, and then solve it manually by…

A: The transportation model is used to calculate the minimum cost of the route by selecting different…

Q: K Race One Motors is an Indonesian car manufacturer. At its largest manufacturing facility, in…

A: Economic order quantity is an order quantity that use to define the optimal quantity of orders to…

Q: why do we need to determine the demographic profile of the customers of a resort business when…

A: "Since you have asked multiple questions, we will answer the first question for you. If you want any…

Q: Why is there some places saying opt out provision?

A: An opportunity for opting out must be mentioned in the email in conjunction with adhering to…

Q: A) What do you think are the key dimensions of culture that make Patagonia successful? How does the…

A: (A) Key dimensions: A balance between lighthearted and serious pursuits. Having direct, practical…

Q: Dundas Bike Components Inc. of Wheelville, Illinois, manufactures bicycle wheels in two different…

A: a. It will be possoible for David to develop just one aggregate plan if time taken on both the…

Q: A company targets a 97% service level for a product with independent weekly demand that is normally…

A: Given that the mean =50 The standard deviation =10 The lead time=3 weeks Here, the service level is…

Q: Formtech Inc. produces transformers. Each order is custom designed and manufactured for the…

A: Given data: No of phases in order =3 Transformer Design takes = 4 weeks. Procurement has a lead…

Q: c. Maximize z = X₁ + X2 Subject to Primal 2x1 + x₂ = 5 3x1 - x₂ = 6 X₁, X2 unrestricted Primal in…

A: Dual is a the linear program which convert primal program into dual program. In the dual program,…

Q: Strategy 2: A combination of overtime, inventory, and subcontracting. Regular production should be…

A: Manually: Cell A1: K18 Period May June July August September October Total Forecast…

Q: Race One Motors is an Indonesian car manufacturer. At its largest manufacturing facility, in…

A: Economic order quantity help the find a production volume or order of the company to minimize the…

Q: What is the utilization? What is the expected number of customers in the system (L)? What is the…

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

Q: A minimum cost flow problem will have feasible solutions as long as there is a balance between the…

A: To determine the most affordable way to send a specific amount of flow through a flow network, one…

Q: In a BIP problem with 3 mutually exclusive alternatives, x₁, x2, and x3, the following constraint…

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

Q: Business Analytics department chair will be scheduling faculty to teach courses during the coming…

A: Find the network representation below:

Q: Which of the following statements are correct regarding PERT and the critical path method (CPM)?…

A: The critical path is the longest chain of activities that must be completed in order to wrap up a…

Q: A sound company compresses and palletizes boxes of merchandise for recycling. In the warehouses They…

A: Given data: Storage cost per day H = $0.10 No. of pallets generated daily = 5 pallets a day Fixed…

Q: Stanford Rosenberg Computing wants to establish an assembly line for producing a new product, the…

A: Find the Calculation methods below: Cycle Time = Available TimeDemand

Q: What will be the demand forecast for period t? (Keep one decimal place in your answer).

A: The weighted average moving forecast is a technique that is used to predict the future of a…

Q: A company is reviewing its policy of putting each sub-assembly bought in from outside through a…

A: Decision analysis helps to make a rational decision based on the available information. Cost of…

Q: The error measurement to use depends on forecast method. True False

A: The error measurement in the forecast is the difference between the observed value and the predicted…

Q: Amelio Rodriguez Computing wants to establish an assembly line for producing a new product, the…

A: Given data: (Task) Time in - (sec) Immediate - (predecessor) A 12 - B 14 A C 8 A D 5 B, C…

Q: Production systems with standardized outputs typically: A. Have relatively high volumes of output…

A: Production may be defined as creating items (commodities) in large quantities for commerce,…

Question

100%

Plant
Denver
Jacksonville
Warehouse
Davenport
Cincinnati
Demand (number
of bracelets)
Shipping Costs ($ per bracelet)
Warehouse
Davenport
$2.00
$3.00
Chicago
$3.00
$5.00
Shipping Costs ($ per bracelet)
Retail Outlet
200
Orlando
$7.00
$5.00
Cincinnati
150
$3.00
$1.00
Houston
$4.00
$7.00
350
Supply (number of
bracelets)
700
400
Little Rock
$7.00
$6.00
300

Fitness Bracelet Distribution. Orion Fitness produces bracelets with an embedded chip that
tracks its wearer's activities. Orion has plants in Denver and Jacksonville. Bracelets produced a
either plant may be shipped to either of the firm's two regional warehouses, which are located
Davenport and Cincinnati. These regional warehouses subsequently supply retail outlets in
Chicago, Orlando, Houston, and Little Rock. The file Orion contains data on each plant's supply
(number of bracelets), each retail outlet's demand (number of bracelets), and the shipping costs
per bracelet) for the shipping channels.

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 Introduction:-

VIEW

Step 2 Solution:-

VIEW

Step 3 ANSWER:-

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 5 images

SEE SOLUTION Check out a sample Q&A here

Similar questions

Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?
Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?
Retailers Warehouse (RW) is an independent supplier of household items todepartment stores. RW attempts to stock enough items for a 98 percent serviceprobability.A stainless steel knife set is one item it stocks. Demand (2,400 sets peryear) is relatively stable over the entire year. Whenever new stock isordered, a buyer must assure that numbers are correct for stock on handand then phone in a new order. The total cost involved to place an order isabout $5. RW figures that holding inventory in stock and paying forinterest on borrowed capital, insurance, and so on adds up to about $4holding cost per unit per year.Analysis of the past data shows that the standard deviation of demandfrom retailers is about four units per day for a 365-day year. Lead time toget the order is seven days.a. What is the economic order quantity?b. What is the reorder point?
is used by traders to record the yearly profits & losses of the business. * General book Correspondence Inventory book Daybook
Distinguish between fixed and variable slot locations. Howmight they affect warehousing design?
Craftwood Furniture Company is a U.S.–based furniture manufacturer that offshored all of its actual manufacturing operations to China about a decade ago. It set up a distribution center in Hong Kong, from which the company ships its items to the United States on container ships. The company learned early on that it could not rely on local Chinese freight forwarders to arrange for sufficient containers for the company’s shipments, so it contracted to purchase containers from a Taiwanese manufacturer and then sell them to shipping companies at the U.S. ports the containers are shipped to. Craftwood needs 715 containers each year. It costs $265 to hold a container at its distribution center, and it costs $6,000 to process and receive an order for the containers. The cost of not having sufficient containers and delaying a shipment is $14,000 per container. Determine the optimal order size, minimum total annual inventory cost, and maximum shortage level.
After applying the NWC Rule for the initial tableau of the given transportation model, evaluate the vacant cells. What is the cell which has the most negative evaluation value and what is the cell evaluation value? DESTINATION SOURCE DEMAND X Y N OX-R; 1 OY-S; -1 OX-S; -1 OY-S; -2 P 75 8 12 EI 11 Q 80 5 8 11 R 120 7 10 10 S 50 11 13 14 SUPPLY 100 125 100 325
Inventory Management .Explain Pro vs. Con:
14 Online channels generally support service provision with lower transaction costs than offline channels. Select one: a. False b. True
define the ABC approach to inventory management Several metrics can be used to identify an A-status:explain?
Discuss the challenges of inventory control.
Explain the three inventory control models and the driving factor in each model. Provide examples for each one using current companies.