PLEASE DO IT ON EXCEL AND COMPLET ALL

(a)The employees of The Fashion Factory completed the number of pieces indicated during the workweek ending June 30: P. Cardin 1,050 J. Woolly 1,040 T. Bloomer 1,065 R. Napp 1,035 (b)Calculate the gross pay for each employee using the following plan: First 500 pieces $0.50 each Next 300 pieces $0.60 each Next 200 pieces $0.70 each Over 1,000 pieces $0.90 each (c)Complete the payroll using the payroll deduction tables illustrated in Figures 10.2, 10.3, 10.4, and 10.5. Assume all employees are Claim Code 1 for federal and provincial income tax purposes. (The Fashion Factory does not have a group health plan.) Total and balance the payroll record. (d)Record the compound General Journal entry for this payroll on June 30. (e)Record the General Journal entry on June 30 for the employers contributions to CPP and EI. (f)Record the entry in the Cash Payments Journal to issue the payroll cheques on June 30. The first paycheque is #11. (g)Record the entry in the Cash Payments Journal for the remittance to CRA on July 15. Issue cheque #29.

The Fashion Factory
PIECEWORK PAYROLL
Claim		Total	Gross	Federal	Provincial			Total	Net
Code	Employee Name	Pieces	Pay*	Tax	Tax	CPP	EI	Deduct	Pay
CC 1	P. Cardin	1050	615.00
CC 1	J. Woolly	1040	606.00
CC 1	T. Bloomer	1065	628.50
CC 1	R. Napp	1035	601.50
			2,451.00

Jun 30,20xx

Wages Expense----

Income Tax Payable (Federal)----

Income Tax Payable (Provincial)

CPP Payable

EI Payable

Wages Payable

To record payroll for week of Jun 30.

30 CPP Expense

EI Expense

CPP Payable

EI Payable

Employer's contributions for payroll,

There is nothing to add this is the only data I have you should calculate F, tax, P, tax, CPP, EI, Total Deduct, and Net Pay.

PLEASE DO IT WHATEVER I GAVE YOU THE INFORMATION