MGT-440 Problem Solving Activity

Must show all work

3.2. The Shades Sunglass Company assembles sunglasses from frames, which it makes, and lenses, which
it purchases from an outside supplier. The sales department has prepared the following 6-week forecast
for Ebony, a popular model. The sunglasses are assembled in lots of 220, and the opening inventory is
300 pairs. Complete the projected available balance and the master production schedule.
week
Forecast sales
Projected available
balance
1
2
3
4
5
6
200
300
300
200
150
150
300
MPS
3.4. Worldwide Can-Openers, Inc., makes a family of two hand-operated can openers. The production
plan is based on months. There are 4 weeks in this month. Opening inventory is 2000 dozen, and it is
planned to increase that to 4000 dozen by the end of the month. The MPS is made using weekly periods.
The forecast and projected available balance for the two models follow. The lot size for both models is
1000 dozen. Calculate the production plan and the MPS for each item.
Production plan
week
Forecast
Projected available
balance
Production plan
1
2
3
4
3000
3500
3500
4000
1
2
3
4
2000
2000
2500
2000
total
2000
model A
week
Forecast
Projected available
balance
MPS
1500
total
Model B
week
Forecast
Projected available
balance
1
2
3
4
1000
1500
1000
2000
total
500
MPS
3.6. The Acme Widget Company makes widgets in two models, and the bottleneck operation is in work
center 10. Following is the resource bill (in hours per part).
Work center
10
Hours per part
Model A
2.4
| Model B
| Model 3.5
The master production schedule for the next 5 weeks is
Week
Model A
Model B
1
70
20
2
50
40
3
50
55
4
60
30
5
48
45
A. Using the resource bill and the master production schedule, calculate the number of hours required in
work center 10 for each of the 5 weeks. Use the following table to record the required capacity on the
work center.
Week
Model A
Model B
Total hours
1
2
3
4
5
B. If the available capacity at work station 10 is 260 hours per week, suggest possible ways of meeting
the demand in week 3.
3.8. Given the following data, calculate how many units are available to promise. There are 5 units on
hand.
Week
Customer
orders
MPS
ATP
1
21
2
30
3
17
4
8
30
30
5
6
3.11. Calculate the available to promise using the following data. There are 50 units on hand.
Week
Customer
orders
MPS
ATP
1
20
2
50
3
30
4
30
5
50
100
6
30
100
3.13. Given the following data, can an order for 40 more units for delivery in week 5 be accepted? If not,
what do you suggest can be done? There are zero units on hand.
Week
1
Customer 70
order
MPS
100
ATP
2
10
3
50
4
40
5
10
6
15
100
7
20
8
15
100
3.15. Given the following data, calculate the projected available balance and the planned MPS receipts.
The lot size is 100. The demand time fence is 2 weeks.
Week
Forecast
Customer
orders
Projected 60
balance
MPS
1
50
60
2
50
30
3
50
65
4
50
25
3.18.
A. Given the following master schedule, fill in the projected available and available to promise
rows:
On hand: 35
Period
1
Forecast 30
Customer 31
order
Projected
available
Available
to
promise
MPS
Planning time fence: 10
Demand time fence: 2
2
40
35
200
3
40
29
4
50
21
5
40
17
6
40
14
7
30
33
Lot size: 200
8
40
11
9
40
5
10
50
2
11
40
0
12
40
1
200
B. A customer wants an order of 100 in period 4. What can you tell him?
C. The customer from part (b) cancels his request, but then says he wants 120 in period 5. What do
you tell him now?
D. Sales has requested that you add an MPS of 200 in period 9 to cover their needs for a sales
promotion. What do you tell them and why?
E. What action (if any) should be taken in period 11? Why is it okay to take the action?
4.2. Given the following parents and components, construct a product tree. Figures in parentheses
show the quantities per item. How many Gs are needed to make one A?
Parent
A
B
C
E
Component
B(2)
E(2)
G(3)
G(4)
C(4)
F(1)
D(4)
F(3)
H(2)
4.5. Given the following product tree, explode, offset, and determine the gross and net
requirements. All lead times are 1 week, and the quantities required are shown in parentheses. The
master production schedule calls for 100 As to be available in week 5. There are 20 Bs available. All
other on-hand balances = 0.
4.11 Given the following product tree, complete the MRP records for parts X, Y, W, and Z. Note that
parts X and Y have specified order quantities.
4.13. Given the following product tree, determine the low-level codes for all the components.