Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started