Question

In: Accounting

Diamond Construction is an owner-managed entity with contracting revenues of $20 million in 2020. As construction...

Diamond Construction is an owner-managed entity with contracting revenues of $20 million in 2020. As construction is a labour-intensive industry, one of Diamond’s largest expense accounts is labour and wages. You are a first-year auditor at Klein and Partners. You have been given the following information regarding the entity’s payroll process for hourly employees at Diamond Construction:

1. The owner-manager is the only person who can authorize the hiring of a new employee.
2. When a new employee is hired, the payroll clerk prepares a new employee package that includes:
(a) safety orientation
(b) tax forms
(c) benefits plan enrolment
3. Only the payroll manager has the ability to update the employee master list. This can only be done once the tax forms, a void cheque with direct deposit information, and the owner’s approval have been received. All forms need to be returned before the payroll manager will update the payroll master list and add any new employees.
4. Hourly employees are paid biweekly.
5. Hours worked are tracked on time cards. Supervisors fill in the time cards for each individual day, noting the hours worked.
6. At the end of the pay period, time cards are provided to the payroll clerk, who compiles the total hours worked and codes the hours to the appropriate job number. Once compiled, the payroll clerk enters the hours worked per person in the payroll system.
7. The accounting system prepares the direct deposit information based on the rates of pay maintained in the payroll master list (listing of all authorized staff and approved wage rates). It also calculates the withholding taxes.
8. This is transferred to the bank and a record of the transmission is printed and attached to the front of the payroll run.
9. The payroll module is integrated with the general ledger. The payroll clerk prepares and posts the journal entry to the payroll expense accounts.
10. Remittance advices are given to the supervisors for distribution.
11. If an employee is terminated, Diamond just stops paying them as they no longer have time cards submitted.
12. When an employee has been promoted or their job classification has changed, the supervisor will verbally communicate this to the payroll manager, who will then update the payroll master file. Therefore, source documentation in employee files will only relate to an employee’s original job classification. The rationale for this was that most job classification changes would only result in an additional dollar or two per hour paid to the employee.

Which of the following are control strengths with the payroll process?

The payroll manager has the ability to update the employee master list once the completed paperwork is received.

Supervisors fill in the time cards for each individual day, noting the hours worked and initialling each of the time cards.

The payroll clerk, who compiles the total hours worked and codes the hours to the appropriate job number, enters the hours worked per person in the payroll system.

All employees are on direct deposit.

The accounting system calculates the wages, withdrawing taxes.

The payroll module is integrated with the general ledger.

If an employee is terminated, Diamond just stops paying them as they no longer have time cards submitted.

When an employee has been promoted or their job classification has changed, the supervisor will verbally communicate this to the payroll manager, who will then update the payroll master file.

  

  

Which of the following tests of controls should be performed for Diamond Construction?

Compare monthly figures to expectations.

Take a sample of employees and compare to the employee files to ensure they exist.

Select a sample of time cards and review for the supervisor’s initials.

Examine termination notices in payroll department.

Take a sample of payroll journal entries and ensure they are posted and posted correctly.

Witness distribution of payroll remittance advices.

Examine evidence of the preparation and use of batch totals.

Test the system using a sample of hours and ensure it is calculating all items correctly.

Solutions

Expert Solution

Strengths

1.

No changes are made to the employee master list without the tax forms and the owner authorization - this ensures only approved employees prevents fictitious employees from being added to the payroll master list.

Test:

Take a sample of employees and go back to the employee files to ensure they exist.

2.

Only owner manager can authorize hiring of new employees — only authorized additions are made to the payroll.

Test:

Take a sample of new employees and review hiring forms for evidence of approval.

3.

Supervisors fill in the time cards for each individual day noting the hours worked and initials each of the time cards. This ensures employees are only paid for actual hours worked.

Test:

Select a sample of time cards and review for the supervisor’s initials.

4.

The payroll module is integrated with the general ledger and prepares and posts the journal entry to the payroll expense accounts. This ensures the payroll expense is recorded in the general ledger and recorded at the right amounts and in the correct general ledger accounts.

Test:

Take a sample of payroll journal entries and ensure it is posted and posted correctly.

5.

All employees are on direct deposit and remittance advices are given to supervisors for distribution, therefore there is no risk cheques will be distributed to unauthorized people.

Test:

Witness distribution of payroll remittance advice.

6.

Accounting system calculates the wages, withdrawing taxes. This prevents calculation errors with respect to wages as well as tax deductions. This ensures the payroll expense is correctly calculated.

Test:

To test the control: Test the system using a sample of hours and ensure it is calculating all items correctly.


Related Solutions

