
Concept explainers
a)
Interpretation: Determine the order policy for the item based on silver-meal method.
Concept Introduction: Silver-Meal method is mainly used to determine the production quantities of the firm to be produced at the minimum cost.it is also provides the appropriate solutions to the time varying demand in production patterns.
a)

Answer to Problem 14P
The order policy according to silver meal method is 18 units in period-1,23 units in Period-4,50 units in Period-6,35 units in period-9 and 12 units in period-12.
Explanation of Solution
Given information: The anticipated demand for an inventory is as follows:
Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |
Demand | 6 | 12 | 4 | 8 | 15 | 25 | 20 | 5 | 10 | 20 | 5 | 12 |
Current inventory is 4 and ending inventory is 8.
Holding cost (h) is $1 per period, set up cost (K) is $40
The objective of this method is to minimize the per-period-cost of ordering policy.
Net Requirements:
The order policy (lot-size) of the item under silver meal method can be calculated as follows:
According to silver meal method the average cost per period C (T) is a function of the average holding and set up cost per period for T number of Periods. The production in period 1 is equal to the demand in that period 1 to incur the order cost K.
Hence
And
And general equation is
Once
Now, calculate the order policy using the above formula as follows:
Starting in period 1:
Stop the process since
Starting in period 4:
Stop the process since
Starting in period 6:
Stop the process since
Starting in period 9:
Stop the process since
The same is explained with the help of a table shown below:
Table 1: Order Quantity using Silver-Meal Method:
Months | No.of periods | Q | 11 | 12 | 13 | 14 | 15 | 16 | 17 | Total inventory | Holding Cost | Ordering Cost | Per Period Cost | Decision |
1 to 1 | 1 | 2 | 0 | =SUM(D3:J3) | =K3*1 | 40 | =SUM((L3:M3)/B3) | Continue | ||||||
1 to 2 | 2 | =2+12 | 12 | 0 | =SUM(D4:J4) | =K4*1 | 40 | =SUM((L4:M4)/B4) | Continue | |||||
1 to 3 | 3 | =14+4 | =C5-C3 | =C5-C4 | 0 | =SUM(D5:J5) | =K5*1 | 40 | =SUM((L5:M5)/B5) | Optimal | ||||
1 to 4 | 4 | =C5+8 | =C6-C3 | =C6-C4 | =C6-C5 | 0 | =SUM(D6:J6) | =K6*1 | 40 | =SUM((L6:M6)/B6) | Go Back | |||
4 to 4 | 1 | 8 | 0 | =SUM(D7:J7) | =K7*1 | 40 | =SUM((L7:M7)/B7) | Continue | ||||||
4 to 5 | 2 | =C7+15 | =C8-C7 | 0 | =SUM(D8:J8) | =K8*1 | 40 | =SUM((L8:M8)/B8) | Optimal | |||||
4 to 6 | 3 | =C8+25 | =C9-C7 | =C9-C8 | 0 | =SUM(D9:J9) | =K9*1 | 40 | =SUM((L9:M9)/B9) | Go Back | ||||
6 to 6 | 1 | 25 | 0 | =SUM(D10:J10) | =K10*1 | 40 | =SUM((L10:M10)/B10) | Continue | ||||||
6to 7 | 2 | =C10+20 | =C11-C10 | 0 | =SUM(D11:J11) | =K11*1 | 40 | =SUM((L11:M11)/B11) | Continue | |||||
6 to 8 | 3 | =C11+5 | =C12-C10 | =C12-C11 | 0 | =SUM(D12:J12) | =K12*1 | 40 | =SUM((L12:M12)/B12) | Optimal | ||||
6 to 9 | 4 | =C12+10 | =C13--C10 | =C13-C11 | =C13-C12 | =C13-C13 | =SUM(D13:J13) | =K13*1 | 40 | =SUM((L13:M13)/B13) | Go Back | |||
9 to 9 | 1 | 10 | 0 | =SUM(D14:J14) | =K14*1 | 40 | =SUM((L14:M14)/B14) | Continue | ||||||
9 to 10 | 2 | =C14+20 | =C15-C14 | 0 | =SUM(D15:J15) | =K15*1 | 40 | =SUM((L15:M15)/B15) | Continue | |||||
9 to 11 | 3 | =C15+5 | =C16-C14 | =C16-C15 | 0 | =SUM(D16:J16) | =K16*1 | 40 | =SUM((L16:M16)/B16) | Optimal | ||||
9 to 12 | 4 | =C16+12 | =C17--C14 | =C17-C15 | =C17-C16 | =C17-C17 | =SUM(D17:J17) | =K17*1 | 40 | =SUM((L17:M17)/B17) | Go Back | |||
12 to 12 | 1 | 12 | 0 | =SUM(D18:J18) | =K18*1 | 40 | =SUM((L18:M18)/B18) | Optimal |
b)
Interpretation: Determine the order policy for the item based on Least Unit Cost method.
Concept Introduction: Least unit cost produced the demand of the present periods based on the trial basis, yield the future periods. The method is calculated by adding the setup cost and carrying inventory cost and finally find the smallest cost per unit.
b)

