Here it is.

Here it is.

You are auditing payroll for the Vineyard Technologies company for the year ended October 31, 2018. Induued next are arounils from the client's trial bance, along with comparative audited information for the prior year. Click the icon lo view the amounts from the trial balance.) Cick the icon to view the actional information! Requirements a. Use the final balance for the prior year and the information in ileris 1 througl 5 to develop an expected value for each account, excel sales. Round lo lhe real whole collar.) b. Calculate the difference between your expectation and the client's recorded amount a parcentage using the famula (expected value-ronorded amountyexpected value. (Round in the nearest hundredth percent, X.XX%. Nole 1: When compuing the expected value of factory hourly payrol, you must lake into consideration both the 2% wage increase and the 8% balance to determne the expected value for sales corrmissions on 10/31/2016.) r ou in the number of uris proud and cold. Nolu 2. Use the increase in the 10/31/2018 preliminary se balance over the 10/31/2015 audied sales Requirement a. Requirement b. i Data Table - X 0 More Infu Dilarance AAA Percentage Executive salaries Factory hourly payroll (SR Note 1) Factory supervisor'laries cc salarcs Bales commissionerse Note 2 Preliminary BALANCA 10/31/2018 576,666 11,405,677 829,583 2,094,585 2.829.500 Expected Value 10/31/2016 511.987 11,099.490 813 038 1,967.797 3,880 685 Audited Balance Preliminary Balance 10/31/2015 10/31/2016 BAAR 54.008.200 $ 58.870.028 Executive salaries 501,948 576,006 Factory hourly payroll 10.210,956 11,405,687 Factory supervisors' salaries 797,066 829,583 Otice solares 1.94,421 2,894,55 Sales commissione 2.950,799 2.829.500 Sales have increased 9% over prior your 3% percent of that is due to an increase in the average saling price. The remaning 6% is attributed to an Increase in the number of units sold. You have obtained a folkring Information to help you perform prelminary analytical procedures for Uw payroll count balances 1. There has been a significant increase in re era for Vineyards products. The increase in sales was due to both an increase in the average selling price of the percent and an ncrease in urits said that resulted from the increased demand and an increased Marketing Affort 2. Even thouah sulas voluminoased there was no addition of executives, factory superviso, cr attice personnel S. Al uployees inducing executives, Luteaduviny COTTBion salespeople, received a tal percent valury increase stang November 1, 2015 Commission salescopic recarve their increased nampensation through the 4. The increased number of factory hourly employees wee accurrplished by recalling cmployces that had been laid olt. They receive the same wage rate AS Axisting employees. Vineyard does not permit certima. Comunisxian salespeople receive a ten percent Commission on al sales an which a commissian is given. Approximately 10 percent of sales ca salcs commission. The other 20 percent Ara cal-rs." for which no commission is given. Cornmissions are paid in a month folowing the month they are earnec. Print Done Print Done Review Homework: 6.5 Lab Score: 377 10 pes P15-34 (similar to) For the brand m a ny organi c has decided to es poden hingg a me to be bed You are auditing payroll for the Vineyard Technologies company for the year ended October 31, 2018. Induued next are arounils from the client's trial bance, along with comparative audited information for the prior year. Click the icon lo view the amounts from the trial balance.) Cick the icon to view the actional information! Requirements a. Use the final balance for the prior year and the information in ileris 1 througl 5 to develop an expected value for each account, excel sales. Round lo lhe real whole collar.) b. Calculate the difference between your expectation and the client's recorded amount a parcentage using the famula (expected value-ronorded amountyexpected value. (Round in the nearest hundredth percent, X.XX%. Nole 1: When compuing the expected value of factory hourly payrol, you must lake into consideration both the 2% wage increase and the 8% balance to determne the expected value for sales corrmissions on 10/31/2016.) r ou in the number of uris proud and cold. Nolu 2. Use the increase in the 10/31/2018 preliminary se balance over the 10/31/2015 audied sales Requirement a. Requirement b. i Data Table - X 0 More Infu Dilarance AAA Percentage Executive salaries Factory hourly payroll (SR Note 1) Factory supervisor'laries cc salarcs Bales commissionerse Note 2 Preliminary BALANCA 10/31/2018 576,666 11,405,677 829,583 2,094,585 2.829.500 Expected Value 10/31/2016 511.987 11,099.490 813 038 1,967.797 3,880 685 Audited Balance Preliminary Balance 10/31/2015 10/31/2016 BAAR 54.008.200 $ 58.870.028 Executive salaries 501,948 576,006 Factory hourly payroll 10.210,956 11,405,687 Factory supervisors' salaries 797,066 829,583 Otice solares 1.94,421 2,894,55 Sales commissione 2.950,799 2.829.500 Sales have increased 9% over prior your 3% percent of that is due to an increase in the average saling price. The remaning 6% is attributed to an Increase in the number of units sold. You have obtained a folkring Information to help you perform prelminary analytical procedures for Uw payroll count balances 1. There has been a significant increase in re era for Vineyards products. The increase in sales was due to both an increase in the average selling price of the percent and an ncrease in urits said that resulted from the increased demand and an increased Marketing Affort 2. Even thouah sulas voluminoased there was no addition of executives, factory superviso, cr attice personnel S. Al uployees inducing executives, Luteaduviny COTTBion salespeople, received a tal percent valury increase stang November 1, 2015 Commission salescopic recarve their increased nampensation through the 4. The increased number of factory hourly employees wee accurrplished by recalling cmployces that had been laid olt. They receive the same wage rate AS Axisting employees. Vineyard does not permit certima. Comunisxian salespeople receive a ten percent Commission on al sales an which a commissian is given. Approximately 10 percent of sales ca salcs commission. The other 20 percent Ara cal-rs." for which no commission is given. Cornmissions are paid in a month folowing the month they are earnec. Print Done Print Done Review Homework: 6.5 Lab Score: 377 10 pes P15-34 (similar to) For the brand m a ny organi c has decided to es poden hingg a me to be bed