A | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 — Generate the material requirements You need BOM for each three products and — After completing plan develop load profile work center
PhysicsGeneralWorked Solution
(a) Generate the material requirements. You need a BOM for each of the three products (A, B, and C), beginning inventory levels, and scheduled receipts. The BOMs are shown in Figure. All items use lot-for-lot as the lot size rule. No beginning inventories exist. Lead time is two weeks for all items except items D and F, which have a lead time of three weeks. All other information is provided for you in Table.
.:.
(b) After completing the material requirements plan, develop a load profile for each work center for each week of the second quarter. Use the planned order releases and calculate the workload at each work center for weeks 14 through 26. The standard times are shown in the table. Use the load profiles to identify potential problems. The effective capacity at each work center is 960 hours each period.
.:.
The Newmarket International Manufacturing Company (NIMCO) was started by Marcia Blakely just two years after she finished graduate school. Her knowledge of mass customization has been the driving force behind NIMCO. The company produces three major custom products. Volume on the products is high even though each item is customized specifically for the customer. The products are processed through up to four different work centers. Even though each item is unique, the processing time at each work center is constant due to the sophisticated equipment used.
SOLUTION:
a.
A
12
13
14
15
16
17
18
19
Gross requirements
7600
8700
9000
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
7600
8700
9000
8700
A
20
21
22
23
24
25
26
27
Gross requirements
8700
8000
6800
3000
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
8000
6800
3000
D (L4L, LT = 3)
9
10
11
12
13
14
15
16
Gross requirements
22800
26100
27000
Scheduled Receipts
22800
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
26100
27000
26100
D (L4L, LT = 3)
17
18
19
20
21
22
23
24
Gross requirements
2610000
24000
20400
9000
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
24000
20400
9000
F (L4L, LT = 3)
9
10
11
12
13
14
15
16
Gross requirements
7600
8700
9000
Scheduled Receipts
7600
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
8700
9000
8700
F (L4L, LT = 3)
17
18
19
20
21
22
23
24
Gross requirements
8700
8000
6800
3000
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
8000
6800
3000
E (L4L, LT = 2)
9
10
11
12
13
14
15
16
Gross requirements
15200
17400
18000
Scheduled Receipts
15200
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
17400
18000
17400
E (L4L, LT = 2)
17
18
19
20
21
22
23
24
Gross requirements
17400
16000
13600
6000
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
16000
13600
6000
I (L4L, LT = 2)
9
10
11
12
13
14
15
16
Gross requirements
34800
36000
34800
Scheduled Receipts
34800
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
36000
34800
32000
I (L4L, LT = 2)
17
18
19
20
21
22
23
24
Gross requirements
32000
27200
12000
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
27200
12000
🔒
Unlock the complete assignment
You are viewing the free preview. Purchase this assignment once to reveal the complete resource.
$9.99 USD
Secure checkout is completed by Stripe.
B
12
13
14
15
16
17
18
19
Gross requirements
4000
4000
4000
3800
3800
3800
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
4000
4000
4000
3800
3800
3800
3600
3600
B
20
21
22
23
24
25
26
27
Gross requirements
3600
3600
3600
3800
3800
3800
4000
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
3600
3800
3800
3800
4000
G (L4L, LT = 2)
9
10
11
12
13
14
15
16
Gross requirements
8000
8000
8000
7600
7600
Scheduled Receipts
8000
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
8000
8000
7600
7600
7600
7200
G (L4L, LT = 2)
17
18
19
20
21
22
23
24
Gross requirements
7600
7200
7200
7200
7600
7600
7600
8000
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
7200
7200
7600
7600
7600
8000
J (L4L, LT = 2)
9
10
11
12
13
14
15
16
Gross requirements
24000
24000
22800
22800
22800
21600
Scheduled Receipts
24000
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
24000
22800
22800
22800
21600
21600
21600
J (L4L, LT = 2)
17
18
19
20
21
22
23
24
Gross requirements
21600
21600
22800
22800
22800
24000
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
22800
22800
22800
24000
H (L4L, LT = 2)
9
10
11
12
13
14
15
16
Gross requirements
16000
16000
16000
15200
15200
Scheduled Receipts
16000
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
16000
16000
15200
15200
15200
14400
H (L4L, LT = 2)
17
18
19
20
21
22
23
24
Gross requirements
15200
14400
14400
14400
15200
15200
15200
16000
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
14400
14400
15200
15200
15200
16000
C
12
13
14
15
16
17
18
19
Gross requirements
5300
6300
6400
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
5300
6300
6400
6000
C
20
21
22
23
24
25
26
27
Gross requirements
6000
5600
5200
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
5600
5200
R (L4L, LT = 2)
9
10
11
12
13
14
15
16
Gross requirements
10600
12600
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
10600
12600
12800
R (L4L, LT = 2)
17
18
19
20
21
22
23
24
Gross requirements
12800
12000
11200
10400
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
12000
11200
10400
X (L4L, LT = 2)
9
10
11
12
13
14
15
16
Gross requirements
5300
6300
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
5300
6300
6400
X (L4L, LT = 2)
17
18
19
20
21
22
23
24
Gross requirements
6400
6000
5600
5200
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
6000
5600
5200
K (L4L, LT = 2)
9
10
11
12
13
14
15
16
Gross requirements
15900
18900
19200
Scheduled Receipts
15900
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
18900
19200
18000
K (L4L, LT = 2)
17
18
19
20
21
22
23
24
Gross requirements
18000
16800
15600
Scheduled Receipts
Projected Available 0
0
0
0
0
0
0
0
0
Planned order releases
16800
15600
b.
Workload for Work Center 1
Workload for Work Center 1
Workload for Work Center 1
Period
Item
Quantity
Standard hrs
Total time
Weekly Load
14
H
15200
0.0375
570
570
15
D
26100
0.02
522
H
15200
0.0375
570
1092
16
H
14400
0.0375
540
540
17
D
24000
0.02
480
H
14400
0.0375
540
1020
18
H
14400
0.0375
540
540
19
D
20400
0.02
408
H
15200
0.0375
570
978
20
H
15200
0.0375
570
570
Workload for Work Center 2
Workload for Work Center 2
Workload for Work Center 2
Period
Item
Quantity
Standard hrs
Total time
Weekly Load
14
G
7600
0.02
152
J
21600
0.015
324
476
15
G
7600
0.02
152
R
12800
0.04
512
J
21600
0.015
324
988
16
G
7200
0.02
144
J
21600
0.015
324
468
17
G
7200
0.02
144
R
12000
0.04
480
J
22800
0.015
342
966
18
G
7200
0.02
144
J
22800
0.015
342
486
19
G
7600
0.02
152
R
11200
0.04
448
J
22800
0.015
342
942
20
G
7600
0.02
152
J
24000
0.015
360
512
Workload for Work Center 3
Workload for Work Center 3
Workload for Work Center 3
Period
Item
Quantity
Standard hrs
Total time
Weekly Load
14
E
18000
0.02
360
I
34800
0.02
696
1056
15
F
8700
0.02
174
K
18000
0.03
540
X
6400
0.04
256
970
16
E
17400
0.02
348
I
32000
0.02
640
988
17
F
8000
0.02
160
K
16800
0.03
504
X
6000
0.04
240
904
18
E
16000
0.02
320
I
27200
0.02
544
864
19
F
6800
0.02
136
K
15600
0.03
468
X
5600
0.04
224
828
20
E
13600
0.02
272
I
12000
0.02
240
512
Workload for Work Center 4
Workload for Work Center 4
Workload for Work Center 4
Period
Item
Quantity
Standard hrs
Total time
Weekly Load
14
A
8700
0.04
348
B
4000
0.1
400
748
15
B
3800
0.1
380
C
6300
0.06
378
758
16
A
9000
0.04
360
B
3800
0.1
380
740
17
B
3800
0.1
380
C
6400
0.06
384
764
18
A
8700
0.04
348
B
3600
0.1
360
708
19
B
3600
0.1
360
C
6000
0.06
360
720
20
A
8000
0.04
320
B
3600
0.1
360
680
We will not have enough capacity in work center 1 during weeks 15, 17 and 19. Capacity will not be enough in work center 2 in weeks 15 and 17. Finally, we will not have enough capacity in work center 3 in weeks 14, 15 and 16.