Requirement a. (1) (2) Preliminary Balance Expected Value 10/31/2016 10/31/2016 Executive salaries 583,956 Factory hourly payroll 11,100,499 Factory supervisors' salaries 770,600 Office salaries 2,515,983 Sales commissions 2,593,315 Show Transcribed Text Data Table с Audited Balance Preliminary Balance 10/31/2015 10/31/2016 Sales Executive salaries 55,934,900 $ 64,884,484 551,291 583,956 Factory hourly payroll 10,603,817 11,100,499 Factory supervisors' salaries 729,582 770,600 Office salaries 2,395,865 2,515,983 Sales commissions 2,503,913 2,593,315 Please show all accurate calculations for requirements a. and b. You have obtained the following information to help you perform preliminary analytical procedures for the payroll account balances. 1. There has been a significant increase in the demand for Tides In's products. The increase in sales was due to both an increase in the average selling price of four percent and an 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. 4. 5. All employees including executives, but excluding commission salespeople, received a three percent salary increase starting November 1, 2015. Commission salespeople receive their increased compensation through the increase in sales. 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. Tides Indoes not permit overtime. Commission salespeople receive a six percent commission on all sales on which a commission is given. Approximately 65 percent of sales earn sales commission. The other 35 percent are "call-ins," for which no commission is given. Commissions are paid in the month following the month they are earned. Requirements Use the final balances for the prior year and the information in items 1 through 5 to develop an expected value for each account, except sales. (Round to the nearest whole dollar.) b. Calculate the difference between your expectation and the client's recorded amount as a percentage using the formula (expected value-recorded amount)/expected value. (Round to the nearest hundredth percent, X.XX%.)