Question
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
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 Sandy LaneSandy Lane's products. The increase in sales was due to both an increase in the average selling price oftwotwo 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 sixsix percent salary increase starting November 1,20152015. 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. Sandy LaneSandy Lane does not permit overtime. |
5. | Commission salespeople receive a sevenseven percent commission on all sales on which a commission is given. Approximately8080 percent of sales earn sales commission. The other2020 percent are "call-ins," for which no commission is given. Commissions are paid in the month following the month they are earned.
|
Audited Balance | Preliminary Balance | |||||||||||||||||||||||||||||||||||||||||||||
10/31/2015 | 10/31/2016 | |||||||||||||||||||||||||||||||||||||||||||||
Sales* | $57,590,900 | $62,774,081 | ||||||||||||||||||||||||||||||||||||||||||||
Executive salaries | 529,481 | 629,481 | ||||||||||||||||||||||||||||||||||||||||||||
Factory hourly payroll | 10,603,817 | 11,100,499 | ||||||||||||||||||||||||||||||||||||||||||||
Factory supervisors' salaries | 659,285 | 829,583 | ||||||||||||||||||||||||||||||||||||||||||||
Office salaries | 2,003,912 | 2,905,881 | ||||||||||||||||||||||||||||||||||||||||||||
Sales commissions | 2,305,911 | 2,827,321 | ||||||||||||||||||||||||||||||||||||||||||||
*Sales have increased 9% over prior year. 2% percent of that is due to an increase in the average selling price. The remaining 7% is attributed to an increase in the number of units sold. You are auditing payroll for the Sandy LaneSandy Lane Technologies company for the year ended October 31, 20162016. Included next are amounts from the client's trial balance, along with comparative audited information for the prior year. LOADING... (Click the icon to view the amounts from the trial balance.) LOADING... (Click the icon to view the additional information.) Requirements
(Note 1: When computing the expected value of factory hourly payroll, you must take into consideration both the 66% wage increase and the 77% increase in the number of units produced and sold. Note 2: Use the increase in the 10/31/20162016 preliminary sales balance over the 10/31/20152015 audited sales balance to determine the expected value for sales commissions on 10/31/20162016.)
|
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started