Penguin Network Warehouses, LLC (PNW, LLC) is a start-up warehousing and logistics company providing grocery stores...

Transcribed Image Text:

Penguin Network Warehouses, LLC ("PNW, LLC") is a start-up warehousing and logistics company providing grocery stores with climate-controlled storage and just-in-time delivery of perishable goods nationwide. PNW, LLC has 10 Regional Offices with the Corporate Headquarters being in Region 5, Chicago. Each Regional Office makes tangible personal property purchases based on the needs of each location and performs the data entry exercise of entering the purchase information into a central system for fixed asset tracking and depreciation purposes. Corporate has negotiated bulk pricing arrangements with its primary suppliers. Each Regional Office purchases the similar tangible personal property from three primary suppliers as follows: Gentoo Refrigeration supplier of commercial cooling machinery and equipment Magellanic Resources - supplier of computers and peripheral equipment used to manage logistics Emperor Office Furniture - supplier of office furniture and fixtures Ms. Humboldt, the Corporate Tax Analyst, has exported the data from the central system and has created the following Tableau visualization. Penguin Network Warehouses, LLC MACRS Depreciation Year 1 Regional Office $2,000,000 $1,800,000 $1,600,000 III Supplier (All) ✔ Emperor Office Furn... ✔Gentoo Refrigeration ✔ Magellanic Resources ... Penguin Network Warehouses, LLC MACRS Depreciation Year 1 MACRS Tax Depreciation Year 1 $2,000,000 $1,800,000 $1,600,000 $1,400,000 $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 $0 Atlanta +ableau Regional Office Kansas Cit New York City Philadelphia San Francisc Supplier ✓(All) ✔Emperor Office Furn... ✔Gentoo Refrigeration ✓Magellanic Resources Regional Office ✓(All) ✔Atlanta ✔Boston ✔Chicago ✔Dallas ✔Denver ✔Kansas City ✔New York City ✔Philadelphia ✔San Francisco ✔Seattle +ableau K New PH Sar → KL 70 As typical of a start-up business, PNW, LLC expects to generate a current year loss with regular deprecation. As such, PNW, LLC does not elect Section 179 depreciation and elects out of bonus depreciation. PNW, LLC qualifies for the half year convention. Required: 1. How much depreciation is reported by Philadelphia Region 3 on assets purchased from Magellanic Resources? 2. How much depreciation is reported by Kansas City Region 7 on assets purchased from Magellanic Resources? 3. What asset class life was used by Kansas City Region 7 on assets purchased from Magellanic Resources? 4. Did Kansas City Region 7 under or over report depreciation on assets purchased from Magellanic Resources? 5. What is the correct depreciation for Kansas City Region 7 on assets purchased from Magellanic Resources? Penguin Network Warehouses, LLC ("PNW, LLC") is a start-up warehousing and logistics company providing grocery stores with climate-controlled storage and just-in-time delivery of perishable goods nationwide. PNW, LLC has 10 Regional Offices with the Corporate Headquarters being in Region 5, Chicago. Each Regional Office makes tangible personal property purchases based on the needs of each location and performs the data entry exercise of entering the purchase information into a central system for fixed asset tracking and depreciation purposes. Corporate has negotiated bulk pricing arrangements with its primary suppliers. Each Regional Office purchases the similar tangible personal property from three primary suppliers as follows: Gentoo Refrigeration supplier of commercial cooling machinery and equipment Magellanic Resources - supplier of computers and peripheral equipment used to manage logistics Emperor Office Furniture - supplier of office furniture and fixtures Ms. Humboldt, the Corporate Tax Analyst, has exported the data from the central system and has created the following Tableau visualization. Penguin Network Warehouses, LLC MACRS Depreciation Year 1 Regional Office $2,000,000 $1,800,000 $1,600,000 III Supplier (All) ✔ Emperor Office Furn... ✔Gentoo Refrigeration ✔ Magellanic Resources ... Penguin Network Warehouses, LLC MACRS Depreciation Year 1 MACRS Tax Depreciation Year 1 $2,000,000 $1,800,000 $1,600,000 $1,400,000 $1,200,000 $1,000,000 $800,000 $600,000 $400,000 $200,000 $0 Atlanta +ableau Regional Office Kansas Cit New York City Philadelphia San Francisc Supplier ✓(All) ✔Emperor Office Furn... ✔Gentoo Refrigeration ✓Magellanic Resources Regional Office ✓(All) ✔Atlanta ✔Boston ✔Chicago ✔Dallas ✔Denver ✔Kansas City ✔New York City ✔Philadelphia ✔San Francisco ✔Seattle +ableau K New PH Sar → KL 70 As typical of a start-up business, PNW, LLC expects to generate a current year loss with regular deprecation. As such, PNW, LLC does not elect Section 179 depreciation and elects out of bonus depreciation. PNW, LLC qualifies for the half year convention. Required: 1. How much depreciation is reported by Philadelphia Region 3 on assets purchased from Magellanic Resources? 2. How much depreciation is reported by Kansas City Region 7 on assets purchased from Magellanic Resources? 3. What asset class life was used by Kansas City Region 7 on assets purchased from Magellanic Resources? 4. Did Kansas City Region 7 under or over report depreciation on assets purchased from Magellanic Resources? 5. What is the correct depreciation for Kansas City Region 7 on assets purchased from Magellanic Resources?