Workshop 4 Ch 9&10 Template

Problem 1 3 points Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblie Item Description Usage X Bracket assembly 1 A Wall board 4 demand (x) 130 B Hanger subassembly 2 D Hanger casting 3 E Ceramic knob 2 C Rivet head screw 3 F Metal tong 4 G Plastic cap 1 Below is a table indicating current inventory levels: Item X A B C D E Inventory 25 16 65 30 180 160 a. Using Excel, create the BOM using the information provided: 105 404 145 255 130 b. What are the net requirements of each items in the MPS. Item X A B C D E Inventory 105 404 145 285 255 130 X A (#) B (#) D (#) E (#)

es (X) is 130 units. The following is the BOM in indented form: F G 1,000 100 285 140 185 F G 140 185 C (#) F (#) G (#) NOTE : move the boxes around to create your BOM then use the "Insert Line" function to create the angled lines to connect the boxes in the appropriate sequence.

anned order receipts, 5 75 45 75 0 0 0 0 45 75 45 75 75 0 4 5

Problem 3 3 points Assume that Product Z is made of three units of A and four units of B. A is made of three un Lead times for purchase or fabrication of each unit to final assembly are: Z takes two weeks; Fifty units are required in Period 10 (Assume that there is currently no inventory on hand of a a) Show the bill of materials (product structure tree). 1 week 1 week 3 weeks b) Develop an MRP planning schedule showing gross and net requirements and order releas Period: Item: Z Gross requirements Onhand: 0 Scheduled receipts LT: 2 Projected available balance SS: Net requirements Q: L4L Planned order receipts Planned order releases Item: A Gross requirements Onhand: Scheduled receipts LT: Projected available balance SS: Net requirements Q: L4L Planned order receipts Planned order releases 1 2 3 4 Z A (3) B (4) C (3) D (4) E (2)

nits of C and four of D. D is made of two units of E. ; A, B, C, and D take one week each; and E takes three weeks. any of these items.) 50 A gr = 150 B gr = 200 C gr = 450 D gr = 600 E gr = 1200 se and order receipt dates. 50 50 50 150 150 150 5 6 7 8 9 10 NOTE : move the boxes around to create your MRP then use the "Insert Line" function to create the angled lines to connect the boxes in the appropriate sequence.

200 200 200 450 450 450 600 600 600 1200 1200

t a Pareto analysis of the data and determine the percentage of total complaints his chart isn't available in your version of Excel. diting this shape or saving this workbook into a different file format will rmanently break the chart.

Problem 5 3 points Sample n p P-bar UCL LCL 1 20 5 0.25 0.080 0.261989 0.0000 2 20 2 0.10 0.080 0.261989 0.0000 3 20 0 0.00 0.080 0.261989 0.0000 4 20 1 0.05 0.080 0.261989 0.0000 5 20 0 0.00 0.080 0.261989 0.0000 6 20 2 0.10 0.080 0.261989 0.0000 7 20 0 0.00 0.080 0.261989 0.0000 8 20 5 0.25 0.080 0.261989 0.0000 9 20 1 0.05 0.080 0.261989 0.0000 10 20 0 0.00 0.080 0.261989 0.0000 total 200 16 p bar 0.080 stDev P-bar 0.060663 UCL 0.261989 LCL 0 b) Based on the plotted data points, what comments can you make? The process is in statist proportion defective abo Ten samples of 20 parts each were taken from an ongoing process to establish a p chart for cont Number of Defective Items in Sample a) Develop a p chart for 95% confidence (1.96 standard deviations). 1 2 3 4 5 6 7 8 9 10 0.00 0.05 0.10 0.15 0.20 0.25 0.30 0.25 0.10 0.00 0.05 0.00 0.10 0.00 0.25 0.05 0.00 Chart Title p P-bar UCL LCL