logo Use CA10RAM to get 10%* Discount.
Order Nowlogo
(5/5)

Create a spreadsheet that will itemize the details of the training

INSTRUCTIONS TO CANDIDATES
ANSWER ALL QUESTIONS

Budget for Professional Development for the year 2022:

 

You have been asked by the owners of the clinic to prepare a budget for the funds you would like to spend on your employees for Professional Development in 2022. 

Create a spreadsheet that will itemize the details of the training and total each type of training include a grand total for all professional development budget for 2022.

There are 3 different types of training: 1-In-service Sessions, 2-Continuing Education and 3-Block conferences. Your job is to enter all details for each category and total the cost f each category and then a grand total for all of them. 

Open the spreadsheet: ProfDeveopBudget, and save it as: ProfDeveopBudget_YourName.

Create a documentation sheet explaining why you are creating this spreadsheet and include the date, your name and student number. Add a header with the file name code in the middle; and a footer with your name and student number. 

Make sure you have 2 sheets: 1-Documentation and 2-Data. (you will need to rename the sheets from --Sheet1 and Sheet2)

On a new sheet called: Data Sheet, enter the details, (some of the details are entered for you):

1. There are 15 in-service sessions to be run throughout the year, and they cost $60.00 per session

2. The continuing education courses are: 

(1) 18 for doctors at $350.00 per course

(2) 30 for nurses at $295.00 per course

(3) 12 for respiratory therapists at $185.00 per course

(4) 14 for anesthesiologists at $192.00 per course

(5) 11 for radiologists at$195.00 per course

(6) 10 for physical therapists at $160.00 per course

(7) 10 for management staff at $150.00 per course

(8) 10 for support staff at $135.00 per course

 

3. The hospital buys block registrations for the following conferences:

1) AMA annual conference $6,500.00

2) Nursing conference $5,750.00

3) Respiratory Conference $4,100.00

4) Radiological Society conference $2,250.00

5) Anesthesiologists conference $3,700.00

6) Physical Therapy conference $1,775.00

7) Hospital association conference $1,950.00

You will need to use simple functions, such as SUM to create a total for each category of training, then a grand total at the bottom of the sheet for all 3 categories. For the grand total: be careful to add only the totals from each category not the details. 

Formatting:

Format the data sheet the way you like, but it must contain: 

Use cell borders; fill colour; different font styles, size and colour of fonts; cell alignments and any other formats that you would like

Make sure all dollar amounts are formatted as currency (using $, not foreign currency) 

Insert the clinic logo in the upper left corner of the data sheet – size it to make it fit and look professional, be sure to keep the “aspect ratio”

The heading can be formatted as you like; but it must be centred, line by line over the spreadsheet

Insert an appropriate picture or graphic from the internet and be sure to cite where you found it

Apply conditional formatting to the price of the conferences to show graphically the cost of the conferences

Don’t forget to check your Spelling 

Review how each sheet will print out, making sure to use the proper paper size, NOT A4

You can decide to use either Portrait or Landscape Orientation

Keep the Data sheet to fit to one page

Final:

The final workbook should contain 2 sheets: Documentation Sheet and Data Sheet

Remember to save it as: ProfDeveopBudget_YourName and upload it to e-Conestoga

 

 

(5/5)
Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. Develop a program to emulate a purchase transaction at a retail store. This program will have two classes, a LineItem class and a Transaction class. The LineItem class will represent an individual

Develop a program to emulate a purchase transaction at a retail store. Thisprogram will have two classes, a LineItem class and a Transaction class. Th

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

Ask This Question To Be Solved By Our ExpertsGet A+ Grade Solution Guaranteed

expert
Um e HaniScience

502 Answers

Hire Me
expert
Muhammad Ali HaiderFinance

963 Answers

Hire Me
expert
Husnain SaeedComputer science

823 Answers

Hire Me
expert
Atharva PatilComputer science

764 Answers

Hire Me