Question: This is the same information as above. please conduct MRP (Material Requirements Planning) under Lot-size ordering with a lot size of 90 units for frames

This is the same information as above. please conduct MRP (Material Requirements Planning) under Lot-size ordering with a lot size of 90 units for frames and 75 units for wood sections.

Note: Please include excel formulas for thumbs up. Thank you

Each shutter consists of three slatted wood sections and two frames
A firm that produces wood shutters has received two orders: one for 150 shutters (week 5) and one for 180 shutters (week 9)
The wood sections are made by the firm, and fabrication takes 2 weeks
The frames are ordered, and lead time is 1 week
Assembly of the shutters requires 1 week

There is a scheduled receipt of 85 wood sections in (i.e., at the beginning of) week 1.

X K12 Name Box B D E F G H 1 J K L M N O 1 1 2 4 5 6 7 8 9 Week Number Quantity 2 Master Schedule 150 180 3 4 Shutter 150 180 5 6 1 1 Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Quantity = LT = Lot Size = On hand - 7 8 9 150 150 180 180 150 180 10 Frames 300 11 12 2 13 14 15 16 Quantity - LT = Lot Size = On hand = Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases 1 90 17 18 Wood Section 19 20 21 22 23 Quantity = LT = Lot Size = On hand = 4 2 75 Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases 24 Sheet1 + X K12 Name Box B D E F G H 1 J K L M N O 1 1 2 4 5 6 7 8 9 Week Number Quantity 2 Master Schedule 150 180 3 4 Shutter 150 180 5 6 1 1 Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases Quantity = LT = Lot Size = On hand - 7 8 9 150 150 180 180 150 180 10 Frames 300 11 12 2 13 14 15 16 Quantity - LT = Lot Size = On hand = Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases 1 90 17 18 Wood Section 19 20 21 22 23 Quantity = LT = Lot Size = On hand = 4 2 75 Gross requirements Scheduled receipts Projected on hand Net requirements Planned-order receipts Planned-order releases 24 Sheet1 +

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 Finance Questions!

This is the same information as above, please conduct MRP (Material Requirements Planning) under Lot-size ordering with a lot size of 90 units for frames and 75 units for wood sections Note: Please...

Each shutter consists of three slatted wood sections and two frames A firm that produces wood shutters has received two orders: one for 150 shutters (week 5) and one for 180 shutters (week 9) The...

This is the same information as above. please conduct MRP ( Material Requirements Planning ) under Lot - size ordering with a lot size of 4 0 units for frames and 6 5 units for wood sections. And...

This is the same information as above. please conduct MRP (Material Requirements Planning) under Lot-size ordering with a lot size of 40 units for frames and 65 units for wood sections. And insert...

This is the same information as above. please conduct MRP (Material Requirements Planning) under Lot-size ordering with a lot size of 40 units for frames and 65 units for wood sections. And insert you

Consider remote pipes (rpipe) versus remote procedure calls (rpc) - rpc is like procedure call but procedure is handled on remote server Client caller blocks until return - rpipe is like pipe but...

1. a. According to the court, did the defendant seller engage in a fraudulent misrepresentation in failing to disclose the ghostly condition of her house? b. The plaintiff won this case on...

Market value is usually estimated on an after - tax basis because of the varying tax consequence and motivations of market participants. True False Clear selection

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...

=+ a. Rick has gotten a large advance to write a textbook. With the money in hand, he prefers

=+spending his time sailing rather than sitting in his offi ce working on the book.

=+ 3. What are adverse selection and moral hazard?