Product Tree Structure Circuit Board A LT=B Resistor B (3) LT=2 I/O Sub C (5) LT=1 T-former DC LT=2 Screw E (4 LT=2 Bolt F (2) LT=1 On Hand Scheduled Receipts Lot Size Item Circuit Board A MPS 100 period 6; 320 period 7; 270 period 8; 100 period 9; 500 period 10; 600 period 11; 200 period 12 Resistor B I/O Sub C T-former D Screw E Bolt F 510 0 14 T 0 2010 125 0 100 0 10 17 40 25 100 Judy figured out her MRP for the given information last meeting. However, since attending the materials management meeting with the production control people, she realizes that there may be capacity problems. Two items are manufactured in-house (the Circuit Board A and the I/O Sub C) the rest of the MRP parts are purchased. She has been given this information regarding capacity: Period Item/Actual Capacity Item/Actual Capacity Circuit Board A 300 300 200 200 200 400 Item/Actual Period Capacity I/O Sub C 1000 1000 1000 2000 2000 2000 Item/Actual Capacity Circuit Board A 400 400 400 I/O Sub C 2000 2000 2000 2000 2000 2000 400 400 400 Maps Judy also was asked to provide a breakdown of capital and inventory costs for Finance and Accounting. She knows the company incurs around $0.50 per unit in inventory costs for any purchased item. From the purchasing department she has collected the following information regarding the capital costs per purchased item (manufactured items are not accounted for in these capital costs so they cab be omitted in the analysis). Item Resistor B T-former D Screw E Bolt F Capital Cost per Unit $5.25 $18.95 $0.03 $0.05 Judy knows from past experience, that she cannot let orders go unfilled or make customers wait. However, she can subcontract work out and/or expedite purchase orders. Her costs for subcontracting run around 2.5 times the net price of the manufactured item. The net price for the Circuit Board A is $156.50/unit and the net price for the I/O Sub is $13.55/unit. Expediting any order consists of a fixed fee and a variable fee based on the parts underlying capital cost. The fixed fee is $300 per expedited item and the variable fee is approximately three times the original capital cost (e.g., to expedite Resistor B, Judy would pay a $300 fixed fee plus $15.75 per Resistor B expedited). Help Judy manage her capacity and reply to all the other departments' requests. Please supply a 1-page executive summary of your findings and recommendations. Please see writing guidelines if you have questions on how to construct an executive summary. Product Tree Structure Circuit Board A LT=B Resistor B (3) LT=2 I/O Sub C (5) LT=1 T-former DC LT=2 Screw E (4 LT=2 Bolt F (2) LT=1 On Hand Scheduled Receipts Lot Size Item Circuit Board A MPS 100 period 6; 320 period 7; 270 period 8; 100 period 9; 500 period 10; 600 period 11; 200 period 12 Resistor B I/O Sub C T-former D Screw E Bolt F 510 0 14 T 0 2010 125 0 100 0 10 17 40 25 100 Judy figured out her MRP for the given information last meeting. However, since attending the materials management meeting with the production control people, she realizes that there may be capacity problems. Two items are manufactured in-house (the Circuit Board A and the I/O Sub C) the rest of the MRP parts are purchased. She has been given this information regarding capacity: Period Item/Actual Capacity Item/Actual Capacity Circuit Board A 300 300 200 200 200 400 Item/Actual Period Capacity I/O Sub C 1000 1000 1000 2000 2000 2000 Item/Actual Capacity Circuit Board A 400 400 400 I/O Sub C 2000 2000 2000 2000 2000 2000 400 400 400 Maps Judy also was asked to provide a breakdown of capital and inventory costs for Finance and Accounting. She knows the company incurs around $0.50 per unit in inventory costs for any purchased item. From the purchasing department she has collected the following information regarding the capital costs per purchased item (manufactured items are not accounted for in these capital costs so they cab be omitted in the analysis). Item Resistor B T-former D Screw E Bolt F Capital Cost per Unit $5.25 $18.95 $0.03 $0.05 Judy knows from past experience, that she cannot let orders go unfilled or make customers wait. However, she can subcontract work out and/or expedite purchase orders. Her costs for subcontracting run around 2.5 times the net price of the manufactured item. The net price for the Circuit Board A is $156.50/unit and the net price for the I/O Sub is $13.55/unit. Expediting any order consists of a fixed fee and a variable fee based on the parts underlying capital cost. The fixed fee is $300 per expedited item and the variable fee is approximately three times the original capital cost (e.g., to expedite Resistor B, Judy would pay a $300 fixed fee plus $15.75 per Resistor B expedited). Help Judy manage her capacity and reply to all the other departments' requests. Please supply a 1-page executive summary of your findings and recommendations. Please see writing guidelines if you have questions on how to construct an executive summary