Question: Solve by hand the Objective Function and subject to constraint and later solve with solver from excel and explain and provide a thorough explaination for

Solve by hand the Objective Function and subject to constraint and later solve with solver from excel and explain and provide a thorough explaination for each step Solve by hand the Objective Function and subject to constraint and later

The company produces broccoli at three plants, which are delivered to two customers via two warehouses. Shipments between plants are allowed after the packaging has been completed. This also applies to between the warehouses and between the customers. The cost of producing the broccoli at each plant is different. As a result, the company is concerned with both production and shipping costs while meeting customer demands. The production capacity of each plant (in tonnes per year), the product cost at each plant (in dollars per tonnes), and the customer demand (in tonnes per year) are summarised in the table below: The cost (in thousands of dollars) of shipping a tonne of the product between each pair of locations is listed in the table below where a blank indicates that the company cannot ship on that route: The management has set the maximum flow for each route to be 250 tonnes. Since sometimes the demands are fluctuated, the company plans to have safety stock of 50 and 25 tonnes at Warehouses 1 and 2 respectively. Based on the information above, the management wants you to design a network flow solution for their strategic plan to minimise the total costs that can meet the demands. Any change in the current scenario (e.g. plant capacities or route capacities) can be proposed if it is reasonable and based on the findings in your analysis (e.g. optimal solution, sensitivity analysis, and alternative optimal solutions)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!