1 / 30

Licensed Costing Model Demonstration

This licensed spreadsheet model calculates total compensation over multiple years and allows for 'What-If' scenarios. Follow guided steps to fill in data, create salary schedules, input insurance costs, manage extra duties, and add staff data easily. Get detailed insights into salary costs, other expenses, and total costs for informed decision-making.

mwinkler
Download Presentation

Licensed Costing Model Demonstration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Licensed Costing Model Demonstration

  2. 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

  3. One CD with everything you need

  4. Open the file

  5. Accept the license

  6. Click the Model Menu Button

  7. Click the [Ok] button to get started Select the desired steps Select 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.

  8. Click the [Ok] button to continue Step 1 – Fill in model information Fill 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

  9. 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.

  10. Copy existing schedule Click the open file button

  11. Copy an existing schedule Select the file containing your existing salary schedule and click the [Open] button.

  12. Click here to finish Copy an existing schedule Select the salaries to be copied

  13. Click the [Copy] button to copy the salaries into the model Click the [Yes] button to confirm Copy an existing schedule

  14. Click the [New] button to enter more insurance premium data or click the [Close] button to finish data entry Step 3 – Fill in Insurance Costs Type in the requested information

  15. Completed Insurance Information

  16. Click the [New] button to enter more extra-duty schedule data or click the [Close] button to finish data entry Step 4 – Fill in extra-duty schedule Type in the requested information

  17. Completed Extra-Duty Information

  18. Step 5 – Fill in Staff Data Step 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…

  19. Click the [Ok] button Type in staff data Witt, Katarina PPO Single 100% 1.0 2 3 Begin typing the requested information for each employee

  20. Click the [Copy Formulas] button after entering all your staff information Type in staff data

  21. Click on the {Summary Sheet} tab to start using the model Model Complete!

  22. Adjust the Base % Increase

  23. Adjust the Insurance Cap

  24. What you get – Salary Costs See 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

  25. What you get – Other costs See 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

  26. What you get – Total Costs

  27. See the employee’s salary, step cost, total percent increase, insurance contributions and extra-duty pay for each year What you get – Staff detail Type in an employee’s current information

  28. What you get – Salary Schedules for each year

  29. Enter your initial proposal’s base percent increase Enter the base percent increase offered by your opponent See your total See the cost of the new figure “What if” scenarios

  30. http://www.osba.org

More Related