Question

In: Accounting

AMC Distributors is a limited company engaged in the manufacturing and distribution of paper products which...

AMC Distributors is a limited company engaged in the manufacturing and distribution of paper products which are considered fast-moving consumer goods. The company had recently undertaken a successful total quality management (TQM) project to improve its manufacturing efficiency, expedite vendor payments and increase availability of finished products. For its next project, the company wanted to address problems in human resources (HR). By working with HR process owners, a focus for the project emerged – the payroll process. Staffing – the company has a staff complement of 150 employees consisting of factory workers, line supervisors, administrative and ancillary staff. Factory workers are hourly paid whereas supervisors, administrative staff and ancillary workers are paid a fixed salary. There are three different payrolls: Weekly (Factory workers), Fortnightly (Ancillary and Clerical staff) and Monthly (Managers and Supervisors). Overtime is paid based on approved submissions by Head of Departments supported by the respective timesheets. ‘Time and a half’ is paid for work in excess of a 40 hour week and ‘Double Time’ is paid to employees working on public holidays. Income Tax is at the rate of 10% of gross pay. Payroll system– The company currently operates a manual payroll system. The Payroll Administrator maintains several Excel spreadsheets for payroll computations and reporting. It is very cumbersome and prone to errors which has resulted in errors in net pay, lateness in paying employees and late submission of monthly payroll taxes resulting in penalties. Although the Accountant reviews and signs off the Net Pay Listing and Tax Payable Listing for processing of payment, there are still a number of errors which are made. Employees are disgruntled and choose to make other arrangements to make payment for bank loans and insurance premiums as the tardiness and inaccuracies in the current system expose them to penalties for late payment on their external commitments. You are the Financial Controller for the company and have come under a lot of pressure from criticism of the poor quality inherent in the payroll function. You are contemplating your strategy in addressing the challenges faced with a manual system which has outgrown its capability to produce timely and accurate payroll information for paying employees and making the necessary payroll tax returns.

Required:

ii) Prepare a user specification for the acquisition of the payroll system

Solutions

Expert Solution

Payroll System addresses the issues of Employee Attendance Recording , Payment, Tax calculations and Deductions etc.

a. Attendance System through thumbs machines about entry & exit of employees. Time will be automatically calculated.

b. Based on their salary structure, based on these times record, leave allowed, taken, extra time bonus etc. salary & wages calculations can be done. After it deduction whatsoever like pf. esi, loans, installments, Net Salary statement of all employees are preparedt. Direct in Bank account with single cheque can be transferred.

c. Special attention is to be taken for exceptional cases. Employees may be some time on tour for company, so there will be no time record in machines. The days spent on tours are to be verified & taken in time record. Different types of leaves are available, Some are paid leave, some are not be paid. These things are to be conisdered. Salary revision , if any from back dates are to be taken care of all of it.

d. Other specifications include regular update as per changes in laws and regulations, complexity level etc.


Related Solutions

