A manager receives a forecast for next year. Demand is projected to be 530 units for the first half of the year and 1,000 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 carry costs for each of the six-month periods. (Round your answers to the nearest whole number.)
Period
1 – 6 months
7 – 12 months
Order Size
units?
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
1 – 6 months
7 – 12 months
Order Size
units?
units?
a)
1 - 6 months period
Monthly demand, D = 530/6 = 88.3
Monthly holding cost, H = $ 2
Order cost, S = $ 55
Economic Order size = SQRT(2DS/H) = SQRT(2*88.3*55/2) = 70
7 - 12 months period
Monthly demand, D = 1000/6 = 167
Monthly holding cost, H = $ 2
Order cost, S = $ 55
Economic Order size = SQRT(2DS/H) = SQRT(2*167*55/2) = 96
______________________________
b)
1 - 6 months period
Total monthly cost of EOQ policy = (D/Q)*S + (Q/2)*H = (88.3/70)*55 + (70/2)*2 = $ 139.38
Total monthly cost of Q=50 policy = (88.3/50)*(55-10) + (50/2)*2 = $ 129.47
Total monthly cost of Q=100 policy = (88.3/100)*(55-10) + (100/2)*2 = $ 139.74
Total monthly cost of Q=150 policy = (88.3/150)*(55-10) + (150/2)*2 = $ 176.49
Total cost of order size 50 is the lowest. Therefore,an order size of 50 units is recommended in the first 6 months.
7 - 12 months period
Total monthly cost of EOQ policy = (D/Q)*S + (Q/2)*H = (167/96)*55 + (96/2)*2 = $ 191.68
Total monthly cost of Q=50 policy = (167/50)*(55-10) + (50/2)*2 = $ 200.3
Total monthly cost of Q=100 policy = (167/100)*(55-10) + (100/2)*2 = $ 175.15
Total monthly cost of Q=150 policy = (167/150)*(55-10) + (150/2)*2 = $ 200.1
Total cost of order size 100 is the lowest. Therefore,an order size of 100 units is recommended in the first 6 months.
Period | Order size |
1 - 6 months | 50 units |
7 - 12 months | 100 units |
A manager receives a forecast for next year. Demand is projected to be 530 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 1,020 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...
Problem 13-7 A manager receives a forecast for next year. Demand is projected to be 600 units for the first half of the year and 930 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 (0.g.100 per month for each of the first six months), determine an order...
task: 1. Develop a forecast for the next 12 months. 2. Develop an ordering strategy for the next 12 months. METRO HOSPITAL You are the materials manager at Metro Hospital. Approximately one year ago, the hospital began stocking a new drug (Ziloene) that helps the healing process for wounds and sutures. It is your responsibility to forecast and order the monthly supply of Ziloene The goal is to minimize the combined cost of overstocking and understocking the drug Orders are...
A manager has projected demand for the next six months (below). Given this information, prepare a LEVEL aggregate plan for production. Assume maximum regular time production is 350 units per month. Overtime is limited to 75 units per month. The limit for subcontracting is 400 per month. The company has a zero beginning inventory and cannot have ending inventory or a backlog at the end of the 6th period. Unit costs are as noted below. Regular Time Cost: $10/unit Overtime...
How many employees will be needed during demand of 610 units in period 5 if no overtime production is to be scheduled oogle Chrome ent/1/OPME%20Study%20Guide%20SP5%20-%202019.pdf 2. Case Study A company has the following demand forecast next year, expressed in six bimonthly(2-month) periods. Period قم قم | Forecast Demand (Standard Units of Work) 400 380 470 530 610 500 alo The following costing data have been obtained: • Each employee works 160 regular working hours per month Each unit requires 20...
Kangaroo P/L has the following demand forecast next year, expressed in six bimonthly (2-month) periods: Period Forecast Demand (Standard U nits of Work) 1 400 2 380 3 470 4 530 5 610 6 500 The following costing data have been obtained: Each employee works 176 regular working hours per month Each unit requires 20 standard hours to produce The labour costs are $6 per normal hour and $9 per overtime hour It costs $3 per month to hold an...
sisas (19-21). A manager has prepared a forecast of expected aggregate demand for the nest s perods Develop an aggregate plan to meet this demand given these additional information . A level production rate of 300 units per month will be used Period 6 Total Forecast 200 200 300 400 500100 Output Regular time Overtime Sabcontract Inventory Outpet- Forecast leventory Backig 19. What is the anding inventory for period 5? A. 0 B. 100 C. -100 D. 200 E -200...
Problem 3. After plotting demand for four periods, an emergency room manager has concluded that a trend- adjusted exponential smoothing model is appropriate to predict future demand. The initial estimate of trend is based on the net change of 30 for the three periods from 1 to 4, for an average of +10 units. Use α-Sand β,4, and TAF of 250 for period 5. Obtain forecasts for periods 6 through 10. Period Actual 210 224 229 240 255 Period Actual...
Demand for the Deskpro computer at Best Buy is 1,000 units per month. Best Buy incurs a fixed order placement, transportation, and receiving cost of $4,000 each time an order is placed. Each computer costs Best Buy $500 and the retailer has a holding cost of 20 percent. The store manager orders in lots of 200 units for each replenishment order. Calculate: 1. The number of times the manager should place an order (order frequency) to meet the annual demand. 2. The...
Demand for a certain product is forecast to be 800 units per month, averaged over all 12 months of the year. The product follows a seasonal pattern, for which the January monthly index is 1.25. What is the seasonally -adjusted sales forecast for January? 1000 units 801.25 units 640 units 83.33 units 798.75 units