NAME: Complete the following questions and tum into the assignment folder on D2L. As part of this assignment you will be working with the Inventory Management Exeel Workshop Template. You will need to create the necessary formulas for the required calculations inside the template. Place your answer in the form below before submitting to assignment folder. 1. Suppose Jones Corporation in the above problem determined that its annual inventory carrying cost =18%. The item unit cost and average inventory is shown the table below. Determine the inventory carrying cost for each item, and the total annual inventory carrying cost. (you can cut and past into Excel to solve) Carryingcost=IUCi 2. Using the data for Jones Company in Problem 2, suppose Jones believes that in the upcoming year, the rate of sales expected for each of the 5 items is as follows: ltem 1=4,000 units per day Item 2=2,000 units per day ltem 3=15,000 units per day liem 4=7,000 units per day liem 5=2,000 units per day