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. ### Shipping Costs and Supply Chain Analysis#### Shipping Costs ($ per bracelet) - Plant to Warehouse| Plant | Davenport | Cincinnati | Supply (number of bracelets) ||--------------|-----------|------------|------------------------------|| Denver | $2.00 | $3.00 | 700 || Jacksonville | $3.00 | $1.00 | 400 |In this table, we see the costs associated with shipping bracelets from two plants (Denver and Jacksonville) to two warehouses (Davenport and Cincinnati). The shipping cost per bracelet from Denver to Davenport is $2.00, while to Cincinnati, it’s $3.00. Jacksonville's costs are $3.00 to Davenport and $1.00 to Cincinnati. Denver can supply 700 bracelets, and Jacksonville can supply 400 bracelets.#### Shipping Costs ($ per bracelet) - Warehouse to Retail Outlet| Warehouse | Chicago | Orlando | Houston | Little Rock ||-------------|---------|---------|---------|-------------|| Davenport | $3.00 | $7.00 | $4.00 | $7.00 || Cincinnati | $5.00 | $5.00 | $7.00 | $6.00 |This table displays the costs of shipping bracelets from two warehouses (Davenport and Cincinnati) to four retail outlets: Chicago, Orlando, Houston, and Little Rock. From Davenport, the shipping costs are $3.00 to Chicago, $7.00 to Orlando, $4.00 to Houston, and $7.00 to Little Rock. From Cincinnati, the costs are $5.00 to both Chicago and Orlando, $7.00 to Houston, and $6.00 to Little Rock.#### Demand (number of bracelets)- Chicago: 200- Orlando: 150- Houston: 350- Little Rock: 300This section provides the demand in number of bracelets needed at each retail outlet. Chicago requires 200 bracelets, Orlando needs 150, Houston demands 350, and Little Rock requires 300 bracelets.This analysis helps in understanding the distribution costs and logistics, allowing for strategic planning in supply chain management. **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 at either plant may be shipped to either of the firm’s two regional warehouses, which are located in 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.

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

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.

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: The following payment period ratios, averaged, for borrowings were reported for the year 2021 y five…

A: Payment period ratio indicates the time required to repay the borrowings. In other words it is the…

Q: Pls solve using excel

A: Find the given details below:

Q: A firm has established a distribution network for the supply of a raw material critical to its…

A: When supply is less than demand or vice versa, it is called as unbalanced problem. For unbalanced…

Q: The manufacturing plant of Carilla Ltd. specializes in crafting specialized pieces for carnival.…

A: Note:Since you have posted multiple questions, we will provide the solution only to the first…

Q: Futura Company purchases the 79,000 starters that it installs in its standard line of farm tractors…

A: o determine the financial advantage or disadvantage of making the 79,000 starters in-house instead…

Q: You work for the Brad's Nailer Company which manufactures three types of nailers: a pneumatic model,…

A: Decision variables: A = Units of Pneum to be produced B = Units of ProLine to be produced C = Units…

Q: Please answer Arjent please fast

A: Decision Variable: Suppose-X1 be the acres of land for apple to be grownX2 be the acres of land for…

Q: With the increased need for parking spaces on campus, Seton Hill University has hired additional bus…

A: Hiring excess Bus drivers to deal with the increasing cost of parking space by Seton Hill…

Q: The manufacturing plant of Carilla Ltd. specializes in crafting specialized pieces for carnival.…

A: If plant capacity were 13,000 pieces each month, then the regular production would be 11,000 pieces,…

Q: GreenLawns provides a lawn fertilizing and weed control service. The company is adding a special…

Q: The distribution of daily demand for party cakes at a bakery is shown in the following table:…

A: Relative frequency Demand Cumulative Relative frequency 0.08 18 0.08 0.02 21 0.1…

Q: Casper Computer(CC) produces X model of computers of its own brand by assembling computer parts…

A: Linear programming helps us to find the optimal solution/best outcome, given the constraintsWe want…

Q: Based on the highest weighted score, which supplier should be selected? Supplier should be selected,…

A: Here, for each supplier, the rating or scores are given against the criteria, each criterion has a…

Q: Explain why satisficing exists and why someone would not require an optimal solution

A: Satisficing refers to a decision-making strategy where the main focus is on achieving satisfactory…

Q: Darren Mack owns the "Gas n' Go" convenience store and gas station. After hearing a marketing…

A: Given-

Q: HERO Corporation is considering three options for managing its data processing operation: continuing…

A: 1. note: if payoff was profit and not cost, max formula would have been used. conservative…

Q: Taylor Smith owns a small clothing company, Cuteness for You, that offers an online subscription and…

A: INTRODUCTION - In this scenario, Taylor Smith is the owner of a small clothing company, Cuteness…

Q: Required: Analyse the risks associated with the following business processes of a manufacturing…

A: The above case study depicts typical example of order to delivery cycle of a manufacturing company.…

Q: 7 11 13 15 17 Kitchen Aisle 2 4 8 10 12 14 16 18 Print Done

A: The answer is as below:

Q: Price and cost (dollars per pillow) 100 90 80 70 60 50 40 822 30 20 10 1,000 2,000 3,000 4,000 S=MC…

A: The primary goal of a monopoly, like any profit-maximizing firm, is to produce and sell a quantity…

