Screenshot- Milestone 1.png ACC 201 Accounting Data Appendix 1.docx Accounting Data Appendix 1. The following events occurred in October: October 1: The business owner used $25,000 from their personal...

1 answer below »
attached file


Screenshot- Milestone 1.png ACC 201 Accounting Data Appendix 1.docx Accounting Data Appendix 1. The following events occurred in October: October 1: The business owner used $25,000 from their personal savings account to buy common stock in their company. October 1: Purchased $8,500 worth of baking supplies from vendor, on account. October 3: The company borrowed $10,000 in cash, in exchange for a two-year, 6% note payable. Interest and the principal are repayable at maturity. October 7: Entered into a lease agreement for bakery space. The agreement is for one year. The rent is $1,500 per month; the last month’s rent payment of $1,500 is required at the time of the lease agreement. The payment was made in cash. Lease period is effective October 1 of this year through September 30 of the next. October 10: Paid $375 to the county for a business license. October 11: Purchased a cash register for $250 (deemed to be not material enough to qualify as depreciable equipment). October 13: The owner has baking equipment, including an oven and mixer, which they have been using for their home-based business and will now start using in the bakery. You estimate that the equipment is currently worth $5,000, and you transfer the equipment into the business in exchange for additional common stock. The equipment has a five-year useful life. October 13: Paid $200 for business cards and flyers to use for advertising. October 14: Paid $300 for office supplies. October 15: Hired a part-time helper to be paid $12 per hour. One pay period is the first of the month through the fifteenth, and the other is the sixteenth through the end of the month. Paydays are the twentieth for the first pay period and the fifth of the following month for the second pay period. (No entry required on this date—for informational purposes only.) October 30: Received telephone bill for October in amount of $75. Payment is due on November 10. October 31: Paid $1,200 for a 12-month insurance policy. Policy effective dates are November 1 through October 31. October 31: Accrued wages earned for employee for period of October 16 through October 31. (See Wage Calculation Data table at the end of this document.) October 31: Total October bakery sales were $15,000 ($5,000 of these sales on accounts receivable). 2. The following events occurred in November: November 5: Paid employee for period ending October 31. November 8: Received payments from customers toward accounts receivable in amount of $3,800. November 10: Paid October telephone bill. November 15: Purchased additional baking supplies in amount of $5,000 from vendor, on account. November 15: Accrued wages earned for employee from period of November 1 through November 15. (See Wage Calculation Data table at the end of this document.) November 15: Paid rent on bakery space. November 18: Received payments from customers toward accounts receivable in amount of $1,000. November 20: Paid $8,500 toward baking supplies vendor payable. November 20: Paid employee for period ending November 15. November 22: Purchased $300 in office supplies. November 30: Received telephone bill for November in amount of $75. Payment is due on December 10. November 30: Accrued wages earned for employee for period of November 16 through November 30. (See Wage Calculation Data table at the end of this document.) November 30: November bakery sales total was $20,000 ($7,500 of this total on accounts receivable). 3. Many customers have been asking for more allergy-friendly products, so in December the bakery started carrying a line of gluten-free products on a trial basis. The information below relates to the purchase and sales of the new products. Use the perpetual inventory method with the FIFO valuation method. Please see the “Inventory Valuation” tab in your workbook for purchase and sales information. The following events occurred in December: December 1: Paid dividends to self in amount of $10,000. December 5: Paid employee for period ending November 30. December 7: Purchased merchandise for resale. See the “Inventory Valuation” tab for details. December 8: Received payments from customers toward accounts receivable in amount of $4,000. December 10: Paid November telephone bill. December 11: Purchased baking supplies in amount of $7,000 from vendor on account. December 13: Paid on supplies vendor account in amount of $5,000. December 15: Accrued employee wages for period of December 1 through December 15. December 15: Paid rent on bakery space $1,500. December 15: Recorded merchandise sales transaction. See the “Inventory Valuation” tab for details. December 15: Recorded impact of sales transaction on COGS and the inventory asset. See the “Inventory Valuation” tab for details. December 20: Paid employee for period ending December 15. December 20: Purchased merchandise inventory for resale to customers. See the “Inventory Valuation” tab for details. December 24: Recorded sales of merchandise to customers. See the “Inventory Valuation” tab for details. December 24: Recorded impact of sales transaction on COGS and the inventory asset. See the “Inventory Valuation” tab for details. December 30: Purchased merchandise inventory for resale to customers. See the “Inventory Valuation” tab for details. December 31: Accrued employee wages for period of December 16 through December 31. December 31: Total December bakery sales were $25,000 ($6,000 of these sales on accounts receivable). 4. On December 31, the following adjustments must be made: · Depreciation of baking equipment transferred to company on October 13. Assume half month of depreciation in October using the straight-line method. Assume no salvage value. · Accrue interest for note payable. Assume a full month of interest for October. (6% annual interest on $10,000 loan) · Record insurance used for the year. · Actual baking supplies on hand as of December 31 are $1,100. · Office supplies on hand as of December 31 are $50. Wage Calculation Data Month Hours Rate Pay 31-Oct 10 12 120 15-Nov 40 12 480 30-Nov 35 12 420 15-Dec 38 12 456 31-Dec 40 12 480 ACC 201 Company Accounting Workbook Template.xlsx Chart of Accounts This chart of accounts should help you identify the appropriate accounts to record to as you are analyzing and journaling transactions for this workbook. There is nothing to complete on this page; this is simply a resource for you. Asset AccountsLiability AccountsEquity Accounts Acct #Acct #Acct # Cash101Notes Payable201Common Stock301 Baking Supplies102Accounts Payable202Dividends302 Prepaid Rent103Wages Payable203Cost of Goods Sold303 Prepaid Insurance104Interest Payable 204 Baking Equipment105 Office Supplies106 Accounts Receivable107 Accumulated Depreciation108 Merchandise Inventory109Revenue Accounts Acct # Bakery Sales401 Merchandise Sales402 Expense Accounts Acct # Baking Supplies Expense501 Rent Expense502 Insurance Expense503 Misc. Expense504 Business License Expense505 Advertising Expense506 Wages Expense507 Telephone Expense508 Interest Expense509 Depreciation Expense510 Office Supplies Expense511 Cash Baking Supplies Prepaid Rent Prepaid Insurance Baking Equipment Office Supplies Accounts Receivable Accumulated Depreciation Merchandise Inventory Notes Payable Accounts Payable Wages Payable Interest Payable Common Stock Dividends Bakery Sales Merchandise Sales Baking Supplies Expense Rent Expense Insurance Expense Misc. Expense Business License Expense Advertising Expense Wages Expense Telephone Expense Interest Expense Depreciation Expense Office Supplies Expense Cost of Goods Sold October Journal Entries A Company General Journal Entries October, 20xx DateAccountsDebitCredit 1-Oct$ $ 1-Oct 3-Oct 7-Oct 10-Oct 11-Oct 13-Oct 13-Oct 14-Oct 30-Oct 31-Oct 31-Oct 31-Oct Total- 0- 0<== do="" the="" debits="" equal="" the="" credits?="" (they="" should)="" november="" journal="" entries="" a="" company="" general="" journal="" entries="" november,="" 20xx="" date="" accounts="" debit="" credit="" total="" -="" 0="" -="" 0=""><== do="" the="" debits="" equal="" the="" credits?="" (they="" should)="" december="" journal="" entries="" a="" company="" general="" journal="" entries="" december,="" 20xx="" date="" accounts="" debit="" credit="" be="" sure="" to="" review="" the="" inventory="" valuation="" tab="" (columns="" m-p)="" for="" all="" inventory="" related="" journal="" entries="" as="" they="" are="" given="" to="" you!="" total="" -="" 0="" -="" 0=""><== do the debits equal the credits? (they should) inventory valuation fifo purchasessalesending inventorypurchases dateno. of itemsunit pricetotal priceno. of itemsunit pricetotal priceno. of itemsunit pricetotal pricedate microsoft: below are the journal entries for each inventory related transaction! all you need to do is copy and paste it into the correct dates on the december journal tab! drcr12/7: 10 boxes purchased at $6 7-dec10$ 6.00$ 60.0010$ 6.00$ 60.007-decmerchandise inventory (10 x $6)60.0012/20: 20 boxes purchased at $6.10 cash60.0012/30: 25 boxes purchased at $6.05 15-dec8$ 6.00$ 48.002$ 6.00$ 12.00purchased inventorysales – selling price, $8.50 a box 12/15: 8 boxes 20-dec20$ 6.10$ 122.002$ 6.00$ 12.0015-deccash (8 x $8.50)68.0012/24: 18 boxes 20$ 6.10$ 122.00 merchandise sales revenue68.00 22$ 134.00record sale of inventory 24-dec2$ 6.00$ 12.0015-deccost of goods sold (8 x $6)48.00 16$ 6.10$ 97.604$ 6.10$ 24.40 merchandise inventory48.00 18$ 109.60recorded the cost of goods sold 30-dec25$ 6.05$ 151.254$ 6.10$ 24.4020-decmerchandise inventory (20 x $6.10 )122.00 25$ 6.05$ 151.25 cash122.00 29$ 175.65 net inventory55$ 333.2526$ 157.6029$ 175.6524-deccash (18 x 8.50)153.00 merchandise sales revenue153.00 record sale of inventory 24-deccost of goods sold (2 x $6)+(16 x $6.10)109.60 merchandise inventory109.60 recorded the cost of goods sold 30-decmerchandise inventory (25 x $6.05)151.25 cash151.25 t-accounts - autofill datecashdatedatenotes payabledatebusiness license expcommon stock 1-oct$$ - 03-oct10-oct$ - 0$1-oct 3-oct$ - 0$ - 013-oct $ - 07-oct$ - 0$ - 0$ - 0$ - 0$ - 0$ - 0 $ - 010-oct$ - 0$ - 0$ - 0 $ - 011-oct $ - 013-oct $ - 014-oct $ - 031-oct 31-oct$ - 0 $ - 05-nov 8-nov$ - 0 $ - 010-nov 18-nov$ - 0 $ - 015-nov $ - 020-novaccounts rec. $ - 020-nov31-oct- 0 $ - 022-nov- 08-nov 30-nov$ - 0- 018-nov $ - 01-dec30-nov- 0 $ - 05-dec- 08-dec $ - 07-dec31-dec- 0 8-dec$ - 0 $ - 010-dec$ - 0$ - 0 $ - 013-dec$ - 0 $ - 015-dec 15-dec$ - 0 $ - 020-dec $ - 020-dec 24-dec$ - 0 $ - 030-dec 31-dec$ - 0 $ - 0$ - 0 $ - 0 misc. expensebaking equipmentadvertising expense 11-oct$ - 013-oct$ - 013-oct$ - 0 $ - 0$ - 0$ do="" the="" debits="" equal="" the="" credits?="" (they="" should)="" inventory="" valuation="" fifo="" purchases="" sales="" ending="" inventory="" purchases="" date="" no.="" of="" items="" unit="" price="" total="" price="" no.="" of="" items="" unit="" price="" total="" price="" no.="" of="" items="" unit="" price="" total="" price="" date="" microsoft:="" below="" are="" the="" journal="" entries="" for="" each="" inventory="" related="" transaction!="" all="" you="" need="" to="" do="" is="" copy="" and="" paste="" it="" into="" the="" correct="" dates="" on="" the="" december="" journal="" tab!="" dr="" cr="" 12/7:="" 10="" boxes="" purchased="" at="" $6="" 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="" 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="" record="" sale="" 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="" inventory="" 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="" 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="" t-accounts="" -="" autofill="" date="" cash="" date="" date="" notes="" payable="" date="" business="" license="" exp="" common="" stock="" 1-oct="" $="" $="" -="" 0="" 3-oct="" 10-oct="" $="" -="" 0="" $="" 1-oct="" 3-oct="" $="" -="" 0="" $="" -="" 0="" 13-oct="" $="" -="" 0="" 7-oct="" $="" -="" 0="" $="" -="" 0="" $="" -="" 0="" $="" -="" 0="" $="" -="" 0="" $="" -="" 0="" $="" -="" 0="" 10-oct="" $="" -="" 0="" $="" -="" 0="" $="" -="" 0="" $="" -="" 0="" 11-oct="" $="" -="" 0="" 13-oct="" $="" -="" 0="" 14-oct="" $="" -="" 0="" 31-oct="" 31-oct="" $="" -="" 0="" $="" -="" 0="" 5-nov="" 8-nov="" $="" -="" 0="" $="" -="" 0="" 10-nov="" 18-nov="" $="" -="" 0="" $="" -="" 0="" 15-nov="" $="" -="" 0="" 20-nov="" accounts="" rec.="" $="" -="" 0="" 20-nov="" 31-oct="" -="" 0="" $="" -="" 0="" 22-nov="" -="" 0="" 8-nov="" 30-nov="" $="" -="" 0="" -="" 0="" 18-nov="" $="" -="" 0="" 1-dec="" 30-nov="" -="" 0="" $="" -="" 0="" 5-dec="" -="" 0="" 8-dec="" $="" -="" 0="" 7-dec="" 31-dec="" -="" 0="" 8-dec="" $="" -="" 0="" $="" -="" 0="" 10-dec="" $="" -="" 0="" $="" -="" 0="" $="" -="" 0="" 13-dec="" $="" -="" 0="" $="" -="" 0="" 15-dec="" 15-dec="" $="" -="" 0="" $="" -="" 0="" 20-dec="" $="" -="" 0="" 20-dec="" 24-dec="" $="" -="" 0="" $="" -="" 0="" 30-dec="" 31-dec="" $="" -="" 0="" $="" -="" 0="" $="" -="" 0="" $="" -="" 0="" misc.="" expense="" baking="" equipment="" advertising="" expense="" 11-oct="" $="" -="" 0="" 13-oct="" $="" -="" 0="" 13-oct="" $="" -="" 0="" $="" -="" 0="" $="" -="" 0="">
Answered Same DayOct 08, 2021

