Question: According to the data provided solve the table beneath it MATL No. BEGIN INV. QTY PER LEADTIME PERIODS LOT SIZE SAFETY STOCK QTY SCHED RECTS

According to the data provided solve the tableAccording to the data provided solve the table beneath it

MATL

No.

BEGIN

INV.

QTY PER

LEADTIME

PERIODS

LOT SIZE

SAFETY STOCK

QTY

SCHED RECTS

1000

MOWER

50

1

2

Lot for Lot

300 period 1

275 period 2

200 period 3

200 period 4

1001

WHEELS

400

4

2

Mult =500

1200 period 4

1200 period 5

1002

BLADE

0

1

2

POQ=3 Periods

none

1003

ENGINE ASSY

20

1

1

Mult =6

300 period 1

1004

CATCHER

40

1

2

Mult=20

300 period 1

1005

CABLE ASSY

30

1

2

Mult=100

200 period 5

1006

CHASIS ASSY

12

1

1

Mult =4

120 period 2

1007

MUFFLER

12

1

1

Mult=12

132 period 2

1008

PISTON ASSY

10

1

1

Lot for Lot

200 period 2

1009

SPARK PLUG

288

1

2

Mult=144

432 period 2

1010

CRANK ASSY

3

1

2

Mult =2

108 period 1

1011

CARBURETOR

51

1

2

Mult=36

360 period 3

360 period 4

1012

MOWER BODY

307

1

2

POQ=4 Periods

1013

HANDLE ASSY

0

1

1

Mult=50

304 period2

1014

PISTON BODY

30

1

3

Mult=200

400 period 1

1015

RING SET

107

1

4

Mult=300

300 period 1

1016

WRIST PIN

211

1

4

Mult=1000

1000 period 2

1017

CRANKSHAFT

102

1

4

Mult=48

336 period 3

288 period 4

1018

CONNECT ROD

110

1

5

Mult=100

300 period 1

300 period 3

1019

STEEL, C.R.

2.5

5

MULT OF 500

1500 period 2

1020

STEEL TUBE

10

0.25

6

MULT OF 4

80 period 3

80 period 4

80 period 5

80 period 6

According to the data provided solve the table

According to the data provided solve the table

According to the data provided solve the table

According to the data provided solve the table

According to the data provided solve the table

According to the data provided solve the tableAccording to the data provided solve the table

