Excel assignment

In I4:I24, use the Man Hours provided along with the information on overheads in the Information sheet, to calculate the manufacturing overhead for each job.

I have the man hrs for each column in the excel and the information:

i have the budgeted MOH WHICH it is 71500 and budgeted direct labour hr which is 7500

also labour and material costs are given per job in the excel table

how to get the overhead cost and the total cost for each job

please help

for first column for example

job 1:

Man Hourly 200

labour cost 4,6940

material cost 17,4908

budgeted MOH WHICH it is 71500

budgeted direct labour hr which is 7500

find the overhead cost and total cost for each job 1