The master schedules for product P and Q along with the Bills of Material and part information are shown below: Given this information, answer the next 3 questions: MPS Period 1 2 3 4 5 6

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
The master schedules for product P and Q along with the Bills of Material and part information are shown
below: Given this information, answer the next 3 questions:
MPS
Period
Product P
Product Q
Part
A
B
C
D
1
0
0
a.
b.
2
50
10
Lead Lot On
time Sizing Hand
1 L4L
50
2
L4L
1
L4L
2
L4L 650
Part Information
3
75
100
50
400
C. 800
d. 200
4
100
200
Scheduled
Receipts
50 in pd 2
10 in Pd 2
0
0
5
125
50
11. The second planned order release for Part A is:
100 in Pd. 1
150 in Pd. 3
c.
10 in Pd. 2
d. 200 in Pd. 3
12. The gross requirements for Part C in Pd. 3 are:
a. 500
b. 300
c. 900
d. 450
C (2)
13. The planned order release for Part D in Pd. 1 is:
a. 0
b. 600
6
75
25
A (2)
P
D (1)
B (1)
D (1)
C (1)
B (1)
Q
D (2)
D (2)
Transcribed Image Text:The master schedules for product P and Q along with the Bills of Material and part information are shown below: Given this information, answer the next 3 questions: MPS Period Product P Product Q Part A B C D 1 0 0 a. b. 2 50 10 Lead Lot On time Sizing Hand 1 L4L 50 2 L4L 1 L4L 2 L4L 650 Part Information 3 75 100 50 400 C. 800 d. 200 4 100 200 Scheduled Receipts 50 in pd 2 10 in Pd 2 0 0 5 125 50 11. The second planned order release for Part A is: 100 in Pd. 1 150 in Pd. 3 c. 10 in Pd. 2 d. 200 in Pd. 3 12. The gross requirements for Part C in Pd. 3 are: a. 500 b. 300 c. 900 d. 450 C (2) 13. The planned order release for Part D in Pd. 1 is: a. 0 b. 600 6 75 25 A (2) P D (1) B (1) D (1) C (1) B (1) Q D (2) D (2)
Acme Inc. sells a widget with demand of 50 a day. Acme reviews its orders every 15 days and maintains a
safety stock level of 200. The lead-time A is 3 days and today there are 227 units in stock. Please answer the
next 2 questions:
14. The target inventory level for item A is:
a. 1500
b. 1150
c. 1250
d. 1700
15. If an order for A is placed today, the order quantity should be:
a. 923
b. 789
c. 1240
d. 800
16. At a Super America convenience store, customers enter the facility at the average rate of 15 customers
per hour. There is a single attendant who takes an average of 4 minutes to process a customer. If we
assume that every customer must be processed, the average number of customers in the store is:
1.0
1.5
c.
5
d. .833
a.
b.
Transcribed Image Text:Acme Inc. sells a widget with demand of 50 a day. Acme reviews its orders every 15 days and maintains a safety stock level of 200. The lead-time A is 3 days and today there are 227 units in stock. Please answer the next 2 questions: 14. The target inventory level for item A is: a. 1500 b. 1150 c. 1250 d. 1700 15. If an order for A is placed today, the order quantity should be: a. 923 b. 789 c. 1240 d. 800 16. At a Super America convenience store, customers enter the facility at the average rate of 15 customers per hour. There is a single attendant who takes an average of 4 minutes to process a customer. If we assume that every customer must be processed, the average number of customers in the store is: 1.0 1.5 c. 5 d. .833 a. b.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 5 steps with 8 images

Blurred answer
Similar questions
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.