Question: Show Screenshot of spread sheet Create a spreadsheet using the information provided to tally the number of seats purchased for each course each by month

Show Screenshot of spread sheet

Create a spreadsheet using the information provided to tally the number of seats purchased for each course each by month and by customer and amount per seat. The spreadsheet should also be able to calculate the revenue made from each course for each month. Lets use this information to assume the month of May 2023

Show Screenshot of spread sheet Create a spreadsheet using the information provided

For example: Mechpart purchased 10 courses and 33 seats. That means they purchased 10 full courses and 33 people took each course.

This is the list of courses taken by customers

Customer Course Month
Merch Part Driving Safely May
Merch Part Fall Protection May
Merch Part Portable Ladder May
Merch Part PPE May
Merch Part Scaffolding May
Merch Part Struck By May
Merch Part Walking & Working May
Merch Part Workplace Ergonomics May
Merch Part May
Merch Part May
Synergy Electrical May
Synergy Fall Protection May
Synergy Skid Steer May
Synergy Struck By May
EN (PPE) PPE May
Hawks Bloodbourne May
Hawks Caught In Between May
Hawks Confined Space May
Hawks Driving Safely May
Hawks Electrical May
Hawks Fire Safety May
Hawks Forklift Safety May
Hawks HazCom & GHS May
Hawks LOTO May
Hawks PPE May
Hawks Respiratory May
Hawks Struck By May
Hawks Walking & Working May
Hawks Workplace Ergonomics May
Rotobec Bloodbourne May
Rotobec Caught In Between May
Rotobec Confined Space May
Rotobec Electrical May
Rotobec Emergency Preparedness May
Rotobec Fire Safety May
Rotobec Forklift Safety May
Rotobec HazCom & GHS May
Rotobec LOTO May
Rotobec Machine Guarding May
Rotobec Noise & Hearing May
Rotobec Portable Ladder May
Rotobec PPE May
Rotobec Respiratory May
Rotobec Struck By May
Rotobec Walking & Working May
Rotobec Workplace Ergonomics May

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!