Current Year	2022
			Original
Year Placed in Service	Useful Life	Description	Cost	Salvage Value
2019	10	Conveyer Oven 1	18,000	2,500
2021	7	Reach-in Refrigerator	4,500	800
2019	7	Freezer	3,500	700
2019	5	Work table	200	50
2020	5	Pizza Prep Table	300	50
2018	7	Dough Mixer	500	100
2016	7	Dough Prep Equipment	400	20
2019	5	Hot Holding Cabinet 1	150	50
2020	5	Hot Holding Cabinet 2	200	50
2019	5	Delivery Bags	200	-
2017	10	Conveyer Oven 2	15,000	2,000
2019	5	Pizza Prep Table	350	150
2019	5	Assorted utensils	300	-

In this lab, you will:

Required:

Calculate depreciation expense using straight-line depreciation, double-declining balance and sum-of-the-years digits depreciation.

Ask the Question: How does depreciation differ by the depreciation method chosen?

Master the Data: Pathway Gardens is a landscaping company. It has various equipment that appears on its fixed asset schedule included in the spreadsheet Lab 1-2.xlsx. We will compute the depreciation using three different methods and compare and contrast them.

Software needed

• Excel
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

Data: Excel File Lab 1-2 Alt Data.xlsx.

Perform the Analysis: Refer to Lab 1-2 Alternative in the text for instructions and Lab 1-2 steps for each of the lab parts.

Share the Story: We have now computed the depreciation for Pathway Gardens using three different depreciation methods. We now have the information we need to compare each method. This data analytics can help us determine which depreciation method should be used.

Part 1: Upload Your Files

Part 2: Assessment

1. What is the 2022 double-declining balance depreciation expense for conveyer oven 1?

• $1,843

• $2,255

• $1,550

• $2,304

2. What is the total depreciation expense using sum-of-the-years digits for 2022?

• $5,620

• $5,479

• $4,160

• $4,610

3. Which asset has $1,300 straight line depreciation expense in 2022?

• Freezer

• Reach-In Refrigerator

• Conveyer Oven 2

• Conveyer Oven 1

4. Which asset has $43 sum-of-the-years digits depreciation in 2023?

• Dough prep equipment

• Work table

• Dough mixer

• Delivery bags

5. Which assets have zero double declining balance depreciation in 2023?

• Dough mixer, hot holding cabinet 1 and pizza prep table

• Work table, hot holding cabinet 1 and pizza prep table

• Work table, hot holding cabinet 2 and assorted utensils

• Dough mixer, hot holding cabinet 2 and assorted utensils

This is the last question in the assignment. To submit, use Alt + S. To access other questions, proceed to the question map button.Next Visit question map

Question1of1Total1 of 1

Prev

Excel File Edit View Insert Fri 12:28 PM Q = Format Tools Data Esvuo- Window Help Lab 1-2 Alt Data AutoSave OFF AC3 Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments C24 A x fix E F G H J K L Mell me Share Comments = = Styles Dictate V A T Salvage Value 2,500 800 700 50 50 A B D 1 Current Year 2022 hom 2 Original 3 Year Placed in Service Useful Life Description Cost 4 2019 10 Conveyer Oven 1 18,000 5 2021 7 Reach-in Refrigerator 4,500 6 2019 7 Freezer 3,500 7 2019 5 Work table 200 8 2020 5 Pizza Prep Table 300 7 Dough Mixer 500 10 2016 7 Dough Prep Equipmen 400 11 2019 5 Hot Holding Cabinet 1 150 12 2020 5 Hot Holding Cabinet 2 200 Cu 13 2019 5 Delivery Bags 200 14 2017 10 Conveyer Oven 2 15,000 15 2019 5 Pizza Prep Table 350 Ye 16 2019 5 Assorted utensils 300 17 20 ccounting analytics, I have learned o achieve a reasonable Ives using a management ient performance. It has a cable laws and regulations. that are used to counteract is called Internal Control Q 9 2018 100 20 50 50 2,000 150 The big data concept has been in blogy has enabled the efficiency sed. The significance growth of sted and analysed to reveal the dicting the future. Big data has is enterprises conduct their data is increasingly becoming 18 20 19 20 20 21 ey need professionals, who work k data" which helps to see what both big and thick data it will 20 22 23 20 24 20 25 26 20 27 rofessionals and experts who will illy study what best fits for your think that what works for Nokia, of services. That is why it is thick data, because it only r data thus avoiding missing that 20 28 29 20 30 21 20 F + 120% Sheet 1 + 20 + + 115% SEP 4 P X W