Compute the Labor Cost for each product

Assignment Help Other Subject
Reference no: EM132298722

Computer Applications in CSET Assignment - Final Spreadsheet Workbook Lab

Step 1 - Go to Blackboard and Open "Final_Workbook_Data"

Note: As you go, put borders around all data. Data needs to be in the proper format, example currency for costs. All data must be visible and legible. Points will be lost for: no borders, wrong format, illegible and misspellings.

Step 2 -

a. In Column F, create a column titled "Labor Cost". Using a formula, compute the Labor Cost for each product

b. In Column G, create a column titled "Unit Cost: Using a formula that includes Materials, Labor and Shipping Costs.

c. In Column H, create a column titled "Unit Labor Cost %". Using a formula, compute the percentage of labor cost for each unit. 2 decimal places.

d. Using a formula, compute the Totals for Columns B-G [excluding H.] Fill cell H17, with a dark green shade.

e. Center the data in columns C + E, and format column E data with a comma separator.

f. In Column I, create a column titled "Unit % of Sales". Using a formula, compute the % of each unit again the total sales. 4 decimal places.

g. In Column J, create a column titled "Overhead per Unit". Using a formula, compute the monthly overhead costs for each sold unit.

h. Using a formula, compute the totals for I17 and J17.

i. In the Title in A1, Insert your initials and center across the sheet.

j. Center all the titles, use a light grey fill on the data in rows 2 + 3, merge and center row 1.

Step 3 -

a. Apply Conditional Formatting so that in Labor Costs, >250 is dark red text and light red fill and <250 is green fill with dark green text.

b. Apply Conditional Formatting so that in Unit Labor Cost, > 70% is Bold Italic purple text.

c. Create a Line Chart with markers, showing the Unit Labor Cost. Chart Title = Unit Labor Cost %, black and bold text. Make sure all data is legible.

d. Re-name Sheet 1 - Products

Step 4 -

a. Go to Sheet 2 and Rename the tab, Employees

b. In Column D, create a column titled "Annual Salary". Wrap the text on the title. Using a formula, based off of the national standard for full-time workers per year, according to the U.S. Office of Personnel Management.

c. In Column E, create a column titled "Annual Health Ins Cost". Wrap the text on the title. Using a formula, compute the annual cost of Health Insurance for each employee.

d. In Column F, create a column titled "Annual Workers Comp Cost". Wrap the text on the title. Using a formula, compute the annual cost of Worker's Comp Insurance for each employee.

e. In Column G, create a column titled "Annual Unemp. Ins. Cost". Wrap the text on the title. Using a formula, compute the annual cost of Unemployment Insurance for each employee.

f. In Column HI, create a column titled "Total Emp. Cost". Using a formula, compute the annual costs for each employee. [Salary and all Insurance]

g. Using a Formula, compute all Total Columns. Merge and Center Acme Industries and Admin Employees across the data.

h. Sort the data based upon Employee Name, Ascending. Make sure the data stays aligned correctly to the employee.

i. Create a 3D Pie Chart that shows the Total Employee Cost by %. Name the Chart, "Your_Initials Employee Cost." (Use your own initials) Move the Legend to the right of the chart.

Step 5 -

a. Title Sheet 3 - 2020.

b. Copy the entire Employees sheet and paste it into the 2019 sheet.

c. Change the Health Insurance rate to 31%, format stays as number.

d. Change the Workers Comp rate to 9%, format stays as number.

e. Change the Unemployment rate to 19%, format stays as number.

f. In Column I, create a column titled "Cost Increase". Wrap the text on the title. Using a formula, compute the Cost Increase of the Employees. [Total Emp Cost from 2020, minus the Total Emp Cost from the Employees sheet.]

Step 6 -

a. Go to Sheet 4 and rename it "Food Dist"

b. Create a Pivot Table, making a new worksheet that shows the Products in rows, with the Customer Information in columns.

c. For your Values, you only want the 2 Quarter [Qtr 2]

d. Insert a Slicer to your Pivot Table so that only the Customer Names, A-F are shown.

e. Rename your sheet with the Pivot table with your Initials [2-3 Characters]

Step 7 -

Save your workbook and upload your .xls or .xlsx file to Blackboard by the deadline. Be sure to upload the workbook to correct place to receive credit. No credit will be given for files uploaded to the wrong location.

Attachment:- Assignment Files.rar

Reference no: EM132298722

Questions Cloud

Describe advantages and disadvantages of using wikis : Forum: "Blogs" or web logs provide an easy way for people to post opinions on any subject - including work-related issues or individuals. Some businesses have.
Define step-by-step process of conducting dismissal meeting : Describe a step-by-step process of conducting the dismissal meeting. Using Microsoft Word or an equivalent such as OpenOffice, create a chart that depicts.
Explain disadvantages of using a pay-for-performance plan : HR Headline: Pay for Performance in Public Schools Remains Controversial. "Pay for Performance" has made inroads in business, but has remained a hard sell.
How should management and leadership address business : The Internet has created new ways to do business for organizations with much less capital planning as opposed to the high capital needs of traditional brick.
Compute the Labor Cost for each product : ITST 1101 Computer Applications in CSET Assignment - Final Spreadsheet Workbook Lab, Columbus State Community College, USA. Compute Labor Cost for each product
What are the firm major products or services : Mission statement is a description of what an organization actually does, what its business, and why it does it. It is a summary of the mission and values.
Define standards of legal accountability and responsibility : When a reporter makes a mistake in a magazine article by misidentifying a fact, the magazine can run a correction. However, if a health care worker makes.
What are the performance management principles : Compare the difference between job satisfaction and organizational commitment. Determine which is more strongly related to performance for your selected company
Discussing the concepts of project planning : Write a 5 page essay discussing the concepts of Project Planning. Purpose of Planning in a Project. Steps in Project Planning and Scheduling.

Reviews

Write a Review

Other Subject Questions & Answers

  Cross-cultural opportunities and conflicts in canada

Short Paper on Cross-cultural Opportunities and Conflicts in Canada.

  Sociology theory questions

Sociology are very fundamental in nature. Role strain and role constraint speak about the duties and responsibilities of the roles of people in society or in a group. A short theory about Darwin and Moths is also answered.

  A book review on unfaithful angels

This review will help the reader understand the social work profession through different concepts giving the glimpse of why the social work profession might have drifted away from its original purpose of serving the poor.

  Disorder paper: schizophrenia

Schizophrenia does not really have just one single cause. It is a possibility that this disorder could be inherited but not all doctors are sure.

  Individual assignment: two models handout and rubric

Individual Assignment : Two Models Handout and Rubric,    This paper will allow you to understand and evaluate two vastly different organizational models and to effectively communicate their differences.

  Developing strategic intent for toyota

The following report includes the description about the organization, its strategies, industry analysis in which it operates and its position in the industry.

  Gasoline powered passenger vehicles

In this study, we examine how gasoline price volatility and income of the consumers impacts consumer's demand for gasoline.

  An aspect of poverty in canada

Economics thesis undergrad 4th year paper to write. it should be about 22 pages in length, literature review, economic analysis and then data or cost benefit analysis.

  Ngn customer satisfaction qos indicator for 3g services

The paper aims to highlight the global trends in countries and regions where 3G has already been introduced and propose an implementation plan to the telecom operators of developing countries.

  Prepare a power point presentation

Prepare the power point presentation for the case: Santa Fe Independent School District

  Information literacy is important in this environment

Information literacy is critically important in this contemporary environment

  Associative property of multiplication

Write a definition for associative property of multiplication.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd