Question : The purchase price of an excavator is $225,200, excluding : 2152208
ESSAY. Write your answer in the space provided or on a separate sheet of paper.
1) The purchase price of an excavator is $225,200, excluding sales tax and deliver. Delivery is $5,500 and sales tax is 7.2% of the purchase price (excluding delivery). The expected useful life of the excavator is 10 years. At the end of its useful life, the excavator is expected to have a salvage value of $10,000. It is expected that the excavator will be used 1,500 hours per year. Using an interest rate of 7.5%, determine the hourly depreciation and interest cost for the excavator.
2) The annual taxes for an excavator are $2,150, the annual insurance is $2,780, and the monthly storage cost is $350. Determine the hourly taxes, insurance, and storage costs for the excavator if it is used 1,200 hours per year.
3) A set of cutters for a cold planer cost $4,200 and last an average of 95 hours. Determine the hourly cost of the cutter for the cold planer.
4) The tires for a front - end loader cost $8,900 for all four tires. The loader is used 1,600 hour per year and the estimated life of the tires is 4,000 hours. Using a repair multiplier of 15% and an interest rate of 7.5%, determine the hourly cost of the tires, including tire repair.
5) An excavator consumes 3.9 gallons of fuel per hour. Determine the hourly fuel cost for the excavator if fuel cost $3.75 per gallon.
6) For an off - road dump truck, it is estimated that under normal conditions its hourly lubricant consumptions are as follows: crankcase, 0.011 gal/hr; transmission, 0.007 gal/hr; final drives including differential, 0.006 gal/hr; and hydraulic controls, 0.008 gal/hr. A tube of grease is used during each 8 - hour day to lubricate the grease fittings. The local costs of lubricants are as follows: oil for the crankcase, $28.00/gal; transmission fluid, $19.00/gal; oil for the final drives, $31.00/gal; hydraulic fluid, $9.00/gal; and grease, $5.00/tube. The filters for the truck cost $0.50 per hour of operation including the labor to install.
7) Excel Quick Tip 22 - 1: Equipment Cost Worksheet
The purchase price of the hydraulic excavator, including sales tax and all other costs associated with its purchase, is $150,000. The life of the excavator is 6 years, at which time it will have an estimated salvage value of $20,000. The interest rate is 8.25%. The taxes and licensing costs are $3,220 per year, the insurance costs are $2,930 per year, and the storage costs are $2,110 per year. The fuel consumption is estimated to be 3.0 gallons per hour at an estimated cost of $3.50 per gallon. It is estimated that under normal conditions, its hourly lubricant consumptions are as follows:
• Crankcase, 0.008 gallons per hour
• Final drives, 0.001 gallons per hour
• Hydraulic controls, 0.021 gallons per hour
• One tube of grease is used during each 8 - hour day to lubricate the grease fittings.
The local costs of lubricants are as follows:
• Oil for the crankcase,$7.43 per gallon
• Oil for the final drives, $8.99 per gallon
• Hydraulic fluid, $3.56 per gallon
• Grease, $4.01 per tube
The filters for the excavator cost $0.25 per hour of operation, including the labor to install them. The estimated repair reserve is $4.20 per hour. Using 1,400 billable hours per year, determine the hourly ownership and operation cost of the excavator.
8) An excavation crew consists of a hydraulic excavator, four dump trucks, an equipment operator, and four truck drivers. The cost of a hydraulic excavator is $120 per hour and a truck costs $85 per hour. The operator cost $42 per hour and a truck driver costs $35 per hour. All labor rates include burden. The crew works four 10 - hour days per week. Determine the average cost of labor per labor hour and the equipment cost per labor hour for the excavation crew.
9) Excel Quick Tip 23 - 1: Crew Rate Worksheet
An excavation crew consists of a hydraulic excavator, five dump trucks, a foreperson, an excavator operator, and five truck drivers. The cost of the hydraulic excavator is $95.00 per hour and the trucks cost $62.00 per hour. The foreperson costs $27.50 per hour, the operator costs $21.00 per hour, and a truck driver costs $17.00 per hour. Labor costs include labor burdens. All employees work an eight hour day. Determine the average labor cost per labor - hour and the equipment cost per labor - hour for the excavation crew.
10) A recent project included a 21,000 - square foot warehouse with tilt - up concrete panel exterior. The electrical for the warehouse was subcontracted for $199,550. Determine the subcontractor's bid per square foot of warehouse.
11) A recent project included a 21,000 - square - foot warehouse with tilt - up concrete panel exterior. The roofing for the warehouse was subcontracted for $41,500. Using the data from this recent project, determine the estimated cost to roof a 23,500 - square - foot warehouse.
12) Using the building permit costs in Table 25 - 1, determine the building permit cost for a project valued at $852,624.
13) Using the bond costs in Table 25 - 2, determine the bonding cost for a project bid at $852,624.
14) The estimated construction cost for a project is $852,624. The company's profit and overhead markup is 7.5% of construction cost. Determine the profit and overhead markup.
15) A construction project has the following estimated costs: materials, $45,245; labor $52,175; equipment, $7,384; and subcontractor, $110,854. Your boss wants to markup the materials, labor, and equipment 12% and markup the subcontractor costs 4%. Determine the profit and overhead markup for the project.
16) Your construction company recently bid against ABC Construction Company. Your construction costs were $355,271, and you added a 7% profit and overhead markup for a total bid of $380,140. ABC's bid was $382,624. What profit and overhead markup would you need to add to your construction costs to match ABC's bid?
17) Excel Quick Tip 25 - 1: Building Permit Cost Worksheet
Determine the building permit costs for a project valued at $523,625 using the rates in Table 25 - 1.
18) Excel Quick Tip 25 - 2: Bond Cost Worksheet
Determine the bond cost for a project valued at $523,625 using the rates in Table 25 - 2.
19) Excel Quick Tip 25 - 3: Competitor Tracking Worksheet
Enter the following bid data into the competitor tracking worksheet for the 9th Street Improvements, which bid on July 14, 2017. You company's cost for the project were $3,205,962.
20) Complete the following detailed worksheet.