I attached the file with questions
COM204.CI003&CI004. COM204.CI003&CI004. 2020 FallAssignment #4 (Ch6)Due on November 7 Q1. Assume Milne’s Moving & Storage Ltd. (MMS) of Regina, Saskatchewan, incurred the following costs in acquiring land, making land improvements, and constructing and furnishing its own storage warehouse: Assume MMS depreciates buildings over 40 years, land improvements over 20 years, and furniture over 8 years, all on a straight-line basis with zero residual value. Requirements: · Set up columns for Land, Land Improvements, Warehouse, Office Building, and Furniture. Show how to account for each of MMS’s costs by listing the cost under the correct account. Determine the total cost of each asset, using the form given below. · Assuming that all construction was complete, and the assets were placed in service on September 1, 2017, record depreciation for the year ended December 31, 2017. Round to the nearest dollar. Q2. Assume that Inter-Provincial Transport Ltd.’s balance sheet includes the following assets under Property, Plant, and Equipment: Land, Buildings, and Motor-Carrier Equipment. Inter-Provincial has a separate accumulated depreciation account for each of these assets except land. Further, assume that Inter-Provincial completed the following transactions in 2019: Jan. 3 Sold motor-carrier equipment with accumulated depreciation of $67,000 (cost of $130,000) for $71,000 cash. Purchased similar new equipment with a cash price of $176,000. July 2 Sold a building that had cost $650,000 and had accumulated depreciation of $145,000 through December 31 of the preceding year. Depreciation is computed on a straight-line basis. The building had a 40-year useful life and a residual value of $250,000. Inter-Provincial received $100,000 cash and a $400,000 note receivable. Oct. 29 Purchased land and a building for a single price of $420,000. An independent appraisal valued the land at $150,000 and the building at $300,000. Dec. 31 Recorded depreciation as follows: · New motor-carrier equipment has an expected useful life of six years and an estimated residual value of 5% of cost. Depreciation is computed on the double-diminishing-balance method. · Depreciation on buildings is computed by the straight-line method. The new building carries a 40-year useful life and a residual value equal to 10% of its cost. Requirements: · Record the transactions in Inter-Provincial Transport Ltd.’s journal. · How does management choose which depreciation method to use? Q3. On January 3, 2016, B.W. Soffer Inc. paid $224,000 for a computer system. In addition to the basic purchase price, the company paid a setup fee of $6,200, $6,700 sales tax, and $3,100 for special installation. Management estimates that the computer will remain in service for five years and have a residual value of $15,000. The computer will process 50,000 documents the first year, decreasing annually by 5,000 during each of the next four years (that is, 45,000 documents in 2017, 40,000 documents in 2018, and so on). In trying to decide which depreciation method to use, the company president has requested a depreciation schedule for each of three depreciation methods (straight-line, units-of-production, and double-diminishing-balance). Requirement: · Follow the EXCEL sheet given on “Course Plan” to compute depreciation by three methods. a. Purchase price of 4 acres of land, including an old building that will be used for an office (land fair value is $320,000, building fair value is $80,000) $350,000 b. Landscaping (additional dirt and earth moving) 8,100 c. Fence around the land 31,600 d. Lawyer fee for title search on the land 1,000 e. Delinquent real estate taxes on the land to be paid by MMS 7,500 f. Company signs at front of the company property3,400 g. Building permit for the warehouse1,500 h. Architect fee for the design of the warehouse24,500 i. Masonry, carpentry, roofing, and other labour to construct the warehouse920,000 j. Renovation of the office building50,200 k. Interest cost on construction loan for warehouse 9,700 l. Landscaping (trees and shrubs)8,200 m. Parking lot, concrete walks, and lights on the property 57,600 n. Concrete, wood, and other materials used in the construction of the warehouse234,300 o. Supervisory salary of construction supervisor (85% to warehouse, 5% to land improvements, 10% to office building) 60,000 p. Office furniture115,700 q. Transportation and installation of furniture2,300 LandLand ImprovementWarehouseOffice BuildingFurniture a b c d e f g h i j l m n o p q Total: