L Page 2 of 8 29°F Clear 696 words ☑ WC 30 40 2 3 Week 1 Z Week 2 Z 50 5 6 D. Given the current resources and inventories available, how many Z's could be produced if all resources are utilized for their production? (5 pts.) English (United States) Text Predictions: On Accessibility: Investigate Q Search ☐ O W Focus ENG 100% 10:00 PM 3/23/2024 PRE 716543 2 ..... Page 1 of 8 34°F 696 words Mostly sunny 冠 DX Inventory on Hand: None Routing File: Lot Ꮓ Bill of Materials: Part Size WC Setup (min) Run Time (min/unit) F(2) D(3) Z 100 30 40 D 85 40 25 4.0 2.1 F 75 50 45 3.0 Work Center Master File: Work Center Available Time Ave. Efficiency* 30 40 50 7000 min. 1.10 7000 min. .90 7000 min. 1.05 *Aaverage efficiency is based on processing time only. A. WC Z 30 40 50 Σ Create a Capacity Bill (using lot sizes) for Z in the box provided. 5 pts B. How much nominal capacity (in hours) is required of Work Center 40 to complete an order for 650 Z's. (Consider both set-up and run time) B. The Master Production Schedule (MPS) calls for 400 units in Week 1 and 500 in Week 2 of product Z. Fill in the Workcenter loads (minutes) for the two weeks in the table below. Can you fulfill the MPS? Explain. 5 pts. English (United States) Text Predictions: On Accessibility: Investigate Q Search W Focus ENG 7:44 PM 3/23/2024 100% PRE

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

Solve this please

L
Page 2 of 8
29°F
Clear
696 words
☑
WC
30
40
2
3
Week 1
Z
Week 2
Z
50
5
6
D. Given the current resources and inventories available, how many Z's could be produced if all
resources are utilized for their production? (5 pts.)
English (United States) Text Predictions: On
Accessibility: Investigate
Q Search
☐
O
W
Focus
ENG
100%
10:00 PM
3/23/2024
PRE
Transcribed Image Text:L Page 2 of 8 29°F Clear 696 words ☑ WC 30 40 2 3 Week 1 Z Week 2 Z 50 5 6 D. Given the current resources and inventories available, how many Z's could be produced if all resources are utilized for their production? (5 pts.) English (United States) Text Predictions: On Accessibility: Investigate Q Search ☐ O W Focus ENG 100% 10:00 PM 3/23/2024 PRE
716543 2 .....
Page 1 of 8
34°F
696 words
Mostly sunny
冠
DX
Inventory on Hand: None
Routing File:
Lot
Ꮓ
Bill of Materials:
Part Size WC
Setup (min)
Run Time (min/unit)
F(2)
D(3)
Z
100
30
40
D
85 40
25
4.0
2.1
F
75 50
45
3.0
Work Center Master File:
Work Center
Available Time
Ave. Efficiency*
30
40
50
7000 min.
1.10
7000 min.
.90
7000 min.
1.05
*Aaverage efficiency is based on processing time only.
A.
WC
Z
30
40
50
Σ
Create a Capacity Bill (using lot sizes) for Z in the box provided. 5 pts
B.
How much nominal capacity (in hours) is required of Work Center 40 to complete an order for 650
Z's. (Consider both set-up and run time)
B.
The Master Production Schedule (MPS) calls for 400 units in Week 1 and 500 in Week 2 of
product Z. Fill in the Workcenter loads (minutes) for the two weeks in the table below. Can you
fulfill the MPS? Explain. 5 pts.
English (United States) Text Predictions: On
Accessibility: Investigate
Q Search
W
Focus
ENG
7:44 PM
3/23/2024
100%
PRE
Transcribed Image Text:716543 2 ..... Page 1 of 8 34°F 696 words Mostly sunny 冠 DX Inventory on Hand: None Routing File: Lot Ꮓ Bill of Materials: Part Size WC Setup (min) Run Time (min/unit) F(2) D(3) Z 100 30 40 D 85 40 25 4.0 2.1 F 75 50 45 3.0 Work Center Master File: Work Center Available Time Ave. Efficiency* 30 40 50 7000 min. 1.10 7000 min. .90 7000 min. 1.05 *Aaverage efficiency is based on processing time only. A. WC Z 30 40 50 Σ Create a Capacity Bill (using lot sizes) for Z in the box provided. 5 pts B. How much nominal capacity (in hours) is required of Work Center 40 to complete an order for 650 Z's. (Consider both set-up and run time) B. The Master Production Schedule (MPS) calls for 400 units in Week 1 and 500 in Week 2 of product Z. Fill in the Workcenter loads (minutes) for the two weeks in the table below. Can you fulfill the MPS? Explain. 5 pts. English (United States) Text Predictions: On Accessibility: Investigate Q Search W Focus ENG 7:44 PM 3/23/2024 100% PRE
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 1 steps with 1 images

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