Will give thumbs up for good work

Problem 2 (27.5 points). The Music company produces bass guitars in Caguas, PR. The production levels are set up to match predicted demand as closely possible. One of the instruments produced is the part number 500 bass guitar. The figure below shows the part number 500 bass guitar and its subassemblies and components. The information of the product structure is represented in the indented bill of materials table. The first step in the assembly process is that the bridges are installed into the body, and the pegs are installed into the neck. Then, the body and the neck are assembled together. Finally, the strings are installed to get the final assembly. To procure the bridges from suppliers takes 1 week of lead time and 2 weeks lead time is required to complete the body. There are 5 bodies on hand. The delivery lead time of the strings is 2 weeks. The production manager wants to protect its strings inventory because of low performance supplier and decided to maintain a safety stock of 20 units each week. The neck requires 2 weeks to produce and the pegs have a lead time of 5 weeks Bridges Strings Pegs Part am MANUFACTURING BILL OF MATERIAL PART NUMBER 500 - BASS GUITAR Description Quantity UOM Number Required 200 Body 1 each 205 Bridge 2 each 300 String 4 each 400 Neck 1 each 405 Peg 4 each CD Neck Body It takes 7 weeks to produce a bass guitar. Hence, the company must begin production now on bass guitars to be shipped in 7 weeks. For that reason, we will consider only forecasts for demands that are at least 7 weeks into the future. Suppose that predicted demands (gross requirements) for those weeks are: Week Demand 8 90 9 30 10 25 11 10 12 15 These forecasts represent the number of bass guitars that the company would like to have ready to ship in the specified week. Based on the current anticipated returns, the company expects the following scheduled receipts to the inventory Week Scheduled Receipts 8 13 9 10 10 17 11 10 addition, the company expects to have 23 bass guitars in inventory at the end of the week 7. The MPS for the bass guitars is now obtained by netting out the inventory on hand at the end of week 7 and scheduled receipts, in order to obtain net predicted demand a. (45 points). Construct a full product tree for part number 500, showing part number description, quantity required and lead time information using BOM data. b. (8 points). Complete the MRP record for part number 500 following a lot-for-lot rule. C. (15 points). Complete the MRP record for part number 300 following a lot-for-lot rule. Assumption: bass guitars can be shipped as soon as all components are available