Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

AutoSave . Off H 9 ACC 201 Company Accounting Workbook Template (1) - Excel Ramel Talk File Home Insert Page Layout Formulas Data Review View

image text in transcribedimage text in transcribed
AutoSave . Off H 9 ACC 201 Company Accounting Workbook Template (1) - Excel Ramel Talk File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri 11 ~ AA = = E ab Wrap Text General Normal Bad Good Neutral Calculation _ AutoSum AY O Fill Paste [ Copy E =E Merge & Center $ ~ % 2 00 20 Conditional Format as Check Cell Explanatory ... Input Linked Cell Note nsert Delete Format Sort & Find & Format Painter Formatting Table v Clear Filter ~ Select v Clipboard Font Alignment Number Styles Cells Editing GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more R7 X V fax Sales - selling price, $8.50 a box B C D E G H K L M N O P Q R S T U V 1 IN FIFO 3 Purchases Sales Ending Inventory Purchases No. of No. of No. of Date Items Unit Price Total Price Items Unit Price Total Price |Items Unit Price Total Price Date 12/7: 10 boxes purchased at $6 D Cr 7-Dec 10 $ 6.00 $ 60.00 10 $ 6.00 $ 60.00 7-Dec Merchandise Inventory (10 x $6) 60.00 12/20: 20 boxes purchased at $6.10 Cash 60.00 12/30: 25 boxes purchased at $6.05 15-Dec 8 $ 6.00 $ 48.00 2 $ 6.00 $ 12.00 Purchased inventory Sales - selling price, $8.50 a box Co 12/15: 8 boxes 20-Dec 20 $ 6.10 $ 122.00 2 $ 6.00 $ 12.00 15-Dec Cash (8 x $8.50) 68.00 12/24: 18 boxes 20 $ 6.10 $ 122.00 Merchandise Sales Revenue 68.00 22 $ 134.00 ale of inventory 24-Dec 2 $ 6.00 $ 12.00 15-Dec Cost of Goods Sold (8 X $6) 48.00 16 $ 6.10 $ 97.60 4 $ 6.10 $ 24.40 Merchandise Inventory 48.00 18 $ 109.60 Recorded the cost of goods sold 30-Dec 25 $ 6.05 $ 151.25 4 $ 6.10 $ 24.40 20-Dec Merchandise Inventory (20 x $6.10 ) 122.00 25 $ 6.05 $ 151.25 Cash 122.00 29 $ 175.65 Net Inventor 55 $ 333.25 26 $ 157.60 29 $ 175.65 24-Dec Cash (18 x 8.50) 153.00 Merchandise Sales Revenue 153.00 Record sale of inventory INNNNB 24-Dec Cost of Goods Sold (2 x $6)+(16 x $6.10) 109.60 Merchandise Inventory 109.60 Recorded the cost of goods sold 30-Dec Merchandise Inventory (25 x $6.05) 151.25 Cash 151.25 OneDrive Screenshot saved The screenshot was added to your T-Accounts - autofill Inventory Valuation Trial Balance Adjusting Entries Income Statement Statement of Stockholder Equity Balance Sheet ... + OneDrive. Ready Type here to search O X ? 5:23 AM 66'F AQ198 ~ 9 A (4 4)) 7/5/2021AutoSave . Off H 9 ACC 201 Company Accounting Workbook Template (1) - Excel Ramel T att File Home Insert Page Layout Formulas Data Review View Help Share Comments & Cut Calibri 11 ~ A" A ab Wrap Text Date 40% - Accent2 40% - Accent3 40% - Accent4 40% - Accent5 40% - Accent6 LIX _ AutoSum O Paste [ Copy Fill BIULA E = = E Merge & Center $ ~ % 9 00 20 Conditional Format as |60% - Accent1 60% - Accent2 |60% - Accent3 60% - Accent4 60% - Accent5 nsert Delete Format Sort & Find & Format Painter Formatting Table Clear Filter ~ Select v Clipboard Font Alignment Number Styles Cells Editing GET GENUINE OFFICE Your license isn't genuine, and you may be a victim of software counterfeiting. Avoid interruption and keep your files safe with genuine Office today. Get genuine Office Learn more A6 X V 12/31/2020 C D E F G H K L M N P Q R S T U V W X Z A Company Adjusting Journal Entries W I 20XX Date Accounts Debit Credit 31-Dec Depreciation Expense Accumulated Depreciation P OneDrive Screenshot saved The screenshot was added to your T-Accounts - autofill Inventory Valuation Trial Balance Adjusting Entries Income Statement Statement of Stockholder Equity Balance Sheet ... + : OneDrive. Ready Type here to search O O X 5:23 AM 66'F AQ198 ~ 91 9 (4 4)) 7/5/2021

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

Managerial Accounting

Authors: Carl Warren

14th Edition

1337516147, 978-1337270595

More Books

Students also viewed these Accounting questions

Question

understand possible effects of lifestyle risk factors;

Answered: 1 week ago

Question

2. Information that comes most readily to mind (availability).

Answered: 1 week ago