3. Item Y is made up of (1) unit of Item B, (3) units of Item...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
3. Item Y is made up of (1) unit of Item B, (3) units of Item C, and (2) units of Item D. Item C is made up of (3) units of Item D and (2) units of Item E. Inventory information for all items are as follows: • Item Y: 0 on hand, Order sizing is Lot-for-lot,lead time is 1 period. ● ● Item B: 30 units on hand. Order sizing is Lot-for-Lot. Lead time = 1 period. Item C: 0 on hand presently, expecting receipt of (20) units in Period 1. Order sizing is Lot- for-Lot. Lead time = 1 period. Item D: 10 units on hand. Expecting receipt of (300) units in Period 1. Order sizing - must buy in quantities of (300) units. Lead time = 2 periods. Item E: 20 units on hand. Expecting receipt of (200) units in Period 1. Order sizing - must buy in qtys of 100 units. Lead time = 2 periods. The gross requirements for Item Y are (40) in Period 4, (50) in Period 6, and (60) in Period 8. A. Create the Product Tree for Item Y. (14 pts) B. Create the "MRP" - planned releases table for all items. Best created in Excel - submit your Excel file. (60 pts) - 3. Item Y is made up of (1) unit of Item B, (3) units of Item C, and (2) units of Item D. Item C is made up of (3) units of Item D and (2) units of Item E. Inventory information for all items are as follows: • Item Y: 0 on hand, Order sizing is Lot-for-lot,lead time is 1 period. ● ● Item B: 30 units on hand. Order sizing is Lot-for-Lot. Lead time = 1 period. Item C: 0 on hand presently, expecting receipt of (20) units in Period 1. Order sizing is Lot- for-Lot. Lead time = 1 period. Item D: 10 units on hand. Expecting receipt of (300) units in Period 1. Order sizing - must buy in quantities of (300) units. Lead time = 2 periods. Item E: 20 units on hand. Expecting receipt of (200) units in Period 1. Order sizing - must buy in qtys of 100 units. Lead time = 2 periods. The gross requirements for Item Y are (40) in Period 4, (50) in Period 6, and (60) in Period 8. A. Create the Product Tree for Item Y. (14 pts) B. Create the "MRP" - planned releases table for all items. Best created in Excel - submit your Excel file. (60 pts) -
Expert Answer:
Answer rating: 100% (QA)
A Product Tree for Item Y The product tree for Item Y can be created as follows Item Y 1 unit B C D ... View the full answer
Related Book For
Auditing and Assurance services an integrated approach
ISBN: 978-0132575959
14th Edition
Authors: Alvin a. arens, Randal j. elder, Mark s. Beasley
Posted Date:
Students also viewed these accounting questions
-
Microkernel operating systems aim to address perceived modularity and reliability issues in traditional "monolithic" operating systems. (i) Describe the typical architecture of a microkernel...
-
Please complete the Web case that covers material discussed in this chapter at www.cengage.com/accounting/Gibson. Youll be using Thomson ONE Business School Edition, a powerful tool that combines a...
-
Taxable income and pretax financial income would be identical for Jiang Group except for its treatments of gross profit on installment sales and estimated costs of warranties. The following income...
-
On January 1, 2014, Alphabet Company leased an office building to Numbers, Inc. The relevant information related to the lease is as follows. 1. The lease arrangement is for 16 years. 2. The leased...
-
Suppose $N$ experimental units are randomly assigned to treatment or control by tossing a coin. A unit is assigned to treatment if the coin toss comes up heads. Assume that the probability of tossing...
-
The employees of Black Cat Designs are paid on a semimonthly basis. Compute the FICA taxes for the employees for the November 30, 2015, payroll. All employees have been employed for the entire...
-
PATA PLC acquired 7 5 % of the equity interest in POTEA PLC at 1 January 2 0 1 9 for KShs . 5 0 million. The Statement of Financial Position as at 3 1 March 2 0 2 0 were as follows: PATA PLC POTEA...
-
Yolanda has the option of investing in two different mutual funds. The return in the random walk fund tends to fluctuate wildly, earning substantial positive returns one year only to realize negative...
-
If the sum of the first 7 terms of an A.P. is 119 and that of the first 17 terms is 714, find the sum of its first n terms.
-
How might Jen's email be misinterpreted by her instructor? Select all that apply. Review the Email Thursday, July 25, 2020 3:15 PM I just saw my total points in Grades. I should be getting an A, but...
-
The cost of inventory is made up of Select one: a. cost of purchase, allocated direct labour, and allocated overhead. b. cost of purchase and allocated direct labour only. c. cost of allocated direct...
-
Should Dubinski recommend a large repurchase, financed in part by a debt issue, to the board? The case does not propose a specific repurchase, so develop your own proposal and defend it. In...
-
2.2 How will the advancements in Artificial Intelligence shape the future of work and daily life, and what factors should be considered to ensure these developments have a positive impact? (15) 2.1...
-
A traditional income statement would separate product costs (COGS) and period costs (administration, selling, marketing, etc.). Can these costs also be classified as either variable or fixed? If so,...
-
Steve is a newborn. His parents are planning to contribute $6,000 a year (or possibly less) towards his college fund into an account that will grow at a constant rate of 5% a year. Both parents work...
-
Graph one period of each function. y = 4 cos x
-
Explain the relationship between substantive tests of transactions for the acquisition and payment cycle and tests of details of balances for the verification of prepaid insurance.
-
The Internet has dramatically increased global e-commerce activities. Both traditional "brick and mortar" businesses and new dot-com businesses use the Internet to meet business objectives. For...
-
What is the primary purpose of analyzing interest expense? Given this purpose, what primary considerations should the auditor keep in mind when doing the analysis?
-
The direct result of the process of transcription is the synthesis of a. DNA. b. RNA. c. a polypeptide. d. all of the above.
-
Using what you learned in this chapter of Dessler Human Resource Management, build on the companys new system by recommending two more specific career development activities the hotel should...
-
Many hotel jobs are inherently dead end; for example, maids, laundry workers, and valets, either have no great aspirations to move up, or are just using these jobs temporarily, for instance, to help...
Study smarter with the SolutionInn App