Homework Assignment 2
留学生商科代写 It is summertime and your winter coat factory is trying to decide its production schedule and staffing level for the next season.
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?
更多代写:html编程代写 雅思代考 Accounting作业代写 留学生申请推荐信代写 留学生人力资源论文代写 论文代写可靠吗