A company is manufacturing product X. To produce one unit of product X, the company has to purchase one unit of component A & two units of component B. Show the MRP using the

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
icon
Related questions
Question

A company is manufacturing product X. To produce one unit of product X, the company has to purchase one unit of component A & two units of component B. Show the MRP using the following information:
Weeks                                     1        2             3    4    5    6
Demand for  Product X       20   30     87     99      100     570

                                      Product x                                                  Component A      Component B
Production run time            1 week                  Lead time                  1 week         2 week
Min Production Quantity    50 units    Min Purchase Quantity          60 units         60 units
Inventory on Hand             90 units    Inventory on Hand                 200 units   150 units
Safety Stock                                         Safety Stock                         20 units    
Scheduled Receipts                             Scheduled Receipts        20 units in week 1

Answer all the following questions:
1- A company is manufacturing product X. To produce one unit of product X, the company has to
purchase one unit of component A & two units of component B. Show the MRP using the
following information
Weeks
1
3
5
6.
Demand for
20
30
87
99
100
570
product X
Product X
Component
Component
A
B
Production
1 week
Lead Time
1 week
2 weeks
Run Time
Min
50 units
Min
60 units
60 units
Production
Purchase
Quantity
Quantity
Inventory
90 units
Inventory
on Hand
200 units
150 units
on Hand
Safety Stock
Safety
20 units
Stock
Scheduled
Scheduled
20 units in
Receipts
Receipts
week 1
2.
Transcribed Image Text:Answer all the following questions: 1- A company is manufacturing product X. To produce one unit of product X, the company has to purchase one unit of component A & two units of component B. Show the MRP using the following information Weeks 1 3 5 6. Demand for 20 30 87 99 100 570 product X Product X Component Component A B Production 1 week Lead Time 1 week 2 weeks Run Time Min 50 units Min 60 units 60 units Production Purchase Quantity Quantity Inventory 90 units Inventory on Hand 200 units 150 units on Hand Safety Stock Safety 20 units Stock Scheduled Scheduled 20 units in Receipts Receipts week 1 2.
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Production and Operations Analysis, Seventh Editi…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.