Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ANSWER part b in Excel, thank you Organic Food Supply-Chain Optimization. A produce company supplies organically grown apples to four regional specialty stores. After the

ANSWER part b in Excel, thank you
image text in transcribed

Organic Food Supply-Chain Optimization. A produce company supplies organically grown apples to four regional specialty stores. After the apples are collected at the company's orchard, they are transported to any of three preparation centers where they are prepared for retail (by undergoing extensive cleaning and then packaging). After the apples are prepared, they are shipped to the specialty stores. Due to the fragility of the product, the cost of transporting this organic fruit is rather high. The company has three preparation centers available for use. The Apple worksheet contains the following: (i) the unit transportation costs (in $/pound) to get the apples from company's orchard to the preparation centers, (ii) the cost ($/pound) to prepare the apples in the preparation centers, (iii) the preparation centers' monthly capacities, (iv) the demand at the specialty stores, and (v) the unit costs of transporting the apples from the preparation centers to the specialty stores. a.Construct and solve a linear optimization model to determine the number of pounds of apples to prepare at each of the three preparation centers and how much of each specialty store's demand to supply from each preparation center, to minimize the total cost of the operation. b.ln a separate worksheet, reformulate the problem to determine if there is an alternative optimal solution. Clearly explain your result. Preparation Center 1 2 3 Preparation Center Transportation Cost (S/pound) (Orchard to Preparation Center) 9.45 $1.00 $1.62 Organic Orchard $0.80 Sl .20 $0.20 300 Preparation Cost (S/pound) $0.15 $0.20 $0.18 Monthly Capacity (pounds) 300 500 800 Shipping Cost (S per pound) 1 2 3 Monthly Demand (pounds) Work in Part b in Excel , thank you. Fresh & Local $1.10 $1.10 $1.40 500 Healthy Pantry $0.70 $0.50 $1.30 400 Season's Harvest $1.40 $1.40 $1.70 200

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project Management Book Of Templates

Authors: Navaid Ur Rehman

1st Edition

9798719847344

More Books

Students also viewed these General Management questions

Question

Describe two of Georg Elias Mllers contributions to psychology.

Answered: 1 week ago

Question

7 How can a culture encourage ethical (or unethical) behaviour?

Answered: 1 week ago