Suppose your company assembles a product named P. Three units of PARTI and two units of PART2 are needed to assemble one unit of P. One unit of PARTI is made up of two units of SUBPARTI and one unit of SUBPART2. The assembling times for P and PARTI are two weeks and one week, respectively. The company buys other parts from different suppliers. The lead times for ordering PART2, SUBPARTI, and SUBPART2 are two weeks, one week and two weeks, respectively. The company currently has 20 units of P, 100 units of PART1, 50 units of PART2, 200 units of SUBPARTI and zero units of SUBPART2. LOG203 Copyright © 2023 Singapore University of Social Sciences (SUSS) Proctored Online Exam-July Semester 2023 Part Name Table 3: Scheduled Receipts Amount Week 50 5 PARTI 40 3 PART2 100 4 SUBPARTI 100 5 50 2 SUBPART2 100 6 PARTI can only be purchased in batches of 100 units. Question 4a Prepare a Bill of Materials (BOM) for the product P. Page 5 of 6 Question 4b Apply the Material Requirements Planning (MRP) approach to schedule orders for different parts and the timing of those orders if 80 units and 100 units of P are to be delivered in week 8 and week 10 from now, respectively. In your answer, you should use the Material Requirement Planning Word Worksheet or Excel sheet provided during the seminar. Remember to include the relevant information in the worksheet/Excel sheet. Question 4c If the supplier of PARTI is unable to supply the parts, would the company be able to satisfy both orders?
Suppose your company assembles a product named P. Three units of PARTI and two units of PART2 are needed to assemble one unit of P. One unit of PARTI is made up of two units of SUBPARTI and one unit of SUBPART2. The assembling times for P and PARTI are two weeks and one week, respectively. The company buys other parts from different suppliers. The lead times for ordering PART2, SUBPARTI, and SUBPART2 are two weeks, one week and two weeks, respectively. The company currently has 20 units of P, 100 units of PART1, 50 units of PART2, 200 units of SUBPARTI and zero units of SUBPART2. LOG203 Copyright © 2023 Singapore University of Social Sciences (SUSS) Proctored Online Exam-July Semester 2023 Part Name Table 3: Scheduled Receipts Amount Week 50 5 PARTI 40 3 PART2 100 4 SUBPARTI 100 5 50 2 SUBPART2 100 6 PARTI can only be purchased in batches of 100 units. Question 4a Prepare a Bill of Materials (BOM) for the product P. Page 5 of 6 Question 4b Apply the Material Requirements Planning (MRP) approach to schedule orders for different parts and the timing of those orders if 80 units and 100 units of P are to be delivered in week 8 and week 10 from now, respectively. In your answer, you should use the Material Requirement Planning Word Worksheet or Excel sheet provided during the seminar. Remember to include the relevant information in the worksheet/Excel sheet. Question 4c If the supplier of PARTI is unable to supply the parts, would the company be able to satisfy both orders?
Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter20: Inventory Management: Economic Order Quantity, Jit, And The Theory Of Constraints
Section: Chapter Questions
Problem 14E: Hales Company produces a product that requires two processes. In the first process, a subassembly is...
Related questions
Question
Please provide the answers in excel with explanation
Transcribed Image Text:Suppose your company assembles a product named P. Three units of PARTI and two
units of PART2 are needed to assemble one unit of P. One unit of PARTI is made up
of two units of SUBPARTI and one unit of SUBPART2. The assembling times for P
and PARTI are two weeks and one week, respectively.
The company buys other parts from different suppliers. The lead times for ordering
PART2, SUBPARTI, and SUBPART2 are two weeks, one week and two weeks,
respectively.
The company currently has 20 units of P, 100 units of PART1, 50 units of PART2, 200
units of SUBPARTI and zero units of SUBPART2.
LOG203 Copyright © 2023 Singapore University of Social Sciences (SUSS)
Proctored Online Exam-July Semester 2023
Part Name
Table 3: Scheduled Receipts
Amount
Week
50
5
PARTI
40
3
PART2
100
4
SUBPARTI
100
5
50
2
SUBPART2
100
6
PARTI can only be purchased in batches of 100 units.
Question 4a
Prepare a Bill of Materials (BOM) for the product P.
Page 5 of 6
Question 4b
Apply the Material Requirements Planning (MRP) approach to schedule orders for
different parts and the timing of those orders if 80 units and 100 units of P are to be
delivered in week 8 and week 10 from now, respectively. In your answer, you should
use the Material Requirement Planning Word Worksheet or Excel sheet provided
during the seminar. Remember to include the relevant information in the
worksheet/Excel sheet.
Question 4c
If the supplier of PARTI is unable to supply the parts, would the company be able to
satisfy both orders?
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning