Week 6 Inventory and Cost of Sales Assignment Assignment and calculations must be done and submitted via Blackboard using Excel no later than Monday June 20th 8:30a.m. There are three (3) questions in total. PLEASE COMPLETE EACH QUESTION IN THE SAME EXCEL FILE USING 3 DIFFERENT TABS ALONG THE BOTTOM. ONE FOR EACH QUESTION. Question #1 - Tab #1 Records for the month indicate the following information regarding 48 oz cans of orange juice juice in inventory at the NC Restaurant. Calculate the opening inventory value as well as the value for each delivery, and the total actual price $ value paid for the juice purchased. (Fill in the shaded portions) $ Value Opening Inventory for the first of the month 9 Cans $10.15 Purchase on the 7th of the Month 20 Cans $10.45 Purchase on the 15th of the Month Purchase on the 26th of the Month 30 Cans $10.50 10 Cans $ 10.15 Total Actual Price Paid $