How do I make an expense schedule?

/viewthread.php?tid=4419See if this helpsSchedule 1: Breakdown of Cigarette Logistics Costs for Commercial Enterprises in the Tobacco Industry Prepared by: Table of Contents: Date of Submission: Month of the Year Unit: Yuan Item No. of items Accumulated item No. of items Accumulated item No. of items Accumulated item No. of items A. Total Logistics Costs B. Supplementary Information: (1) Subtotal of Warehousing and Sorting Costs (1) Total of Logistics Capital Inputs ( Including construction in progress) 1, warehousing, sorting labor costs 1, buildings of which: warehousing, sorting staff wages and benefits 2, machinery and transportation equipment category subtotal 2, storage costs ① Shelving, stacking machines 3, packaging costs ② Sorting equipment 4, merchandise loss ③ large screen monitoring equipment 5, loading and unloading costs ④ Warehouse electric forklift, manual forklift 6, other costs ⑤ Warehouse coding machine, inkjet printer (2) Subtotal of distribution costs (6) Computer and equipment 1, distribution staff labor costs (7) Control cabinets and equipment of which: distribution staff wages and benefits (8) Transportation equipment 2, transportation costs of which: storage vehicles 3, fuel costs delivery trucks 4, road and bridge tolls 3, intangible asset inputs 5, other costs of which: the right to use the land (3) Subtotal of administrative expenses Software costs 1, the management personnel's labor costs (4) Other capital inputs of which: management personnel wages and benefits (2) Logistics expenses Salary and welfare costs (b) logistics cost analysis indicators 2, depreciation 1, total business assets (yuan) which: vehicle depreciation 2, sales volume (box) 3, taxes and fees 3, total profit (yuan) 4, amortization of intangible assets 4, the average inventory balance (yuan) 5, utilities 5, inventory turnover (times) 6, communication costs 6, inventory stock per unit area (box / square meter) 7, travel costs 7, single box Logistics costs (yuan/case) 8, office expenses 8, single-case warehousing and sorting costs (yuan/case) 9, business hospitality 9, single-case distribution costs (yuan/case) 10, amortization of low-value consumables 10, single-case management costs (yuan/case) 11, management vehicle costs 11, single-case depreciation of vehicles (yuan/case) Of which: Fuel costs 12, cumulative investment in capital for cigarette logistics in proportion to the total assets ratio of the % road tolls and bridge tolls 13, Logistics cost rate % Road maintenance fee 14, Logistics cost margin % 12, Repair costs 15, Logistics vehicle number of which: vehicle repair costs 16, Total monthly mileage of the vehicle (km) 13, Lease fee 17, Storage area (square meters) 14, Insurance premiums of which: Vehicle insurance premiums 15, Labor protection fee 16, Other costs Remarks: 1, Inventory stock per unit area (box / square meter) = Inventory stock per unit area (box/square meter) = inventory stock at the end of the period ÷ warehouse floor area 2. Logistics cost per box (yuan/box) = logistics cost at the end of the period ÷ sales at the end of the period 3. Warehousing and sorting cost per box (yuan/box) = warehousing and sorting cost at the end of the period ÷ sales at the end of the period 4. Distribution cost per box (yuan/box) = distribution cost at the end of the period ÷ sales at the end of the period 5. Management expense per box (yuan/box) = management expense at the end of the period ÷ sales at the end of the period 6. Vehicle depreciation (yuan/case) = Vehicle depreciation expense ÷ End of period sales quantity 7. Cigarette logistics capital investment in total assets = Cigarette logistics capital investment ÷ Total assets of the enterprise at the end of the period × 100% 8. Logistics expense ratio = Logistics expense ÷ End of period sales revenue × 100% 9. Logistics expense profit ratio = Total profit ÷ Logistics expense × 100%