Table 1: Time Clock Data from Security Detail (Supervisor is on salary)
Employee |
Rate |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Supervisor |
$25.00 |
8.0 |
8.0 |
8.0 |
8.0 |
8.0 |
Officer 1A |
$20.00 |
8.1 |
7.6 |
8.2 |
7.5 |
7.8 |
Officer 1B |
$20.00 |
7.4 |
7.3 |
7.8 |
7.1 |
8.1 |
Officer 2A |
$17.50 |
7.0 |
8.3 |
8.4 |
8.1 |
8.4 |
Officer 2B |
$17.50 |
8.2 |
7.3 |
7.7 |
7.7 |
8.4 |
Officer 2C |
$17.50 |
7.1 |
7.5 |
8.5 |
8.3 |
7.7 |
Officer 3A |
$15.00 |
7.2 |
7.8 |
8.3 |
7.8 |
7.6 |
Officer 3B |
$15.00 |
7.5 |
7.0 |
7.8 |
7.3 |
7.5 |
Officer 3C |
$15.00 |
7.1 |
7.0 |
7.4 |
7.0 |
7.5 |
Officer 3D |
$15.00 |
8.2 |
7.1 |
8.3 |
8.5 |
8.0 |
Paste this data to an excel sheet to obtain desired results. Ensure that the top left corner 'Employee' Cell is at 1A position.
Employee | Rate | Monday | Tuesday | Wednesday | Thursday | Friday | |
SuperVisor | 25 | 8 | 8 | 8 | 8 | 8 | |
Officer 1A | 20 | 8.1 | 7.6 | 8.2 | 7.5 | 7.8 | |
Officer 1B | 20 | 7.4 | 7.3 | 7.8 | 7.1 | 8.1 | |
Officer 2A | 17.5 | 7 | 8.3 | 8.4 | 8.1 | 8.4 | |
Officer 2B | 17.5 | 8.2 | 7.3 | 7.7 | 7.7 | 8.4 | |
Officer 2C | 17.5 | 7.1 | 7.5 | 8.5 | 8.3 | 7.7 | |
Officer 3A | 15 | 7.2 | 7.8 | 8.3 | 7.8 | 7.6 | |
Officer 3B | 15 | 7.5 | 7 | 7.8 | 7.3 | 7.5 | |
Officer 3C | 15 | 7.1 | 7 | 7.4 | 7 | 7.5 | |
Officer 3D | 15 | 8.2 | 7.1 | 8.3 | 8.5 | 8 | |
Employee | Rate | Monday | Tuesday | Wednesday | Thursday | Friday | Total |
SuperVisor | 25 | =$B16*C2 | =$B16*D2 | =$B16*E2 | =$B16*F2 | =$B16*G2 | =SUM(C16:G16) |
Officer 1A | 20 | =$B17*C3 | =$B17*D3 | =$B17*E3 | =$B17*F3 | =$B17*G3 | =SUM(C17:G17) |
Officer 1B | 20 | =$B18*C4 | =$B18*D4 | =$B18*E4 | =$B18*F4 | =$B18*G4 | =SUM(C18:G18) |
Officer 2A | 17.5 | =$B19*C5 | =$B19*D5 | =$B19*E5 | =$B19*F5 | =$B19*G5 | =SUM(C19:G19) |
Officer 2B | 17.5 | =$B20*C6 | =$B20*D6 | =$B20*E6 | =$B20*F6 | =$B20*G6 | =SUM(C20:G20) |
Officer 2C | 17.5 | =$B21*C7 | =$B21*D7 | =$B21*E7 | =$B21*F7 | =$B21*G7 | =SUM(C21:G21) |
Officer 3A | 15 | =$B22*C8 | =$B22*D8 | =$B22*E8 | =$B22*F8 | =$B22*G8 | =SUM(C22:G22) |
Officer 3B | 15 | =$B23*C9 | =$B23*D9 | =$B23*E9 | =$B23*F9 | =$B23*G9 | =SUM(C23:G23) |
Officer 3C | 15 | =$B24*C10 | =$B24*D10 | =$B24*E10 | =$B24*F10 | =$B24*G10 | =SUM(C24:G24) |
Officer 3D | 15 | =$B25*C11 | =$B25*D11 | =$B25*E11 | =$B25*F11 | =$B25*G11 | =SUM(C25:G25) |
Total Payroll for all | =SUM(H16:H25) | ||||||
Position | Position Cost | Average Cost | Proportion | ||||
Supervisor | =SUM(H16) | =AVERAGE(H16) | =B30/H26*100 | ||||
Officer 1 | =SUM(H17:H18) | =AVERAGE(H17:H18) | =B31/H26*100 | ||||
Officer 2 | =SUM(H19:H21) | =AVERAGE(H19:H21) | =B32/H26*100 | ||||
Officer 3 | =SUM(H22:H25) | =AVERAGE(H22:H25) | =B33/H26*100 |
Table 1: Time Clock Data from Security Detail (Supervisor is on salary) Employee Rate Monday Tuesday...
In West Texas, water is extremely important. The following data represent ph levels in ground water for a random sample of 102 West Texas wells. A pH less than 7 Is adidic and a pH above 7 is alkaline. Scanning the data, you can see that water in this region tends to be hard (alkaline). Too high a pH means the water is unusable or needs expensive treatment to make it usable.t These data are also available for download at...
An object of weight 1 N is falling vertically. The time vs. speed data can be found here. In this case the effect of air-drag cannot be neglected. Use your critical thinking to estimate the air-drag coefficient . Make sure you include the units in your answer. 0 0 0.1 0.9992 0.2 1.993 0.3 2.978 0.4 3.948 0.5 4.898 0.6 5.826 0.7 6.728 0.8 7.599 0.9 8.438 1 9.242 1.1 10.01 1.2 10.74 1.3 11.43 1.4 12.09 1.5 12.7 1.6 ...
A particular talent competition has five judges, each of whom awards a score between 0 and 10 to each performer. Fractional scores, such as 8.3, are allowed. A performer’s final score is determined by dropping the highest and the lowest score received then averaging the three remaining scores. Write a program that does the following: 1. Reads names and scores from an input file into a dynamically allocated array of structures. The first number in the input file represents the...
4.3 Analysis Assignment #4 Note 1: all assignments moving forward must adhere to the appropriate Six Step Process (SSP). As our study materials have specified, the SSP has 3 versions. Version 1 is to be used for all t-tests; for all correlation analyses and Version 3 is be used for all regression analyses. Note 2: The data sets for Q1, Q2 and Q3 below can be downloaded here. Week 4 Analysis Assignments.xlsx Q1: (30 points) Complete the following data analysis:...
• 1. What are the quarterly growth rates (Percentage Change From Preceding Period in Real Gross Domestic Product) for the U.S. economy for the last six quarters? Report those numbers in your submission 2. What is the average of those 6 quarters? . 3. Is the average of those growth rates above or below the long-run U.S. annual growth rate of 3.5 percent? Bureau of Economke Analysis Table 1.1.1. Percent Change From Preceding Period in Real Gross Domestic Product Percent...
Please solve problem 1 and show formulas used Tables for reference: Homework 6- Chapter 9 Problem 1: A crawler hoe having a 2 -cy bucket and whose cost per hour, including the wages to an operator, is $109 will excavate and load haul units under each of the stated conditions. The maximum digging depth of the machine is 22 ft. Determine the cost per bank cubic yard for each condition. (Condition 1: 315 bey/hr, S0.346/bcy; condition 2: 289 bey/hr, S0.377/bcy;...
Refer to Table 1. Write the Excel formula for each cell marked with “?” in columns B, C and D such that formula could be copied and pasted into columns D, E, F and G using Microsoft Excel without further editing. There is no need to explicitly write the Excel formula for cells marked with “Copy & paste”. Label each formula clearly with cell reference position. In 2020, BS Bank employs 800 employees in its call centres in the United States...
CASE 1-5 Financial Statement Ratio Computation Refer to Campbell Soup Company's financial Campbell Soup statements in Appendix A. Required: Compute the following ratios for Year 11. Liquidity ratios: Asset utilization ratios:* a. Current ratio n. Cash turnover b. Acid-test ratio 0. Accounts receivable turnover c. Days to sell inventory p. Inventory turnover d. Collection period 4. Working capital turnover Capital structure and solvency ratios: 1. Fixed assets turnover e. Total debt to total equity s. Total assets turnover f. Long-term...