Answer to Problem 14P
The order policy according to LUC method is 26 units in period-1, 40 units in Period-5, 25 units in Period-7, 35 units in period-9 and 12 units in period-12.
Explanation of Solution
Given information: The anticipated demand for a component VC is as follows:
Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Demand | 42 | 42 | 32 | 12 | 26 | 112 | 45 | 14 | 76 | 38 |
Holding cost (h) is $0.60 per period, set up cost (K) is $132
The order policy (lot-size) of the item under Least Unit Cost(LUC)method can be calculated as follows:
LUC divides the average cost per period C (T) by the total number of units demanded. Hence
And
And general equation is
Once
Starting from period 1
Stop the process since
Starting in period 5:
Stop the process since
Starting in period 7:
Stop the process since
Starting in period 9:
Stop the process since
The same is explained with the help of a table shown below:
Table 2: Order Quantity using Least-Unit-Cost Method:
Demand | Months | Q | 11 | 12 | 13 | 14 | 15 | Total inventory | Holding Cost | Ordering Cost | Total Cost | Per Period Cost | Decision |
2 | 1 to 1 | =A3 | 0 | =SUM(D3:H3) | =L3*1 | 40 | =K3+J3 | =L3/C3 | Continue | ||||
12 | 1 to 2 | =C3+A4 | =C4-C3 | 0 | =SUM(D4:H4) | =L4*1 | 40 | =K4+J4 | =L4/C4 | Continue | |||
4 | 1 to 3 | =C4+A5 | =C5-C3 | =C5-C4 | 0 | =SUM(D5:H5) | =L5*1 | 40 | =K5+J5 | =L5/C5 | Continue | ||
8 | 1 to 4 | =C5+A6 | =C6-C3 | =C6-C4 | =C6-C5 | =C6-C6 | =SUM(D6:H6) | =L6*1 | 40 | =K6+J6 | =L6/C6 | Optimal | |
15 | 1 to 5 | =C6+A7 | =C7-C3 | =C7-C4 | =C7-C5 | =C7-C6 | =C7-C7 | =SUM(D7:H7) | =L7*1 | =K7+J7 | =L7/C7 | Go Back | |
15 | 5 to 5 | =A8 | 0 | =SUM(D8:H8) | =L8*1 | 40 | =K8+J8 | =L8/C8 | Continue | ||||
25 | 5 to 6 | =C8+A9 | =C9-C8 | 0 | =SUM(D9:H9) | =L9*1 | 40 | =K9+J8 | =L9/C9 | Optimal | |||
20 | 5 to 7 | =C9+A11 | =C10-C8 | =C10-C9 | =C10-C10 | =SUM(D10:H10) | =L10*1 | 40 | =K10+J10 | =L10/C10 | Go Back | ||
20 | 7 to 7 | =A11 | 0 | =SUM(D11:H11) | =L11*1 | 40 | =K11+J11 | =L11/C11 | Continue | ||||
5 | 7 to 8 | =C11+A12 | =C12-C11 | 0 | =SUM(D12:H12) | =L12*1 | 40 | =K12+J12 | =L12/C12 | Optimal | |||
10 | 7 to 9 | =C12+A13 | =C13-C11 | =C13-C12 | =C13-C13 | =SUM(D13:H13) | =L13*1 | 40 | =K13+J13 | =L13/C13 | Go Back | ||
10 | 8 to 8 | =A14 | 0 | =SUM(D14:H14) | =L14*1 | 40 | =K14+J14 | =L14/C14 | Continue | ||||
20 | 8 to 9 | =C14+A15 | =C15-C14 | 0 | =SUM(D15:H15) | =L15*1 | 40 | =K15+J15 | =L15/C15 | Continue | |||
5 | 8 to 10 | =C15+A16 | =C16-C14 | =C16-C15 | 0 | =SUM(D16:H16) | =L16*1 | 40 | =K16+J16 | =L16/C16 | Optimal | ||
12 | 8 to 11 | =C16+A17 | =C17-C14 | =C17-C15 | -C17-C16 | =C17-C17 | =SUM(D17:H17) | =L17*1 | 40 | =K17+J17 | =L17/C17 | Go Back | |
12 | 12 to 12 | 12 | 0 | =SUM(D18:H18) | =L18*1 | 40 | =K18+J18 | ==L18/C18 | Optimal |
c)
Interpretation: Determine the order policy for the item based on Part Period Balancing method.
Concept Introduction: Part Period Balancing method is the lot-size method which use the starting and ending of the process function to consider the multiple periods to modifying the calculation based on the least total cost.
c)

