You are auditing payroll for the Reel In Technologies company for the year ended October 31,...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are auditing payroll for the Reel In 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. (Click the icon to view the amounts from the trial balance.) (Click the icon to view the additional information.) Requirements 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%.) (Note 1: When computing the expected value of factory hourly payroll, you must take into consideration both the 6% wage increase and the 8% increase in the number of units produced and sold. Note 2: Use the increase in the 10/31/2016 preliminary sales balance over the 10/31/2015 audited sales balance to determine the expected value for sales commissions on 10/31/2016.) Requirement a. (B) Expected Value 10/31/2016 Executive salaries Factory hourly payroll (see Note 1) Factory supervisors' salaries Office salaries Sales commissions (see Note 2) (A) Preliminary Balance 10/31/2016 629,481 11,100,499 837,567 2,713,957 3,059,893 al balance.) 7.) e informati tion and th tory hourly e over the A) ry Balanc 1/2016 629,4 11,100,4 837,4 2,713,9 3,059,8 Data Table Sales* Executive salaries Factory hourly payroll Factory supervisors' salaries Office salaries Audited Balance $ 10/31/2015 52,918,457 $ 544,881 10,399,587 759,699 2,239,582 Sales commissions 2,305,911 *Sales have increased 15% over prior year. 7% percent of that is due to an increase in the average selling price. The remaining 8% is attributed to an increase in the number of units sold. Print Preliminary Balance Done 10/31/2016 60,856,226 629,481 11,100,499 837,567 2,713,957 3,059,893 to the nearest wh int)/expected valu the number of uni 10/31/2016.) nologies company for the year ended October 31, 2016. Included next are amounts from the client's trial balance, along with comparative audited info the trial balance. ormation.) and the informati expectation and th e of factory hourly balance over the (A) eliminary Balanc 10/31/2016 629,4 11,100,4 837, 2,713,9 3,059, 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 Reel In's products. The increase in sales was due to both an increase in the average selling price of seven 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 six percent salary increase starting November 1, 2015. 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. Reel In does not permit overtime. 5. Commission salespeople receive a three percent commission on all sales on which a commission is given. Approximately 75 percent of sales earn sales commission. The other 25 percent are "call-ins," for which no commission is given. Commissions are paid in the month following the month they are earned. en click Check Answer. Print Done to the nearest whole dollar.) int)/expected value. (Round to the ne the number of units produced and sol 10/31/2016.) You are auditing payroll for the Reel In 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. (Click the icon to view the amounts from the trial balance.) (Click the icon to view the additional information.) Requirements 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%.) (Note 1: When computing the expected value of factory hourly payroll, you must take into consideration both the 6% wage increase and the 8% increase in the number of units produced and sold. Note 2: Use the increase in the 10/31/2016 preliminary sales balance over the 10/31/2015 audited sales balance to determine the expected value for sales commissions on 10/31/2016.) Requirement a. (B) Expected Value 10/31/2016 Executive salaries Factory hourly payroll (see Note 1) Factory supervisors' salaries Office salaries Sales commissions (see Note 2) (A) Preliminary Balance 10/31/2016 629,481 11,100,499 837,567 2,713,957 3,059,893 al balance.) 7.) e informati tion and th tory hourly e over the A) ry Balanc 1/2016 629,4 11,100,4 837,4 2,713,9 3,059,8 Data Table Sales* Executive salaries Factory hourly payroll Factory supervisors' salaries Office salaries Audited Balance $ 10/31/2015 52,918,457 $ 544,881 10,399,587 759,699 2,239,582 Sales commissions 2,305,911 *Sales have increased 15% over prior year. 7% percent of that is due to an increase in the average selling price. The remaining 8% is attributed to an increase in the number of units sold. Print Preliminary Balance Done 10/31/2016 60,856,226 629,481 11,100,499 837,567 2,713,957 3,059,893 to the nearest wh int)/expected valu the number of uni 10/31/2016.) nologies company for the year ended October 31, 2016. Included next are amounts from the client's trial balance, along with comparative audited info the trial balance. ormation.) and the informati expectation and th e of factory hourly balance over the (A) eliminary Balanc 10/31/2016 629,4 11,100,4 837, 2,713,9 3,059, 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 Reel In's products. The increase in sales was due to both an increase in the average selling price of seven 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 six percent salary increase starting November 1, 2015. 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. Reel In does not permit overtime. 5. Commission salespeople receive a three percent commission on all sales on which a commission is given. Approximately 75 percent of sales earn sales commission. The other 25 percent are "call-ins," for which no commission is given. Commissions are paid in the month following the month they are earned. en click Check Answer. Print Done to the nearest whole dollar.) int)/expected value. (Round to the ne the number of units produced and sol 10/31/2016.)
Expert Answer:
Answer rating: 100% (QA)
Reel in Technologies Account Executive Salaries Factory Hourly Payroll Factory Hourly Payroll Factor... View the full answer
Related Book For
College Accounting A Contemporary Approach
ISBN: 978-0077639730
3rd edition
Authors: David Haddock, John Price, Michael Farina
Posted Date:
Students also viewed these accounting questions
-
The is true about profitability drivers and industry demand determinants: Group of answer choices The economic recession had no impact. World pricing of coffee has little impact Per capita tea...
-
1. Use the final balances of the vendor accounts after completing Exercise 8.8 to prepare a schedule of accounts payable for Bioplast Jewelry, Inc., as of January 31, 2016. In Exercise 8.8, Assume...
-
You are auditing payroll for the Morehead Technologies Company for the year ended October 31, 2011. Included next are amounts from the client's trial balance, along with comparative audited...
-
Write balanced equations based on the information given. (a) Solid magnesium + oxygen gas solid magnesium oxide (b) Nitrogen monoxide gas + oxygen gas nitrogen dioxide gas (c) Gaseous ethane(C2H6)...
-
Calculate R4,4 for the integrals in Exercise 2. In Exercise 2 (cos a)2 dx 0.75 x In(x 1) dx ((sin x) - 2xsinx 1) dx 212 le dx x Inx
-
Give one good reason that you should not use global variables in a program.
-
Why petrol engines are called S.I. engines and why diesel engines are called C.I. engines.
-
In Gallups Annual Consumption Habits Poll, telephone interviews were conducted for a random sample of 1014 adults aged 18 and over. One of the questions was, How many cups of coffee, if any, do you...
-
A block of mass =309 g is dragged with a string across a rough horizontal table. The string tension is =2.47 N, and it pulls upward at an angle of =46.0 with the horizontal. At one particular...
-
The table below shows Lanark's production possibilities. Wheat Cars A 0 51 B 50 49 C 88 44 D 114 34 E 126 19 F 131 e a. If Lanark is producing 39 cars, it can produce approximately b. If Lanark is...
-
String Changer Build a function called stringChanger() that takes in two arguments: a word and an operation. Based on the operation, your function will return the word modified in some way. The...
-
On the sheet called Income Statement, in cell E14 create the formula for the Income Tax. On the sheet called Income Statement, make cell C14 is the only cell that the enduser can type in. Protect the...
-
I sign a contract that guarantees me an immediate payment of $2 000, but then I have to invest $800 a year for ten years. At the end of the tenth year, I get a further payment of $8 000. If I can...
-
A small block slides down a frictionless track whose shape is described by y = ( x ^ 2 ) / d for x < 0 and by y = - ( x ^ 2 ) / d for x > 0 . The value of d is 2 . 8 8 m , and x and y are...
-
Select all that apply, then click Submit below Response 1 of 4: Jennifer would prefer to use the internal rate of return, which is more accurate.Jennifer would prefer to use the internal rate of...
-
Provide a summary on political neutrality and impartiality, considering the various perspectives in political science or international relations?
-
Rewrite the expression by factoring out (v+2). 2 5v (v+2)+2(v+2)
-
Anna, a high school counselor, devised a program that integrates classroom learning with vocational training to help adolescents at risk for school dropouts stay in school and transition to work...
-
On April 1, Moloney Meat Distributors sold merchandise on account to Fronkes Franks for $3,000 on Invoice 1001, terms 1/10, n/30. Payment was received in full from Fronkes Franks, less discount, on...
-
What kind of account is Sales Discounts?
-
How is net income determined?
-
See the option quote on IBM from the CBOE Web site on the next page showing options expiring in March and April 2022. a. Which option contract had the most trades that day? b. Which option contract...
-
You are an options dealer who deals in non-publicly traded options. One of your clients wants to purchase a one-year European call option on HAL Computer Systems stock with a strike price of \($20.\)...
-
It is February 21, 2022, and you have decided to purchase 10 June call contracts on eBays stock with an exercise price of \($57.50.\) Because you are buying, you must pay the ask price. How much...
Study smarter with the SolutionInn App