Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are auditing payroll for the Drop Line Technologies company for the year ended October 31, 2019. Included next are amounts from the client's trial

image text in transcribed

image text in transcribed

image text in transcribed

You are auditing payroll for the Drop Line Technologies company for the year ended October 31, 2019. Included next are amounts from the client's trial balance, along with comparative audited information for the prior year. (Click the icon to view the amounts from the trial balance.) (Click the icon to view the additional information.) Read the requirements. (Note 1: When computing the expected value of factory hourly payroll, you must take into consideration both the 5% wage increase and the 10% increase in the number of units produced and sold. Note 2: Use the increase in the 10/31/2019 preliminary sales balance over the 10/31/2018 audited sales balance to determine the expected value for sales commissions on 10/31/2019.) Requirement a. (2) Requirement b. [(2) - (1)]/(2) Expected Value 10/31/2019 Difference as a Percentage % (1) Preliminary Balance 10/31/2019 650,381 11,302,991 840,392 2,084,001 3,195,884 Executive salaries Factory hourly payroll (see Note 1) Factory supervisors' salaries Office salaries Sales commissions (see Note 2) % % % % Data table Audited Balance 10/31/2018 Preliminary Balance 10/31/2019 19 ni Sales* $ 59,401,400 $ 67,123,582 Executive salaries 560,499 650,381 Factory hourly payroll 10,594,822 11,302,991 Factory supervisors' salaries 797,096 840,392 Office salaries 2,239,582 2,084,001 Sales commissions 2,305,911 3,195,884 *Sales have increased 13% over prior year. 3% percent of that is due to an increase in the average selling price. The remaining 10% is attributed to an increase in the number of units sold. Print Done More info 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 Drop Line's products. The increase in sales was due to both an increase in the average selling price of 3 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. All employees including executives, but excluding commission salespeople, received a 5 percent salary increase starting November 1, 2018. 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. Drop Line does not permit overtime. 5. Commission salespeople receive a 7 percent commission on all sales on which a commission is given. Approximately 90 percent of sales earn sales commission. The other 10 percent are "call-ins," for which no commission is given. Commissions are paid in the month following the month they are earned. You are auditing payroll for the Drop Line Technologies company for the year ended October 31, 2019. Included next are amounts from the client's trial balance, along with comparative audited information for the prior year. (Click the icon to view the amounts from the trial balance.) (Click the icon to view the additional information.) Read the requirements. (Note 1: When computing the expected value of factory hourly payroll, you must take into consideration both the 5% wage increase and the 10% increase in the number of units produced and sold. Note 2: Use the increase in the 10/31/2019 preliminary sales balance over the 10/31/2018 audited sales balance to determine the expected value for sales commissions on 10/31/2019.) Requirement a. (2) Requirement b. [(2) - (1)]/(2) Expected Value 10/31/2019 Difference as a Percentage % (1) Preliminary Balance 10/31/2019 650,381 11,302,991 840,392 2,084,001 3,195,884 Executive salaries Factory hourly payroll (see Note 1) Factory supervisors' salaries Office salaries Sales commissions (see Note 2) % % % % Data table Audited Balance 10/31/2018 Preliminary Balance 10/31/2019 19 ni Sales* $ 59,401,400 $ 67,123,582 Executive salaries 560,499 650,381 Factory hourly payroll 10,594,822 11,302,991 Factory supervisors' salaries 797,096 840,392 Office salaries 2,239,582 2,084,001 Sales commissions 2,305,911 3,195,884 *Sales have increased 13% over prior year. 3% percent of that is due to an increase in the average selling price. The remaining 10% is attributed to an increase in the number of units sold. Print Done More info 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 Drop Line's products. The increase in sales was due to both an increase in the average selling price of 3 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. All employees including executives, but excluding commission salespeople, received a 5 percent salary increase starting November 1, 2018. 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. Drop Line does not permit overtime. 5. Commission salespeople receive a 7 percent commission on all sales on which a commission is given. Approximately 90 percent of sales earn sales commission. The other 10 percent are "call-ins," for which no commission is given. Commissions are paid in the month following the month they are earned

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Computerized Accounting Using QuickBooks Pro 2020

Authors: Alvin A. Arens, D. Dewey Ward, Carol J. Borsum

6th Edition

0912503793, 9780912503790

More Books

Students also viewed these Accounting questions

Question

How could any of these verbal elements be made stronger?

Answered: 1 week ago

Question

Does your message use pretentious or exaggerated language?

Answered: 1 week ago