Checking reports and spreadsheets for wrong totals, broken formulas, mismatched units and figures that do not add up.
Good work shows: Re-adds totals and checks subtotals; spots figures that differ between pages; flags numbers that look out of scale.
Spotting errors in figures is one of the analysis skills on FinderK.
The job simulations and Skill Paths below include work that is checked for this skill. You do the work in an original fictional company and get feedback on it.
A client's finance director has told his board that closing a depot will save 3.04 million pounds a year. Rebuild the savings from the client's own data, tell the steering committee the true number in a deck, and correct it again when a depot manager's figure turns out to be wrong.
Skills: Separate costs that end from costs that move; Build a savings and payback model from client data; Present an unwelcome number answer first; Handle a client sponsor's expectations with evidence; Revise analysis openly when data changes
Assistant restaurant manager at The Gannet Kitchen
About 55 minutes. Included in Plus.
The weekly food cost has jumped from 31 to 40.5 percent and head office sees it on Wednesday. Find what is wrong in the records, query the supplier, and explain what is really driving the cost.
Skills: Check purchases and stock records for errors; Calculate a weekly food cost percentage; Query a supplier politely and within authority; Explain the cause of a cost rise with figures and options