大數(shù)據(jù)技術在財務中的應用 固定資產(chǎn)清單

資產(chǎn)編號,資產(chǎn)名稱,類別,單位,使用部門,購置日期,折舊方法,原值,期初累計折舊,使用狀態(tài),狀態(tài)變更時間,預計使用年限,預計殘值率

101001,辦公樓,房屋建筑物,棟,行政部,2018/6/1,年限平均法,8000000,1076666.67,正常使用,,30,0.05

102001,1號倉庫,房屋建筑物,棟,生產(chǎn)部,2018/6/15,年限平均法,1000000,134583.33,正常使用,,30,0.05

102002,2號倉庫,房屋建筑物,棟,生產(chǎn)部,2020/3/10,年限平均法,1000000,79166.67,改建,2022/10/15,30,0.05

103001,1號廠房,房屋建筑物,棟,生產(chǎn)部,2018/6/1,年限平均法,2000000,269166.67,正常使用,,30,0.05

103002,2號廠房,房屋建筑物,棟,生產(chǎn)部,2020/3/25,年限平均法,2000000,158333.33,正常使用,,30,0.05

201001,波峰焊機,生產(chǎn)設備,臺,生產(chǎn)部,2018/6/1,年數(shù)總和法,45000,27593.19,正常使用,,10,0.05

201002,波峰焊機,生產(chǎn)設備,臺,生產(chǎn)部,2018/6/1,年數(shù)總和法,45000,27593.19,正常使用,,10,0.05

201003,波峰焊機,生產(chǎn)設備,臺,生產(chǎn)部,2020/5/5,年數(shù)總和法,45000,16840.91,正常使用,,10,0.05

201004,波峰焊機,生產(chǎn)設備,臺,生產(chǎn)部,2020/5/5,年數(shù)總和法,45000,16840.91,正常使用,,10,0.05

202001,機床,生產(chǎn)設備,臺,生產(chǎn)部,2018/6/1,年數(shù)總和法,100000,61318.19,正常使用,,10,0.05

202002,機床,生產(chǎn)設備,臺,生產(chǎn)部,2018/6/1,年數(shù)總和法,100000,61318.19,正常使用,,10,0.05

202003,機床,生產(chǎn)設備,臺,生產(chǎn)部,2018/6/1,年數(shù)總和法,100000,61318.19,正常使用,,10,0.05

202004,機床,生產(chǎn)設備,臺,生產(chǎn)部,2020/6/15,年數(shù)總和法,100000,36272.73,正常使用,,10,0.05

202005,機床,生產(chǎn)設備,臺,生產(chǎn)部,2020/6/15,年數(shù)總和法,100000,36272.73,正常使用,,10,0.05

202006,機床,生產(chǎn)設備,臺,生產(chǎn)部,2020/6/15,年數(shù)總和法,100000,36272.73,正常使用,,10,0.05

301001,貨車,運輸設備,輛,銷售部,2018/6/15,年數(shù)總和法,80000,58200.00,正常使用,,8,0.03

301002,貨車,運輸設備,輛,銷售部,2019/8/1,年數(shù)總和法,80000,46164.81,正常使用,,8,0.03

401001,計算機,辦公設備,臺,采購部,2018/6/1,年限平均法,6000,4947.00,正常使用,,5,0.03

401002,計算機,辦公設備,臺,采購部,2019/5/12,年限平均法,8000,5173.33,正常使用,,5,0.03

401003,計算機,辦公設備,臺,銷售部,2017/6/1,年限平均法,5000,4850.00,正常使用,,5,0.03

401004,計算機,辦公設備,臺,財務部,2018/6/1,年限平均法,6000,4947.00,正常使用,,5,0.03

401005,計算機,辦公設備,臺,財務部,2018/6/1,年限平均法,6000,4947.00,報廢,2022/10/29,5,0.03

401006,計算機,辦公設備,臺,行政部,2018/6/1,年限平均法,6000,4947.00,正常使用,,5,0.03

401007,計算機,辦公設備,臺,銷售部,2019/5/12,年限平均法,8000,5173.33,正常使用,,5,0.03

401008,計算機,辦公設備,臺,行政部,2019/5/12,年限平均法,8000,5173.33,正常使用,,5,0.03

402001,打印機,辦公設備,臺,行政部,2019/5/12,年限平均法,1200,776.00,正常使用,,5,0.03

402002,打印機,辦公設備,臺,財務部,2018/6/1,年限平均法,1000,824.50,停用,2022/9/30,5,0.03

402003,打印機,辦公設備,臺,采購部,2019/