The accompanying spreadsheet model, which is designed to analyze profits, contains an error.
a. Use the model auditing tools to identify the error. Is the error due to circular reference, incorrect cell reference, or invalid user inputs?
b. To ensure that the user of the spreadsheet model enters a valid quantity amount, set a validation rule for users to only enter a positive whole number lower than 50,000. Show an error message when the user violates the rule.

 

Assumptions:
Fixed cost:	$ 5,000.00
Material costs per item:	$ 2.25
Labor costs per item:	$ 6.50
Shipping costs per 100 items:	$ 200.00
Price per item:	$ 12.99
Quantity:	2000
Outputs:
Total revenues:	$ 25,980.00
Total costs:	$ 26,500.00
Total profits:	$ -