Q: Formulate the situation in matrix form. Be sure to indicate the meaning of your rows and columns.…

A: THE ANSWER IS AS BELOW:

Question

100%

### Shipping Costs and Supply Chain Analysis

#### Shipping Costs ($ per bracelet) - Plant to Warehouse

| Plant | Davenport | Cincinnati | Supply (number of bracelets) |
|--------------|-----------|------------|------------------------------|
| Denver | $2.00 | $3.00 | 700 |
| Jacksonville | $3.00 | $1.00 | 400 |

In this table, we see the costs associated with shipping bracelets from two plants (Denver and Jacksonville) to two warehouses (Davenport and Cincinnati). The shipping cost per bracelet from Denver to Davenport is $2.00, while to Cincinnati, it’s $3.00. Jacksonville's costs are $3.00 to Davenport and $1.00 to Cincinnati. Denver can supply 700 bracelets, and Jacksonville can supply 400 bracelets.

#### Shipping Costs ($ per bracelet) - Warehouse to Retail Outlet

| Warehouse | Chicago | Orlando | Houston | Little Rock |
|-------------|---------|---------|---------|-------------|
| Davenport | $3.00 | $7.00 | $4.00 | $7.00 |
| Cincinnati | $5.00 | $5.00 | $7.00 | $6.00 |

This table displays the costs of shipping bracelets from two warehouses (Davenport and Cincinnati) to four retail outlets: Chicago, Orlando, Houston, and Little Rock. From Davenport, the shipping costs are $3.00 to Chicago, $7.00 to Orlando, $4.00 to Houston, and $7.00 to Little Rock. From Cincinnati, the costs are $5.00 to both Chicago and Orlando, $7.00 to Houston, and $6.00 to Little Rock.

#### Demand (number of bracelets)

- Chicago: 200
- Orlando: 150
- Houston: 350
- Little Rock: 300

This section provides the demand in number of bracelets needed at each retail outlet. Chicago requires 200 bracelets, Orlando needs 150, Houston demands 350, and Little Rock requires 300 bracelets.

This analysis helps in understanding the distribution costs and logistics, allowing for strategic planning in supply chain management.

**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 at either plant may be shipped to either of the firm’s two regional warehouses, which are located in 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

the excel file president’s inn guest database provides a list of customers, rooms they occupied, arrival and departure dates, number of occupants, and daily rate for a small bed- and-breakfast inn during one month. room rates are the same for one or two guests; however, additional guests must pay an additional $20 per person per day for meals. guests staying for seven days or more receive a 10% discount. modify the spreadsheet to calculate the number of days that each party stayed at the inn and the total revenue for the length of stay.
Please do not give solution in image format thanku
It is summertime and your winter coat factory is trying to decide its production schedule and staffing level for the next season. You are forecasting a demand of 5000 coats in October, 8000 coats in November, 8000 coats in December, 12000 coats in January, 12000 coats in February, and 9000 coats in March. You want to manufacture these coats at the lowest cost possible/ The first decision you need to make is how many people to hire. Each employee will cost $2500 a month. You don’t want to hire or fire any employees mid-season in order to minimize disruptions in your factory floor. You can have employees idle if there isn’t sufficient work for them to do. Employees still need to be paid even if they are idle. An employee works 20 business days a month and takes half a day to produce one coat. The employees can also be asked to work overtime, in which case you need to pay them $70 per coat they produce. You don’t need to assume there is any capacity constraint on the number of overtime…
Please solve using Excel @Risk add-in the question is Textbook Problem from Practical Management Science 6th Edition Chapter 11.4 Problem 30P. In the solution please provided step-by-step excel formulas used. The full Question is attached in the image. Seas Beginning sells clothing by mail order. An important question is when to strike a customer from the company’s mailing list. At present, the company strikes a customer from its mailing list if a customer fails to order from six consecutive catalogs. The company wants to know whether striking a customer from its list after a customer fails to order from four consecutive catalogs results in a higher profit per customer. Thefollowing data are available:-> If a customer placed an order the last time she received a catalog, then there is a 20% chance she will order from the next catalog.-> If a customer last placed an order one catalog ago, there is a 16% chance she will order from the next catalog she receives.-> If a customer…
A chef must decide how many chocolate lava cakes to prepare for the upcoming Mother's Day Dinner special. The chef can either prepare 50, 100, or 150 lava cakes. Assume that demand for the lava cakes can be 50, 100, or 150. Each dish costs $5 to make and is priced at for $7 on the menu. Unsold cakes are donated to a nearby charity center. Assume that there is no opportunity cost for lost sales. Which alternative should be chosen based on the maximax criterion?
Jasmine owns 12 apartment buildings in a college town, which it rents exclusively to students. Each apartment building contains 120 rental units, but the owner is having cash flow problems due to an average vacancy rate of nearly 50 percent. The apartments in each building have comparable floor plans, but some buildings are closer to campus than others. Jasmine’s accumulated data from last year on the number of apartments rented, the rental price (in dollars), and the amount spent on advertising (in hundreds of dollars) at each of the 12 apartments are available below. These data, along with the distance (in miles) from each apartment building to campus, are presented below. Jasmine is looking for expert advice on the available data to inform administrative and business policy. By applying this scenario, help her regress the quantity demanded of her apartments on price, advertising, and distance datasets by using Excel or SPSS. Observation or (Number of Apartments) Quantity…