Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Is this correct? I need help. Thanks! #6 CURRENT LIABILITIES - INVOICES Below you will find a copy of invoices received this week. Each vendor

Is this correct? I need help. Thanks! image text in transcribed
image text in transcribed
#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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting For Managers Interpreting Accounting Information For Decision Making

Authors: Paul M. Collier, Sandy M. Kizan, Eckhard Schumann

1st Canadian Edition

1118037960, 9781118037966

More Books

Students also viewed these Accounting questions