Q2. Company B earned $20 million before interest and taxes on revenues of $60 million last...
Q2. Company B earned $20 million before interest and taxes on revenues of $60 million last year. Investment in fixed capital was $12 million, and depreciation was $8 million. Working capital investment was $3 million. The company expects earnings before interest and taxes (EBIT), investment in fixed and working capital, depreciation, and sales to grow at 12% per year for the next five years. After five years, the growth in sales, EBIT, and working capital investment will decline to a...
The Construction cost of the bypass is 20 million and 500,000 would be required each year...
The Construction cost of the bypass is 20 million and 500,000 would be required each year for annual maintenance. The annual benefits to the public have been estimated to be 2 million. If the study period is 50 years and the government interest rates is 8% per year, a.) Should the bypass be constructed? B.)What impact does a social interest rate of 4% per year have on the B-C ratio of the project
A company generates perpetual revenues averaging $20 million per year. On average, raw materials are 60%...
A company generates perpetual revenues averaging $20 million per year. On average, raw materials are 60% of revenues. There are no other operating costs. (Ignore taxes.) A vendor offers to supply all raw materials for a five-year fixed price contract of $12 million per year. Subsequently, your company will revert to variable prices for raw materials. The company cost of capital is 10% and the cost of debt is 6% a. Calculate the value of the company with and without...
CH: 20; Irwin, Inc., constructed a machine at a total cost of $79 million. Construction was...
CH: 20; Irwin, Inc., constructed a machine at a total cost of $79 million. Construction was completed at the end of 2012 and the machine was placed in service at the beginning of 2013. The machine was being depreciated over a 10-year life using the sum-of-the-years’-digits method. The residual value is expected to be $2 million. At the beginning of 2016, Irwin decided to change to the straight-line method. Ignoring income taxes, prepare the journal entry relating to the machine...
CH 20; Irwin, Inc., constructed a machine at a total cost of $59 million. Construction was...
CH 20; Irwin, Inc., constructed a machine at a total cost of $59 million. Construction was completed at the end of 2012 and the machine was placed in service at the beginning of 2013. The machine was being depreciated over a 10-year life using the straight-line method. The residual value is expected to be $3 million. At the beginning of 2016, Irwin decided to change to the sum-of-the-years’-digits method. Ignoring income taxes, prepare the journal entry relating to the machine...
During 2020, Pina Colada Corporation started a construction job with a contract price of $5.32 million....
During 2020, Pina Colada Corporation started a construction job with a contract price of $5.32 million. Pina Colada ran into severe technical difficulties during construction but managed to complete the job in 2022. The contract is non-cancellable. Under the terms of the contract, Pina Colada sends billings as revenues are earned. Billings are non-refundable. The following information is available: 2020 2021 2022 Costs incurred to date $ 760,000 $2,660,000 $5,220,000 Estimated costs to complete 3,990,000 2,660,000 -0- (a) Calculate the...
During 2020, Blue Spruce Corporation started a construction job with a contract price of $6.16 million....
During 2020, Blue Spruce Corporation started a construction job with a contract price of $6.16 million. Blue Spruce ran into severe technical difficulties during construction but managed to complete the job in 2022. The contract is non-cancellable. Under the terms of the contract, Blue Spruce sends billings as revenues are earned. Billings are non-refundable. The following information is available: 2020 2021 2022 Costs incurred to date $ 880,000 $3,080,000 $6,060,000 Estimated costs to complete 4,620,000 3,080,000 -0- Calculate the amount...
A company has decided to sell $50 million in new 20-year bonds to finance new construction...
A company has decided to sell $50 million in new 20-year bonds to finance new construction projects. The company is also considering whether to issue coupon bearing bonds or zero coupon bonds both with the same face value of $1,000. The YTM on either bond issue will be 7.5%. The coupon bond would have a 7.5% coupon rate and the bond makes semiannual payments. (1) How many of the coupon bonds must the company issue to raise the $50 million?...
Sampras Ltd issues $20 million of convertible notes on 1 July 2020. The notes have a...
Sampras Ltd issues $20 million of convertible notes on 1 July 2020. The notes have a life of 6 yrs and a face value of $20 each. Annual interest of 5% is payable at the end of each year. The notes were issued at their face value and each note can be converter into one ordinary shares in Sampras Ltd at any time over their lives. Organisations with similar risk profile to Sampras Ltd have issued debt with similar terms...
In July 2020, Worley Ltd calls for public subscriptions for 20 million shares. The issue price...
In July 2020, Worley Ltd calls for public subscriptions for 20 million shares. The issue price per share is $1.20, to be paid in three parts, these being $0.50 on application, $0.40 within one month of the shares being allotted and $0.30 within two months of the first and final call, with the call for final payment being payable on 1 September 2020. By the end of July, when applications close, applications have been received for 24 million shares; that...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT