Design an aggregate production plan

Assignment Help Operation Management

Reference no: EM131033185

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.

Reference no: EM131033185

Questions Cloud

More traits you would like to see in a mentor : In the book Pour Your Heart Into It, Schulz relied on several people for advice when he was following his dreams. Think about a time when you have given or received advice. Was it helpful? Was it not so good advice? Additionally, list two or more tra..

Banks engage in proprietary trading : Banks engage in proprietary trading as part of their operations. Briefly speculate on why they now must adhere to much more stringent trading activity as a result of the 2008-09 financial crises.

Evaluate costs and benefits associated with achieving ISO : Evaluate the costs and benefits associated with achieving ISO 9000/9001 certification status for a specific product- or service-based company.

Design an aggregate production plan : 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 increase..

How would you anticipate attending to issues and concerns : Thinking about stakeholders in terms of our project, what issues and concerns do you foresee arising? What questions should we ask the owners? How would you anticipate attending to the issues and concerns?

Strategy in healthcare is all about making the best choices : Strategy in healthcare is all about making the best choices for our healthcare organizations, looking several years into the future. What are the common characteristics of choices that become successful strategies in healthcare?

Some leaders gravitate toward tenets of servant leadership : Some leaders gravitate toward the tenets of servant leadership because of perceived compatibility with the Christian worldview. Is servant leadership the only theory of leadership that is compatible with the Christian worldview? Explain.

Based on the poisson distribution : Historically, a textile company samples three sheets of a certain material as part of incoming inspection and the historical 10.5 blemishes are found on average. If a sample of one sheet of this material is tested, based on the Poisson distribution: ..

User Account

All Pages