Bill Evans began Evans Distributors, a sporting goods distribution company, in January 20X1 and engaged in...
Bill Evans began Evans Distributors, a sporting goods distribution company, in January 20X1 and engaged in the transactions below. Assume Evans Distributors and its customers take advantage of all cash discounts. DATE TRANSACTIONS 20X1 Jan. 1 Bill Evans started Evans Distributors with an investment of $56,050. He also invested personal business equipment worth $7,920. 2 Purchased merchandise for cash, $11,850, Check 100. 3 Sold merchandise on account to Rivera Corporation, $1,010, terms 2/10, n/30, Invoice 1001. 4 Purchased merchandise on...
Ozark Distributing Company is primarily engaged in the wholesale distribution of consumer products in the Ozark...
Ozark Distributing Company is primarily engaged in the wholesale distribution of consumer products in the Ozark Mountain regions. The following disclosure note appeared in the company’s 2018 annual report: Note 5. Convertible Preferred Stock (in part): The Company has the following Convertible Preferred Stock outstanding as of September 2018: Date of issuance: June 17, 2015 Optionally redeemable beginning: June 18, 2017 Par value (gross proceeds): $ 6,900,000 Number of shares: 230,000 Liquidation preference per share: $ 30 Conversion price per...
Ozark Distributing Company is primarily engaged in the wholesale distribution of consumer products in the Ozark...
Ozark Distributing Company is primarily engaged in the wholesale distribution of consumer products in the Ozark Mountain regions. The following disclosure note appeared in the company’s 2021 annual report: Note 5. Convertible Preferred Stock (in part): The Company has the following Convertible Preferred Stock outstanding as of September 2021: Date of issuance: June 17, 2018 Optionally redeemable beginning: June 18, 2020 Par value (gross proceeds): $ 3,750,000 Number of shares: 150,000 Liquidation preference per share: $ 25 Conversion price per...
Ozark Distributing Company is primarily engaged in the wholesale distribution of consumer products in the Ozark...
Ozark Distributing Company is primarily engaged in the wholesale distribution of consumer products in the Ozark Mountain regions. The following disclosure note appeared in the company’s 2021 annual report: Note 5. Convertible Preferred Stock (in part): The Company has the following Convertible Preferred Stock outstanding as of September 2021: Date of issuance: June 17, 2018 Optionally redeemable beginning: June 18, 2020 Par value (gross proceeds): $ 2,800,000 Number of shares: 140,000 Liquidation preference per share: $ 20 Conversion price per...
Ozark Distributing Company is primarily engaged in the wholesale distribution of consumer products in the Ozark...
Ozark Distributing Company is primarily engaged in the wholesale distribution of consumer products in the Ozark Mountain regions. The following disclosure note appeared in the company’s 2018 annual report: Note 5. Convertible Preferred Stock (in part): The Company has the following Convertible Preferred Stock outstanding as of September 2018: Date of issuance: June 17, 2015 Optionally redeemable beginning: June 18, 2017 Par value (gross proceeds): $ 2,800,000 Number of shares: 140,000 Liquidation preference per share: $ 20 Conversion price per...
Ozark Distributing Company is primarily engaged in the wholesale distribution of consumer products in the Ozark...
Ozark Distributing Company is primarily engaged in the wholesale distribution of consumer products in the Ozark Mountain regions. The following disclosure note appeared in the company’s 2021 annual report: Note 5. Convertible Preferred Stock (in part): The Company has the following Convertible Preferred Stock outstanding as of September 2021: Date of issuance: June 17, 2018 Optionally redeemable beginning: June 18, 2020 Par value (gross proceeds): $ 6,000,000 Number of shares: 240,000 Liquidation preference per share: $ 25 Conversion price per...
Ozark Distributing Company is primarily engaged in the wholesale distribution of consumer products in the Ozark Mountain regions
Ozark Distributing Company is primarily engaged in the wholesale distribution of consumer products in the Ozark Mountain regions. The following disclosure note appeared in the company’s 2018 annual report: Note 5. Convertible Preferred Stock (in part): The Company has the following Convertible Preferred Stock outstanding as of September 2018: Date of issuance: June 17, 2015 Optionally redeemable beginning: June 18, 2017 Par value (gross proceeds): $ 2,500,000 Number of shares: 100,000 Liquidation preference per share: $ 25.00 Conversion price per...
Quartz Auto Limited (QAL) is engaged in the business of manufacturing of trucks. Since a number...
Quartz Auto Limited (QAL) is engaged in the business of manufacturing of trucks. Since a number of the prospective customers do not have adequate funds to purchase the vehicles against full payment, QAL provides financing facility to its customers. It expects to receive a return at the rate of 15% per annum on the amount of finance. On 1 July 2014, QAL sold seven trucks to Emerald Goods Transport Company (EGTC) on lease. The terms of the lease and related...
Anas Company engaged in manufacturing plastic products is working at 60% capacity and produces 5,400 units...
Anas Company engaged in manufacturing plastic products is working at 60% capacity and produces 5,400 units per month. The present cost breaks up for one unit is as under: Material SR 8; Labor- SR 2; Overhead-SR 6 (25% fixed) The selling price is SR 25 per unit.  If it is desired to work the company at 70% capacity the selling price falls by 4%. At 80% capacity the selling price increase by 2%. You are required to prepare a statement showing...
1. LP is a limited partner in a newly formed partnership which is engaged in the...
1. LP is a limited partner in a newly formed partnership which is engaged in the following activities: (i) A research and development activity to which LP contributed $10,000 cash; LP’s share of partnership nonrecourse liability attributable to this activity is $10,000. LP’s share of loss from the research and development activity is $12,000 for the current year. (ii) A motion picture production activity to which LP contributed $20,000 cash; LP’s share of income from this activity for the current...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT