For this assignment, you will set up a spreadsheet to track labor costs for the given...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
For this assignment, you will set up a spreadsheet to track labor costs for the given scenario below. This assignment will give you practice in setting up a basic spreadsheet with calculations and then linking that data to another tab (worksheet). You will also build upon the output from this assignment in future modules as you learn more concepts about spreadsheet functionality. First, create an Excel spreadsheet and name the document "Labor Hours." Label the first tab of the document Data. Then, complete the following steps: 1. In the Data tab, create a table with the following information: a) Employees' names b) Each employee's hourly rate c) The number of hours per day for five days for each employee 2. Use basic formulas to calculate the following: a) The total amount of hours each employee worked for five days b) The labor cost for each employee c) The total labor cost for the project 3. Within the same document (workbook), set up a separate tab labeled Data Link. In this tab, set up a blank table and populate the table by linking the cells to the data from the table you created in the Data tab. Note: For this part of the assignment it may be tempting to simply copy and paste the table and formulas from the Data tab. However, it is important that you learn to link data from one tab to another. In the real world, you could have a spreadsheet with multiple tables on multiple tabs all pulling from the same dataset. If you copy data instead of linking it, you will have to update every table. However, if you link the data, all of the tables will automatically update if any of the data changes. Hint: On your separate worksheet, if you click on any cell that is importing data, you will see the name of the original worksheet (the name on the tab), followed by an exclamation point, before the cells are listed. For example: sheet1!A2. You are examining labor costs for a construction project using eight employees: The eight employees' names are: Smith, Rodriquez, Daniel, Eli, Lee, Kim, Buster, and Green. Each employee worked eight hours a day for five days. The employees' wages per hour are as follows: Smith: $8.95 ● O O Rodriguez: $11 O Daniel: $14 O Eli: $16 Lee: $19 Kim: $20 Buster: $25 Green: $40 000 Scenario O For this assignment, you will set up a spreadsheet to track labor costs for the given scenario below. This assignment will give you practice in setting up a basic spreadsheet with calculations and then linking that data to another tab (worksheet). You will also build upon the output from this assignment in future modules as you learn more concepts about spreadsheet functionality. First, create an Excel spreadsheet and name the document "Labor Hours." Label the first tab of the document Data. Then, complete the following steps: 1. In the Data tab, create a table with the following information: a) Employees' names b) Each employee's hourly rate c) The number of hours per day for five days for each employee 2. Use basic formulas to calculate the following: a) The total amount of hours each employee worked for five days b) The labor cost for each employee c) The total labor cost for the project 3. Within the same document (workbook), set up a separate tab labeled Data Link. In this tab, set up a blank table and populate the table by linking the cells to the data from the table you created in the Data tab. Note: For this part of the assignment it may be tempting to simply copy and paste the table and formulas from the Data tab. However, it is important that you learn to link data from one tab to another. In the real world, you could have a spreadsheet with multiple tables on multiple tabs all pulling from the same dataset. If you copy data instead of linking it, you will have to update every table. However, if you link the data, all of the tables will automatically update if any of the data changes. Hint: On your separate worksheet, if you click on any cell that is importing data, you will see the name of the original worksheet (the name on the tab), followed by an exclamation point, before the cells are listed. For example: sheet1!A2. You are examining labor costs for a construction project using eight employees: The eight employees' names are: Smith, Rodriquez, Daniel, Eli, Lee, Kim, Buster, and Green. Each employee worked eight hours a day for five days. The employees' wages per hour are as follows: Smith: $8.95 ● O O Rodriguez: $11 O Daniel: $14 O Eli: $16 Lee: $19 Kim: $20 Buster: $25 Green: $40 000 Scenario O
Expert Answer:
Answer rating: 100% (QA)
As we are bound not to share any link I will not be able t... View the full answer
Related Book For
Posted Date:
Students also viewed these marketing questions
-
In this problem, you will set up the accounting, fixed assets, payroll, inventory, and budgeting data for Schaff Irrigation Co. Schaff Irrigation Co. is a merchandising business organized as a sole...
-
Set up a spreadsheet to reproduce Figure 4-15. Add error bars: Follow the procedure on page 90. Use s y for the and + error. Figure 4-15 3 10 m 0.6154 1.3462" style="" class="fr-fic fr-dib"> A B D F...
-
For this assignment you will examine three primary source documents from the British colonial period in North America, and then write a one-paragraph journal entry explaining the similarities and...
-
Discuss sources of revenues Explain the importance of prices and volume in revenue budgeting Clarify why revenues are often ignored in nursing budgets Discuss when revenues should be considered in...
-
Prepare journal entries for each of the following transactions for a company that has a fiscal year-end of December 31: (1) On October 1, $12,000 was paid for a one-year fire insurance policy; (2) On...
-
Use the graph of f(x) = 4x 4 - 4x 3 - 25x 2 + x + 6 shown in the figure to factor the polynomial completely. f(x) = 4x4 - 4x 25x + x + 6 y HF #B 20- 10 1---10 -20- -30- -40- -50- -60- LOLIT II H X
-
A current loop lies in the \(x y\) plane, with the current circulating counterclockwise when viewed from the positive \(z\) axis. Is there a torque on the loop, and if so, in what direction, if a...
-
It is important in accounting theory to be able to distinguish the types of accounting changes. Required 1. If a public company desires to change from the sum-of the- years-digits depreciation method...
-
In a high-profile criminal trial, the defendant alleges that their confession was coerced by law enforcement officers during interrogation. How might the court assess the admissibility of the...
-
The Lead-Tin phase diagram: a) Show the eutectic three phase reaction on this phase diagram. b) A Pb-45% Sn alloy is cooled from 300C to 100C. What phases are present for this alloy at this...
-
Who does protectionism generally hurt? Foreign consumers O Domestic producers Domestic consumers and foreign producers Domestic producers and foreign producers
-
2. Write balanced half reactions and complete reactions for the following oxidation-reduction reactions. a.* aluminum(s) + hydrogen ion(aq) aluminum ion(aq) + hydrogen (g) oxid. half rxn.: Alis) =...
-
The Prime Minister of Canada is responding to questions at a press conference. Reporters are in seats in front of his podium, raising their hands to get his attention in order to ask their question....
-
A bag is too heavy if it contains more than 125 pounds of giraffe food. What percentage of the bags would you expect would be too heavy? Assume the following: bags are normally distributed with a...
-
Joe has just received his first credit and decided to use it to pay for part of his tuition for school. He is paying 23% APR interest on credit. He decided he can afford to pay $50 per month to pay...
-
A train traveler named Mark can pay a train ticket or attempt to ride the train for free. If Mark is caught, he must pay a hefty fine. For the train company, checking a traveler's ticket costs money....
-
Assume the tax rate is 40%, the unlevered beta of the firm is 1, and the invested capital is $1,000,000 (200,000 of which is debt). What is the leveraged beta?
-
Refer to the data in QS 10-1. Based on financial considerations alone, should Helix accept this order at the special price? Explain.
-
A. Describe some of the attributes of an ideal risk indicator for stock market investors. B. On the Internet, go to Yahoo! Finance (or msn Money) and download weekly price information over the past...
-
Marginal cost pricing, as well as the use of incremental analysis, is looked upon with favor by economists, especially those on the staffs of regulatory agencies. With this encouragement, regulated...
-
Eye-de-ho Potatoes is a product of the Coeur dAlene Growers Association. Producers in the area are able to switch back and forth between potato and wheat production depending on market conditions....
-
In 2022, Mark purchased two separate activities. Information regarding these activities for 2022 and 2023 is as follows: The 2022 losses were suspended losses for that year. During 2023, Mark also...
-
Jerry sprayed all of the landscaping around his business with a pesticide in June 2023. Shortly thereafter, all of the trees and shrubs unaccountably died. The FMV and the adjusted basis of the...
-
In 2023, Julie, a single individual, reported the following items of income and deduction: Julie owns 100% and is an active participant in the rental real estate activity. What is her taxable income...
Study smarter with the SolutionInn App