Question

In: Operations Management

A manager receives a forecast for next year. Demand is projected to be 528 units for...

A manager receives a forecast for next year. Demand is projected to be 528 units for the first half of the year and 960 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., 88 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

Solutions

Expert Solution


Related Solutions

Demand is projected to be 600 units for the first half of the year and 900...
Demand is projected to be 600 units for the first half of the year and 900 units for the second half. The monthly holding cost is $2 per unit, and it costs $55 to process an order. 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...
Exhibit 1:   Sales and Cost Forecast The sales forecast is based on projected levels of demand....
Exhibit 1:   Sales and Cost Forecast The sales forecast is based on projected levels of demand. All the numbers are expressed in today’s dollars. The forecasted average inflation per year is 3.0% . Price per bus $220,000 Units sold per year 11,000 Labor cost per bus $50,000 Components & Parts per bus $95,000 Selling General & Administrative (fixed) $250,000,000 NOTE: Average warranty cost per year per bus for the first five years is $1,000. The present value of this cost...
Exhibit 1:   Sales and Cost Forecast The sales forecast is based on projected levels of demand....
Exhibit 1:   Sales and Cost Forecast The sales forecast is based on projected levels of demand. All the numbers are expressed in today’s dollars. The forecasted average inflation per year is 3.0% Price per bus $220,000 Units sold per year 11,000 Labor cost per bus $50,000 Components & Parts per bus $95,000 Selling General & Administrative (fixed) $250,000,000 NOTE: Average warranty cost per year per bus for the first five years is $1,000. The present value of this cost will...
The sales forecast is based on projected levels of demand. All the numbers are expressed in...
The sales forecast is based on projected levels of demand. All the numbers are expressed in today’s dollars. Price per bus $220,000 Units sold per year 12,250 Labor cost per bus $32,500 Components & Parts $86,500 Selling General & Administrative $200,000,000 The average warranty cost per year per bus for the first five years is $2,000. The present value of this cost will be used as a cost figure for each bus. Afterwards, the bus operator will become responsible the...
Demand: You are the manager of a hardware store. One of your duties is to forecast...
Demand: You are the manager of a hardware store. One of your duties is to forecast demand for the products that the store carries. The products include items ranging from Christmas tree lights, to garden supplies to hammers and nails. Which demand pattern or patterns would you use to determine the forecast? Explain.
A manufacturer of integrated circuits is planning production for the next four months. The forecast demand...
A manufacturer of integrated circuits is planning production for the next four months. The forecast demand for the circuits is shown in the following table. Circuit September October November December IC341 650 875 790 1100 IC256 900 350 1200 1300 At the beginning of September, the warehouse is expected to be completely empty. There is room for no more than 1,800 integrated circuits to be stored. Holding costs for both types is $0.05 per unit per month. Because workers are...
The production manager of Rordan Corporation has submitted the following forecast of units to be produced...
The production manager of Rordan Corporation has submitted the following forecast of units to be produced by quarter for the upcoming fiscal year: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Units to be produced 11,000 8,000 8,500 10,800 Each unit requires 0.75 direct labor-hours, and direct laborers are paid $16 per hour. Required: 1. Complete the company’s direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number...
Forecast market demand for the product of BA Ltd is 40,000 units. BA will be able...
Forecast market demand for the product of BA Ltd is 40,000 units. BA will be able to satisfy 50% of the demand. The selling price per unit is K 100. The cost of producing a unit of the product is as follows:               Direct material             2 kgs @ K2.50 per kg               Direct labour                 4 hours @K 5 per hour              Variable overhead         2 machine hours @ K 5 per machine hour               Fixed overhead              6 machine hours @ K5...
1. Forecast market demand for the product of BA Ltd is 40,000 units. BA will be...
1. Forecast market demand for the product of BA Ltd is 40,000 units. BA will be able to satisfy 50% of the demand. The selling price per unit is K 100. 2. The cost of producing a unit of the product is as follows: Direct material 2 kgs @ K2.50 per kg Direct labour 4 hours @K 5 per hour Variable overhead 2 machine hours @ K 5 per machine hour Fixed overhead 6 machine hours @ K5 per machine...
The manager of the I-85 Carpet outlet needs to be able to forecast accurately the demand...
The manager of the I-85 Carpet outlet needs to be able to forecast accurately the demand of Soft Shag carpet (its biggest seller). If the manager does not order enough carpet from the carpet mill, customers will buy their carpets from one of the outlets many competitors. The manager has collected the following demand data for the past eight months. Month Demand for Soft Shag Carpet 1 5000 2 10000 3 6000 4 8000 5 14000 6 10000 7 9000...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT