answer all questions using excel and excel functions

PROBLEM \#1 (Prepare an Excel spreadsheet to solve the problem) Estimated demand for gold-filled lockets at Sam's Bargain Jewelry and Housewares is 16,000 lockets a year. Manager Veronica Winters has indicated that ordering cost per order is $50 and the holding cost per unit is $2.50. Setup an Excel file and perform the following tasks. a) Find the best order quantity and the lowest possible total inventory cost and show them in a graph. The graph should show the holding costs, ordering costs, and the total costs. b) What is the average inventory on hand throughout the year? c) How many orders will be made every year? (Assume that the company is open 300 days a year) d) If the lead time is 7 days, what will be the reorder point