Ingram Heating & Cooling reports the following earnings and deductions for their employees for the 1st quarter of the year:

Total Federal State City Total Net

Earnings Inc. Tax OASDI HI Inc. Tax Inc. Tax Deductions Pay

Roy Bell 10489.00 1211.00 650.32 152.09 187.20 220.27 2420.88 8068.12

Karl Radek 10477.00 1209.00 649.57 151.92 228.67 220.02 2459.18 8017.82

Marie Rossi 10695.00 1131.00 663.09 155.08 191.49 224.60 2365.26 8329.74

John Scott 10258.00 1170.00 636.00 148.74 228.67 215.42 2398.83 7859.17

1st quarter totals 41919.00 4721.00 2598.98 607.83 836.03 880.31 9644.15 32274.85

Requirements: Use the forms attached.Attach document with calculations for partial credit.

1.Prepare the quarterly Form 941

Monthly 941 liabilities:Jan. $ 3,565.10, Feb. $3,615.70, March $3,953.82

Monthly deposits for the quarter were: $3,556.10, Feb. $3,615.70, March $3,953.82

Do not worry about their EIN Number or Address.

2.Prepare the quarterly SUTA Form .See rate on form provided.

3.Prepare the annual Form 940. (16 Points)

Assume that the second, third, and the fourth quarter earnings are the same as the 1st qtr above for each employee.

Assume all Ohio SUTA contributions were made timely.

They did not make any FUTA deposits this year.

• Form941,
• Ohio SUTA, ( Contribution Rate : 3.50% )
• Form 940
• and calculations for partial credit (optional - use the excel problem description file)