(40 points) 1. Complete the following postings, calculations, and entries. a. Start Microsoft Excel and open...

Transcribed Image Text:

(40 points) 1. Complete the following postings, calculations, and entries. a. Start Microsoft Excel and open the BUS114_05_06.xlsx file from C:\ACTT2\Data\Unit_5. b. Click the File tab and click Save As. Save the file to C:\ACTT2\Student\Unit 5. c. Navigate to the Furry Pets Aging Report. d. Post the appropriate column totals from the top of the Furry Pets Aging Report to the green shaded boxes in the Summary below. (10 points) e. Post the total from the Estimated Uncollectible column to the Furry Pets Ledger by navigating to the Furry Pets Ledger tab. Navigate to the Kicks Depreciation Schedule. Review the Facts box at the top. Calculate the straight-line depreciation by filling in the green shaded areas, in the calculation boxes provided, with the appropriate data from the Facts box. Complete the Schedule of Depreciation by filling in the green shaded areas. f. g. h. i. Journalize the year one depreciation expense from the Kicks Depreciation Schedule by navigating to the Kicks Ledger tab. (10 points) 2. Calculate the gain or loss on the sale of a plant asset. a. Navigate to the House Foods tab. b. Calculate the carrying value of the asset in calculation box provided. Fill in the green shaded area with the appropriate data from the Facts box at the top. c. Calculate the gain or loss from the disposal of the asset in the calculation box provided. Fill in the green shaded area with the appropriate data from the Facts box at the top. 3. Journalize the gain or loss. a. Stay on the House Foods tab. b. Below the calculation boxes, post the entry to record the disposal of the asset in the House Foods Ledger. c. Save and close the spreadsheet. d. Submit your file to your instructor for grading. Customer Cat-Dog Groomers Feline Festivities Dog Yoga Total Past Due Furry Pets Accounts Receivable Aging Report 31-60 days 61-90 days over 90 days Current 1-30 days 31-60 days 61-90 days over 90 days $ 350.00 $ 200.00 $ 100.00 Aging Report Summary $ $ 550.00 $ 100.00 $ Total % Uncollectible Total Estimated Uncollectible 10% $ 20% $ 45% $ $ $ 350.00 $ 300.00 200.00 $ 300.00 $ 500.00 200.00 $ 300.00 $1,150.00 Total - Date Account Name Furry Pets Ledger 4/30/20xx Uncollectible Accounts Expense Allowance for Uncollectible Accounts To adjust the allowance for uncollectible accounts Debit Credit Furry Pets Aging Report Furry Pets Ledger Kicks Depreciation Schedule Kicks Ledger House Foods + Kicks Depreciation Calculation and Schedule Facts: Asset Cost = $75,000 Salvage Value = $10,000 Useful life = 5 years Straight Line, Annual Depreciation Calculation: Less Divide By Annual Depreciation Exp Furry Pets Aging Report $ #DIV/0! Schedule of Depreciation Book Value Year Beginning of Year 1 $ 75,000.00 2 3 4 5 Annual Depreciation Book Value End of Year $ 75,000.00 $ $ $ $ Furry Pets Ledger Kicks Depreciation Schedule Kicks Ledger House Foods > Date 12/31/20XX Kicks Ledger Account Name To account for delivery truck depreciation Debit Furry Pets Aging Report Furry Pets Ledger Kicks Depreciation Schedule Credit Kicks Ledger House Foods Facts: House Foods bought a packing machine for $250,000. Ten years later, the accumulated depreciation totaled $175,000. Ten years later plus a few days, the machine was sold for $80,000. Calculate the salvage value in the box below: $ Less $ Carrying Value $ LA LA Less Gain/(Loss) Calculate the gain or loss on the sale of the machine in the box below: $ Date LA GA $ $ House Foods House Foods Ledger Account Name Debit To Record Disposal of Packing Machine Credit (40 points) 1. Complete the following postings, calculations, and entries. a. Start Microsoft Excel and open the BUS114_05_06.xlsx file from C:\ACTT2\Data\Unit_5. b. Click the File tab and click Save As. Save the file to C:\ACTT2\Student\Unit 5. c. Navigate to the Furry Pets Aging Report. d. Post the appropriate column totals from the top of the Furry Pets Aging Report to the green shaded boxes in the Summary below. (10 points) e. Post the total from the Estimated Uncollectible column to the Furry Pets Ledger by navigating to the Furry Pets Ledger tab. Navigate to the Kicks Depreciation Schedule. Review the Facts box at the top. Calculate the straight-line depreciation by filling in the green shaded areas, in the calculation boxes provided, with the appropriate data from the Facts box. Complete the Schedule of Depreciation by filling in the green shaded areas. f. g. h. i. Journalize the year one depreciation expense from the Kicks Depreciation Schedule by navigating to the Kicks Ledger tab. (10 points) 2. Calculate the gain or loss on the sale of a plant asset. a. Navigate to the House Foods tab. b. Calculate the carrying value of the asset in calculation box provided. Fill in the green shaded area with the appropriate data from the Facts box at the top. c. Calculate the gain or loss from the disposal of the asset in the calculation box provided. Fill in the green shaded area with the appropriate data from the Facts box at the top. 3. Journalize the gain or loss. a. Stay on the House Foods tab. b. Below the calculation boxes, post the entry to record the disposal of the asset in the House Foods Ledger. c. Save and close the spreadsheet. d. Submit your file to your instructor for grading. Customer Cat-Dog Groomers Feline Festivities Dog Yoga Total Past Due Furry Pets Accounts Receivable Aging Report 31-60 days 61-90 days over 90 days Current 1-30 days 31-60 days 61-90 days over 90 days $ 350.00 $ 200.00 $ 100.00 Aging Report Summary $ $ 550.00 $ 100.00 $ Total % Uncollectible Total Estimated Uncollectible 10% $ 20% $ 45% $ $ $ 350.00 $ 300.00 200.00 $ 300.00 $ 500.00 200.00 $ 300.00 $1,150.00 Total - Date Account Name Furry Pets Ledger 4/30/20xx Uncollectible Accounts Expense Allowance for Uncollectible Accounts To adjust the allowance for uncollectible accounts Debit Credit Furry Pets Aging Report Furry Pets Ledger Kicks Depreciation Schedule Kicks Ledger House Foods + Kicks Depreciation Calculation and Schedule Facts: Asset Cost = $75,000 Salvage Value = $10,000 Useful life = 5 years Straight Line, Annual Depreciation Calculation: Less Divide By Annual Depreciation Exp Furry Pets Aging Report $ #DIV/0! Schedule of Depreciation Book Value Year Beginning of Year 1 $ 75,000.00 2 3 4 5 Annual Depreciation Book Value End of Year $ 75,000.00 $ $ $ $ Furry Pets Ledger Kicks Depreciation Schedule Kicks Ledger House Foods > Date 12/31/20XX Kicks Ledger Account Name To account for delivery truck depreciation Debit Furry Pets Aging Report Furry Pets Ledger Kicks Depreciation Schedule Credit Kicks Ledger House Foods Facts: House Foods bought a packing machine for $250,000. Ten years later, the accumulated depreciation totaled $175,000. Ten years later plus a few days, the machine was sold for $80,000. Calculate the salvage value in the box below: $ Less $ Carrying Value $ LA LA Less Gain/(Loss) Calculate the gain or loss on the sale of the machine in the box below: $ Date LA GA $ $ House Foods House Foods Ledger Account Name Debit To Record Disposal of Packing Machine Credit