Spreadsheet Supplement for Case UV5969

Canyon Mining intended to purchase four haul trucks to use for heavy mining, and a team from Censeo Consulting Group must to identify a methodology to track cost changes over time for that purchase. The current project's primary objective was to estimate the year-over-year trend in factory manufacturing margins for these four pieces of heavy machinery. These estimates were crucial to Canyon Mining as contracts for heavy machinery lasted for five years and served as a baseline for future negotiations. Although the team arrived at 2008 cost figures for the four haul trucks, it still lacked insight into cost trends and accurate cost forecasting.