Answer To: Screenshot- Milestone 1.png ACC 201 Accounting Data Appendix 1.docx Accounting Data Appendix 1. The...

Rochak answered on Oct 09 2021
129 Votes
Chart of Accounts
    This chart of accounts should help you identify the appropriate accounts to record to as you are analyzing and journaling transactions for this workbook. There is nothing to complete on this page; this is simply a resource for you.
    Asset Accounts        Liability Accounts        Equity Accounts
        Acct #        Acct #        Acct #
    Cash    101    Notes Payable    201    Common Stock    301
    Baking Supplies    102    Accounts Payable    202    Dividends    302
    Prepaid Rent    103    Wages Payable    203    Cost of Goods Sold    
303
    Prepaid Insurance    104    Interest Payable     204
    Baking Equipment    105
    Office Supplies    106
    Accounts Receivable    107
     Accumulated Depreciation    108
    Merchandise Inventory    109            Revenue Accounts
                        Acct #
                    Bakery Sales    401
                    Merchandise Sales    402
                    Expense Accounts
                        Acct #
                    Baking Supplies Expense    501
                    Rent Expense    502
                    Insurance Expense    503
                    Misc. Expense    504
                    Business License Expense    505
                    Advertising Expense    506
                    Wages Expense    507
                    Telephone Expense    508
                    Interest Expense    509
                    Depreciation Expense    510
                    Office Supplies Expense    511
    Cash
    Baking Supplies
    Prepaid Rent
    Prepaid Insurance
    Baking Equipment
    Office Supplies
    Accounts Receivable
    Accumulated Depreciation
    Merchandise Inventory
    Notes Payable
    Accounts Payable
    Wages Payable
    Interest Payable
    Common Stock
    Dividends
    Bakery Sales
    Merchandise Sales
    Baking Supplies Expense
    Rent Expense
    Insurance Expense
    Misc. Expense
    Business License Expense
    Advertising Expense
    Wages Expense
    Telephone Expense
    Interest Expense
    Depreciation Expense
    Office Supplies Expense
    Cost of Goods Sold
