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:

Go to the Walt Disney Company Web site at www.disney.com. Follow the link at the bottom to Corporate Info and then to Investor Relations. Finally, select Corporate Governance. What information is...

Q:

A small privately held corporation is trying to raise money for a business expansion. The total cost of the expansion is $5,000,000. The expected return on assets before taxes (EBIT) for the business...

Q:

? _ _ _ _ _ _ _ i s N O T c o n s i d e r e d a s t e p i n a c t i v i t y - b a s e d c o s t i n g . S e l e c t a n s w e r f r o m t h e o p t i o n s b e l o w I d e n t i f y i n g a n d c l a...

Q:

Case: Cost System Considerations for CANADA SNOWCONES LTD. Table 1 Canada Snowcones Ltd. - Budgeted MOH Costs Activity Budgeted Cost ($000) Driver Budgeted Activity Level Purchasing S 60,000 Purchase...