Question

Industrial Solutions Payroll

You are auditing the payroll for Industrial Solutions for the year ended April 30, 2018. Below are the amounts from the client’s trial balance, along with the client’s 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 client’s reported total payroll expenses.

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

Enter your answer with no commas and no decimal places and no dollar sign

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

Answer 1

Solution:

Given that:

  
nswer qiven har The botowin inmation abou he Solution Patl nfa a Solutions Aud e Pa te ea endedAprti 30 2.018 ticars Amount (*) 4,4 364 102, 631, 468 12, 315, 816 tlo5 2.18 Sales 2018 t Sale o2013 increaie in áalea due to both - Encreating in Slue to increastng Selln preu {02, 632、 't68.x4./ increase in sale lue to uantare 8.210, 59구 Increase sales due to uantity! 8) 210, s44 sales c -. 201쿠 ar new Preca. Leve | 06, 33, 64 [↓ 2 63 2 468 1041 , 69 231 у.

Executtve Salooie Valuu x 3 | I' | 26696-5 03.8& O 32816 4 149.5 , 61 ,1775 Emple20, 077,54 602332420, 6800 2 0, 6goo 86.62 20,680, ot6. 62 + 2.0, 680、0866×ㅋ . 69 231 み3, 270, 862.99 86, 211, 23 Sale commission . o above mtr, 4, 310, 56 3.6

balan rend Dihjcreni Valua Executive salate 4 12.31,940 | ,124676 05243-91 .3уу 2 22 1S2, 638 OU又 8C3 (68RA*)| 3,04% emploee 1621ノ 16 618 alau e aler commissior isso432y4, 31025 3603 7.87