|
|
| Question 1: |
| Western Lithium produces a special type of material that is currently in short supply. Four of Western Lithium’s customers have already placed orders that together exceed the combined capacity of Western Lithium’s two plants. Western Lithium’s management faces the problem of deciding how many units it should supply to each customer. Since the four customers are in different industries, different prices can be charged because of the various industry pricing structures. However, slightly different production costs at the two plants and varying transportation costs between the plants and customers make a “sell to the highest bidder” strategy unacceptable. After considering price, production costs, and transportation costs, Western Lithium has established the following profit per unit for each plantcustomer alternative. |
| Plant | Customer |
| | Panasonic | Samsung | Tesla | Sony |
| Reno | $32 | $34 | $32 | $40 |
| Vancouver | $34 | $30 | $28 | $38 |
| The plant capacities and customer arders are as follows |
| | Plant Capacity(units) |
| | Reno | 5000 |
| | Vancouver | 3000 |
| | Distributor Order(units) |
| | Panasonic | 2000 |
| | Samsung | 5000 |
| | Tesla | 3000 |
| | Sony | 2000 |
| A. Develop an Excel layout and solver model to find a solution for this problem. |
| B. How many units should each plant produce for each customer to maximize profits? |
| | Customer | Reno | Vancouver |
| | Panasonic | 0 | 2000 |
| | Samsung | 4000 | 0 |
| | Tesla | 0 | 0 |
| | Sony | 1000 | 1000 |
| | Profit |
| | Panasonic | $32 | $34 |
| | Samsung | $34 | $30 |
| | Tesla | $32 | $28 |
| | Sony | $40 | $38 |
| | Maximum profit | $282,000 |
| | Distributror Orders |
| | Panasonic | $2,000 |
| | Samsung |
| | Tesla | 0 |
| | Sony |
| | Pant Capacity |
| | Reno | | $5,000 |
| | Vancouver | $3,000 | $3,000 |
| Question 2: |
| Anderson and Associates, Inc. is a software development firm that has three new clients. Project teams will be assigned to the three clients. Based on the different backgrounds and experiences of the teams, the various team-client assignments differ in terms of projected completion times. The possible assignments and the estimated completion times in weeks are: |
| Project Team | Client |
| Agile team | C1 | C2 | C3 |
| Spiral team | 10 | 16 | 32 |
| Waterfall team | 14 | 22 | 40 |
| | 22 | 24 | 34 |
| A. Develop an Excel layout and solver model to find a solution to this problem. |
| B. What team assignments will result in the minimum overall completion time? |
Mohsin
homework.xls