1000 Lawn Mower (Production Plan shown in Gross Requirements line) 6 7 co 8 9 10 250 325 300 275 300 250 PERIOD 1 2 3 4 5 PART: 1000 LT= QTY PER=1 LS: LTL GROSS REQTS 250 300 350 300 SCHED. REC'TS 300 275 200 200 ENDING INV. 50 100 125 25 0 0 NET REQTS 125 300 PLD REC'TS 125 300 PLD ORDER REL 125 300 325 Post to: 1001 x 4, 1002 x 1, 1003 x 1, 1004 x 1, 1005 x 1, 1006 x 1 0 0 325 325 0 300 300 275 0 275 275 300 300 300 250 250 300 250 1001 Wheels 1 2 3 4 5 6 7 8 9 10 500 1200 1200 1100 1200 1000 PERIOD PART: 1001 LT=2 QTY PER= 4 Lot Size: mult= 500 GROSS REQTS SCHED. REC'TS ENDING INV. 400 NET REQ'TS PLD REC'TS PLD ORDER REL Post to: Nothing 1200 100 0 0 300 300 1300 1200 100 0 0 1000 400 400 200 0 100 800 500 1000 1000 0 0 Exception Message 300 1200 300 700 1000 1000 1000 1000 0 1500 1500 1002 Blade 1 2 3 4 5 6 7 8 9 10 125 300 325 300 275 300 250 PERIOD PART: 1002 LT= 2 QTY PER=1 Lot Size: POQ=3 GROSS REQTS SCHED. REC'TS ENDING INV. O NET REQTS PLD REC'TS PLD ORDER REL Post to: Nothing 0 0 0 0 0 625 125 750 325 300 575 300 875 300 275 250 250 750 875 250 1000 Lawn Mower (Production Plan shown in Gross Requirements line) 6 7 co 8 9 10 250 325 300 275 300 250 PERIOD 1 2 3 4 5 PART: 1000 LT= QTY PER=1 LS: LTL GROSS REQTS 250 300 350 300 SCHED. REC'TS 300 275 200 200 ENDING INV. 50 100 125 25 0 0 NET REQTS 125 300 PLD REC'TS 125 300 PLD ORDER REL 125 300 325 Post to: 1001 x 4, 1002 x 1, 1003 x 1, 1004 x 1, 1005 x 1, 1006 x 1 0 0 325 325 0 300 300 275 0 275 275 300 300 300 250 250 300 250 1001 Wheels 1 2 3 4 5 6 7 8 9 10 500 1200 1200 1100 1200 1000 PERIOD PART: 1001 LT=2 QTY PER= 4 Lot Size: mult= 500 GROSS REQTS SCHED. REC'TS ENDING INV. 400 NET REQ'TS PLD REC'TS PLD ORDER REL Post to: Nothing 1200 100 0 0 300 300 1300 1200 100 0 0 1000 400 400 200 0 100 800 500 1000 1000 0 0 Exception Message 300 1200 300 700 1000 1000 1000 1000 0 1500 1500 1002 Blade 1 2 3 4 5 6 7 8 9 10 125 300 325 300 275 300 250 PERIOD PART: 1002 LT= 2 QTY PER=1 Lot Size: POQ=3 GROSS REQTS SCHED. REC'TS ENDING INV. O NET REQTS PLD REC'TS PLD ORDER REL Post to: Nothing 0 0 0 0 0 625 125 750 325 300 575 300 875 300 275 250 250 750 875 250 1003 Engine 5 6 7 8 9 10 325 300 275 300 250 PERIOD 1 2 3 4 PART: 1003 LT= 1 QTY PER=1 Lot Size: Mult= 6 GROSS REQ'TS 125 300 SCHED. REC'TS ENDING INV. 20 320 320 195 1 NET REQ'TS 106 PLD REC'TS 100 PLD ORDER REL 106 326 Post to: 1007 x 1, 1008 x 1, 1009 x 1, 1010 x 1, 1011 x 1 300 7 7 255 4 300 300 286 5 281 286 300 1 299 300 272 272 1004 Grass Catcher 1 2 3 4 5 6 7 8 9 10 125 300 325 300 275 300 250 PERIOD PART:1004 LT=2 QTY PER=1 Lot Size: Mult=20 GROSS REQTS SCHED. REC'TS ENDING INV.40 NET REQ'TS PLD REC'TS PLD ORDER REL 5 300 340 340 215 15 85 100 300 10 310 320 280 10 290 300 300 15 265 280 240 15 285 300 5 235 240 100 320 Post to: Nothing 1005 Cable Assembly 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1005 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post to: Nothing 1006 Chassis Assy 1 2 2 3 3 4 5 6 6 7 8 9 10 PERIOD PART:1006 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post to: 1012 x 1, 1013 x 1 1007 Muffler 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1007 LT= QTY PER= Lot Size; GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post to: Nothing 1008 Piston Assy 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1008 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post to:1014 x 1, 1015 x 1, 1016x1 8 1009 Spark Plug 1 2 3 4 5 6 In 7 8 9 10 PERIOD PART:1009 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post to: Nothing 1010 Crank Assembly 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1010 LT= QTY PER= Lot Size: GROSS REQTS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post to: 1017 x 1, 1018 x 1 1011 Carburetor 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1011 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQTS PLD REC'TS PLD ORDER REL Post to: Nothing 1012 Mower Body | 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1012 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post to: 1019 x 2.5 1013 Handle Assembly 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1013 LT= QTY PER= Lot Size: GROSS REQTS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post to: 1020 x 0.25 1014 Piston Body 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1014 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post To: Nothing 8 1015 Ring Set 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1015 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post To: Nothing 1016 Wrist Pin 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1016 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post To: Nothing 1017 Crankshaft 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1017 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post To: Nothing 1018 Connecting Rod | 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1018 LT= QTY PER= Lot Size: GROSS REQTS SCHED. REC'TS ENDING INV. NET REQTS PLD REC'TS PLD ORDER REL Post To: Nothing 1019 Steel, Cold Rolled, 0.125" 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1019 LTE QTY PER= Lot Size: GROSS REQTS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post To: Nothing 1020 Steel Tube, x" OD x 24' LG 1 2 3 4. 5 6 7 8 9 10 PERIOD PART:1020 LT= QTY PER= Lot Size: GROSS REQTS SCHED. REC'TS ENDING INV NET REQTS PLD REC'TS PLD ORDER REL Post To: Nothing 10 1000 Lawn Mower (Production Plan shown in Gross Requirements line) 6 7 co 8 9 10 250 325 300 275 300 250 PERIOD 1 2 3 4 5 PART: 1000 LT= QTY PER=1 LS: LTL GROSS REQTS 250 300 350 300 SCHED. REC'TS 300 275 200 200 ENDING INV. 50 100 125 25 0 0 NET REQTS 125 300 PLD REC'TS 125 300 PLD ORDER REL 125 300 325 Post to: 1001 x 4, 1002 x 1, 1003 x 1, 1004 x 1, 1005 x 1, 1006 x 1 0 0 325 325 0 300 300 275 0 275 275 300 300 300 250 250 300 250 1001 Wheels 1 2 3 4 5 6 7 8 9 10 500 1200 1200 1100 1200 1000 PERIOD PART: 1001 LT=2 QTY PER= 4 Lot Size: mult= 500 GROSS REQTS SCHED. REC'TS ENDING INV. 400 NET REQ'TS PLD REC'TS PLD ORDER REL Post to: Nothing 1200 100 0 0 300 300 1300 1200 100 0 0 1000 400 400 200 0 100 800 500 1000 1000 0 0 Exception Message 300 1200 300 700 1000 1000 1000 1000 0 1500 1500 1002 Blade 1 2 3 4 5 6 7 8 9 10 125 300 325 300 275 300 250 PERIOD PART: 1002 LT= 2 QTY PER=1 Lot Size: POQ=3 GROSS REQTS SCHED. REC'TS ENDING INV. O NET REQTS PLD REC'TS PLD ORDER REL Post to: Nothing 0 0 0 0 0 625 125 750 325 300 575 300 875 300 275 250 250 750 875 250 1000 Lawn Mower (Production Plan shown in Gross Requirements line) 6 7 co 8 9 10 250 325 300 275 300 250 PERIOD 1 2 3 4 5 PART: 1000 LT= QTY PER=1 LS: LTL GROSS REQTS 250 300 350 300 SCHED. REC'TS 300 275 200 200 ENDING INV. 50 100 125 25 0 0 NET REQTS 125 300 PLD REC'TS 125 300 PLD ORDER REL 125 300 325 Post to: 1001 x 4, 1002 x 1, 1003 x 1, 1004 x 1, 1005 x 1, 1006 x 1 0 0 325 325 0 300 300 275 0 275 275 300 300 300 250 250 300 250 1001 Wheels 1 2 3 4 5 6 7 8 9 10 500 1200 1200 1100 1200 1000 PERIOD PART: 1001 LT=2 QTY PER= 4 Lot Size: mult= 500 GROSS REQTS SCHED. REC'TS ENDING INV. 400 NET REQ'TS PLD REC'TS PLD ORDER REL Post to: Nothing 1200 100 0 0 300 300 1300 1200 100 0 0 1000 400 400 200 0 100 800 500 1000 1000 0 0 Exception Message 300 1200 300 700 1000 1000 1000 1000 0 1500 1500 1002 Blade 1 2 3 4 5 6 7 8 9 10 125 300 325 300 275 300 250 PERIOD PART: 1002 LT= 2 QTY PER=1 Lot Size: POQ=3 GROSS REQTS SCHED. REC'TS ENDING INV. O NET REQTS PLD REC'TS PLD ORDER REL Post to: Nothing 0 0 0 0 0 625 125 750 325 300 575 300 875 300 275 250 250 750 875 250 1003 Engine 5 6 7 8 9 10 325 300 275 300 250 PERIOD 1 2 3 4 PART: 1003 LT= 1 QTY PER=1 Lot Size: Mult= 6 GROSS REQ'TS 125 300 SCHED. REC'TS ENDING INV. 20 320 320 195 1 NET REQ'TS 106 PLD REC'TS 100 PLD ORDER REL 106 326 Post to: 1007 x 1, 1008 x 1, 1009 x 1, 1010 x 1, 1011 x 1 300 7 7 255 4 300 300 286 5 281 286 300 1 299 300 272 272 1004 Grass Catcher 1 2 3 4 5 6 7 8 9 10 125 300 325 300 275 300 250 PERIOD PART:1004 LT=2 QTY PER=1 Lot Size: Mult=20 GROSS REQTS SCHED. REC'TS ENDING INV.40 NET REQ'TS PLD REC'TS PLD ORDER REL 5 300 340 340 215 15 85 100 300 10 310 320 280 10 290 300 300 15 265 280 240 15 285 300 5 235 240 100 320 Post to: Nothing 1005 Cable Assembly 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1005 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post to: Nothing 1006 Chassis Assy 1 2 2 3 3 4 5 6 6 7 8 9 10 PERIOD PART:1006 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post to: 1012 x 1, 1013 x 1 1007 Muffler 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1007 LT= QTY PER= Lot Size; GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post to: Nothing 1008 Piston Assy 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1008 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post to:1014 x 1, 1015 x 1, 1016x1 8 1009 Spark Plug 1 2 3 4 5 6 In 7 8 9 10 PERIOD PART:1009 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post to: Nothing 1010 Crank Assembly 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1010 LT= QTY PER= Lot Size: GROSS REQTS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post to: 1017 x 1, 1018 x 1 1011 Carburetor 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1011 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQTS PLD REC'TS PLD ORDER REL Post to: Nothing 1012 Mower Body | 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1012 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post to: 1019 x 2.5 1013 Handle Assembly 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1013 LT= QTY PER= Lot Size: GROSS REQTS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post to: 1020 x 0.25 1014 Piston Body 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1014 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post To: Nothing 8 1015 Ring Set 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1015 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post To: Nothing 1016 Wrist Pin 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1016 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post To: Nothing 1017 Crankshaft 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1017 LT= QTY PER= Lot Size: GROSS REQ'TS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post To: Nothing 1018 Connecting Rod | 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1018 LT= QTY PER= Lot Size: GROSS REQTS SCHED. REC'TS ENDING INV. NET REQTS PLD REC'TS PLD ORDER REL Post To: Nothing 1019 Steel, Cold Rolled, 0.125" 1 2 3 4 5 6 7 8 9 10 PERIOD PART:1019 LTE QTY PER= Lot Size: GROSS REQTS SCHED. REC'TS ENDING INV. NET REQ'TS PLD REC'TS PLD ORDER REL Post To: Nothing 1020 Steel Tube, x" OD x 24' LG 1 2 3 4. 5 6 7 8 9 10 PERIOD PART:1020 LT= QTY PER= Lot Size: GROSS REQTS SCHED. REC'TS ENDING INV NET REQTS PLD REC'TS PLD ORDER REL Post To: Nothing 10

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Q:

