Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

PLEASE INCLUDE ALL THE STEPS AND SOLUTIONS Question #3. [21 points] Delish is a fresh produce company in Nova Scotia and operates its own supply

image text in transcribed

PLEASE INCLUDE ALL THE STEPS AND SOLUTIONS

Question \#3. [21 points] Delish is a fresh produce company in Nova Scotia and operates its own supply chain with its own fleet of trucks. Delish supplies organically grown apples to five Nova Scotia specialty stores. After the apples are collected at the company's orchard, they are transported to any of four preparation centers where they are prepared for retail (by undergoing extensive cleaning and then packaging), after which the prepared apples are shipped to the specialty stores. The cost of transporting organic fruit is rather high due to the product's fragility. The company has four preparation centers available for use. The following tables summarize the data required.(E.g., it costs $0.50akg to transport (from the orchard) to and prepare in Preparation Center \#2, which has a 5,000 kgs processing capacity per month. E.g., it costs $0.10 to transport a kg of apples from Preparation Center 3 to the Healthy Pantry store, which has a demand requirement of 6,000 kgs.) a) Delish must decide the amount of apples to prepare at each of the four preparation centers and how much of each specialty store's demand to supply from each preparation center, at the leastcost. Clearly define your decision variables and parameters, and write down the full mathematical problem (objective function, constraints etc.) [8] b) Solve your model in part a) to optimality using Excel Solver. Include the optimality snapshots and draw the network of optimal solutions (i.e., optimal cost, optimal total shipment quantities at each centre, and optimal shipment amounts between each cente ant the specialty stores). [5]

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

Enterprise

Authors: William B. Gartner; Marlene G. Bellamy

1st edition

978-0324130850, 324130856, 978-0324786552

More Books

Students also viewed these General Management questions

Question

Explain how Enron used the Prepay Transactions to overstate CFFO.

Answered: 1 week ago