Using the appropriate solver to find the minimal-cost plan

Assignment Help Operation Management

Reference no: EM131654929

Exeter Enterprises produces premium golf clubs. It is in need of a planning tool that will help it make decisions over the next eight quarters. The demand forecast for the upcoming eight quarter period is developed every quarter, and the production manager must determine how many people to hire and lay off and also how much overtime and subcontracting to schedule.

Information relevant to the problem is shown. The demand for the upcoming eight quarters is for the following number of sets of clubs, respectively: 1920, 2160, 1440, 1200, 2040, 2400, 1740, and 1500. Clubs can be inventoried from one period to the next, incurring the holding cost. Back orders are also permitted; however, no backordering is allowed at the end of last quarter.

The production manager would like a tool to be able to find the plan minimizing the total costs over the next eight quarters.

Cost Data

Regular-time labor cost per hour $12.50

Overtime labor cost per hour $18.75

Subcontracting cost per unit (labor only) $125.00

Back-order cost per unit per quarter $25.00

Inventory holding cost per unit per quarter $10.00

Hiring cost per employee $800.00

Firing cost per employee $500.00

Capacity Data

Beginning workforce 90 employees

Beginning inventory 0 units

Production standard per unit 8 hours of labor per unit

Regular time available per period 160 hours per period per employee

Overtime available per period 40 hours per period per employee

Questions:

i) Provide a detailed Linear Programming formulation for the problem

ii) Develop spreadsheet model and solve it using the appropriate Solver to find the minimal-cost plan.

Reference no: EM131654929

Questions Cloud

When selling to business customers : When selling to business customers, marketers should focus on meeting the needs of:

Discuss poisson distribution with a mean of patients per day : It is believed that the distribution of the number of cardiac patients entering the emergency room per day over a two-month period has a Poisson distribution.

Numbers and finds the cartesian distance : A function called tupleDistance that takes two lists of numbers and finds the cartesian distance between them.

Discuss what we eat and the moral issues of eating animals : Do we have a responsibility to be aware of how our food is produced, so we can decide whether or not there is an ethical question behind it

Using the appropriate solver to find the minimal-cost plan : Develop spreadsheet model and solve it using the appropriate Solver to find the minimal-cost plan.

Requisitions for the capital refinery project : Terps Success, Inc., is a consultant firm with approximately 300 employees. A database is required to keep track of all employees, their skills, projects assign

What is the amount of glucose in grams : You need to make 20 mL of a 20% glucose solution. The M.W. of glucose is 180.16. What is the amount of glucose in grams

Distribution of the number of customer arrivals : From previous years, the manager believes that the distribution of the number of customer arrivals has a Poisson distribution with an average of 3.5 loan.

Managing change at global green books publishing : Global Green Books Publishing is producing customized eBooks for a local college. What impacts could these requested changes have on the budget?

User Account

All Pages