50.1K

Verified Solution

Link Copied!

Is this correct? I need help. Thanks!

#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 post of doing business this week. Take the information that follows and key it into the Excel Spreadsheet and make sure you are on the Spdsbt 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 Groceries - $13.36 Cleaning - $54.85 $68.21 11/9/14 Sunbeam SB-1 Bread- $8.38 S8.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. $2.485.56 $2.461.80 $980.15 5626.15 $778.625826.62 $289.65 $222.00 Other Purchases Beginning Inventory $900 5640 $201 $72 $65 5430 $170 573 $725 5698 S161 $50 584 5376 SI15 567 Ending Inventory J.J. Doster Cafe SPREAD SHEET REPORT NO: WEEK ENDING: Meat Grocery Produce Dairy Student Name: Vendor Involce Date Involce No. Name Sysco 1177/14 36382 Sysco 1177/14366102 Tanner Bro 11/8/1436255 Southeaste 8-Nov SE123 Dalry Fresh 11/8/14 BB 101 Sysco 11/9/14 417335 2 Sunbeam 11/9/14 SB-1 3 4 5 6 7 18 $0.00 $0.00 $0.00 $27.15 $0.00 $0.00 $0.00 $12.47 $8720 $0.00 $0.00 $0.00 $13.36 $0.00 $0.00 $0.00 $30.85 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $14.61 $0.00 $0.00 Bread Paper Cleaning Misc. Invoice Total $0.001 $11.99 $0.00 $0.00 $24.461 $0.00: $0.00 $0.00 $0.00 $87 20: $0.00 0 $0.00 $0.00 $30.851 $0.00 $0.00 $0.00 $0.00 $27.15! $0.00! $0.00 $0.00 $0.00 $14.61 $0.00: $0.00 $54.85 $0.00 $68.21: $8.38! $0.00 $0.00 $0.00 $8.38 50.00 $0.00 $0.001 $0.00: $0.00 $0.00: $0.001 $0.00: $0.00! $0.00 $0.00 $0.00 $8.38$11.991 $54.85$0.00 $280.86 $0.00 $0.00 $838! $11.99 $54 85 11$0.00 $260.86 Bread Paper Cleaning Misc TOTAL EXPENSE Total Supply Exp $66.84 $260.86 + 20 21 22 23 24 25 26 27 $27.15 $113.03 $30 85 $14.61 Other Purchases Total Purchases: Beginning Inventory Ending Inventory Expenses 28 $27/15 Meat $113.03 Grocery $30.85 Produce $14.61 Dairy 29 30 Total Food Expense: $194.02

Answer & Explanation Solved by verified expert

See Answer