A manager receives a forecast for next year. Demand is projected to be 600 units for the first half of the year and 920 units for the second half. The monthly holding cost is $2 per unit, and it costs an estimated $55 to process an order. a.Assuming that monthly demand will be level during each of the six-month periods covered by the forecast (e.g., 100 per month for each of the first six months), determine an order size that will minimize the sum of ordering and carrying costs for each of the six-month periods. (Round your answers to the nearest whole number.) Period Order Size 1 – 6 months?_____units 7 – 12 months?_____units b.If the vendor is willing to offer a discount of $10 per order for ordering in multiples of 50 units (e.g., 50, 100, 150), would you advise the manager to take advantage of the offer in either period? If so, what order size would you recommend? (Round intermediate calculations to 2 decimal places.) Period Order Size 1 – 6 months?____ units 7 – 12 months?____ units

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 33P: Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand...
icon
Related questions
icon
Concept explainers
Topic Video
Question

A manager receives a forecast for next year. Demand is projected to be 600 units for the first half of the year and 920 units for the second half. The monthly holding cost is $2 per unit, and it costs an estimated $55 to process an order.

a.Assuming that monthly demand will be level during each of the six-month periods covered by the forecast (e.g., 100 per month for each of the first six months), determine an order size that will minimize the sum of ordering and carrying costs for each of the six-month periods. (Round your answers to the nearest whole number.)

Period Order Size

1 – 6 months?_____units

7 – 12 months?_____units

b.If the vendor is willing to offer a discount of $10 per order for ordering in multiples of 50 units (e.g., 50, 100, 150), would you advise the manager to take advantage of the offer in either period? If so, what order size would you recommend? (Round intermediate calculations to 2 decimal places.)

Period Order Size

1 – 6 months?____ units

7 – 12 months?____ units

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Inventory management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,