Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The Paris Paint Company is in the process of planning labor force requirements and production levels for the next four quarters. The marketing department has

image text in transcribed

The Paris Paint Company is in the process of planning labor force requirements and production levels for the next four quarters. The marketing department has provided production with the following forecasts of demand for Paris Paint over the next year: Assume that there are currently 280 employees with the company. Employees are hired for at least one full quarter. Hiring costs amount to $1, 200 per employee and firing costs are $2, 500 per employee. Inventory costs are $1 per gallon per quarter. It is estimated that one worker produces 1,000 gallons of paint each quarter. Assume that Paris currently has 80,000 gallons of paint in inventory and would like to end the year with an inventory of at least 20,000 gallons. Determine the minimum constant workforce plan for Paris Paint and the cost of the plan. Assume that stock-outs are not allowed. If Paris were able to back-order excess demand at a cost of $2 per gallon per quarter, determine a minimum constant workforce plan that holds less inventory than the plan you found in part (a), but incurs stock-outs in quarter 2. Determine the cost of the new plan. Formulate this as a linear program. Assume that stock-outs are not allowed. Solve the linear program. Round the variables and determine the cost of the resulting plan. Consider the problem of Paris Paint presented in Problem 33. Suppose that the plant has the capacity to employ a maximum of 370 workers. Suppose that regular-time employee costs are $12.50 per hour. Assume seven-hour days, five-day weeks, and four-week months. Overtime is paid on a time-and-a-half basis. Subcontracting is available at a cost of $7 per gallon of paint produced. Overtime is limited to three hours per employee per day, and no more than 100,000 gallons can be subcontracted in any quarter. Formulate as a linear program. Solve the linear program. Round the variables and determine the cost of the resulting plan

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advanced Database Systems

Authors: Carlo Zaniolo, Stefano Ceri, Christos Faloutsos, Richard T. Snodgrass, V.S. Subrahmanian, Roberto Zicari

1st Edition

155860443X, 978-1558604438

More Books

Students also viewed these Databases questions

Question

What are Measures in OLAP Cubes?

Answered: 1 week ago

Question

How do OLAP Databases provide for Drilling Down into data?

Answered: 1 week ago

Question

How are OLAP Cubes different from Production Relational Databases?

Answered: 1 week ago