Question

3. Consider the followine Product Structure Data, Demand Data. Routing and Standard data for a company that assembles two products, A and B. Product Structure Data F (3 required 3 requiredil Complete the following tables in order to determine the capacity requirements by using Capacity Bills method. (30 points) Routine and Standard Data Total Standard Setup Hours per unit Operation Hours Sizes per unit с End Lot Work Standard Standard Product Center Setup Production Hours Hours per unit 501 of 1 100 3 0.25 1001 of 1 100 3 0.30 Components 40 of 2 2002 0.35 40 2 of 23002 0.45 D20 of 23001 0.55 20 2 of 2 2001 0.30 E 50 1 of 200 3 0,25 F 501 of 1 300 3 0 .50 Demand Data: Week 1 2 3 4 A40301535 IB 30 30 40 30 Bill of Capacity: LA B

Answer 1

A(1 unit) requires:			B(1 unit) requires:
C(1)			D(1)
E(2)	E(1 unit) require 3 F		E(2)	E(1 unit) require 3 F
F(6)			F(6)
Routing and Standard Data
End Product	Lot Sizes (a)	Operations	Work Center	Standard Setup Hours (b)	Standard Production Hours per unit (c )	Standard Setup Hours per unit (d=b/a)	Total Hours per unit (c+d)
A	50	1/1	100	3	0.25	0.06	0.31
B	100	1/1	100	3	0.3	0.03	0.33
Components
C	40	1/2	200	2	0.35	0.05	0.4
	40	2/2	300	2	0.45	0.05	0.5
D	20	1/2	300	1	0.55	0.05	0.6
	20	2/2	200	1	0.3	0.05	0.35
E	50	1/1	200	3	0.25	0.06	0.31
F	50	1/1	300	3	0.5	0.06	0.56
Demand Data
Week	1	2	3	4
A	40	30	15	35
B	30	30	40	30
Bill of Capacity
	A		B
Work Center	Total Time/Unit	Calculation	Total Time/Unit	Calculation
100	0.31	=0.31	0.33	=0.33
200	1.02	=0.4+(0.31*2)	0.97	=0.35+(0.31*2)
300	3.86	=0.5+(0.56*6)	3.96	=0.6+(0.56*6)
Total Time/unit	5.19		5.26
Capacity Requirements by using Capacity Bills:
Work Center	1	2	3	4	Total Hours	Projected Work Center %
100	22.3	19.2	17.85	20.75	80.1	6.13%
200	69.9	59.7	54.1	64.8	248.5	19.02%
300	273.2	234.6	216.3	253.9	978	74.85%
Total	365.4	313.5	288.25	339.45	1306.6
Calculation
=[(Demand units of A for week)*(Total time of A for Work Center)] + [(Demand units of B for week)*(Total time of B for Work Center)]
For work center 100 for week 1:
=[(40*0.31)+(30*0.33)]
22.3
Similar calculation for all.