Closed

Create and update given excel sheet with formula

Update excel sheet according to given Instructions and using knowledge of Risk management in Project.

Instructions:

[url removed, login to view] year Mega Corp noted an average absenteeism rate of 4 days per employee per year. Create a column that represents the number of employees to expect in a session. If 33 employees are in the session, then how many employees can we expect?

[url removed, login to view] might involve time, money or scope. Try to calculate the cost of a training session. We are taking each employee away from their job for 1 day. Someone must be hired temporarily to take over. Let’s budget $200 for each temp. What is the cost of each training day?

[url removed, login to view] transportation to the site might fail. Your supervisor worries a lot and wants to mitigate this risk – she wants you to arrive a day early. One trainer’s daily salary would be the only additional cost. ( this is our assumption – pick a cost for the day ) If you miss the first session, then the cost is the trainees’ daily salaries. ( the temps are hired and paid in advance ) Calculate the frequency of the risk of the transportation failing that will make arriving a day early an advantage.

[url removed, login to view] suggested training 40 employees at a time. The room holds 40 people, so we could teach them in groups of 40, 40 and 20. Does this lower the chance of an employee being absent? Does is lower the consequence of the absenteeism? If it does, by how much? Maybe if it’s 20,40,40 then the risk of the transportation failure is less?

Values used in this project are given in Excel Sheet in Green Cells on top on sheet

Skills: Excel

See more: microsoft excel formulas list with examples, how to put formula in excel 2007, how to put percentage formula in excel, how to create a formula in excel 2016, ms excel formula list in pdf, how to create a custom formula in excel, excel formulas, how to create a formula in excel for multiple cells, i need to create a leave excel sheet, hiring someone to create a budget excel sheet australia, excel sheet formula, update stock excel sheet ebay, create statement cash excel sheet, edit excel sheet 2000 cells edit manually, edit excel sheet 2000 cells edit manually repost

About the Employer:
( 1 review ) HAMILTON, Canada

Project ID: #16705633

4 freelancers are bidding on average $36 for this job

schoudhary1553

Hello, I have the good knowledge of Create and update given excel sheet with formula . I have more than 5 years of experience in Excel We have worked on several similar projects before! We have worked on 300+ Proje More

$50 CAD in 1 day
(213 Reviews)
7.3
BHARATBEURA

Dear Sir I have completed many similar projects in freelancer details of which you can find in my profile. Please message me for further details over the project. REGARDS BHARAT

$55 CAD in 2 days
(11 Reviews)
3.8
$25 CAD in 1 day
(3 Reviews)
1.2
andrewmikhail95

hi my name is andrew mikhail i can do this for u in less time and u will get a perfect work i can send u more than 1 sample ;)

$15 CAD in 1 day
(1 Review)
1.3