Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A company produces heaters. Demand during each of the next 12 months is forecasted as shown below. Other relevant information is as follows: * Workers

A company produces heaters. Demand during each of the next 12 months is forecasted as shown below. Other relevant information is as follows:

* Workers are paid $5000 per month.

* It costs $500 to hold a heater in inventory for a month. The holding cost is based on each month's ending inventory.

* It costs $4000 to hire a worker.

* It costs $20,000 to fire a worker.

* Each worker can make up to 8 heaters a month.

* At the beginning of month 1 there are 500 heaters in inventory and 60 workers.

This information is summarized below.

Workers are hired and fired at beginning of each month which determines how the number of units that can be produced each month. Assume workers are hired and fired at the beginning of each month. How can the company minimize the cost of meeting demand for heaters on time?

123456789101112
Demand945791364725268132160304989293279794

Pay$5,000per month
HoldCost$500per EI heater
Hire$4,000per worker
Fire$20,000per worker
Productivity8heaters/month
Beg Inv500heaters
Workers(T=0)60Workers

Step by Step Solution

3.44 Rating (170 Votes )

There are 3 Steps involved in it

Step: 1

Albebraic formulation and solution of the problem using Excel Solver is given below Decision Variabl... 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_2

Step: 3

blur-text-image_3

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

CFIN

Authors: Scott Besley, Eugene Brigham

5th edition

1305661656, 9781305888036 , 978-1305666870

More Books

Students also viewed these Finance questions

Question

Propose a reasonable mechanism for the following reaction. OH

Answered: 1 week ago