Answer to Problem 14P
The order policy according to part period balancing method is 26 units in period-1, 60 units in Period-5, 35 units in Period-8, 17 units in period-11.
Explanation of Solution
Given information: The anticipated demand for a component VC is as follows:
Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Demand | 42 | 42 | 32 | 12 | 26 | 112 | 45 | 14 | 76 | 38 |
Holding cost (h) is $0.60 per period, set up cost (K) is $132
The order policy (lot size) according to part period balancing method can be calculated as follows:
In this method the order horizon that equates holding and setup cost over that period has to be calculated as follows:
Starting from Period 1
d)
Interpretation: Determine the three lot-sizing method resulted in the lowest cost for the 12 periods.
Concept Introduction: Lot size is determined the quantity order during the production time. The size of the lot may be dynamic or fixed.ERP (Enterprise Resource Planning) is the inbuilt multiple heuristic methods to determine the size of the lot to the production unit.
d)

Answer to Problem 14P
The Silver-meal method is giving lowest cost.
Explanation of Solution
Given information: The anticipated demand for a component VC is as follows:
Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
Demand | 42 | 42 | 32 | 12 | 26 | 112 | 45 | 14 | 76 | 38 |
Holding cost (h) is $0.60 per period, set up cost (K) is $132
Calculate the total cost of the ordering for the three methods as shown below:
Silver-meal | Least Unit Cost | Part Period Balancing | |
Holding Cost | =20+15+30+30 | =44+25+5+30 | =44+65+50+12 |
Setup Cost | =40*5 | =40*5 | =4*40 |
Total Cost | =B3+B2 | =C3+C2 | =D3+D2 |
Silver-meal | Least Unit Cost | Part Period Balancing | |
Holding Cost | 95 | 104 | 171 |
Setup Cost | 200 | 200 | 160 |
Total Cost | 295 | 304 | 331 |
Want to see more full solutions like this?
Chapter 8 Solutions
EBK PRODUCTION AND OPERATIONS ANALYSIS
- Say women on average take twice as long in the restroom (not including waiting times) than men. Is the 2:1 ration for flushing capacity the right ratio?arrow_forwardTo what extent does the equation for the waiting time in the queue help explain why queues for the Women's room might be longer than queues for the Men's room before 2005 in New York City?arrow_forwardBesides adding flushing capacity for the women's bathrooms versus men's bathrooms, what can be done to reduce waiting time for the restrooms?arrow_forward
- How does rework hurt a process? Give examples on how rework can hurt a process. Please provide a referencearrow_forwardHow does rework hurt a process? Give examples on how rework can hurt a process. Please provide a referencearrow_forwardWhat the different between a near miss and hazard 1. movement and contact 2. Contact 3. movementarrow_forward
- The fixed and variable costs for three potential manufacturing plant sites for a rattan chair weaver are shown: Site Fixed Cost Per Year Variable Cost per Unit 1 $700 $12.00 2 $1,000 $7.00 $2,200 $5.00 a) After rounding to the nearest whole number, site 1 is best below After rounding to the nearest whole number, site 2 is best between After rounding to the nearest whole number, site 3 is best above b) If the demand is 590 units, then the best location for the potent 3 units. and units. 600 0 60 units. g plant isarrow_forwardRefer to Table S6.1 - Factors for Computing Control Chart Limits (3 sigma) for this problem. Sampling 4 pieces of precision-cut wire (to be used in computer assembly) every hour for the past 24 hours has produced the following results: Hour R Hour X R Hour X R Hour X R 1 3.25" 0.71" 7 3.15" 0.58" 13 3.11" 0.85" 19 4.51" 1.56" 2 3.20 1.18 8 2.65 1.08 14 2.83 1.31 20 2.79 1.14 3 3.12 1.38 9 15 4. 3.39 1.31 10 5 2.97 1.17 6 2.76 0.32 3.02 0.71 3.12 1.01 2.75 1.33 16 2.74 0.50 22 11 2.73 1.17 17 2.76 1.43 23 12 2.87 0.45 18 2.64 1.24 21 2.75 1.03 3.18 0.46 2.94 1.53 24 2.54 0.97 Based on the sampling done, the control limits for 3-sigma x chart are (round all intermediate calculations to three decimal places before proceeding with further calculations): Upper Control Limit (UCL) = inches (round your response to three decimal places). Lower Control Limit (LCL) = inches (round your response to three decimal places). Based on the x-chart, the wire cutting process has been The control limits…arrow_forwardChoose a specific cars company. E.g Toyota, Volkswagen, Hyundai, Mercedes-Benz, BMW, Honda, Ford, Audi, Tesla Define a list of required machinery, equipment, workstations, offices, rest areas, materials, etc. Develop and define the location of machinery, equipment, workstations, offices, rest areas, materials. Make the distribution in the manufacturing facility the most efficient way possible. Develop a process distribution for one specific product. Explain why you consider this is the most efficient distribution for this specific manufacturing facility. demonstrate the benefits of optimizing a production line with the best distribution of its equipment and spaces. To be more productive and profitable.arrow_forward
- Provide a Synposis of the Articlearrow_forwardThe goal of understanding personality in negotiation is to better predict behavior, such as the counterparty's acceptance or rejection of a negotiation offer. One investigation used acoustic and visual cues to predict the likely behavior of a counterparty to a proposal. The best visual cue predictor of the counterparty (55%) was whether they _____. A. tilted their head B. had their arms and legs crossed C. steepled their fingers D. tapped a penarrow_forwardWomen who ask for what they want in negotiation are less well-liked than women who do not self-advocate. However, nonassertive, other-advocating women suffer a leadership backlash and are regarded as less competent because their behavior is regarded to be _____ and _____. A. high-negative feminine; low-positive masculine B. high-positive feminine; high-positive masculine C. high-negative masculine; low-negative feminine D. low-positive masculine; low-positive femininearrow_forward
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningPractical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
- MarketingMarketingISBN:9780357033791Author:Pride, William MPublisher:South Western Educational Publishing

