Create a depreciate schedule for a client.
Attached is the Depreciation Schedule to be setup and the details showing the items purchased.
Additional instructions:
- Purchase description name of item purchased; for example Dell computer
- Cost per item is the cost for each item; for example, if there were 3 computers purchased enter each one on a separate line. Also add the labor cost associated with each item to get the total cost per item
- Depreciation years- for computers 3 year; for furniture 7 years
- Depreciation rate- cost per item divided by the number of years
FIXED ASSET & DEPRECIATION SCHEDULE Depreciation Schedule CA ARO Cost per Per month Der Purchase Description A Der 2 2003 . was NOR wer Fordi 2004 Chwth Doogee 2001 2013 9 w 10 w 11 WAG Purchase Beervice 2000 020 401.2019 2010 110420 1012014 2013 12010 0903 2014 12018 HD w 14 Flow 15 MM 9201 16 32/2011 17 2004 180 mm 100 190 2001 21 2017 120 22.com 23 2. Open 2009 24 mm 25 25 2000 22 23 28 29 272000 West 00011 01.2011 100 . 012018 301 10.01.2019 19018 1000 1000 19000 11010000 37 To De 13 100 250 41 Depreciation Schedule Sheet Items on Original Quote: Quan Description Rate Total 2 919.00 1.838.00 Dell Laptops Dell Server Dell Inspiron 15 3510 Laptops with Win10 Pro Dell PowerEdge R620 Server. Win 2019 Server 1 3692.50 3.692.50 Dell Monitors 2 Dell 27" Full HD 75Hz HDMI VGA Monitor 226.00 452.00 Dell Dock 2 199 99 399.98 2 59.99 119.98 Keyboard & Mouse UPS for Rack Dell USB 3.0 Triple Display UltraHD Dock D3100 Logitech Wireless Keyboard and Mouse TRIPPLITE 1500VA USB 8-Outlet AVR W LCD NETGEAR Business 24 Port All Gb PoE Switch 2 249.95 499.90 Network Switch 1 529.99 529.99 Network Firewall 1 SonicWall TZ370 759.94 759.94 Firewall License 1 Total Secure - Essential Edition 1 Year 795.00 795.00 3 Ubiquiti UniFi nanoHD AC2000 209.99 629.97 Wi-Fi Access Points - Riser Cable Rack for Network 1 CAT5e Ethernet Cable for Offices 1000 135.00 135.00 1 336.00 336.00 Network Hardware 1 145.00 145.00 Star Tech 12U Server Cabinet RK1233BKM Wall Plates, Keystones. Patch Panel, Misc Items Maglocks. REX Touchless. Readers, Proxy Cards Access Cable 18/2 Stranded Access Control 1 2707.00 2.707.00 Stranded Cable 1 150.00 150.00 Stranded Cable 1 Access Cable 22/6 Stranded 212.99 212.99 NVR for Cameras 1 639.00 639.00 Security Cameras 11 Hikvision 16 Channel 4K NVR w/6TB HDD Hikvision Smp ColorVu2.8mm lens CAT6 Plenum Ethernet Cable 1000 245.00 2.695.00 Camera Cable 1 259.00 259.00 J Hooks 50 3.47 173.50 Rack KVM for Server 1 191.03 191.05 2" J Hooks w/Beam Clamp Rack Mounted Keyboard. Monitor & Mouse Scissor Lift Weekly Rental Rack Screws, 12 Outlet Power Strip. Scissor Lift 1 840.00 840.00 Misc Hardware 1 55.00 55.00 TV and Mount: TV for Cameras 1 999.00 999.00 Sainsung 75" 4K UHD Crystal Smart TV AFL AL650-A Full Motion Wall Mount TV Wall Mount 1 104.99 104.99 HDMI Cable 1 39.4 ft HDMI Male to Male Cable - TV to NVR 69.99 69.99 Laptops 2nd Monitors and Mouse Pad Dell PC Monitors 2 209.99 419.98 Dell S2721 HS 27" Full HD 75Hz LED Monitors Ergonomic Mouse Pad with Wrist Support Mouse Pads 2 14.99 29.98 Doorbell, PA & Cameras with Mics Doorbells 2 129.00 258.00 Boorbells Cable and Transformer 2 Hikvision Security Doorbells - DS-HD1 Power Supply and Cables for Doorbells 70 Volt Commercial Amplifier 35.00 70.00 PA Amplifier 1 139.00 159.00 1 69.00 69.00 PA Amplifier Cable PA Loud Speaker Cameras with Microphones 1 22/2 Cable to connect PA System - 300ft. PA Loudspeaker Installed in Warehouse Hikvision Smp Microphone Cameras 149.99 149.99 2 245.00 490.00 Monitor, KBD & Mouse for KVM Dell 27" Full HD 75Hz HDMI VGA Monitor 226.00 226.00 Dell Monitors Keyboard & Mouse Logitech Wireless Keyboard and Mouse 39.99 39.99 Power Strip: Power Strip for Rack 1 BTU Power Strip Surge Protector Rack-Mount 39 99 39.99 Conduit for Fiber Drop Conduit 1 Conduit Materials 1" 20.00 20.00 Revised Quote for Returned Laptop Dell Lup Dell Dock Dell Dell USB 3.0 Triple Display Ultra HD Dock D3100 919.00 199.99 1 199.99 PC Monitor 2 209.99 419.98 Dell S2721HS 27" Full HD 75Hz LED Monitor Logitech Wireless Mouse Mouse 1 1 41.99 41.99 Mouse Pads 1 Ergonomic Mouse Pad with Wrist Support 15.99 15.99 Windows 10 Pro Upgrade 107.17 Windows 10 Upgrades USB3 Cables for KVN 321.31 Purchased Three Upgrades of Windows 10 Pro Cables to Connect Multiple Devices to KVM 22.37 22.57 Total Parts S 22.443.74 Labor Quan Hrs Description Rate Total Total Dell Laptops 2 1 1 125.00 250.00 Configure Users. Email & Network Connect Laptop, Monitors and Mice Docking Stations 2 0.5 125.00 125.00 Server 1 3 125.00 375.00 Configure Users, Security & Access Mount and Configure UPS in rack UPS for Rack 2 0.25 125.00 62.50 Network Switches 1 0.5 Install & Connect Computers & Cameras 125.00 62.50 1 2 Install & Configure Firewall Security 125.00 250.00 Network Firewall Setup Office365 Access Control 2 0.5 125.00 125.00 3 3.75 175.00 1.968.75 11 1 Setup Office 365 on Two Laptops Install and Config Access for 3 Doors 3 Install and Config 11 IP Cameras Install Network Drops Patch Panel to Walls Install Network Drops for Whse Wi-Fi Camera Installation Office Data Drops Whse Data Drops 175.00 13 1 100.00 1.925.00 1.300.00 350.00 2 1 175.00 TV and Mount: : TV for Cameras 11 Mount Samsung TV and Connect to NVR 175.00 175.00 1 0.75 175.00 131.25 TV Wall Mount Connect HDMI Cable Install Wall Mount for Samsung TV Run HDMI Cable in Ceiling from NVR to TV 1 0.3 175.00 87.50 Laptops 2nd Monitors: PC Monitors 2 0 0.00 No Charge Connect Second PC Monitors to Laptops No Charge Doorbell, PA & Cameras with Mics Connect Doorbells 2 1 Connect Doorbells to Transformer & Configure 175.00 350.00 1 1.75 175.00 306.2 Connect PA System Install Microphone Cameras Connect PA Amp to Loud Speaker in Warehouse Install Hikvision Spm Microphone Cameras 2 1 175.00 350.00 Conduit Installation Install Conduit Installation of Conduit for Consolidated ISP 175.00 175.00 175.00 Revised Quote for Returned Laptop Docking Station 1 0.3 Connect Workstation, Monitors and Mice 125.00 62.50 PC Monitors 2 O No Installation Labor Charge 0.00 No Charge Windows 10 Pro Upgrade Windows Upgrade 1 2 Upgrade your New HP Laptop from Windows S to Pro 125.00 250.00 Network MACS Folder Strucuture 1 1 Setup Shared and Private Network Folders 125.00 125.00 Network MACS 3 0.5 Network Mac Laptops and Workstation 125.00 187.50 Total Labor S 8.993.75 Parts & Labor 31.437.49 Tax 2,593.59 Total Parts, Labor & Sales Tax 34,031.08 Paid 7/13/2021 17,735.13 Paid 7/16/2021 1,948.42 Paid 7/21/2021 6,304.34 Paid 8/20/2021 3,301.54 Balance S 4.741.65 P.O. NUMBER TERMS DUE DATE SALESMAN ESTIMATED SHIP DATE SHIP VIA 50%/BALANCE... 7/9/2021 LAURA 7/9/2021 DELIVER CD-VSS3060 1 398.85 BLANC DE GRIS 398.85T CD-VSS3066-AE 3 320.38 BLANC DE GRIS 961.147 WORKSTATIONS CORP DESIGN: 30DX60WX29H (Sg! station group)(Includes: legs, beams, mounting clips, screws and surface) BENCHING- 30"D X 66"W X 29"H (EXT SGL STATION GROUP) (INCLUDES: LEGS, BEAMS, MOUNTING CLIPS, SCREWS AND SURFACE) CORP DESIGN: ACRYLIC DIVIDERS; 24" X 16"H X 0.4" THICK CORP DESIGN: UNDERMOUNT DIVIDER CLIPS - 2X CLIPS FOR END OF RUN 24.4"H X 20"D GREY METAL MOBILE PEDESTAL W/ BLACK CUSHION CD-VAD24 3 98.08 294.24T CD-VDC-VAD-SC-S 3 107.89 323.677 CD-VBBFMP-G-B 4 1,216.20T 304.05 GREY METAL BLACK CUSHION 35.00 512490 4 140.00T CD-611B 6 1.745.82T 290.97 STD CARPET CASTERS: BLK WIRE MANAGEMENT CHANNEL. - BLACK PVC 48"W CORPDESIGN-CONCETTO ERGONOMIC TASK CHAIR. ADAPTIVE MESH BACK, PNEUMATIC SEAT AND HEIGHT ADJUSTMENT, SYNCHRO TILT CONTROL, NYLON BASE WITH CASTERS XS83 1 400.00 400.00T DELIVERY & INSTALLATION DURING BUSINESS HOURS sales tax 8.25% 452.09 WE APPRECIATE THE OPPORTUNITY TO ASSIST YOU WITH YOUR OFFICE FURNITURE NEEDS. TOTAL: $5,932.01 2165.93 2454.08. 512.00 FIXED ASSET & DEPRECIATION SCHEDULE Depreciation Schedule CA ARO Cost per Per month Der Purchase Description A Der 2 2003 . was NOR wer Fordi 2004 Chwth Doogee 2001 2013 9 w 10 w 11 WAG Purchase Beervice 2000 020 401.2019 2010 110420 1012014 2013 12010 0903 2014 12018 HD w 14 Flow 15 MM 9201 16 32/2011 17 2004 180 mm 100 190 2001 21 2017 120 22.com 23 2. Open 2009 24 mm 25 25 2000 22 23 28 29 272000 West 00011 01.2011 100 . 012018 301 10.01.2019 19018 1000 1000 19000 11010000 37 To De 13 100 250 41 Depreciation Schedule Sheet Items on Original Quote: Quan Description Rate Total 2 919.00 1.838.00 Dell Laptops Dell Server Dell Inspiron 15 3510 Laptops with Win10 Pro Dell PowerEdge R620 Server. Win 2019 Server 1 3692.50 3.692.50 Dell Monitors 2 Dell 27" Full HD 75Hz HDMI VGA Monitor 226.00 452.00 Dell Dock 2 199 99 399.98 2 59.99 119.98 Keyboard & Mouse UPS for Rack Dell USB 3.0 Triple Display UltraHD Dock D3100 Logitech Wireless Keyboard and Mouse TRIPPLITE 1500VA USB 8-Outlet AVR W LCD NETGEAR Business 24 Port All Gb PoE Switch 2 249.95 499.90 Network Switch 1 529.99 529.99 Network Firewall 1 SonicWall TZ370 759.94 759.94 Firewall License 1 Total Secure - Essential Edition 1 Year 795.00 795.00 3 Ubiquiti UniFi nanoHD AC2000 209.99 629.97 Wi-Fi Access Points - Riser Cable Rack for Network 1 CAT5e Ethernet Cable for Offices 1000 135.00 135.00 1 336.00 336.00 Network Hardware 1 145.00 145.00 Star Tech 12U Server Cabinet RK1233BKM Wall Plates, Keystones. Patch Panel, Misc Items Maglocks. REX Touchless. Readers, Proxy Cards Access Cable 18/2 Stranded Access Control 1 2707.00 2.707.00 Stranded Cable 1 150.00 150.00 Stranded Cable 1 Access Cable 22/6 Stranded 212.99 212.99 NVR for Cameras 1 639.00 639.00 Security Cameras 11 Hikvision 16 Channel 4K NVR w/6TB HDD Hikvision Smp ColorVu2.8mm lens CAT6 Plenum Ethernet Cable 1000 245.00 2.695.00 Camera Cable 1 259.00 259.00 J Hooks 50 3.47 173.50 Rack KVM for Server 1 191.03 191.05 2" J Hooks w/Beam Clamp Rack Mounted Keyboard. Monitor & Mouse Scissor Lift Weekly Rental Rack Screws, 12 Outlet Power Strip. Scissor Lift 1 840.00 840.00 Misc Hardware 1 55.00 55.00 TV and Mount: TV for Cameras 1 999.00 999.00 Sainsung 75" 4K UHD Crystal Smart TV AFL AL650-A Full Motion Wall Mount TV Wall Mount 1 104.99 104.99 HDMI Cable 1 39.4 ft HDMI Male to Male Cable - TV to NVR 69.99 69.99 Laptops 2nd Monitors and Mouse Pad Dell PC Monitors 2 209.99 419.98 Dell S2721 HS 27" Full HD 75Hz LED Monitors Ergonomic Mouse Pad with Wrist Support Mouse Pads 2 14.99 29.98 Doorbell, PA & Cameras with Mics Doorbells 2 129.00 258.00 Boorbells Cable and Transformer 2 Hikvision Security Doorbells - DS-HD1 Power Supply and Cables for Doorbells 70 Volt Commercial Amplifier 35.00 70.00 PA Amplifier 1 139.00 159.00 1 69.00 69.00 PA Amplifier Cable PA Loud Speaker Cameras with Microphones 1 22/2 Cable to connect PA System - 300ft. PA Loudspeaker Installed in Warehouse Hikvision Smp Microphone Cameras 149.99 149.99 2 245.00 490.00 Monitor, KBD & Mouse for KVM Dell 27" Full HD 75Hz HDMI VGA Monitor 226.00 226.00 Dell Monitors Keyboard & Mouse Logitech Wireless Keyboard and Mouse 39.99 39.99 Power Strip: Power Strip for Rack 1 BTU Power Strip Surge Protector Rack-Mount 39 99 39.99 Conduit for Fiber Drop Conduit 1 Conduit Materials 1" 20.00 20.00 Revised Quote for Returned Laptop Dell Lup Dell Dock Dell Dell USB 3.0 Triple Display Ultra HD Dock D3100 919.00 199.99 1 199.99 PC Monitor 2 209.99 419.98 Dell S2721HS 27" Full HD 75Hz LED Monitor Logitech Wireless Mouse Mouse 1 1 41.99 41.99 Mouse Pads 1 Ergonomic Mouse Pad with Wrist Support 15.99 15.99 Windows 10 Pro Upgrade 107.17 Windows 10 Upgrades USB3 Cables for KVN 321.31 Purchased Three Upgrades of Windows 10 Pro Cables to Connect Multiple Devices to KVM 22.37 22.57 Total Parts S 22.443.74 Labor Quan Hrs Description Rate Total Total Dell Laptops 2 1 1 125.00 250.00 Configure Users. Email & Network Connect Laptop, Monitors and Mice Docking Stations 2 0.5 125.00 125.00 Server 1 3 125.00 375.00 Configure Users, Security & Access Mount and Configure UPS in rack UPS for Rack 2 0.25 125.00 62.50 Network Switches 1 0.5 Install & Connect Computers & Cameras 125.00 62.50 1 2 Install & Configure Firewall Security 125.00 250.00 Network Firewall Setup Office365 Access Control 2 0.5 125.00 125.00 3 3.75 175.00 1.968.75 11 1 Setup Office 365 on Two Laptops Install and Config Access for 3 Doors 3 Install and Config 11 IP Cameras Install Network Drops Patch Panel to Walls Install Network Drops for Whse Wi-Fi Camera Installation Office Data Drops Whse Data Drops 175.00 13 1 100.00 1.925.00 1.300.00 350.00 2 1 175.00 TV and Mount: : TV for Cameras 11 Mount Samsung TV and Connect to NVR 175.00 175.00 1 0.75 175.00 131.25 TV Wall Mount Connect HDMI Cable Install Wall Mount for Samsung TV Run HDMI Cable in Ceiling from NVR to TV 1 0.3 175.00 87.50 Laptops 2nd Monitors: PC Monitors 2 0 0.00 No Charge Connect Second PC Monitors to Laptops No Charge Doorbell, PA & Cameras with Mics Connect Doorbells 2 1 Connect Doorbells to Transformer & Configure 175.00 350.00 1 1.75 175.00 306.2 Connect PA System Install Microphone Cameras Connect PA Amp to Loud Speaker in Warehouse Install Hikvision Spm Microphone Cameras 2 1 175.00 350.00 Conduit Installation Install Conduit Installation of Conduit for Consolidated ISP 175.00 175.00 175.00 Revised Quote for Returned Laptop Docking Station 1 0.3 Connect Workstation, Monitors and Mice 125.00 62.50 PC Monitors 2 O No Installation Labor Charge 0.00 No Charge Windows 10 Pro Upgrade Windows Upgrade 1 2 Upgrade your New HP Laptop from Windows S to Pro 125.00 250.00 Network MACS Folder Strucuture 1 1 Setup Shared and Private Network Folders 125.00 125.00 Network MACS 3 0.5 Network Mac Laptops and Workstation 125.00 187.50 Total Labor S 8.993.75 Parts & Labor 31.437.49 Tax 2,593.59 Total Parts, Labor & Sales Tax 34,031.08 Paid 7/13/2021 17,735.13 Paid 7/16/2021 1,948.42 Paid 7/21/2021 6,304.34 Paid 8/20/2021 3,301.54 Balance S 4.741.65 P.O. NUMBER TERMS DUE DATE SALESMAN ESTIMATED SHIP DATE SHIP VIA 50%/BALANCE... 7/9/2021 LAURA 7/9/2021 DELIVER CD-VSS3060 1 398.85 BLANC DE GRIS 398.85T CD-VSS3066-AE 3 320.38 BLANC DE GRIS 961.147 WORKSTATIONS CORP DESIGN: 30DX60WX29H (Sg! station group)(Includes: legs, beams, mounting clips, screws and surface) BENCHING- 30"D X 66"W X 29"H (EXT SGL STATION GROUP) (INCLUDES: LEGS, BEAMS, MOUNTING CLIPS, SCREWS AND SURFACE) CORP DESIGN: ACRYLIC DIVIDERS; 24" X 16"H X 0.4" THICK CORP DESIGN: UNDERMOUNT DIVIDER CLIPS - 2X CLIPS FOR END OF RUN 24.4"H X 20"D GREY METAL MOBILE PEDESTAL W/ BLACK CUSHION CD-VAD24 3 98.08 294.24T CD-VDC-VAD-SC-S 3 107.89 323.677 CD-VBBFMP-G-B 4 1,216.20T 304.05 GREY METAL BLACK CUSHION 35.00 512490 4 140.00T CD-611B 6 1.745.82T 290.97 STD CARPET CASTERS: BLK WIRE MANAGEMENT CHANNEL. - BLACK PVC 48"W CORPDESIGN-CONCETTO ERGONOMIC TASK CHAIR. ADAPTIVE MESH BACK, PNEUMATIC SEAT AND HEIGHT ADJUSTMENT, SYNCHRO TILT CONTROL, NYLON BASE WITH CASTERS XS83 1 400.00 400.00T DELIVERY & INSTALLATION DURING BUSINESS HOURS sales tax 8.25% 452.09 WE APPRECIATE THE OPPORTUNITY TO ASSIST YOU WITH YOUR OFFICE FURNITURE NEEDS. TOTAL: $5,932.01 2165.93 2454.08. 512.00
