Below are the annual payroll amounts for various businesses operating in different provinces. Assume that the payroll

amounts given are consistent from year to year. Calculate the provincial health$/$education tax in each province for these

private sector employers who are not in the primary$/$manufacturing industry nor are associated to any other companies.

If an cell is zero, enter a formula or a zero to indicate this, do not leave any field blank.

British Newfoundland

Columbia Manitoba & Labrador Quebec Ontario

Payroll amount $$2,050,000$ $$2,050,000$ $$2,050,000$ $$2,050,000$ $$2,050,000$

Less exemption

Net amount

Rate

Provincial health tax

What payment frequency would B$.$C$.$ and Ontario each have to follow?

Payment Frequency

B$.$C$.$ Ontario