Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

a. Use the final balances for the prior year and the information in items 1 through 5 to develop an expected value for each account,

a.

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%.)

You are auditing payroll for the Harbor Creek Technologies company for the year ended October 31, 2016. Included next are amounts from the client's trial balance, along with comparative audited information for the prior year.

Audited Balance

Preliminary Balance

10/31/2015

10/31/2016

Sales

$53,395,900

$61,939,244

Executive salaries

581,745

583,956

Factory hourly payroll

10,594,822

11,210,049

Factory supervisors' salaries

809,654

770,600

Office salaries

2,405,000

2,404,933

Sales commissions

2,305,911

2,593,315

You have obtained the following information to help you perform preliminary analytical procedures for the payroll account balances.

There has been a significant increase in the demand for Harbor Creek 's products. The increase in sales was due to both an increase in the average selling price of six percent and an increase in units sold that resulted from the increased demand and an increased marketing effort.

Even though sales volume increased there was no addition of executives, factory supervisors, or office personnel.

All employees including executives, but excluding commission salespeople, received a four 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. Harbor Creek does not permit overtime.

Commission salespeople receive a seven percent commission on all sales on which a commission is given. Approximately 60 percent of sales earn sales commission. The other 40 percent are "call-ins," for which no commission is given. Commissions are paid in the month following the month they are earned

1. Find and show work for the Expected value for

Executive salaries

Factory hourly payroll

Factory supervisors' salaries

Office salaries

Sales commissions

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

Step: 3

blur-text-image

Ace Your Homework with AI

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

Get Started

Students also viewed these Accounting questions