Planning and Scheduling Assignment 1. Read ABC Manufacturing Company (pp. 160-161) in the textbook 2. Answer question 14, parts a and b. (Please note: there is a typo in the textbook on page 160. Question 14.b.3 refers to Product B when it should refer to Product Y). 3. Copy the spreadsheet, complete the cells highlighted in yellow, answer the question at the end of the sheet and submit via Dropbox.

Question

The MPC system at ABC Manufacturing Company is run weekly to update the master produc-tion schedule (MPS) and MRP records. At the start of week 1, the MPS for end products X and Y is below

One unit of component C is required to manufacture one unit of either end product X or Y. Pur-chasing lead time for component C is two weeks, an order quantity of 40 units is used, and no (zero) safety stock is maintained for this item. Inventory balance for component C is 5 units at the start of week 1, and there's an open order (scheduled receipt) for 40 units due to be delivered at the beginning of week 1. a. Complete the MRP record for component C as it would appear at the beginning of week 1:

During week 1, the following transactions occurred for component C: 1. The open order for 40 units due to be received at the start ofweek 1was received on Monday ofweek 1 with a quantity of30 (10 units of component were scrapped on this order). 2. An inventory cycle count during week 1 revealed that five units of component C were missing. Thus, an inventory adjustment of -5 was processed. 3. Ten units of component C were actually disbursed (instead of the 15 units planned for disbursement to produce end products X and Y). (The MPS quantity of 5 in week 1 for product B was canceled as a result of a customer order cancellation.) 4. The MPS quantities for week 7 include 15 units for product X and 0 units for product Y. 5. Because of a change in customer order requirements, marketing has requested that the MPS quantity of 25 units for product X scheduled in week 3 be moved to week 2. 6. An order for 40 units was released. Given this information, complete the MRP record for component C as it would appear at the beginning of week 2:

What action(s) are required by the inventory planner at the start of week 2 as a result of the transactions occurring during week 1?

Minimize image

I understand the Product X , Product Y , Component C and how it transfers to Gross requirements, basically beyond that I am super lost on how these other numbers will be generated given the information in the book, I'm really not sure what information is going to belong in which slot

5 XSCM 20004 Planning and Scheduling Dropbox 2Jan29_2021 (3) [Protected View] - Excel Sign in 0 x File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do & Share 0 PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you need to edit it's safer to stay in Protected View. Enable Editing X G40 X fac G H J K L M N 0 A 4 5 Week Number 6 6 Product X 7 Product Y | | D C D E F Master Production Schedule 12 3 4 10 25 5 5 30 20 6 5 10 20 8 9 Component 10 Week 4 2 3 5 6 11 12 13 14 Gross requirements 15 Scheduled receipts 16 Projected available balance 17 Planned order releases 18 19 20 21 22 23 Gross requirements 24 Scheduled receipts 25 Projected available balance 26 Planned order releases 27 Week 2 3 4 5 6 7 28 Sheet1 + + 100% % o Type here to search 1 W -- 1:08 PM 3/10/2021 LU