licensed costing model demonstration. what is it? spreadsheet model calculates total compensation...
TRANSCRIPT
![Page 1: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/1.jpg)
Licensed Costing Model Demonstration
![Page 2: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/2.jpg)
What is it?
Spreadsheet model
Calculates total compensation over multiple years
Create “What-If” scenarios
When this button appears on screen and you are ready to continue, click
your mouse
![Page 3: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/3.jpg)
One CD with everything you need
![Page 4: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/4.jpg)
Open the file
![Page 5: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/5.jpg)
Accept the license
![Page 6: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/6.jpg)
Click the Model Menu Button
![Page 7: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/7.jpg)
Select the desired stepsSelect the steps to
complete by clicking the
boxes next to the step.
You can skip steps you don’t
need by leaving the box
unmarked.
Click the [Ok] button to get
started
![Page 8: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/8.jpg)
Step 1 – Fill in model informationFill in the description for the model (appears on each sheet) and other requested information
Fill in the column headings and the
number of the last step on the column
Click the [Ok] button to continue
![Page 9: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/9.jpg)
Step 2 – Create Salary Schedule
Step 2 gives you three methods for creating a salary schedule:
Type in allows you to type each salary in using an Excel data form
Copy allows you to copy the entire schedule from an existing Excel file
Create a structured schedule creates the schedule from a base salary, the column increment and the step increment
The most common method is to copy the schedule, so we’ll choose this option.
![Page 10: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/10.jpg)
Copy existing scheduleClick the open file
button
![Page 11: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/11.jpg)
Copy an existing schedule
Select the file containing your existing salary
schedule and click the [Open] button.
![Page 12: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/12.jpg)
Copy an existing schedule
Select the salaries to be copied
Click here to finish
![Page 13: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/13.jpg)
Copy an existing schedule
Click the [Copy] button to copy the salaries into the
model
Click the [Yes] button to confirm
![Page 14: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/14.jpg)
Step 3 – Fill in Insurance Costs
Type in the requested information
Click the [New] button to enter more insurance premium data
or click the [Close] button to finish data entry
![Page 15: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/15.jpg)
Completed Insurance Information
![Page 16: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/16.jpg)
Step 4 – Fill in extra-duty schedule
Type in the requested information
Click the [New] button to enter
more extra-duty schedule data
or click the [Close] button to finish data entry
![Page 17: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/17.jpg)
Completed Extra-Duty Information
![Page 18: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/18.jpg)
Step 5 – Fill in Staff DataStep 5 gives you two methods for adding staff data to the model:
Type in allows you to type each staff person’s information directly on the {Staff List} worksheet.
Copy allows you to copy the staff information from an existing Excel file. (The file must have the same 11 columns as the first 11 columns on the {Staff List} worksheet.
When you choose Type in, the system displays the {Staff List} worksheet as shown next…
![Page 19: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/19.jpg)
Type in staff data
Click the [Ok] button
Begin typing the requested information for each
employee
Witt, Katarina PPO Single 100% 1.0 2 3
![Page 20: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/20.jpg)
Type in staff data
Click the [Copy Formulas] button after entering all your staff information
![Page 21: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/21.jpg)
Model Complete!
Click on the {Summary Sheet} tab to start using the model
![Page 22: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/22.jpg)
Adjust the Base % Increase
![Page 23: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/23.jpg)
Adjust the Insurance Cap
![Page 24: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/24.jpg)
What you get – Salary CostsSee the top and bottom of your schedule at a
glance.
See the average teacher salary and the total FTE.
See the cost of increasing the base salary, the cost of giving a step and the
total salary cost
![Page 25: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/25.jpg)
What you get – Other costsSee the total for
extra-duty pay and the percent
increase over the previous year’s
costs See the total cost for additional employer
benefits such as FICA, retirement and Worker’s
Compensation
See the lowest employee contribution, the highest
employee contribution and the total employer
contribution
![Page 26: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/26.jpg)
What you get – Total Costs
![Page 27: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/27.jpg)
What you get – Staff detail
Type in an employee’s current information
See the employee’s salary, step cost, total percent increase, insurance contributions and extra-duty pay for each year
![Page 28: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/28.jpg)
What you get – Salary Schedules for each year
![Page 29: Licensed Costing Model Demonstration. What is it? Spreadsheet model Calculates total compensation over multiple years Create What-If scenarios When this](https://reader036.vdocuments.us/reader036/viewer/2022070307/551a42b755034619378b5f88/html5/thumbnails/29.jpg)
“What if” scenarios
Enter your initial proposal’s base percent increase
See your total
Enter the base percent increase offered by your
opponent
See the cost of the new figure