Business Finance Homework Help

I screen shot the questions and attached the excel sheet.

1 Initially, assume that Phil wants to minimize his in-ventory 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 accountants are currently using for inventory carrying and setup for the gear boxes and input shafts. These costs are as follows:

3Find a better schedule by reducing the number of orders and carrying some inventory. What are the savings with this new schedule?