Problem No. 1
A machine produces a product and the operator of the machine would like to develop an SPC chart to control the proportion of non-conforming (defective) units produced. She/he takes twenty samples of 250 units each and records the number of defective units found in each sample in the following table:
1 8 11 4
2 5 12 3
3 3 13 5
4 9 14 6
5 4 15 2
6 5 16 5
7 8 17 0
8 5 18 3
9 3 19 4
10 6 20 2
A. [2 points] What type of control chart (X-bar, R, p, or c) is appropriate for this process? Why? (No explanation, no credit)
B. [4 points] Calculate the control limits for a 2-sigma control chart for this process.
C. [4 points] Given the sample data above, is the process in or out of control? EXPLAIN (be specific as to why). No explanation, no credit! You must draw a control chart (Use Excel for this purpose and copy the graph into your Word document).
Problem No. 2
A chocolate manufacturer would like to develop a process control chart to control the weight of chocolate bars it produces. Historically, the process has had a standard deviation of 0.25. The operator has taken 39 samples of size 7 each and calculated the following sample means:
1 3.86 14 3.81 27 3.81
2 3.90 15 3.83 28 3.86
3 3.83 16 3.86 29 3.98
4 3.81 17 3.82 30 3.96
5 3.84 18 3.86 31 3.88
6 3.83 19 3.84 32 3.76
7 3.87 20 3.87 33 3.83
8 3.88 21 3.84 34 3.77
9 3.84 22 3.82 35 3.86
10 3.80 23 3.89 36 3.80
11 3.88 24 3.86 37 3.84
12 3.86 25 3.88 38 3.79
13 3.88 26 3.90 39 3.85
A. [3 points] Calculate the control limits for a 2-sigma x-bar control chart for this process.
B. [3 points] Assuming the R-chart for the process is in control, is this process in control? Why or Why not? EXPLAIN (be specific as to why). No explanation, no credit.
C. [4 points] The specifications for the product are as follows: 3.8 ± 0.4 oz. Calculate the Capability ratio and index. Interpret them (be specific).
Problem No. 3
An appliance store carries a certain brand of TV which has he following characteristics:
Average daily demand 2 units
Ordering cost $25 per order
Carrying Cost 35% of unit cost per year
Unit cost $400 per unit
Average Lead time 4 days
Standard deviation of daily demand 0.8 unit
Standard deviation of lead time 0.6 days
The firm currently orders the product 85 units at a time and operates 250 days a year.
A. [4 points] With the current lot-size policy, what is the annual holding and ordering costs?
B. [3 points] With the current lot size, what is the average time (in days) between orders?
C. [3 points] Calculate EOQ for the TVS.
Problem No. 4
A retailer needs to choose between two suppliers for one of its products. The only criterion used for the decision is the cost. The following information about the product is available:
Demand 200 a week
Ordering cost (for all suppliers) $75 per order
Holding cost 20% of the unit cost
Working weeks 50 a year
The retailer has narrowed down the choices to two suppliers. The following shows the price-break schedule for each supplier:
SUPPLIER A SUPPLIER B
Quantity Unit Price Quantity Unit Price
1-299 $14.00 1-249 $14.10
300-699 13.80 250-449 13.90
700+ 13.60 450+ 13.70
A. [4 points] Which supplier should the retailer choose? Explain and support your answer with appropriate calculations. Do NOT exceed the box for explanation.
B. [3 points] What is the optimal lot size for the item? (Note: There has to be only ONE choice, regardless of supplier).
C. [3 points] What is the total annual cost of inventory for the chosen (best) lot size?
Problem No. 5
A retailer is considering a P-system of inventory control for one of its products. However, the total cost of the system (including safety stock) is a concern. The following information about this item is gathered:
Average demand for the product 120 units per day
Standard deviation of demand 30
The store operates 300 days a year
Holding cost 35 percent of the unit cost
Ordering costs $120 per order
Production lead time (setup time) 3 days
Stock out policy No more than 7%
Unit cost $9.25
Given this information, determine the following:
A. [5 points] Assuming a P system with a review period of 14 days, calculate the safety stock needed to support the desired stockout policy.
B. [5 points] Annual total cost of the P-system (Grand total cost of inventory for the year)
Problem No. 6
[5 points] A retailer currently holds 45 units of safety stock for one of its products. Demand for this product averages 100 units a week with the standard deviation of 12 and the lead time for it is 3 weeks. The current industry standard for this firm is 2% stockout. Is this retailer competitive? WHY? You must show your calculation and explanation below, otherwise there will be no credit.
SHOW BOTH YOUR KEY FIGURES AND YOUR EXPLANATION IN THE FIELD FOR THIS QUESTION
BONUS PROBLEM # 2
[5 points] A retailer is considering a P-system of inventory control for one of its products. However, the first question is what the review period (P) should be. The following information about this item is gathered:
Average demand for the product 150 units per day
The store operates 300 days a year
Holding cost 30 percent of the unit cost
Ordering cost $90 per order
Unit cost $10.75
Given this information, determine the best estimate for the P (Review Period)