Create a contiguous chart for the budget. Create a non-contiguous chart for the payroll.

TRAINING NETWORK
Monthly Spread Sheet
										5.8%	12%
Last Name	First Name	Hourly Rate	Hours Worked	Regular Pay	Overtime Hours	Overtime Pay	Double-time Hours	Double-time Pay	Gross Pay	N.I.B.	VAT	Net Pay
Barr	Kendall	$ 15.63	40		5	$ -			$ -	$ -	$ -	$ -
Brown	Sophia	$ 15.63	40		8	$ -	8		$ -	$ -	$ -	$ -
Cooper	Leslie	$ 11.25	38		9	$ -	12		$ -	$ -	$ -	$ -
Rose	Amber	$ 11.25	37.5		6	$ -			$ -	$ -	$ -	$ -
Scott	Destiny	$ 12.50	37.5		8	$ -	6		$ -	$ -	$ -	$ -
Ward	Jesse	$ 12.50	40		10	$ -	5		$ -	$ -	$ -	$ -
Roberts	Eloise	$ 18.75	40		12	$ -			$ -	$ -	$ -	$ -
Scott	Destiny	$ 18.75	39.9		7	$ -	4		$ -	$ -	$ -	$ -
Grand Total

1. Use a formula in I17 that will sum all employees with OT hours was greater than 8 hrs.
2. Use a formula in I19 that will sum all employees whose Regular Pay was greater than or equal to $500, and their Net Pay was greater than $600.

Answer rating: 100% (QA)

TRAINING NETWORK Monthly Spread Sheet 58 12 Last Name First Name Hourly Rate Hours Worked Regular Pa... View the full answer