University of North Carolina Wilmington Simple Linear Programming Excel Task

User Generated

ybevylaa9175

Business Finance

University of North Carolina Wilmington

Description

I need the same thing as last week. 2 Homework questions answered using Solver in excel.


1. Lincoln Lock Company The Lincoln Lock Company manufactures a commercial security lock at plants in Atlanta, Louisville, Detroit, and Phoenix. The unit cost of production at each plant is $35.50, $37.50, $37.25, and $36.25, and the annual capacities are 18,000, 15,000, 18,000, and 20,000, respectively. The locks are sold through wholesale distributors in seven locations around the country. The unit shipping cost for each plant– distributor combination is shown in the following table, along with the forecasted demand from each distributor for the coming year. Set this problem as a network flow model and determine the least costly way of shipping locks from plants to distributors.

plants to distributors. Tacoma SanDiego Dallas Denver StLouis Tampa Baltimore Atlanta 2.50 2.75 1.75 2.00 2.10 1.80 1.65 Louisville 1.85 1.90 1.50 1.60 1.00 1.90 1.85 From: Plants Detroit 2.30 2.25 1.85 1.25 1.50 2.25 2.00 Phoenix 1.90 0.90 1.60 1.75 2.00 2.50 2.65 Demand 5500 11500 10500 9600 15400 12500 6600

2. Assigning Tasks Suppose a data processing department wishes to assign five programmers to five programming tasks (one programmer to each task). Management has estimated the total number of days each programmer would take if assigned to the different jobs, and these estimates are summarized in the following table. Task 1 2 3 4 5 1 50 25 78 64 60 2 43 30 70 56 72 Programmer 3 60 28 80 66 68 4 54 29 75 60 70 5 45 32 70 62 75 1. Determine the assignment that minimizes the total programmer days required to complete all five jobs.

Unformatted Attachment Preview

Week 3 - Network Flow Models – Assignment 2 1. Lincoln Lock Company The Lincoln Lock Company manufactures a commercial security lock at plants in Atlanta, Louisville, Detroit, and Phoenix. The unit cost of production at each plant is $35.50, $37.50, $37.25, and $36.25, and the annual capacities are 18,000, 15,000, 18,000, and 20,000, respectively. The locks are sold through wholesale distributors in seven locations around the country. The unit shipping cost for each plant– distributor combination is shown in the following table, along with the forecasted demand from each distributor for the coming year. Set this problem as a network flow model and determine the least costly way of shipping locks from plants to distributors. From: Plants Tacoma SanDiego Dallas Denver StLouis Tampa Baltimore Atlanta 2.50 2.75 1.75 2.00 2.10 1.80 1.65 Louisville 1.85 1.90 1.50 1.60 1.00 1.90 1.85 Detroit 2.30 2.25 1.85 1.25 1.50 2.25 2.00 Phoenix 1.90 0.90 1.60 1.75 2.00 2.50 2.65 Demand 5500 11500 10500 9600 15400 12500 6600 2. Assigning Tasks Suppose a data processing department wishes to assign five programmers to five programming tasks (one programmer to each task). Management has estimated the total number of days each programmer would take if assigned to the different jobs, and these estimates are summarized in the following table. Programmer Task 1 2 3 4 5 1 50 25 78 64 60 2 43 30 70 56 72 3 60 28 80 66 68 4 54 29 75 60 70 5 45 32 70 62 75 1. Determine the assignment that minimizes the total programmer days required to complete all five jobs. 1
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

You know, that are almost the same buy one of them has an additional detail about constraints (in exe...


Anonymous
I was having a hard time with this subject, and this was a great help.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags