Question: TASK 3: THREE PROBLEMS (each 10% - total 30%) PROBLEM A: A LINEAR PROGRAMMING PROBLEM Three orchards supply crates of oranges to four retailers. The

TASK 3: THREE PROBLEMS (each 10% - total 30%)

TASK 3: THREE PROBLEMS (each 10% - total 30%) PROBLEM A: A LINEAR PROGRAMMING PROBLEM Three orchards supply crates of oranges to four retailers. The daily demand amounts at the four retailers are 150,150,400, and 100 crates, respectively. Supplies at the three orchards are dictated by available regular labour and are estimated at 150,200 , and 250 crates daily. However, both orchards 1 and 2 have indicated that they could supply more crates, if necessary, by using overtime labour. Orchard 3 does not offer this option. The transportation costs per crate from the orchards to the retailers are given in Table below a) Formulate the problem as a linear program (look up the "transportation model"). b) Use Excel Solver to solve your linear program c) Write a report explaining the steps you take in approaching the above problems and interpret your solution

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!

Problem 2: Three orchards supply crates of oranges to four retailers. The daily demand amounts at the four retailers are 150, 150, 400, and 100 crates, respectively. Supplies at the three Is are...

2. Problem 2 Three orchards supply crates of oranges to four retailers. The daily demand amounts at the four retailers are 150, 150, 400, and 100 crates, respectivelySupplies at the three orchards...

Three orchards supply crates of oranges to four retailers. The daily demand amounts at the four retailers are 150, 150, 400, and 100 crates, respectively. Supplies at the three orchards are dictated...

11. Three orchards supply crates of oranges to four retailers. The daily demand amounts at the four retailers are 150,150,400, and 100 crates, respectively. Supplies at the three orchards are...

Three orchards supply crates of oranges to four retailers. The daily demand amounts at the four retailers are 150,150,400, and 100 crates, respectively. Supplies at the three orchards are dictated by...

OPERATION Research Solve it ASAP Three orchards supply crates of oranges to four retailers. The daily demand amounts at the four retailer are 150, 150, 200, and 100 crates respectively. Suppliers at...

The key concepts involved in this problem are primarily linear programming and sensitivity analysis. Please see attachments, I need you to provide handwritten detailed solution steps. Problem 2 (40...

MULTIPLE CHOICE: 1. Using the balanced scorecard approach, an organization evaluates managerial performance based on: a. A single ultimate measure of operating results, such as residual income. b....

Please solve the question5-10 9:51 9-Operations Research-A... >>> (al Formulate the problem as a transportation model (h) Determine an optimal distribution plan for the utility company le) Determine...

Design a survey of the way that companies use the Web in your area. What kind of companies forms your population? How can you select an unbiased sample from these? What data would you want and how...

A government organization is examining the effectiveness of a program intended to shorten security lines at airports for "trusted travelers". For comparison purposes, a sample was obtained of the...

Which of the following matters is most likely to be included in a management representation letter as a specific representation? A . Length of a material contract with a new customer. B . Information...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...