# Question: A company faces the following demands during the next three

A company faces the following demands during the next three weeks: week 1, 2000 units; week 2, 1000 units; week 3, 1500 units. The unit production costs during each week are as follows: week 1, $130; week 2, $140; week 3, $150. A holding cost of $20 per unit is assessed against each week’s ending inventory. At the beginning of week 1, the company has 500 units on hand. In reality, not all goods produced during a month can be used to meet the current month’s demand. To model this fact, assume that only half of the goods produced during a week can be used to meet the current week’s demands.

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?

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?

**View Solution:**## Answer to relevant Questions

Maggie Stewart loves desserts, but due to weight and cholesterol concerns, she has decided that she must plan her desserts carefully. There are two possible desserts she is considering: snack bars and ice cream. After ...A company manufactures two types of trucks. Each truck must go through the painting shop and the assembly shop. If the painting shop were completely devoted to painting type 1 trucks, 800 per day could be painted, whereas if ...A pharmaceutical company manufactures two drugs at Los Angeles and Indianapolis. The cost of manufacturing a pound of each drug depends on the location, as indicated in the file S13_42.xlsx. The machine time (in hours) ...Continuing the previous problem, make the problem even more general by allowing upper bounds (arc capacities) and lower bounds for the flows on the allowable arcs. Some of the upper bounds can be very large numbers, ...Consider a modification of the original Red Brand problem where there are N plants, M warehouses, and L customers. Assume that the only allowable arcs are from plants to warehouses and from warehouses to customers. If all ...Post your question