Can someone fill out the charts?

1. Deivered price to the customer 1157.200 . 2. Residua value 35t, fines te (the purchase price inst tire) 3. a) ine 16lint ?, b) 3a10 4. interent rate 12% 5. inturande: is 6. Property tan116 7. Calculate QearetingiCats 8. Fuel - Unit Price: 52 ib / gallon - Fuel Cansurption: Refer to Hounty Fuel Consunption Tables for HEX D Series 220D2 SID Panther Model (CAT Handbech Page 25-16) Use the avnrage value of the madum ranget Q. Pianned Mainerance 5320 10. Underctiage * Feler io Pege 25-47 (Tuble and Exavole) for 3600 Model - Cendidans Myltpliart Moderale 11. Pepair Cont 55.5 12. Scedial Wear liamo: 51,62 13. Totar Operating Costs Calculate 14. Uachine Owring * Operating Cakzdole 15. Opermar's Houry Wage 930 16. Calcuime the fnal oso dout Model: 14M Motor Grader A. Machine Designation: Wheel Type B. Estimated Ownershp Period: 6 years C. Estimated Usage: 2000 houn per year D. Ownership Usage: Colculate Oevrestho Contr 1. 1a) Delivered price so the customer, $236,800,16 ) Tree Cost $6,600, 1c) Detivered Price - Tire Cost 2. Residual value: 30% times ic (the purchase price less tre) 3. a) line 1cline2, b) 3a/D 4. Interest rate: 123 5. insurance: 1% 6. Property tax: 1% 7. Calculate Qperating Coats 8. Fuel: - Unit Price: \$2.60/ gallon - Fuel Contumption: Reter to Hourly Fuel Consumption Tabies for M Senies 14M Model (CAT Handbook Page 25-11). Use the average value of the medium range 9. Planned Maintenance: $2.85 10. Tre Cost Refer to Page 25-42 for Motor Graders Use the averape value of the estimated tire life on Zone B Recall the tre replacement cost is $6.600 11. Fiepair Cont: 56.50 12. Special Wear hems: 50,00 13. Total Operating Costs Calculale 14. Machine Owning + Operating Calculate 15. Operator's Hourly Wage: $38.0 16. Cakulate the final OsO Cost HOUAIY ONVWTEAND OPERATING COST ESTIMLTF owina costs 1. 1. Dellvered Frice (), 10 the Cystomer (ineluding attachmente) t. LnisTiee Replacenten Cent if desired c Deiveced Price Losstitet 2. Leis Mrsidual Value at Hheplasement (S) ISee tubsection 2A on buck 2. a. Net Value to be recovered through work. Bunte teat tice a) th Cint Per Hour Net Walue. (1) 30B (2) 34an (1) +1+14(7)+1+1= Houreyt BaureYr. N = No. Yri. Houryi: Herisy (Optiand methed when Misurbece cott oer vear is knmen) ins 5 Weryir, hesurir = 25 2 cetiden 46 Estimate #1 Estimate \#2 (1) +1+41 %(2)+1+1 % Hoursir. = Hours/Yr. (Optional method when Property Tax cost per year is known) PropertyTax $ Per Yrr+ Hours /Yrr= 7. TOTAL HOURLY OWNING COST (add lines 3b,4,5 and 6 ) OPERATING COSTS 8. Fuel: (1) (2) Unit Price Consumption x = 9. Planned Maintenance (PM)-Lube Oils, Filters, Grease, Labor: (contact your local Cat dealer). 3.20 2.85 10. a. Tires: Replacement Cost Life in Hours LifeCost (1) Na (2) N/A b. Undercarriage (impact + Abrasiveness +Z Factor) Basic Factor (1) +1+1= x = (2) (n/a+n/a+nn/a)=(Total)n/a(Factor)n/a= 11. Repair Cost (Per Hour) (contact your local Cat dealer). 12. Special Wear Items: Cost Life 8.35 (See subsection 12A on back) 1.62 0.66.50 13. TOTAL OPERATING COSTS (add lines 8, 9, 10a (or 10b), 11 and 12). 14. MACHINE OWNING PLUS OPERATING (add lines 7 and 13) 15. OPERATOR'S HOURLYWAGE (include fringes) 16. TOTAL OWNING AND OPERATING COST SUBSECTION 2A: Residual Value at Replacement Gross Selling Price (est. \#1) (\%) (est. \#2) \%) Less: a. Commission b. Make-ready costs c. Inflation during ownership period* Net Residual Value % \%) of original (Enter on line 2) delivered price "When used equipment auction prices are used to estimate residual value, the effect of inflation during the ownership period should be removed to show in constant value what part of the asset must be recovered through work. SUBSECTION 12A: Special items (cutting edges, ground engaging tools, bucket teeth, etc.) (1) Cost Cost/Hour (2) 1. 120 =0.8 1. 120 +200 2. 130 +500250=0.30.52 2. 3. 150 +500 =0.3 4. = 3. 4. 5. = 5. 6. Total = (1) 1.62 (2) 0.60 (Enter total on line 12)