To change: The model for reflecting the behavior. Quantity discounts and demand under uncertainty: Quantity discount is the discount given when the products are ordered in large quantities. A quantity discount is often given by a seller to induce the buyer to purchase large quantities. Demand uncertainty is the situation when a business is unable to accurately predict the demand for a product or a business.

Question

Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 60 units. The MPS rule is to schedule production if the projected on-hand Inventory would be negative without it. Customer orders (committed) are as follows: Week Customer Orders 1 2 36 28 4 1 Use a production lot size of 85 units and no beginning inventory. Note: In the ATP row, enter a value of 0 (zero) in any periods where ATP should not be calculated. Leave no cells blank - be certain to enter "0" wherever required. June July 1 2 3 4 5 8 7 8 Forecast 60 60 60 60 60 60 60 60 Customer Orders 38 28 4 1 0 0 0 0 Projected On-Hand Inventory MPS ATP

Answer 1

Question

Chapter 2.5, Problem 5P

Summary Introduction

To change: The model for reflecting the behavior.

Quantity discounts and demand under uncertainty:

Quantity discount is the discount given when the products are ordered in large quantities. A quantity discount is often given by a seller to induce the buyer to purchase large quantities.

Demand uncertainty is the situation when a business is unable to accurately predict the demand for a product or a business.

Expert Solution & Answer

Trending nowThis is a popular solution!

See solution

Check out sample textbook solution

Students have asked these similar questions

Prepare a master schedule given this information: The forecast for each week of an eight-week schedule is 60 units. The MPS rule is to schedule production if the projected on-hand Inventory would be negative without it. Customer orders (committed) are as follows: Week Customer Orders 1 2 36 28 4 1 Use a production lot size of 85 units and no beginning inventory. Note: In the ATP row, enter a value of 0 (zero) in any periods where ATP should not be calculated. Leave no cells blank - be certain to enter "0" wherever required. June July 1 2 3 4 5 8 7 8 Forecast 60 60 60 60 60 60 60 60 Customer Orders 38 28 4 1 0 0 0 0 Projected On-Hand Inventory MPS ATP

Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week 1 2 3 4 5 6 7 8 9 10 Demand 21 21 27 38 25 30 35 24 25 30 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.50 and a week 1 initial forecast of 21.0 are (round your responses to two decimal places): Week 1 2 3 4 5 6 7 8 9 10 Demand 21 21 27 38 25 30 35 24 25 30 Forecast 21.0 21 21 24 31 28 29 32 28 26.50 b) For the forecast developed using exponential smoothing (a = 0.50 and initial forecast 21.0), the MAD = |||||sales (round your response to two decimal places).

Sales of tablet computers at Marika Gonzalez's electronics store in Washington, D.C., over the past 10 weeks are shown in the table below: Week Demand 1 2 3 4 5 6 7 8 9 10 21 21 27 38 25 30 35 24 25 30 a) The forecast for weeks 2 through 10 using exponential smoothing with a = 0.50 and a week 1 initial forecast of 21.0 are (round your responses to two decimal places): Week 1 2 3 4 5 Demand 21 21 27 38 Forecast 21.0 ☐ G ☐ ☐ 6 7 25 30 35 ∞ ☐ 8 9 10 24 25 30