Documentation
Shelly Cashman Excel 2019 | Module 9: SAM Project 1a
Maxwell Training
FORMULA AUDITING, DATA VALIDATION, AND COMPLEX PROBLEM SOLVING
Author: FATEMATUZ ZAHARA
Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website.
Blended Training
Maxwell Training
Orientation Tech Skills Soft Skills Product Mandatory
Training fee per person $ 150 $ 495 $ 329 $ 229 $ 495
Sessions per program 2 12 10 6 4
Minimum trainees 10 - 0 15 20 10
Online access fee $ 500 $ 1,200 $ 750 $ 500 $ 750
Gross Income $ 2,000 $ 1,200 $ 5,685 $ 5,080 ERROR:#VALUE!
Number of trainers 2 5 3 3 3
Trainer cost $ 525 $ 1,100 $ 1,000 $ 785 $ 1,100
Materials cost $ 470 $ 1,400 $ 650 $ 750 $ 1,200
Expenses $ 1,520 $ 6,900 $ 3,650 $ 3,105 $ 4,500
Income stats
Per program $ 480 $ (5,700) $ 2,035 $ 1,975 ERROR:#VALUE!
Per session $ 240 $ (475) $ 204 $ 329 ERROR:#VALUE!
Per trainee ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#DIV/0! ERROR:#VALUE!
Average income
Per program ERROR:#VALUE!
Per session ERROR:#NAME?
Per trainee ERROR:#DIV/0!
Tutorial Fees
Maxwell Training
Orientation Tech Skills Soft Skills Product Mandatory
Trainer cost per day $ 360 $ 480 $ 480 $ 375 $ 400
Materials cost $ 65 $ 35 $ 55 $ 120 $ 100
Total cost $ 425 $ 515 $ 535 $ 495 $ 500
Maximum trainees per day 24 8 32 24 32
Enrolled trainees per day 15 6 24 16 12
Training fee per person $ 75 $ 125 $ 100 $ 80 $ 95
Average profit per program $ 700 $ 235 $ 1,865 $ 785 $ 640
Average profit per trainee $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX
New Fees
Maxwell Training
Orientation Tech Skills Soft Skills Product Mandatory
Trainer cost per day $ 360 $ 480 $ 480 $ 375 $ 400
Materials cost $ 65 $ 35 $ 55 $ 120 $ 100
Total cost $ 425 $ 515 $ 535 $ 495 $ 500
Maximum trainees per day 24 8 32 24 32
Enrolled trainees per day 15 6 24 16 12
Training fee per person $ 75 $ 125 $ 100 $ 80 $ 95
Average profit per program $ 700 $ 235 $ 1,865 $ 785 $ 640
Average profit per trainee $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX
Webinars
Maxwell Training
Webinar Schedule
Orientation Tech Skills Soft Skills Product Mandatory Total
Tuesday webinars 0 0 0 0 0 0
Thursday webinars 0 0 0 0 0 0
Webinars per week 0 0 0 0 0 0
Webinars - Profit Analysis
Orientation Tech Skills Soft Skills Product Mandatory Total
Profit per Tuesday webinar $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX 200.00
Subtotal profit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 - 0
Profit per Thursday webinar $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX $ XXXXXXXXXX 220.00
Subtotal profit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 - 0
Total weekly profit $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
Consultations
Tech Management Total
Tuesday consultations 0 0 0
Thursday consultations 0 0 0
Consultations per week 0 0 0
Maximum weekly profit model