PLEASE USE THE NUMBERS POSTED. DO NOT COPY AND PASTE FROM OTHER CHEGG ANSWERS. I WILL DOWNVOTE AS I HAVE ALREADY LOOKED AND THEY ARE WRONG. THANK YOU SO MUCH. (;

fecently, Phil Harris, the production contral manager at Brunswick, read an article an time.phased requirements planning. He was curious about haw this technique might work in scheduling Brunswick's engine assembly operations and decided to prepare an example va illustrate the use of time-ghased requirements planning. Phis first step was to prepare a master schedule far ane of the engine types produced by Brunswick the Model 1000 engine. This on the next page. Next, Phil decided to simplify his requirements planning example by considering only two of the many components that are needed to complete the assembly of the Model tooo engine. These two companents, the gear box and the input shaft, are shown in the product structure diagram below. Phil noted that the gear bax is assembled by the Subassembly Department and subsequently is sent to the main engine assembly line. The input shaft is one of scveral component parts manulactured by Brunswick the three manufacturing stoges that are irmolved in producing an engine: the Engine Assembly Department, the Subassembly Department, and the Machine Shap. The manufacturing leod times required to produce the gear box and input shaft components are also indicated in the product structure diagram. Nate that two weeks are required to produce a batch of gear bowes and that all the gear bawes must be deliwered to the produce a lot of input shafts, and ail the shafts that are needed far the production of gear bawes in a ghen week must be delivered to the Subassembly Department stockroom before Monday moening of that week. In pecparing the MFe example Phil planned to use the warksheets shown and to make the follawing assumptions: 1. Twenty ffue gear bcues are an hand at the beginning of Week 1 , and seven gear bexes are currently on order to be delivered at the start of Wicek 2. 2. Fifty input shafts are on hand at the start of Week 1 , and 26 are scheduled for delivery at the beginning of Weck 2. a. Initially, assume that Phil wants to minimize his inwentory requirements. Assume that each order will be only for what is required for a single period. Calculate the net requirements and planned order releases for the gear bowes and ingut shafts. Assume that iot sizing is done using lat.forliat (L-4L). (Leave no cells blank - be certain to enter "or wherever required.) Gear Bax Requirements lnput Shaft Requirements Phil would like to censider the costs that his accountants are currently using for irwentery carrying and setup for the gear bawes and input shafts. These costs are as follows: Suppose least total-cost int sizing is to be used. Using the planned order receipts shown below, complate the remainder of the gear box and input shaft tables. (Leave no cells blank - be certain to enter 0 wherever required.) Gear Bax Repuirements lnput Shaft Requirements c. What are the sawngs with the new schedule? Assume inventary is valued at the end of each wreck. Coat af the schedule from part (a) Coat af the schedule using least-total-cost lot sizing. Savings with the new schedule