Question: Using MS Excel, build a Material Requirements Planning (MRP) record based on the following Master Production Schedule and Inventory Records File. MPS: Master Production Schedule

Using MS Excel, build a Material Requirements Planning (MRP) record based on the following Master Production Schedule and Inventory Records File.

MPS: Master Production Schedule

Finished Product: Rocking Chair

Date

April 5

April 12

April 19

April 26

May 3

May 10

Required Demand

75

75

75

100

100

125

Inventory Records File (IRF)

Scheduled Receipts

SR

200 on April 12

Initial Stock Balance (Beginning Inventory)

BI

100

Lead Time

LT

2 weeks

Safety Stock

SS

10

Lot Size Discipline

Qd

LFL

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:

Please use the diagram and help me create a excel file. I am unsure how to do this, please use simple steps. Show calculations. Using MS Excel, build a Material Requirements Planning ( MRP ) record...

Q:

Using MS Excel, build a Material Requirements Planning ( MRP ) record based on the following Master Production Schedule and Inventory Records File. MPS: Master Production Schedule Finished Product:...

Q:

Using MS Excel, build a Material Requirements Planning (MRP) record based on the following Master Production Schedule and Inventory Records File. MPS: Master Production Schedule Finished Product:...

Q:

Using MS Excel, build a Material Requirements Planning (MRP) record based on the following Master Production Schedule and Inventory Records File. Master Production Schedule (MPS) Finished Product:...

Q:

Hello! Can someone help me double check my work, im unsure if I did the assignment correctly. Would like some feedback/guidance. Thanks in advance! Using MS Excel, build a Material Requirements...

Q:

build a Material Requirements Planning (MRP) record based on the following Master Production Schedule and Inventory Records File. MPS: Master Production Schedule Finished Product: Rocking Chair Date...

Q:

provide a summary hat Is Material Requirements Planning ( MRP ) ? Material requirements planning ( MRP ) is a software - based integrated inventory and supply management system designed for...

Q:

1. Gross requirements of an item are generated by the Planned Order Releases from the level above in the BOM. Answer: True Explanation: Gross requirements are the total requirements for an item,...

Q:

X CW211.pdf - Adobe Acrobat Reader DC File Edit View Window Help Home Tools CW2-170393.pdf CW2-170393 (002)... CW211.pdf X ? Sign In 4 / 6 o 82.1% 2 do Share Search 'Rotate Page Po Export PDF 11 13...

Q:

Hello dear, Please may you answer this question Note I need all steps and when u take the pictures I hope it will be very clear write down the solution on the computer write down an analysis and a...

Q:

Explain how the allocation process can make a fixed cost appear variable, leading to a poor decision.

Q:

The price of jewel, passing through three hands, rises on the whole by 65%. If the first and the second sellers earned 20% and 25% profit respectively, find the profit percent earned by the third...

Q:

How do differences in accounting standards across countries affect financial reporting for multinational corporations? Answer areaDifferences in accounting standards have no impact on financial...

Q:

The poster, which was designed to promote the 'Climate Betterment Fund' fundraising charity campaign, will place significant emphasis on the crucial nature of climate change issues and the various...