Problems-Operations Management Make sure to show all your work to get full credit. The instructor needs to know the formulas and calculations you used to get to your final answer. You can do part of the exam in Excel and Paste your Excel work into this document.
Arsenal Electronics is going to construct a new $1.2 billion semiconductor plant and has selected four towns in the Midwest as potential sites. The important location factors and ratings for each town.
Sawyer Furniture is one of the few remaining domestic manufacturers of wood furniture. In the current competitive environment, cost containment is the key to its continued survival. Demand for furniture follows a seasonal demand pattern with increased sales in the summer and fall months, culminating with peak demand in November.
The cost of production is $16 per unit for regular production, $24 for overtime, and $33 for subcontracting. Hiring and firing costs are $500 per worker. Inventory holding costs are $20 per unit per month. There is no beginning inventory. Ten workers are currently employed. Each worker can produce 50 pieces of furniture per month. Overtime cannot exceed regular production. Given the following demand data, use Excel Solver to design an aggregate production plan for Sawyer Furniture that will meet demand at the lowest possible cost.
Pre-Written Pages: 2
*Please note down the Number of Pages & Order Topic before place the Pre-Written Order
*Please note that pre-written orders are previously submitted orders by students and tutors. They are not plagiarism-free and should only be used for reference or better understanding of the topic.
If you require newly written order then please select custom order. We guarantee that the completed custom order will be free of plagiarism.