with formulas used please

4. Each week, Sue takes a full bar inventory as part of her job as a bartender at Lamont's Bar & Grill. Part of that inventory involves counting the well liquors the bar offers for sale. Sue counts the inventory including cases, bottles, and tenths of a bottle held in the well. Complete the inventory valuation form that Sue will submit for the week ending January 15". LAMONT'S BAR AND GRILL: BEVERAGE INVENTORY Weekly Beverage Inventory: Well Liquors Week Ending: 1-15 Storage Area Well Purchase Bar Area Liquor Liquor Total Cost Purchase Cost Inventory Value Item unit (bottles) Storeroom Storeroom Inventory per Case Units per per (bottle) (cases) (bottles) (bottles) Case Purchase Unit Bourbon 750 ml 4.5 2 6 $61.50 12 Gin 750 ml 12 3.1 3 3 $58.25 Rum 750 ml 12 6.2 1 8 $48.70 12 $63.55 Scotch 750 ml 10 5.5 2 12 $45.65 750 ml 4 Vodka 5.1 2 Total Value