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 Item Y Item B 1 unit Item C 3 units Item D 3 units Item E 2 units Item D 6 ... 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
-
What are different types of loyalty programs that might enhance the customer relationship for the company keurig green mountain and when they should be delivered during the customer cycle? I NEED...
-
Microkernel operating systems aim to address perceived modularity and reliability issues in traditional "monolithic" operating systems. (i) Describe the typical architecture of a microkernel...
-
Basic Motor Corporation uses target costing. Assume that Basic marketing personnel estimate that the competitive selling price for the QuikCar in the upcoming model year will need to be $ 2 3 , 2 0 0...
-
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...
-
Luo Ltd. establishes a 90 million liability at the end of 2019 for the estimated litigation settlement for manufacturing defects. All related costs will be paid and deducted on the tax return in...
-
1. The number of miles n a marathon runner has completed in terms of the time t in hours 2. The depth of the tide d at a beach in terms of the time t over a 24-hour period determine whether the...
-
Sprague Company manufactures basketballs. Materials are added at the begin- ning of the production process and conversion costs are incurred uniformly. Production and cost data for the month of July...
-
The net income reported on the income statement for the current year was $165,300. Depreciation recorded on equipment and a building amounted to $46,700 for the year. Balances of the current asset...
-
In this individual assignment, you will participate in an investment game project (please ensure you have registered). Create a portfolio comprising of individual securities (you are allowed to trade...
-
You are working on a free-form Packet Tracer challenge activity as seen in Figure 1, you have been given the London Railways network.' The purpose of this EMA question is to build upon each of the...
-
QUESTION 1 The trial balance of Abad Baru Sdn Bhd (ABSB) as at 31 December 2020 is listed as follows: Other information: 1) Inventories as at 31 December 2020 was RM15,000. 2) ...
-
A company's old machine has a book value of $47,000 and a remaining three-year useful life. The old machine could be sold now for $25,900, and the company could buy a new machine for $68,500. The old...
-
Tasty Meat Inc. uses ABC costing to allocate the manufacturing overhead costs incurred by producing tasty pork ribs. The following activities related to yearly manufacturing overhead costs, and cost...
-
Describe and discuss, with examples, why the board of directors is considered the conscience of the organization. Describe and discuss the basic managerial functions in healthcare organizations....
-
Daniels Arts Sales uses the perpetual inventory system. On September 3 0 , 2 0 2 2 , the companys year - end, a physical count was taken of the inventory on hand, The cost of the inventory on hand...
-
Scenario: Assuming that your organisational target is to met at least 90% of sales target, 85% of service level target, and 80% of your waste reduction target and you have exceeded both the service...
-
1.Saskatoon Oil Drilling (SOD) needs new equipment. The equipment can be purchased at a cost of $6 million. The equipment qualifies for a 30% CCA rate. SOD has a tax rate of 20% and it can borrow at...
-
Why is the national security argument for tariffs questionable?
-
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?
-
Treasury Bonds. After the Global Financial Crisis especially, sovereign and portfolio investors from emerging market economies have purchased significant volumes of European treasury bonds. Discuss...
-
BOP and Inflation. What are the direct and indirect relationships between the balance of payments and inflation?
-
Capital MobilityEurozone. Low interest rates should normally lead to capital outflows to other countries and currencies in the search for higher interest rates. Explain why the opposite has occurred...
Study smarter with the SolutionInn App