Answered: Fgre 1414 INIENTORY PART ONHAND PART…

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...

See similar textbooks

Related questions

Question

Your stockroom manager, Mehmet Altag, arrived
at your desk just a fter you had completed the net requirements
plan for product A ( You are product pla nner for product A (in Problem A part structure, lead time (weeks), and on-hand quantities for product A are shown in Figure 14. 14. From the
information shown, generate:
a) An indented bill of material fo r product A
b) Net requirements for each part to produce I0 As in week 8 using lot-for-lot. IP).) The field service manager, Mark Moon, has just called and told you that the requirements for B and F
should each be increased by I 0 units for his repair requi rements in the field.
a) Prepare a list showing the quantity of each part required to produce the requirements for the service manager and the production request of I0 Bs and Fs. b) Prepare a net requirement plan by date for the new requirements (for both production and field service), assuming that the field service manager wants his 10 units of B and F in week 6 and the 10 production units of A in week 8. ),
exclaiming that the cycle counter should be fired. It seems that the cycle counter was wrong; there are 3 As available now, not 0, as the original data showed; moreover, 5 Es are also available.
About then, your boss, Joe Orlicky, who overheard the discussion, says, "You might as well extend the net requirements plan out to 16 weeks because we just received an order for I 0 more As in week 12 and 5 more in week 15. Additionally, count on the field service
department wanting 3 more Bs in week 16, as well as those I0 units of B and F in week 6. And item G now has a lead time of4 weeks."
Your assignment is to prepare a new net requirements plan, based
on the actual inventory (as reported) and the new schedule.