## Homework Assignment 2

### Problem 1 (30 points)  留学生商科代写

Swayze Pottery is a company that produces plates, cups and vases. Each of the items requires different times to go through two stages of production (molding and finishing), different clay quantities and yields different profit per unit. This information is given in the table below. The Available column shows the aggregate daily time that can be used for molding and for finishing as well as the total amount of clay available.

 Plates Cups Vases Available Molding (mins/unit) 4 6 3 2400 Finishing (mins/unit) 8 14 12 7200 Clay (ounces/unit) 5 4 3 3000 Profit (\$/unit) 3.10 4.75 4.00

Your trustworthy operations team formulated the decision problem as an LP, found the optimal manufacturing schedule and reported it to you along with the sensitivity analysis.

The following questions do not require reusing the Excel solver. Each part is independent (i.e. changes made in one part do not apply to other parts)

a.A worker in the finishing department called in sick. As a result, 8 fewer hours are available that day? What will be the impact on today’sprofit?

b.A worker from the molding department offered to do 4 hours of overtime work tonight for a pay of \$14 an hour. Is it possible to say from the sensitivity report whether this is a worthwhile proposition? What is the most you can say about the value of those additional 4 hours of molding without re-running Solver.

c.The allowable decrease for the clay constraint is missing. Are you able to deduce what number should be there?

### Problem 2 (35 points)  留学生商科代写

In the prestigious MBA program of a university in the Atlantic Northeast, students are required to bid for elective courses during the second year of their program. Each student has a pool of a total 100 points to bid, and must take two of four elective courses available. There are four alternatives: Economics, Operations Management, Information Systems, and Marketing. Each class cannot have more than 5 students. The bids that the students submitted can be seen in the table below. Find an assignment of students to classes that maximizes the total bid points of the assignments.

 Student ECON OM IS MKT John 60 10 10 20 Matthew 20 20 40 20 Leah 45 45 5 5 Jennifer 50 20 5 25 Hannah 30 30 30 10 Ed 50 50 0 0 Elisabeth 70 20 10 0 David 25 25 35 15 Ann 35 15 35 15 George 60 10 10 20

### Problem 3 (35 points)

It is summertime and your winter coat factory is trying to decide its production schedule and staffing level for the next season. You are forecasting demand of 5000 coats in October, 8000 coats in November, 8000 coats in December, 12000 coats in January, 12000 coats in February and 9000 coats in March. You want to manufacture these coats at the lowest cost possible.

The first decision you need to make is how many people to hire. Each employee will cost \$2500 a month. You don’t want to hire or fire any employees mid-season in order to minimize disruptions in your factory floor. You can have employees idle if there isn’t sufficient work for them to do. Employees still need to be paid even if they are idle. An employee works 20 business days a month and takes half a day to produce one coat. The employees can also be asked to work in overtime, in which case you need to pay them \$70 per coat they produce. You don’t need to assume there is any capacity constraint on the number of overtime hours.  留学生商科代写

Coats can be produced ahead of time, but holding them in inventory costs \$10 a month per coat due to warehousing and financing costs. What’s your ideal staffing level and production schedule?