You are auditing payroll for the Cast IronCast Iron Technologies company for the year ended October? 31, 20162016. Included...

90.2K

Verified Solution

Question

Accounting

You are auditing payroll for the

Cast IronCast Iron

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

a.

Use the final balances for the prior year and the information initems 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 thenearest hundredth? percent, X.XX%.)

?(Note 1: When computing the expected value of factory hourly?payroll, you must take into consideration both the

44?%

wage increase and the

66?%

increase in the number of units produced and sold. Note? 2: Usethe increase in the

?10/31/20162016

preliminary sales balance over the

?10/31/20152015

audited sales balance to determine the expected value for salescommissions on

?10/31/20162016?.)

Requirement a.

(A)

(B)

Preliminary Balance

Expected Value

10/31/2016

10/31/2016

Executive salaries

649,215

Factory hourly payroll (see Note 1)

11,597,899

Factory supervisors' salaries

797,096

Office salaries

2,694,881

Sales commissions (see Note 2)

2,395,881

Audited BalancePreliminary Balance
10/31/1510/31/16
Sales*$55,934,900$60,969,041
Executive salaries544,881649,215
Factory hourly payroll9,284,51111,597,899
Factory supervisors' salaries729,582797,096
Office salaries2,239,5822,694,881
Sales commissions2,798,3212,395,881
*Sales haveincreased 9% over prior year. 3% percent of that is due to anincrease in the average selling price. The remaining 6% isattributed to an increase in the number of units sold.

You have obtained the following information to help you performpreliminary analytical procedures for the payroll accountbalances.

1.

There has been a significant increase in the demand for

Cast IronCast Iron?'s

products. The increase in sales was due to both an increase in theaverage selling price of

threethree

percent and an increase in units sold that resulted from theincreased 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

fourfour

percent salary increase starting November? 1,

20152015.

Commission salespeople receive their increased compensation throughthe increase in sales.

4.

The increased number of factory hourly employees wasaccomplished by recalling employees that had been laid off. Theyreceive the same wage rate as existing employees.

Cast IronCast Iron

does not permit overtime.

5.

Commission salespeople receive a

sevenseven

percent commission on all sales on which a commission is given.Approximately

6060

percent of sales earn sales commission. The other

4040

percent are? "call-ins," for which no commission is given.Commissions are paid in the month following the month they areearned.

PrintDone

Answer & Explanation Solved by verified expert
3.7 Ratings (549 Votes)
WorkingsNote 1 Calculation of Executive salaries Balance as on 10312015 54488100 A Increase 4 B Increase amount 2179524 CAB Expected as on 10312016 56667624 DAC 2 Calculation of Factory supervisors salaries Balance as on 10312015 72958200 E Increase 4 F Increase amount 2918328 GEF Expected as on 10312016 75876528    See Answer
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students