Elm Manufacturing Company $($ELM$)$ is a small manufacturer of back packs located in Rochelle, Illinois.

ELM has three bulldings, all on one property. First, they own a manufacturing plant, where all the backpacks are

manufactured and product repairs are made. All raw materlals are also stored at the manufacturing plant. Second, they

own a warehouse where all finished goods are stored and products are shipped to customers. Finally, they own a small

office bullding where they conduct their operations, Including processing of orders, purchases, as well as all managerial

activities. The company also provides company cars to several employees and has the expected manufacturing

equipment, furniture and fixtures. Some of the relevant information related to property, plant and equipment for ELM is

below.

ELM uses the straight IIne method of depreclation for all property, plant and equipment.ELM calculates depreclation as if

the asset was purchased on the $1$st day of the month it was purchased in$.$ ELM has a $3/31$ year end. For example, an asset

purchased in May, $2018$ would have $11$ months of depreciation in fiscal $2019($ending March $31,2019)$ and $12$ months of

depreclation for fiscal $2020.$ In the final year of useful life, one month of depreciation would be recognized.

ELM assigns each asset purchased a unique ASSETNO for tracking purposes. The number is assigned as Asset Class

Number, followed by the sequentlal item number for that asset class. For example, the first bullding would be ASSETNO

The $999$th furniture and fixture purchased by ELM would be $5999$ and the $1000$th would be $51000.$ ELM does not

remove assets from the register, but it does note them as retired once they are no longer in service.

You have access to the following data:

ELM PEE Data file

The following is a data dictionary IIsting the column names, descriptions and field types in the Flxed Asset Register