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 to help you answer Question 2. You must not submit the spreadsheet, only answer the questions in the Submission form.

 

​​

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.​​

​

support@nolanschool.com

Whatsapp +61 401 844 406

 

nolanschool

jj

 

Located in Brisbane Australia and fully online.

 

All content © 2024.

​

​

Nolan School of Procurement - Updated logo_2023_3-04.png
  • Facebook
bottom of page