use execl and show me how
The following is a payroll sheet for Otis Import Company for themonth of September 2017. Selected information follows.
nemployment compensation rate allowed by the state 1.00%,Unemployment compensation rate for the federal government0.80%,Maximum wages for unemployment for federal and stategovernments$7,000 Federal income tax rate for all employees10%,FICA tax on employee and employer7.65Maximum wages for FICA tax$118,500 Employer and employee rate for an employee’s excess wages1.45%,Maximum wages per employee to avoid the excess wages charge$118,500
| Name | Earnings to
Aug 31 | Sept
Earnings | Income Tax
Withholding | F.I.C.A. | State
U.C. | Federal
U.C. |
| B.D. Williams | $ 6,800 | $ 800 | | | | |
| D. Raye | 6,500 | 700 | | | | |
| K. Baker | 7,600 | 1,100 | | | | |
| F. Lopez | 13,600 | 1,900 | | | | |
| A. Daniels | 107,000 | 13,000 | | | | |
| B. Kingston | 112,000 | 16,000 | | | | |
|
(a) Complete the payroll sheet and make the necessary entry to recordthe payment of thepayroll.
(b) Makethe entry to record the payroll tax expenses of Otis ImportCompany.
(c) Make the entry to record the payment of the payroll liabilitiescreated. Assume that the company pays all payroll liabilities atthe end of eachmonth.
