On the DailyTransactions worksheet, in cell F11, the data in the Trans Sold column is the number of items sold. YO16_XL_BU03_GRADER_PS1_HW Inventory 1 Project Description: The gift shop staff wants to track inventory so it can reduce out-of-stock inventory items and reorder inventory more efficiently. The staff needs a template designed that will hold all the product information and then analyze daily transactions at the end of every month. You have been asked to help the gift shop employees develop a workbook that will help them manage the store's inventory. Because the staff currently does not collect this data, the gift shop manager has given you a template with a small amount of fictitious data so you can create the needed formulas and worksheets. The worksheet also contains named ranges that you will use to create formulas in the template. (Negative Trans_Qty numbers are the quantity that was sold or outgoing. Positive Trans Oty numbers are the total number received from the