October Journal Entries
        A Company
        General Journal Entries
        October, 20xx
    Date    Accounts    Debit    Credit
    1-Oct    Cash    25,000.00
        Common Stock        25,000.00
    1-Oct    Baking Equipment    8,500.00
        Accounts Payable        8,500.00
    3-Oct    Cash    8,500.00
        Notes Payable        8,500.00
    7-Oct    Prepaid Rent    1,500.00
        Rent Expense    1,500.00
        Cash        3,000.00
    10-Oct    Business License Expense    375.00
        Cash        375.00
    11-Oct    Misc. Expense    250.00
        Cash        250.00
    13-Oct    Baking Equipment    5,000.00
        Common Stock        5,000.00
    13-Oct    Advertising Expense    200.00
        Cash        200.00
    14-Oct    Office Supplies Expense    300.00
                300.00
    30-Oct    Telephone Expense    75.00
        Accounts Payable        75.00
    31-Oct    Prepaid Insurance    1,200.00
        Cash        1,200.00
    31-Oct    Wages Expense    120.00
        Wages Payable        120.00
    31-Oct    Cash    10,000.00
        Accounts Receivable    5,000.00
        Bakery Sales        15,000.00
        Total    67,520.00    67,520.00    <== Do the debits equal the credits? (they should)
