Question: create a spreadsheet with 10 employees with first and last name of a fruit and vegetable tht includes this information to pull from a database.
create a spreadsheet with 10 employees with first and last name of a fruit and vegetable tht includes this information to pull from a database. Please include the calculations in the formula for the spreadhseet. Entry of the employee's first and last name, ID, number of dependents, hours worked. The hourly rate should be pulled from a database using the employee ID as the primary key. Calculate Gross Pay Amount Overtime will be calculated on hours over 40 at 1.5 times the hourly rate. Calculate the number of dependents x $25. Calculate State Tax at 5.6% Calculate Federal Tax at 7.9% Calculate the pre-tax amount. Calculate the pre-tax amount - the dependents x 25. Calculate the post-tax amount. Hint: state and federal taxes are calculated on pre-tax amounts
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
