The accompanying spreadsheet model, which is designed to compute commissions and salaries, contains some errors.
a. Use the model auditing tools and techniques to identify the errors. Are the errors due to circular reference, incorrect cell reference, or invalid user inputs?
b. Repair the spreadsheet so that it produces correct outcomes. What is the total salary for Larry Anderson? What is the commission for Sunil Gupta?

 

Commision Calculator
Employee ID	First name	Last name	Job classification	Jan Sales	Base Salary	Commission	Total Salary
1001	Mary	Stevens	Senior Sales Rep	$ 85,000	$ 3,000.00	$ 6,800.00	$ 9,800.00
1002	Larry	Anderson	Sen. Sales Rep.	$ 72,000	$ -	$ -	$ -
1003	Sunil	Gupta	Junior Rep	$ 35,000	$ -	$ -	$ -
1004	Sarah	Ellis	Junior Sales Rep	$ 61,500	$ -	$ -	$ -
1005	Timothy	Chau	Trainee	$ 48,000	$ -	$ -	$ -
Base Salary and Commission Rates
Title	Base Salary	Commission Rates
Senior Sales Rep	$ 3,000.00	8%
Junior Sales Rep	$ 2,000.00	6%
Trainee	$ 2,500.00	0%