70.2K

Verified Solution

Link Copied!

how do i plug this information into the excel sheet below?

#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 Groceries - $12.47 Paper Goods-S11.99 $24.46 11/7/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 Groceries - $13:36 Cleaning - $54.85 $68.21 11/9/14 Sunbeam SB-1 Bread- $8.38 $ 8.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 Bre: d Paper Cleaning Misc. Other S2,485.56 $2.4680 5980.15 $62615 5778.62 5826,62 $289.65 222.00 Purchases Beginning $900 S640 5201 572 $65 $430 $170 $73 Inventory $725 Ending Inventory $698 $161 S50 584 $376 $115 567 D E B J.J. Doster Caf H J K M F G SPREAD SHEET REPORT NO: WEEK ENDING: Student Name: Vendor Invoice Date Involce No. Name Meat Grocery Produce Dalry Bread Paper Cleaning Misc. $900.00 Invoice Total $0.001 $0.00: $0.00! $0.00 $0.00 $0.00: $0.00! $0.00 $0.00 $0.00 $0.00: $0.001 $0.00: 1 $0.00l $0.00 $0.00! $0.00 $0.00 $0.00 $0.00 11111 $0.00 $0.00 111 $0.00 1111 $0.00 $0.00 $0,00 $0.00 $0.00 111 $0.00.1111 $0.00 1111 $0 001111 $0.00 $0.00 Dairy Bread Paper Cleaning Miso TOTAL EXPENSE $0.00 Total Supply Exp: $0.00 | 11 $0.00 $0.00 $0.00 $0.00 Other Purchases Total Purchases: Beginning Inventory: Ending Inventory Expenses $0.00 $0.00 $0.00 Meat Grocery Produce Total Food Expense

Answer & Explanation Solved by verified expert

See Answer