Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Could someone help me please, I dont know how to do any of this :( The four spreadsheets displayed on the last page are all

Could someone help me please, I dont know how to do any of this :( image text in transcribed
image text in transcribed
The four spreadsheets displayed on the last page are all worksheets in a single workbook. You are using this workbook to keep track of labor costs for your small construction company. In this exercise you will be calculating each person's yearly compensation and vacation based on the following data: The worksheet named wages lists the hourly wages of each of the different craft skills. Each craft-skill is uniquely identified by a job code. . . The benefit costs in dollars per month are determined based on the hourly wage. The spreadsheet named benefits lists the monthly benefit that corresponds to a specific range of hourly wages. For example: wages of less than $25 per hour have a $416 per month benefit paid, and wages between $25 and $29.99 per hour have a benefit of $624 per month benefit paid. The length of paid vacation (in weeks) is given in sheet vacation. The vacation length is based on the employment length. The spreadsheet named summary lists the name of each employee, the number of years they have been employed and to which craft skill they belong. The cell summary!B1 has been named hours and contains the number of hours per year each . employee is paid. Write an Excel formula in cell summary!D3, which can be copied down the column, to calculate the hourly wage for this person. Write an Excel formula in cell summary!E3, which can be copied down the column, to determine the total value of the benefits per year for this person. Note that the figures given in sheet benefits are per month. 3. Write an Excel formula in cell summary!F3, which can be copied down the column, to determine the total yearly value of the compensation including wages and benefits for this on. Use the named range previously entered into the worksheet (see problem pers description) to represent the number of hours per year each employee works

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamentals Of Database Management Systems

Authors: Mark L. Gillenson

2nd Edition

0470624701, 978-0470624708

More Books

Students also viewed these Databases questions