Industrial Solutions Payroll

You are auditing the payroll for Industrial Solutions for the year ended April 30, 2018. Below are the amounts from the clients trial balance, along with the clients comparative audited information from the prior year.

	Audited Balance 4/30/2017	Unaudited Balance 4/30/2018
Sales	$ 102,632,468.00	$ 114,948,364.00
Executive Salaries	$ 1,093,880.00	$ 1,231,940.00
Factory hourly payroll	$ 20,077,754.00	$ 22,952,638.00
Factory Supervisors salaries	$ 1,571,650.00	$ 1,621,176.00
Office Salaries	$ 3,980,592.00	$ 4,110,604.00
Sales Commissions	$ 4,036,298.00	$ 4,735,924.00

You have obtained the following information to help you perform analytical procedures for the payroll account balances

1. There has been significant increase in the demand for Industrial Solutions products. The increase in sales was due to both an increase in the average selling price of four percent and increase in units sold that resulted from the increased demand and an increased marketing effort.
2. Even though sales volume increased, there was no addition of executives, factory supervisors, or office personnel.
3. All employees including executives, but excluding commission salespeople, received a three percent salary increase starting May 1, 2017. Commission salespeople receive their increased compensation through the increase in sales
4. The increased number of factory hourly employees was accomplished by recalling employees that had been laid off. They receive the same wage rate as existing employees. Industrial Solutions does not permit overtime.
5. Commission salespeople receive a five percent commission on all sales on which a commission is given. Approximately 75% of sales earn sales commission. The other 25% are call-ins, for which no commission is given. Commissions are paid in the month following the month they are earned.

Required

Perform analytical procedures by answering the questions in Canvas to ascertain whether the 2018 payroll account has been fairly stated.

Calculate your tolerable misstatement using 2% of the clients reported total payroll expenses.

Answer the following questions based on given information and Round all you answers to the nearest whole number.

Question 1

Develop and expectation for Executive Salaries.

Question 2

Develop and expectation for Factory hourly payroll

Question 3

Develop and expectation for Factory Supervisors' Salaries

Question 4

Develop and expectation for Office Salaries

Question 5

Develop and expectation for Sales Commissions

Question 6

What is the total misstatement?

Question 7

What is the tolerable misstatement?

Question 8

What is your conclusion on the total payroll amount?

Fairly Stated

Materially Misstated