ABC Co. makes tables which are sold in kits to be assembled by the customer. The Master Production Schedule calls for the manufacture of 80 and 200 tables in Weeks 5 and 6 respectively:

Week	1	2	3	4	5	6
MPS Quantity	--	--	--	--	80	200

The components of the table (tops and legs) have the following data:

Operation	Top (1 needed)
Machine	Setup Time (min)	Run Time (min)
1	Saw	10	5
2	Planer	40	20

Operation	Leg (4 needed)
Machine	Setup Time (min)	Run Time (min)
1	Saw	10	1
2	Sander	52.5	17

The lot size for both tops and legs is 100 units. Lead time for every operation is 1 week. Historically the load proportions on the machines have been as follows:

Machine	Historical Load Distribution
Saw	15%
Planer	25%
Sander	60%

Standard time to make a table is 100 minutes.

1. Using Overall Factors (CPOF) method determine capacity requirements in Week 4 and 5 for individual resources. (3 points)

Capacity Requirement in Week 5:

Saw:

Planer:

Sander:

Total:

Capacity Requirement in Week 6:

Saw:

Planer:

Sander:

Total:

1. Using Capacity Bills method determine capacity requirements in Week 4 and 5 for individual resources. (5 points)

HINT: Compute Standard Times using the following templates:

Operation	Top	Time/Top	Time/Table
Machine	Setup Time (min)	Run Time (min)
1	Saw	10	5
2	Planer	40	20

Operation	Leg	Time/Leg	Time/Table
Machine	Setup Time (min)	Run Time (min)
1	Saw	10	1
2	Sander	52.5	17

Machine	Time/Table
Saw
Planer
Sander
Total

Capacity Requirement in Week 5:

Saw:

Planer:

Sander:

Total:

Capacity Requirement in Week 6:

Saw:

Planer:

Sander:

Total:

1. Using Resource Profiles method determine capacity requirements in Week 4 and 5 for individual resources. (8 points)

Capacity Requirement in Week 5:

Saw:

Planer:

Sander:

Total:

Capacity Requirement in Week 6:

Saw:

Planer:

Sander:

Total: