Answered step by step
Verified Expert Solution
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
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
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