Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

please answer within 30 minutes. Question 1 options: MS.51 An office furniture m

ID: 366239 • Letter: P

Question

please answer within 30 minutes.

Question 1 options:

MS.51 An office furniture manufacturer needs to calculate material requirements for one of its most popular office chairs. The graphic above shows the bill of material for this item. Below is the MRP table for the top-level assembly (the chair):

Based on the information in the "Chair" table above, what are the Net Requirementsin the week of 8/15?

What are the Planned Order Releases in the week of 9/5?

What are the Scheduled Receipts in the week of 9/19?

What is the Projected On-Hand Inventory quantity in the week of 9/26?

Chair Final Assembly 8/1 8/8 8/15 8/22 8/29 9/5 9/12 9/19 9/26 Gross Requirements 300 300 400 400 400 400 400 500 300 Scheduled Receipts 120 480 480 Projected On-Hand Inv. 310 Net Requirements Planned Order Receipts Planned Order Releases Lead Time (in weeks) 1 Lot Size 120 Bill of Material for Chair Chair Final Assembly Base Assembly (1 required) (other parts...) Caster (other parts...) (5 required)

Explanation / Answer

the MRP schedule is as follows

week

8/1

8/8

8/15

8/22

8/29

9/5

9/12

9/19

9/26

GR

300

300

400

400

400

400

400

500

300

SR

120

480

480

POH (ending inv)

310

0+310+ 120-300

= 130

240+130 +0-300

= 70

30

110

70

150

110

90

30

NR

0

300-130

= 170

330

290

250

390

210

PORp

0

240

360

360

360

480

240

PORs

240

360

360

360

480

240

NR in week of 8/15 = 330

PORs in the week 9/5 = 360

SR in week 9/19 = 0

POH in week 9/26 = 30

week

8/1

8/8

8/15

8/22

8/29

9/5

9/12

9/19

9/26

GR

300

300

400

400

400

400

400

500

300

SR

120

480

480

POH (ending inv)

310

0+310+ 120-300

= 130

240+130 +0-300

= 70

30

110

70

150

110

90

30

NR

0

300-130

= 170

330

290

250

390

210

PORp

0

240

360

360

360

480

240

PORs

240

360

360

360

480

240