Let experts handle it, then spot the difference! ORDER NOW
How Much Does It Cost Case Study
Purpose
The goal of this assignment is to practice creating an Excel document and using the built-in calculations tool.
How much does it cost?
You may think that taking a few Post-It® Notes for personal use or arriving to work a few minutes late doesn’t matter. This assignment uses Microsoft®Excel (or Google Sheets) to create a spreadsheet of how much a company loses each day/year to theft.
Before you begin this assignment, I strongly recommend you take this refresher course on Microsoft®Excel. (Links to an external site.)
Once you have looked through the training videos and are ready to proceed, begin by creating a new Microsoft®Excel workbook.
Instructions
Using Microsoft®Excel, create a spreadsheet utilizing the information in the scenarios below.
- Add a Title to your spreadsheet for your fictitious company and a subtitle identifying the information you are displaying.
- Add appropriate columns to your spreadsheet and add a heading to each column.
- Add borders to your columns and rows for clarity, if desired.
- Incorporate the information below into that spreadsheet.
- Using the Excel calculation tools, determine how much employee theft costs your fictitious company of 30 employees over the course of one week.
To determine the formula for each calculation, think about how many people are involved, the number of items/time involved and the cost per item/time. For example, the formula calculating the total amount for the first scenario below would be [=3*2*0.67] meaning three workers each taking two packs costing $0.67 each. - Add another column and perform calculations to see how much employee theft costs a fictitious company of 30 employees over the course of one year.
- How does this information effect your opinion about the impact of employee pilfering? Include a short explanation below your spreadsheet information.
Here’s an example:
NOTE: Please do not just put a number in the weekly and yearly total cells. I need to see your calculation formula.
Here Are the Scenarios
Five workers each take home two packs of Post-It®Notes, at a cost of $.67 per pack.
Two workers arrive at work 15 minutes late, at a cost of $11/hour.
Four workers take an extra half-hour for lunch, at a cost of $14/hour.
Three employees play computer games for a total of 4 hours each, at a cost of $10/hour.
One employee sends three personal packages at the company’s expense, at a cost of $7, $4.50, and $12.
One worker makes 300 personal copies on the company photocopier, at a cost of $.05/copy.
Three workers call in sick for one 8-hour day when they are healthy, at a cost of $10/hour.
Ten workers spend one hour each sending personal emails, at a cost of $10/hour.
ORDER an A++ paper from our MASTERS and DOCTORATE WRITERS
Who We Are
We are a professional custom writing website. If you have searched for a question and bumped into our website just know you are in the right place to get help in your coursework.
Do you handle any type of coursework?
Yes. We have posted over our previous orders to display our experience. Since we have done this question before, we can also do it for you. To make sure we do it perfectly, please fill out our Order Form. Filling the order form correctly will assist our team in referencing, specifications, and future communication.
Is it hard to Place an Order?
ORDER NOW FOR AN ORIGINAL PAPER ASSIGNMENT
1. Click on the “Order Now” on the Main Menu and a new page will appear with an order form to be filled.
2. Fill in your paper’s requirements in the “PAPER INFORMATION” section and the system will calculate your order price/cost.
3. Fill in your paper’s academic level, deadline, and the required number of pages from the drop-down menus.
4. Click “FINAL STEP” to enter your registration details and get an account with us for record-keeping and then, click on “PROCEED TO CHECKOUT” at the bottom of the page.
100% Reliable Site. Make this your Home of Academic Papers.
SCORE A+ WITH HELP FROM OUR PROFESSIONAL WRITERS: ORDER NOW FOR AN ORIGINAL PAPER ASSIGNMENT
Always Order High-Quality Academic Papers from HERE
5. From there, the payment sections will show, follow the guided payment process and your order will be available for our writing team to work on it.
We will process your orders through multiple stages and checks to ensure that what we are delivering to you, in the end, is something that is precise as you envisioned it. All of our essay writing service products are 100% original, ensuring that there is no plagiarism in them. The sources are well-researched and cited so it is interesting. Our goal is to help as many students as possible with their assignments, i.e. our prices are affordable and services premium.
Looking for a Similar Assignment? Order a custom-written, plagiarism-free paper