# A company faces the following demands during the next three weeks: week 1, 2000 units; week 2, 1000 units; week

## Question:

a. Determine how to minimize the cost of meeting the demand for the next three weeks.

b. Revise the model so that the demands are of the form Dt + k Δt, where Dt is the original demand (from above) in month t, k is a given factor, and Δt is an amount of change in month t demand.

Develop the model in such a way that you can use SolverTable to analyze changes in the amounts produced and the total cost when k varies from 0 to 10 in 1-unit increments, for any fixed values of the Δts. For example, try this when Δ1 = 200, Δ2 = 500, and Δ3 = 300. Describe the behavior you observe in the table. Can you find any reasonable Δts that induce positive production levels in week 3?

Ending Inventory

The ending inventory is the amount of inventory that a business is required to present on its balance sheet. It can be calculated using the ending inventory formula Ending Inventory Formula =...

## This problem has been solved!

Do you need an answer to a question different from the above? Ask your question!

## Step by Step Answer:

**Related Book For**

## Data Analysis and Decision Making

**ISBN:** 978-0538476126

4th edition

**Authors:** Christian Albright, Wayne Winston, Christopher Zappe

**View Solution**

Create a free account to access the answer

**Cannot find your solution?**

Post a FREE question now and get an answer within minutes.
* Average response time.