Question
I Need Step 4-7. I am attaching Step 1-3 if it helps. I. Incorporate the feedback that you received from your Milestone One submission on
I Need Step 4-7. I am attaching Step 1-3 if it helps.
I. Incorporate the feedback that you received from your Milestone One submission on Steps 14. A. Step One: Complete the July Journal Entries tab in your workbook using the Step One data in the appendix. B. Step Two: Complete the August Journal Entries tab in your workbook using the Step Two data in the appendix. C. Step Three: Complete the September Journal Entries tab in your workbook using the Step Three data and updated scenario information in the appendix. Note that there was an additional line of products added this month, so you must first complete the Inventory Valuation tab in your workbook and copy the journal entries from the inventory evaluation page into your journal for this month to ensure the impact of merchandising is reflected in your reporting. D. Step Four: Transfer posted entries to T accounts. II. Apply the accrual basis of accounting to correctly create adjusting entries in the preparation of financial statements: A. Step Five: Prepare the unadjusted trial balance. Note that you should use the T account balances completed in the previous step to prepare the unadjusted trial balance portion of the Trial Balance tab in your workbook. B. Step Six: Complete the Adjusting Entries tab in your workbook using the Step Six data in the appendix. Note that you should take the adjusting entries from this worksheet and enter them into the Trial Balance tab in your workbook. C. Step Seven: Apply adjusting entries to create the adjusted trial balance. Note that the adjusting entries from Step Six will apply to affected accounts in the unadjusted trial balance to arrive at the adjusted trial balance.
Step One Data (Click on the link to return to the prompt.) The following events occur in July, 2018: July 1: You take $10,000 from your personal savings account and buy common stock in Peyton Approved. July 1: Purchase $6,500 in baking supplies from vendor, on account. July 3: Your parents lend the company $10,000 cash in exchange for a two-year, 6% note payable. Interest and the principal are repayable at maturity. July 7: Enter into a lease agreement for bakery space. The agreement is for 1 year. The rent is $1,500 per month, and the last months rent payment of $1,500 is required at time of lease agreement. The payment was made in cash. Lease period is effective July 1, 2018, through June 30, 2019. July 10: Pay $375 to the county for a business license. July 11: Purchase a cash register for $250 (deemed to be not material enough to qualify as depreciable equipmentuse misc. exp.). July 13: You have baking equipment, including an oven and mixer, which you have been using for your home-based business and will now start using in the bakery. You estimate that the equipment is currently worth $6,000, and you transfer the equipment into the business in exchange for additional common stock. The equipment has a 5-year useful life. July 13: Pay $200 for business cards/flyers/posters/ads to use for advertising. July 14: Pay $300 for office supplies. July 15: Hire part-time helper to be paid $12 per hour. Pay periods are the 1st through the 15th and 16th through the end of the month, with paydays being the 20th for the first pay period and the 5th of the following month for the second pay period. (No entry is required on this date; it is here for informational purposes only.) July 30: Received telephone bill for July in amount of $75. Payment is due on August 10. July 31: Pay $2,400 for a 12-month insurance policy. Policy effective dates are August 1, 2018, through July 31, 2019. July 31: Accrue wages earned for employee for period of 16th through 31st of July (Wage calculations table provided below) July 31: Total July bakery sales were $15,000. $5,000 of these sales are on accounts receivable. Step Two Data (Click on the link to return to the prompt.) The following events occur in August, 2018: August 5: Paid employee for period ending 7/31. August 8: Receive payments from customers towards accounts receivable in amount of $3,800. August 10: Paid July telephone bill. August 15: Purchase additional baking supplies in amount of $5,000 from vendor, on account. August 15: Accrue wages earned for employee from period of 1st through 15th of August (Wage calculations table provided below). August 15: Pay rent on bakery space. August 18: Receive payments from customers towards accounts receivable in amount of $3,000. August 20: Paid $8,500 toward baking supplies vendor payable. August 20: Pay employee for period ending 8/15. August 22: $300 in office supplies purchased. August 31: Received telephone bill for August in amount of $75. Payment is due on September 10. August 31: Accrue wages earned for employee for period of August 16th through August 31st (Wage calculations table provided below). August 31: August bakery sales total $20,000. $7,500 of this total is on accounts receivable, Step Three (Click on the link to return to the prompt.) Updated Scenario: Many customers have been asking for more hypoallergenic products, so in September you start carrying a line of hypoallergenic shampoos on a trial basis. The following information relates to the purchase and sales of the shampoo: You use the perpetual inventory method. You are uncertain as to which valuation method to useFIFO, LIFO, or weighted average, so you calculate inventory using all three and then decide which one you would like to choose. Data: The following events occur in September, 2018: September 1: Paid dividends to self in amount of $10,000. September 5: Pay employee for period ending 8/31. September 7: Purchase merchandise for resale. See Inventory Valuation tab for details. September 8: Receive payments from customers toward accounts receivable in amount of $4,000. September 10: Pay August telephone bill. September 11: Purchase baking supplies in amount of $7,000 from vendor on account. September 13: Paid on supplies vendor account in amount of $5,000. September 15: Accrue employee wages for period of September 1 through September 15. September 15: Pay rent on bakery space: $1,500. September 15: Record merchandise sales transaction. See Inventory Valuation tab for details. September 15: Record impact of sales transaction on COGS and the inventory asset. See Inventory Valuation tab for details. September 20: Pay employee for period ending 9/15. September 20: Purchase merchandise inventory for resale to customers. See Inventory Valuation tab for details. September 24: Record sales of merchandise to customers. See Inventory Valuation tab for details. September 24: Record impact of sales transaction on COGS and the inventory asset. See Inventory Valuation tab for details. September 30: Purchase merchandise inventory for resale to customers. See Inventory Valuation tab for details. September 30: Accrue employee wages for period of September 16th through September 30th September 30: Total September bakery sales are $20,000. $6,000 of these sales are on accounts receivable. Step Six Data (Click on the link to return to the prompt.) On September 30, the following adjustments must be made: [Note: This is a sample.] Depreciation of baking equipment transferredto company on 7/13. Assume a half month of depreciation in July using the straight-line method. Accrue interest for note payable. Assume a full month of interest for July. (6% annual interest on $10,000 loan from parents.) Record insurance used for the year. Actual baking supplies on-hand as of September 30 are $1,100. Office supplies on-hand as of September 30 are $50.
Wage calculation data:
Month Hours Rate Pay
31 Jul. 10 12 120
15 Aug. 40 12 480
31 Aug. 35 12 420
15 Sep. 38 12 456
30 Sep. 40 12 480
D C Jul-18 Credit Debit Accounts Date 10,000.00 1-Jul Cash 10,000.00 Common Stock 6,500.00 1-Jul Baking Supplies Accounts Payable 6,500.00 10,000,00 3 Jul Cash Notes Payable 10,000.00 1,500.00 1,500.00 7Jul Prepaid Rent Rent Expense Cash 3,000.00 375.00 10 Jul Business License Expense Cash 375.00 250.00 11-Jul Misc. Expense Cash 250.00 6,000.00 13-Jul Baking Equipment Common Stock 6,000.00 200.00 13-Jul Advertising Expense Cash 200.00 300.00 Jul Misc Supplies Cash 300.00 75.00 30-Jul Telephone Expensel Accounts Payable 75.00 31-Jul Prepaid Insurance Cash 2,400.00 2,400 00 31-Jul Salary and Wages Expense Salary and Wages Payable 120.00 120.00 10.000 00 5,000.00 31-Jul Cash Accounts Receivable for 6 A C E Bakery Sales 15,000.00 Total 54.220.00 54,220.00 108,440.00 108.440.00 X Peyton Approved General Journal Entries Aug-18 Accounts Credit Date Debit 5-Aug Salary and Wages Payable Cash 120.00 120.00 8-Aug Cash Accounts Receivable 3,800.00 3,800.00 75.00 10-Aug Accounts Payable Cash 75.00 15-Aug Baking Supplies Accounts Payable 5.000.00 5,000.00 480.00 15-Aug Salary and Wages Expense Salary and Wages Payable 480.00 15-Aug Rent Expense Cash 1,500.00 1,500.00 18-Aug Cash 3,000.00 Accounts Receivable 3,000.00 20-Aug Accounts Payable Cash 8.500.00 8,500.00 20-Aug Salary and Wages Payable Cash 480.00 480.00 22-Aug Misc. Supplies Cash 300.00 300.00 31-Aug Telephone Expense Accounts Payable 75.00 75.00 31-Aug Salary and Wages Expense Salary and Wages Payable 420.00 420.00 31-Aug Cash 12,500.00 7.500.00 Accounts Receivable 20.000.00 1 Total 43,750.00 S 43,750.00 Uate 10000.00 1-Sep Dividends Cash 10,000.00 7 5-Sep Salary and Wages Payable Cash 420.00 420.00 10 11 7-Sep Merchandise Inventorty Cash 60.00 12 60.00 t3 14 4,000.00 8-Sep Cash 15 4.000,00 Accounts Receivable 16 10-Sep Accounts Payable Cash 75.00 75.00 19 20 7.000.00 11-Sep Baking Supplies Cash 21 7.000.00 22 23 5.000 00 13-Sep Accounts Payable Cash 24 5,000.00 25 26 458 001 15-Sep Salary and Wages Expense Salary and Wages Payable 27 456.00 28 23 1500 00 30 N15-Sep Rent Expense Cash 1500,00 31 32 15-Sep Cash 68 00 33 68.00 Merchendise sales Reverue 34 35 15-Sep Cost of Goods Sold Merchendise Inventory 48.00 36 48.00 37 38 456.00 20-Sep Salary and Wages Payable Cash 39 456.00 40 41 20-Sep Merchandse Inventory Cash 122.00 42 122.00 43 44 153.00 24-Sep Carh e Merchendise sales Revenue 45 153 00 46 47 24-Sep Cost of Goods Sold Merchandise inventory 109 80 48 109 80 49 50 151 25 30-Sep Merchandise Inventory Cash 51 15125 52 53 BANE 30-SepSalary and Wages expense 480 00 54 480 00 Salary and Wages Payable 55 56 14.000 00 6000 00 30-Sep Cash 57 Aocounts Receivable Bakery Seles Total 58 20,000.00 50099 05 50099 05 59 D C Jul-18 Credit Debit Accounts Date 10,000.00 1-Jul Cash 10,000.00 Common Stock 6,500.00 1-Jul Baking Supplies Accounts Payable 6,500.00 10,000,00 3 Jul Cash Notes Payable 10,000.00 1,500.00 1,500.00 7Jul Prepaid Rent Rent Expense Cash 3,000.00 375.00 10 Jul Business License Expense Cash 375.00 250.00 11-Jul Misc. Expense Cash 250.00 6,000.00 13-Jul Baking Equipment Common Stock 6,000.00 200.00 13-Jul Advertising Expense Cash 200.00 300.00 Jul Misc Supplies Cash 300.00 75.00 30-Jul Telephone Expensel Accounts Payable 75.00 31-Jul Prepaid Insurance Cash 2,400.00 2,400 00 31-Jul Salary and Wages Expense Salary and Wages Payable 120.00 120.00 10.000 00 5,000.00 31-Jul Cash Accounts Receivable for 6 A C E Bakery Sales 15,000.00 Total 54.220.00 54,220.00 108,440.00 108.440.00 X Peyton Approved General Journal Entries Aug-18 Accounts Credit Date Debit 5-Aug Salary and Wages Payable Cash 120.00 120.00 8-Aug Cash Accounts Receivable 3,800.00 3,800.00 75.00 10-Aug Accounts Payable Cash 75.00 15-Aug Baking Supplies Accounts Payable 5.000.00 5,000.00 480.00 15-Aug Salary and Wages Expense Salary and Wages Payable 480.00 15-Aug Rent Expense Cash 1,500.00 1,500.00 18-Aug Cash 3,000.00 Accounts Receivable 3,000.00 20-Aug Accounts Payable Cash 8.500.00 8,500.00 20-Aug Salary and Wages Payable Cash 480.00 480.00 22-Aug Misc. Supplies Cash 300.00 300.00 31-Aug Telephone Expense Accounts Payable 75.00 75.00 31-Aug Salary and Wages Expense Salary and Wages Payable 420.00 420.00 31-Aug Cash 12,500.00 7.500.00 Accounts Receivable 20.000.00 1 Total 43,750.00 S 43,750.00 Uate 10000.00 1-Sep Dividends Cash 10,000.00 7 5-Sep Salary and Wages Payable Cash 420.00 420.00 10 11 7-Sep Merchandise Inventorty Cash 60.00 12 60.00 t3 14 4,000.00 8-Sep Cash 15 4.000,00 Accounts Receivable 16 10-Sep Accounts Payable Cash 75.00 75.00 19 20 7.000.00 11-Sep Baking Supplies Cash 21 7.000.00 22 23 5.000 00 13-Sep Accounts Payable Cash 24 5,000.00 25 26 458 001 15-Sep Salary and Wages Expense Salary and Wages Payable 27 456.00 28 23 1500 00 30 N15-Sep Rent Expense Cash 1500,00 31 32 15-Sep Cash 68 00 33 68.00 Merchendise sales Reverue 34 35 15-Sep Cost of Goods Sold Merchendise Inventory 48.00 36 48.00 37 38 456.00 20-Sep Salary and Wages Payable Cash 39 456.00 40 41 20-Sep Merchandse Inventory Cash 122.00 42 122.00 43 44 153.00 24-Sep Carh e Merchendise sales Revenue 45 153 00 46 47 24-Sep Cost of Goods Sold Merchandise inventory 109 80 48 109 80 49 50 151 25 30-Sep Merchandise Inventory Cash 51 15125 52 53 BANE 30-SepSalary and Wages expense 480 00 54 480 00 Salary and Wages Payable 55 56 14.000 00 6000 00 30-Sep Cash 57 Aocounts Receivable Bakery Seles Total 58 20,000.00 50099 05 50099 05 59
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started