| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
1 | Machine Rate Logging Cost Spreadsheet (6-18-02 beta version) | |||||
2 | Contact: ipetaisto@fs.fed.us or 970-870-2164 for more info or questions | |||||
3 | ||||||
4 | PURPOSE: | |||||
5 | This Excel program was designed to quickly estimate logging costs by entering machine data (from Appendix B and other | |||||
6 | research studies) and production estimates (from contractors or contract administrators). A machine rate worksheet in Machine | |||||
7 | Rates for Selected Forest Harvesting Machines (Brinker, R.W., etal., 2002) was modified to calculate stump-to-truck costs | |||||
8 | for a complete logging operation with multiple machines. | |||||
9 | ||||||
10 | ||||||
11 | INTRODUCTION: | |||||
12 | Logging cost is basically the total costs (stump-to-truck) divided by total production for a given periof of time. In most logging | |||||
13 | operations, the major cost components are labor and equipment. A percentage for profit and risk and administrative costs | |||||
14 | may be added and haul costs are usually calculated seperately. | |||||
15 | ||||||
16 | Production | |||||
17 | Truck numbers and volumes can be tracked to determine a logger's average production: loads per time period, loads per unit, | |||||
18 | volume per load, logs per load, and volume by species. Since production is the denominator in logging cost (total cost$ / total | |||||
19 | volume or tons per time period), production values (average loads per day, average volume per load, maximum weight per load, | |||||
20 | volume by species, and average wood density or lbs./CF) need to be as accurate as possible. The denominator (production) | |||||
21 | obviously has a huge impact on the numerator (costs). | |||||
22 | ||||||
23 | Cost Components | |||||
24 | 1) The labor component is the employer's payroll and normally includes wages and fringe benefits (workers' compensation | |||||
25 | insurance, State and federal unemployment tax, and social security tax). Although wage rates and benefits are usually | |||||
26 | assumed for a region, research may indicate that local rates are much higher or lower than the regional average. | |||||
27 | ||||||
28 | 2) The equipment component is the other major cost component in logging cost analyses. Ownership and operating costs | |||||
29 | are usually calculated by the machine rate method. Ownership costs, also known as fixed costs, include: depreciation, | |||||
30 | insurance, interest, and taxes. Since fixed costs occur whether a machine is idle or operating, they are usually associated | |||||
31 | with "scheduled hours" per year. Operating costs, also known as variable costs, include: fuel, lubrication, oil, repair, | |||||
32 | maintenance, tire-track-wire-rope replacement, and other costs. Since operating costs vary in proportion to equipment use, | |||||
33 | they are usually based on "productive hours". | |||||
34 | ||||||
35 | A clear distinciton must be made between "scheduled" vs. "productive" time. Scheduled machine hours (SMH) are the hours | |||||
36 | per year (typically 250 days x 8 hours per day = 2000 SMH) that the machine is scheduled to perform productive work. | |||||
37 | Productive machine hours (PMH) are the hours of scheduled time when the machine is in actual operation. The relationship | |||||
38 | between productive time and scheduled time is expressed as a utilization percentage. For example, a feller-buncher may be | |||||
39 | scheduled for 2000 hours per year but due to operational delays (moving, repair, weather, fire, etc.), its productive time | |||||
40 | is estimated at 1200 hours per year. In this case, the machine's annual utilization rate is PMH/SMH or 1200/2000 = 60%. | |||||
41 | ||||||
42 | Assumptions | |||||
43 | Although the machine rate method is widely used, it may not match the actual site-specific cost due to many assumptions: | |||||
44 | - machine life is an average by machine category (not for an individual machine) | |||||
45 | - salvage value is a percent of initial purchase cost | |||||
46 | - interest, insurance, and taxes are a percentage of average annual investmetn | |||||
47 | - repair and maintenance is a percentage of depreciation | |||||
48 | - scheduled hours is an average per year by machine category | |||||
49 | - productive hours is an average per year by machine category | |||||
50 | ||||||
51 | NOTE: Machine life and purchase price have the most significant effect on a machine's hourly rates. |