can do the answers on excel

1 2/2 points Part 1: A company sells 850 of its product per month. Its cost per product is $4 with a carrying cost of 65 percent of the product cost. It costs $105 to place an order. Currently the order size is 1,500. What is the current annual total cost for inventory? (round to 2 decimals) 2,664 2 2/2 points Part 2: A company sells 850 of its product per month. Its cost per product is $4 with a carrying cost of 65 percent of the product cost. It costs $105 to place an order. Currently the order size is 1,500. a What is the annual total cost for inventory using the EOQ? (round to 2 decimals) 2,359.92 3 2/2 points How much does the company save by using the EOQ? (use the raw values from Part 1 and Part 2 then round the final answer to 2 decimals, enter a positive number) 304.08 2/2 points A company sells 850 of its product per month. Its cost per product is 54 with a carrying cost of 65 percent of the product cost. It costs $105 to place an order. Currently the order size is 1,500. If the supplier offers a 20 percent discount for order in multiples of 100. what order quantity should be used? 800 5 2/2 points If we use an order quantity in multiples of 100, what is the annual total cost for inventory at the new optimal order quantity (round to 2 decimals) 2.111