and calculations must be done and submitted via Blackboard in Excel PLEASE COMPLETE EACH EXERCISE ON THE SAME FILE BUT A DIFFERENT TAB (5 Tabs total) Inventory Tab Valuing Physical Inventory Opening inventory on the first of the month: 9 cans @ $ 10.20 Purchased on the 7th of the month: 20 cans at $ 10.35 Purchased on the 15th of the month: 30 cans at $ 10.35 Purchased on the 26th of the month: 10 cans at $ 10.20 Total Value of Purchases Add value of opening inventory Value of total number of units available Inventory