I need help figuring this out

#6 CURRENT LIABILITIES - INVOICES Below you will find a copy of invoices received this week. Each vendor has delivered goods and services to your facility and we must now determine how much the cost of goods sold or the cost of doing business this week. Take the information that follows and key it into the Excel Spreadsheet and make sure you are on the Spdsht tab on the excel spreadsheet. DATE VENDOR CATEGORY TOTALS VENDOR INVOICE NUMBER 11/7/14 Sysco 36382 $24.46 Groceries - $12.47 Paper Goods-$11.99 1177/14 Sysco 366102 Groceries - $87 20 $87.20 11/8/14 Tanner Bro 36255 Produce - $30.85 $30.85 11/8/14 Southeastern Meats SE123 Meats - $27.15 $27.15 11/8/14 Dairy Fresh BB 101 Dairy - $14.61 $14.61 11/9/14 Sysco 417335 $68.21 Groceries - $13.36 Cleaning - 554 85 11/9/14 Sunbeam SB-1 Bread- $8.38 $18.38 Make sure to complete the following section as well. You must complete other purchases, beginning inventory and ending inventory to make the Excel spreadsheet calculate correctly. Meat Grocery Produce Dairy Bread Paper Cleaning Misc. Other $2.485.56 $2.461.80 S980.15 $626.15 $278.62 $826,62 $289.65 $222.00 Purchases Beginning $900 $640 S201 572 $65 $430 $170 $73 Inventory $725 S698 $161 S50 584 $376 Ending Inventory SIIS 567