excel sheet needs the answers and the formulas

1 Initially, assume that Phil wants to minimize his in-inventory requirements. Assume that each order will be only for what is required for a single period. Using the following forms, calculate the net requirements and planned order releases for the gear boxes and input shafts. Assume that lot sizing is done using lot-for-lot (L4L).2 Phil would like to consider the costs that his accoun-tants are currently using for inventory carrying and setup for the gear boxes and input shafts. These costs are as follows: 

Question 1& 2 Chapter 21

Operations and Supply Chain Management (14th Edition)