final assignments

profiledlc523
om.finalexcel1.xlsx

14.8

14.8 As the production planner for Scott Sampson Products, Inc., you have been given a bill of material for a bracket that is made up of a base, two springs, and four clamps. The base is assembled from one clamp and two housings. Each clamp has one handle and one casting. Each housing has two bearings and one shaft. There is no inventory on hand. a) Design a product structure noting the quantities for each item and show the low-level coding. b) Determine the gross quantities needed of each item if you are to assemble 50 brackets. c) Compute the net quantities needed if there are 25 of the base and 100 of the clamp in stock. PX
a) Design a product structure noting the quantities for each item and show the low-level coding.
Item Low-Level code
Bracket 0
Spring 1
Base 1
Clamp 2
Housing 2
Handle 3
Casting 3
Bearing 3
Shaft 3
b) Determine the gross quantities needed of each item if you are
to assemble 50 brackets.
Item Low-Level code Gross quantity Required Available Net Quanity required
Bracket 0 50 0 50
Spring 1 100 0 100
Base 1 50 0 50
Clamp 2 250 0 250
Housing 2 100 0 100
Handle 3 250 0 250
Casting 3 250 0 250
Bearing 3 200 0 200
Shaft 3 100 0 100
c) Compute the net quantities needed if there are 25 of the base
and 100 of the clamp in stock. PX
Item Low-Level code Gross quantity Required Available Net Quanity required
Bracket 0 50 0 50
Spring 1 100 0 100
Base 1 50 25 25
Clamp 2 225 100 125
Housing 2 50 0 50
Handle 3 125 0 125
Casting 3 125 0 125
Bearing 3 100 0 100
Shaft 3 50 0 50

Bracket

Springs(2)

Clamps(4)

Handle(1)

Base(1)

Clamp(1)

Housings(2)

Casting(1)

Handle(1)

Casting(1)

Bearings(2)

Shaft(1)

14.9

Bracket Spring Base Clamp Housing Handle Casting Bearing Shaft Item Low-Level code
Week 10 Bracket 0
Week 9 Spring 1
Week 8 Base 1
Week 7 Clamp 2
Week 6 Housing 2
Week 5 Handle 3
Week 4 Casting 3
Week 3 Bearing 3
Week 2 Shaft 3
Week 1
14.9 Your boss at Scott Sampson Products, Inc., has just provided you with the schedule and lead times for the bracket in Problem 14.8. The unit is to be prepared in week 10. The lead times for the components are bracket (1 week), base (1 week), spring (1 week), clamp (1 week), housing (2 weeks), handle (1 week), casting (3 weeks), bearing (1 week), and shaft (1 week). a) Prepare the time-phased product structure for the bracket. b) In what week do you need to start the castings? PX
Casting needs to be started in week 7.
Time Phased Product Structure
Week 10 Week 9 Week 8 Week 7 Week 6 Week 5 Week 4 Week 3 Week 2 Week 1
Spring Handle
Bracket Clamp
Base Casting
Housing
Bearing
shaft

Bracket

Springs(2)

Clamps(4)

Handle(1)

Base(1)

Clamp(1)

Housings(2)

Casting(1)

Handle(1)

Casting(1)

Bearings(2)

Shaft(1)

Bracket

Springs(2)

Clamps(4)

Handle(1)

Base(1)

Clamp(1)

Housings(2)

Casting(1)

Handle(1)

Casting(1)

Bearings(2)

Shaft(1)

Bracket

Springs(2)

Clamps(4)

Handle(1)

Base(1)

Clamp(1)

Housings(2)

Casting(1)

Handle(1)

Casting(1)

Bearings(2)

Shaft(1)

Bracket

Springs(2)

Clamps(4)

Handle(1)

Base(1)

Clamp(1)

Housings(2)

Casting(1)

Handle(1)

Casting(1)

Bearings(2)

Shaft(1)

Bracket

Springs(2)

Clamps(4)

Handle(1)

Base(1)

Clamp(1)

Housings(2)

Casting(1)

Handle(1)

Casting(1)

Bearings(2)

Shaft(1)

Bracket

Springs(2)

Clamps(4)

Handle(1)

Base(1)

Clamp(1)

Housings(2)

Casting(1)

Handle(1)

Casting(1)

Bearings(2)

Shaft(1)

Bracket

Springs(2)

Clamps(4)

Handle(1)

Base(1)

Clamp(1)

Housings(2)

Casting(1)

Handle(1)

Casting(1)

Bearings(2)

Shaft(1)

Bracket

Springs(2)

Clamps(4)

Handle(1)

Base(1)

Clamp(1)

Housings(2)

Casting(1)

Handle(1)

Casting(1)

Bearings(2)

Shaft(1)

Bracket

Springs(2)

Clamps(4)

Handle(1)

Base(1)

Clamp(1)

Housings(2)

Casting(1)

Handle(1)

Casting(1)

Bearings(2)

Shaft(1)

Bracket

Springs(2)

Clamps(4)

Handle(1)

Base(1)

Clamp(1)

Housings(2)

Casting(1)

Handle(1)

Casting(1)

Bearings(2)

Shaft(1)