Please help with this question in excel

A&R Construction Effective 9/14/2021 Weekly Field Hours Worked Weekly Commission Earned / Hour 0-5,000 (Breakeven) 5000-6000 6000-6500 6500-7000 7000-10000 10000-15000 15000+ $0.00 $0.16 $0.22 $0.25 $0.50 $0.75 $0.10 Max pay per step 160.00 110.00 125.00 1,500.00 3,750.00 Morgan is D&D's manager of freelance construction. When A&R pairs a freelance construction worker with a company, they receive commission based on hours completed. Jake would like your help creating a commission calculator. Commission is based on hour graduated scale. Information is listed in column C. Example - 7000 hours completed. = 5000 hours at 0 + 1000 hours at .16 an hour + 500 hours at .22 an hour + 500 hours at .25 an hour. Total Hours Worked 0 Total Commisson Paid Home