INSTRUCTIONS All 3 of the following must be done for each part in the Lawnmower Model A 1. For the product demonstrated in the BOM below and using the information for the BOM items in table 1 below,...

Q:

please fill in the box for 1002 blade INSTRUCTIONS - All 3 of the following must be done for each part in the Lawnmower Model A 1. For the product demonstrated in the BOM below and using the...

Q:

supply chain: lean supply chain: lean now they should easier to see Analyze the value stream map below and answer the following questions: VSM Question H1: What is the total lead-time once the...

Q:

According to the data provided below what would 3 contingencies be for risks involved? Below is my previous work for reference: Business Case Analysis of Behavioral Analysis Services Manpower...

Q:

Exercise 2 SGB company has three plants in Jeddah, Riyadh and Dammam. SGB has four major distribution centers in Quassim, Dhahran, Tabuk and Mekkah. The table hereinafter presents the costs of each...

Q:

1. According to the data provided, despite the Covid-19, outbreak, it seems like Public Bank Berhad Malaysia kept its asset portfolio with no major changes and with growth in the Residential...

Q:

1. Complete the deposit cycles according to the data provided: (30 Points) a) Required Reserves = 2 b) c= .3 (cash flight coefficient c) P (or M) = Loan received from the Federal Reserve $ 1,000,000...

Q:

1. Based on the industry data provided, following the hit of the GFC in 2008, the credit risk for small, medium and large banks in the US has jumped in 2009 comparing to 2008. True or False? 2....

Q:

1. Use the following data to answer the next question: ============================================================================= # Hofstede's Individualism: Denmark: 74; England: 89; Greece: 35;...

Q:

Use the following data to answer the next question: ## Freedom House's 2018 Freedom in the World Rating: Benin=2; Bolivia= 3; Jordan=5; Maldives= 5; Romania= 2; Serbia= 3; Singapore= 4; United Arab...

Q:

A dial is spun and an angle 9 is measured, which can be taken to be uniformly distributed between 0 and 360. If 0

Q:

1. Let R be the region bounded by y=- and the 2x+1 horizontal line y = 3, and let S be the region bounded by the graph x-14x +53x-40 of y= and the horizontal lines y = 1 and y = 3. 2x+1 a. Find the...

Q:

NASA astronauts retrieved a satellite and brought it into the cargo bay of the space shuttle, as shown in Figure E10.7(a). A model of the feedback control system is shown in Figure E10.7(b)....

Q:

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...