top of page

Nolan School Gap Analysis
Question 2 of 6:
Price Analysis

Semitrailer vehicle with sophisticated Telematics techology imagery in the background..jpg

Download the Microsoft Excel spreadsheet.

 

​​

A Supplier responds to a agricultural logistics Tender for a Telematics In-Vehicle Monitoring ICT solution. The solution will be installed on its fleet. The Supplier submits a pricing schedule, noting:

​

  • The Customer has a fleet of 54 trailers and 65 tankers.

  • There is a 6-month implementation before operations commence.​

  • No leasing costs occur during implementation.

  • Fleet is projected to ramp-up during the 3-year contract period. 

  • The application requires four Customer Administrators only.​

  • Only 1 Support licence per year for the Customer.

​​​​

​

In your the downloaded spreadsheet, the Supplier’s Total Contract Value is incorrectly stated as $594,318.20 excl. VAT. The TCV should be $473,230.34 excl. VAT.

 

There are 9 mistakes causing the erroneous total. Download the attached Excel spreadsheet. Can you fix the spreadsheet, without adding rows, columns, or cells, and only changing formulas or numbers in-cell, so Total Contract Value is correct? You are not required to submit your corrected spreadsheet. Instead, simply provide the 9 original problem cell numbers (e.g., cell A1).

​

Here is a clue for each problem cell:

 

  • Problem cells #1 and #2 clue: Two similar items need to be swapped.

  • Problem cell #3 clue: Talk about adding extra hours!

  • Problem cell #4 clue: Someone forgot Implementation is half a year.

  • Problem cells #5 and #6 clue: Did we forget that things only get bigger?

  • Problem cell #7 clue: Something wasn’t meant to be counted.

  • Problem cell #8 clue: Are you sure it's per month?

  • Problem cell #9 clue: Careless addition mistake.

​

Answer this question on your Word template.​​

​

bottom of page