November Journal Entries
        A Company
        General Journal Entries
        November, 20xx
    Date    Accounts    Debit    Credit
    5-Nov    Wages Payable    120.00
        Cash        120.00
    8-Nov    Cash    3,800.00
        Accounts Receivable        3,800.00
    10-Nov    Accounts Payable    75.00
        Cash        75.00
    15-Nov    Baking Supplies    5,000.00
        Accounts Payable        5,000.00
    15-Nov    Wages Expense    480.00
        Wages Payable        480.00
    18-Nov    Rent Expense    1,500.00
        Cash        1,500.00
    20-Nov    Cash    1,000.00
        Accounts Receivable        1,000.00
    20-Nov    Baking Supplies    8,500.00
        Cash        8,500.00
    22-Nov    Wages Payable    480.00
        Cash        480.00
    30-Nov    Office Supplies Expense    300.00
        Cash        300.00
    30-Nov    Telephone Expense    75.00
        Accounts Payable        75.00
    30-Nov    Wages Expense    420.00
        Wages Payable        420.00
    30-Nov    Cash    12,500.00
        Accounts Receivable    7,500.00
        Bakery Sales        20,000.00
        Total    41,750.00    41,750.00    <== Do the debits equal the credits? (they should)
December Journal Entries
        A Company
        General Journal Entries
        December, 20xx
    Date    Accounts    Debit    Credit
    1-Dec    Dividends    10,000.00
        Cash        10,000.00
    5-Dec    Wages Payable    420.00
        Cash        420.00
    7-Dec    Merchandise Inventory    60.00            Be sure to review the Inventory Valuation tab (Columns M-P) for all Inventory related journal entries as they are given to you!
        Cash        60.00
    8-Dec    Cash    4,000.00
        Accounts Receivable        4,000.00
    10-Dec    Accounts Payable    75.00
        Cash        75.00
    11-Dec    Baking Supplies    7,000.00
        Accounts Payable        7,000.00
    13-Dec    Accounts Payable    5,000.00
        Cash        5,000.00
    15-Dec    Wages Expense    456.00
        Wages Payable        456.00
    15-Dec    Cash    68.00
        Merchandise Sales        68.00
    15-Dec    Cash    68.00
        Merchandise Sales        68.00
    20-Dec    Cost of Goods Sold    48.00
        Merchandise Inventory        48.00
    20-Dec    Wages Expense    456.00
        Cash        456.00
    24-Dec    Merchandise Inventory    122.00
        Cash        122.00
    24-Dec    Cash    153.00
        Merchandise Sales        153.00
    30-Dec    Cost of Goods Sold    109.60
        Merchandise Inventory        109.60
    31-Dec    Cash    151.25
        Merchandise Inventory        151.25
    31-Dec    Wages Expense    480.00
        Wages Payable        480.00
    31-Dec    Cash    19,000.00
        Accounts Receivable    6,000.00
        Bakery Sales        25,000.00
        Total    53,666.85    53,666.85    <== Do the debits equal the credits? (they should)
Inventory Valuation
    FIFO
                Purchases            Sales            Ending...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here