Use the information provided to fix my Pay grade and ranges table.

Thank you so much!

This is the information needed to be used:

Position Title	Current Pay Rate	New Pay Rates
Partner 1	$150,000.00 annually	$155,000 annually
Partner 2	$150,000.00 annually	$155,00 annually
Partner 3	$150,000.00 annually	$155,000 annually
Lead software designer 1	$120,000.00 annually	$125,000 annually
Brand Manager	New position	$125,000 annually
Software designer 1	$117,220.00 annually	$122,000 annually
Software designer 2	$90,100.00 annually	$92,000 annually
Software designer 3	$90,000.00 annually	$92,000 annually
Human resource manager 1	$75,900 annually	$91,000 annually
Product sales rep 1	New position	$90,000 Annually
Product sales rep 2	New position	$90,000 annually
Software designer 4	$85,000.00 annually	$87,000 annually
Software designer 5	$75,897.00 annually	$78,000 annually
Software designer 6	$70,000.00 annually	$72,000 annually
Operations supervisor 1*	$55,000.00 annually	$58,000 annually
Customer service representative 1	$32.50 hourly	$34.00 hourly
IT technician 1 (help desk)	$25.75 hourly	$27.00 hourly
Administrative assistant 1 - billing	$24.50 hourly	$26.00 hourly
IT technician 2 (help desk)	$21.10 hourly	$22.50 hourly
Administrative assistant 1 - general	$19.65 hourly	$21.00 hourly
IT technician 3 (help desk)	$15.50 hourly	$16.50 hourly
Customer service representative 2*	$15.38 hourly	$16.00 hourly
Customer service representative 3	$11.50 hourly	$12.00 hourly

This is what I initially made but it was marked as incorrect:

Pay Grade	Positions	Minimum	Midpoint	Maximum
6	Partner 1-3	$150,000	$175,000	$200,000
5	Brand manager, lead software designer	$125,000	$145,000	$165,000
4	Software designer 1-3	$92,000	$110,000	$128,000
3	Software designer 4-5, Product sales reps 1-2, HR manager	$78,000	$95,000	$112,000
2	Software designer 6, CSR1	$58,720	$73,720	$88,000
1	CSR 2-3, Help desk 1-3, admin billing, admin general, OPS Supervisor	$24,960	$41,600	$58,240

This is the feedback I was given:

The response includes a pay grade and range table that accurately includes all twenty-three positions. Unfortunately, overlap was not noted between pay grades 1 and 2. Also, the CSR 1 and Ops Supervisor positions do not fit into their assigned pay grades. Please ensure your revised submission includes a pay grade and range table that displays overlapping pay transitions, addresses each new role within an appropriate pay grade, aligns with market survey data, and demonstrates consistent steps. All positions must be placed in a pay grade where the pay of the positions (from A) falls somewhere between the minimum and maximum of the pay grade. Be sure to proofread!Consistency of overlap between pay grades - The overlap should never be so large that the minimum is below the midpoint of the prior pay grade. A good guideline is that the minimum should be between the midpoint and maximum of the prior pay grade. The Principle of Consistency/Progression states that the pay grade span, the dollar amount between the minimum and maximum of the pay grade is consistent, or it gets larger as the pay grades go up to the partners.