PLEASEEE HEEELLLPPP MCreate a spreadsheet to calculate the your company's payroll or how much you pay each employee and the total you pay all employees. You pay your employees every two weeks, and for the last two weeks, your employees worked the following hours:

Employee 1: 78
Employee 2: 75
Employee 3: 80
Employee 4: 45
Employee 5: 50
Employee 6: 80
Employee 7: 65
Employee 8: 60
Employee 9: 78
Employee 10: 75
Your spreadsheet should calculate:

the total hours worked for each employee;
the gross pay for each employee (pay rate is $12.50 per hour);
the state income tax for each employee. Use 5.7%;
the Federal income tax for each employee. Use 15%;
Social Security for each employee. Use 3.5 %;
the net pay for each employee by subtracting the income tax and Social Security from the gross pay;
the total gross pay, total state income tax, total Federal income tax, total Social Security, and total net pay paid to all employees.
When you finish your spreadsheet, estimate your answers.

During the year, the delph company had no beginning or ending inventories and it started, completed, and sold only two jobs—job d-75 and job c-100. it provided the following information related to those two jobs: job d-75: molding fabrication total direct materials cost $ 375,000 $ 325,000 $ 700,000 direct labor cost $ 200,000 $ 160,000 $ 360,000 machine-hours 15,000 5,000 20,000 job c-100: molding fabrication total direct materials cost $ 300,000 $ 250,000 $ 550,000 direct labor cost $ 175,000 $ 225,000 $ 400,000 machine-hours 5,000 25,000 30,000delph had no overapplied or underapplied manufacturing overhead during the year. assume delph uses a plantwide overhead rate based on machine-hours.1-a. compute the predetermined plantwide overhead rate.1-b. compute the total manufacturing costs assigned to job d-70 and job c-200.1-c. if delph establishes bid prices that are 150% of total manufacturing costs, what bid price would it have established for job d-70 and job c-200? 1-d. what is delph's cost of goods sold for the year? assume delph uses departmental overhead rates based on machine-hours.2-a. compute the predetermined departmental overhead rates.2-b. compute the total manufacturing costs assigned to job d-70 and job c-200.2-c. if delph establishes bid prices that are 150% of total manufacturing costs, what bid price would it have established for job d-70 and job c-200? 2-d. what is delph's cost of goods sold for the year?