Company A provides delivery services to and from warehouses owned by a large e-commerce company. The company operates 10 routes in the local area. The company owns three types of fixed assets: delivery vans, forklifts, and light equipment. Each route has 10 delivery vans, one forklift, and two pieces of light equipment for its operations. The company depreciates all fixed assets using the straight-line method. The Data worksheet contains a list of vehicles and equipment the company owns. Each row provides information about one asset, including its type, cost, residual value, useful life, route, and number of months already in service. Required: Open spreadsheet Complete four columns on the Data worksheet: Depreciable Base, Annual Depreciation, Accumulated Dep., and Book Value. Use this information to complete the requirements below.

R1. Cell H2: Use a formula referring to other amounts in the row to calculate the depreciable base for the first asset. fill in the blank 1 of 1$ R2. Cell I2: Use the SLN function to determine the annual depreciation expense amount for the first asset. fill in the blank 1 of 1$

R3. Cell J2: Use a formula referring to other amounts in the row to calculate accumulated depreciation for the first asset. fill in the blank 1 of 1$

R4. Cell K2: Use a formula referring to other amounts in the row to calculate the book value of the first asset. fill in the blank 1 of 1$ R5. Copy down the entries in cells H2, I2, J2, and K2 to all the other rows with data.

Steps to create a pivot table: S1. Select a cell in the data on the Data worksheet. S2. Select Insert / PivotTable. The data range will automatically be inserted. A "Create PivotTable" window should appear. S3. In the window, under "Choose where you want the PivotTable report to be placed," select "New Worksheet." A new worksheet should appear with the PivotTable. S4. A PivotTable Field List should pop up. Drag fields into rows, columns, filters, and values areas as needed. (If this gray work box does not appear, right click in the pivot table and select "Show Field List.")

Questions: Use the information on the Data worksheet and pivot tables, formulas, and/or functions to answer the following questions. Q1. What is the total amount of annual depreciation expense for the delivery vans on the Eastside Manor and State Road 31 routes combined? fill in the blank 1 of 1$ Q2. How many pieces of light equipment have a depreciable base over $8,100? fill in the blank 1 of 1 Q3. What is the total amount of accumulated depreciation for all the forklifts? fill in the blank 1 of 1$ Q4. What is the average book value of the delivery vans on the Shockley Station route? (Round the answer to the nearest whole dollar.)