help please I need it to be done in excel
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...
Related questions
Question
help please I need it to be done in excel
Transcribed Image Text:5. a. One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a mate-
rial requirements plan for component C. Take into account that on hand there are 40 units of Z,
70 units of A, 100 units of B, and 30 units of C. Also, there is a scheduled receipt of 20 units of
component C in week 4. Lead times are two weeks for Z and B, and one week for the other com-
ponents. Lot-for-lot ordering will be used for all items.
A(2)
B(4)
C(3)
D(2)
E(2)
C(2)
b. Ninety-five units of end item E are needed at the beginning of week 7. Prepare a material require-
ments plan for component D. Take into account that 5 units of E are currently on hand, as well as
50 units of B, 100 units of C, and 80 units of D. Also, 30 units of C have been outsourced and are
expected to arrive in week 4. Lead times are two weeks for E and C, and one week for the other
components. Assume lot-for-lot ordering except for D, where multiples of 40 must be used.
E
B(3)
C(2)
D(2)
1(2)
S(2)
D(2)
Expert Solution
Introduction
MRP stands for material requirements planning, and it is a system for determining the materials and components required to make a product. It entails three main steps, that is, inventorying existing resources and components, determining which extra ones are required, and arranging their manufacture or acquisition.
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 16 images
Recommended textbooks for you
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
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…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.