# 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

( 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

(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