1. (TCO 1) You work for a local construction firm, "DeVry Engineering Group" and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions: Note: This is a one part question. • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour. • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. • Each employee will have a standard 7.65% deduction for social security • Each employee will have a standard 14.00% deduction for Federal Taxes • Each employee will have a standard 5.33% deduction for State …show more content…
The NET Pay is Gross Pay – Total Deductions and it can be in column R. Also, it is better to use ONE sheet per weekly payroll so that it will be organized better. You can also easily export sheets to other workbooks in the future if the Excel file gets too bloated after long period of use and the accumulated data in it. 2. (TCO 3) You currently work for an automotive parts supply store. Your company is growing and is considering expansion. The company currently has three locations (North, South, and Central) in one state. Each parts supply store carries inventory in four categories. You have been presented with the sales figures for the last three years for each location and inventory category by store. Based on this information, you're tasked with analyzing current sales for each store by category and overall total sales by store and category. Note: This is a four part question. 1.) Explain your approach to setting up your worksheets and organizing the data. 2.) Explain how you will visually represent the data for the total sales of the individual inventory categories for each location for the time periods shown. 3.) Explain how you will
Name: Amber Smith CAUTION: See "round" rules in Excel Instructions before calculating OT for slaried employees. Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer. For a breakdown of the solution by chapter, see the worksheet tabs labeled CPP 2 through 6 representing the solutions for chapters 2-6. Continuing Payroll Problem-B
Enter the appropriate numbers/formulas in the shaded (gray) cells. An asterisk (*) will appear to the right of an incorrect answer.
Pam and Susan’s department stores are in the process of opening a new business unit. There are two locations that are being considered for the new store and decision is based upon estimates of sales for both of them. My job is to use data gathered from each store as well census data in store’s trading zones to predict sales at both of the sites that are being consider for their newest store.
than $5.15 an hour. Overtime pay at a rate of not less than one and
2a. Consumers would certainly see a hike in prices on the imported product and in turn could affect the consumer’s ability to afford neither the domestic made clothing nor foreign made clothing.
1. You recently retired from government contracting work and established a consulting company (fully consistent with government ethics laws and rules, of course) with the primary focus of advising potential government contractors and subcontractors. Mr. Johnny Jones, of The Johnny Jones Flooring and Construction Company has approached you with a question. Jones and his company are potential subcontractors (they, obviously, specialize in flooring) on a federal construction contract worth a little over two million dollars ($ 2,000,000.00) recently awarded to the Jimmy Smith Construction Company (Jimmy Smith, the prime contractor). Neither Johnny nor his company have ever been part of a government contract
| if maritalStatus = ‘M’ taxRate = MARRIED_RATEif maritalStatus = ‘S’ taxRate = SINGLE_RATEif maritalStatus = ‘D’ taxRate = DIVORCED_RATEif maritalStatus = ‘W’ taxRate = WIDOWED_RATEIf hoursWorked <= 40 grossPay = hoursWorked * hourlyRateElse regularPay = (40 * hourlyRate) overtimePay = ((hoursWorked-40) * (hourlyRate * 1.5)) grossPay = regularPay + overtimePaytaxAmount = grossPay * taxRatenetPay = grossPay - taxAmount
1. In the paternalistic model of doctor-patient relationship, power resident exclusively with Doctors; in the engineering model, it resides entirely with Patients.
1. (TCO B) Identify four categories of measures that might constitute a Balanced Scorecard of performance measures and provide an example of each. Also explain how a Balanced Scorecard could assist your organization. This answer must be in your own words—significant cut and paste from the text or other sources is not acceptable. (Points : 30)
Which layer of the OSI reference model handles logical addressing (IP addresses) and routing traffic?
-3 x 1.66 pts. = minus 5 pts. = 45 pts. out of 50 pts. = 90%
Looking at the outcomes, which are the result of the support plan, these include inputs, outputs and outcomes. In simplified terms, these items look like:
The new owner of a beauty shop is trying to decide whether to hire one, two, or three beauticians. She estimates that profits next year (in thousands of dollars) will vary with demand for her services and has estimated demand in three categories low, medium and high.
Can we also ask them to submit the annual turnover per sqft (ideally, if they can provide the breakdown per unit or per merchandise category would be great)? This would give a clear picture of what is the sales potential of the subject retail unit.
2. Working according to the agreed ways means following the organisation’s policy and procedures in relation to pressure areas. It also means following the individual care plans and respecting the instructions in place. For example making sure a resident is turned every two hours, applying Cavilon cream on areas; fill in turning charts, prompt fluid intake. Under the duty of care a care assistant must always be aware of and raise concerns regarding possible pressure areas. Always record information in care plans accurately and in confidentiality.