1 Based on the data provided below, create a perpetual inventory card Use formulas to calculate Balance, Cost per Tin (when there is a price change), and Total Value Use ROUND function where appropriate Use $ sign and round to 2 decimal places where appropriate Product: Plain Yogurt - Pack Size: 24 x 100g per case. Assuming the opening inventory for Aug 1st is 100 each, at cost of $0.71 each. Supplier Invoices indicated the following: Aug 10 2 cases @ $17.25/case Aug 14 3 cases @ $17.40/case Aug 18 2 cases @ $17.75/case Aug 27 4 cases @ $17.90/case Requisitions for store room supplies indicated: 30 each. 22 each 56 each 70 each 34 each 26 each 45 each Aug 5 Aug 7 Aug 12 Aug 15 Aug 22 Aug 25 Aug 30