Question
A company produces Blu-Ray disc players. Estimated demands for the next four quarters are: Quarter 1 2 3 4 Demand 5000 10,000 8000 2000 At
A company produces Blu-Ray disc players. Estimated demands for the next four quarters are: Quarter 1 2 3 4 Demand 5000 10,000 8000 2000 At the beginning of quarter 1, the company has 60 workers. It costs $2000 to hire a worker and $4000 to fire a worker. Workers are paid $10,000 per quarter plus $80 for each unit they make during overtime. A worker can make 90 units per quarter. Any worker can make up to 10 units per quarter during overtime. Each disc player is sold for $160. It costs $20 to hold a disc player in inventory for a quarter. Assume workers are hired or fired at the beginning of each quarter and that all of a quarters production is available to meet demand for that quarter. Initial inventory at the beginning of quarter 1 is 1000 disc players, and desired quarter 4 ending inventory is also 1000 units.
Create an spreadsheet model of the above problem and use Solver to determine the number of workers to hire or fire at the beginning of each quarter and the overtime production each quarter in order to maximize profit subject to constraints on maximum quarterly overtime production, meeting (or exceeding) quarterly demand, and leaving the desired quarter 4 ending inventory. Note: Ensure number of a hire or fire is integer.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started