Simple Program Budget Template

12/26
99

Simple Program Budget Template

Posted in:

In this post we're going to walk through how our favorite fictional company Litware uses PerformancePoint Services with SharePoint list data to do simple 'under budget' KPIs. In Litware's party planning committee we log how much we spend on events using a SharePoint list. Corporate's creating a corporate balanced scorecard using PerformancePoint Services, and they've asked us to contribute a KPI showing how we're doing. For now our KPI will be based on the data we have, and the rules will be >100% budget is warning, >120% budget is bad. Later we can swap in other sources of information, for example employee anticipation around the next golf scramble, into the KPI's definition to make it a more accurate or more predictive metric, and the changes will flow into the higher level scorecard that uses the KPI. Here's a sample of our spending history list. Let's create the KPI and scorecard from this point.

I launch from the Business Intelligence site template homepage. First I create a new data connection using the SharePoint List template: After the data source appears in Workspace Browser I give it a name and point it towards the specific list in the site: Very important: based on the settings above, the must have access to the list.

Simple Program Budget Template

I can find out if it does by clicking 'Test Data Source.' I'm done with the data source, so I save the data source to SharePoint: Now we're ready to build the KPI and a test scorecard. Hewlett Packard Printer Software Download Mac. I create a scorecard in PerformancePoint Content using the SharePoint List template; this will create both our KPI and the test scorecard: Next I select the data connection we created. Then on the next screen I add a KPI, select the columns representing Actual and Target, and select 'Closer to Target is Better' for some flexibility later: I click 'Next' through the rest of the wizard to get a KPI and scorecard added to the workspace, and I see what I have so far as the scorecard updates. The exact rules haven't been set yet (remember we're after >100% budget is warning, >120% budget is bad) and I'm going to get a stern warning if I format dollars with this precision: To change these I need to edit the KPI. I select it in the Workspace Browser, and then change the number format and thresholds: That's better! Although corporate probably won't care about this detail when they integrate the KPI into their scorecard, I can break the number down by the individual event titles, or any other column in the list, by dragging the field into the scorecard.

Tip: I use the 'Named Sets' instead of 'Dimensions' so that new rows in the SharePoint list will automatically show up in the scorecard: After I click Update in the Edit tab of the ribbon, here's the result: I save both the scorecard and KPI in the workspace, and now I can put it into SharePoint using the PerformancePoint Services Scorecard webpart. I think I'll touch up the test scorecard for use by our team, and I’ll tell corporate my work here is done; they can find the KPI for broader use at Wade Dorrell Program Manager, Office BI.

This Propel Nonprofits guide and accompanying spreadsheet template break down the process of understanding true program costs. A program booklet is designed for your help, because you can state all important points to accompany it to your event. You can write a schedule of performance.

What I have been fighting is the negative numbers in the Target field. If I am over I want negative but if I am under I would want positive numbers. I have used other calculations in the KPI and get totally obscurred numbers when using scoring patterns of Decreasing is Better or Increasing is Better. Is there a simple method when you have a target value that you are trying to meet for the year, and to determine if you are positive or negative that target? Like in this example are you above or below your target. Where to get backlins.

Backlinks enable you to keep track of other pages on the web that link to your posts. For instance, suppose Alice writes a blog entry that Bob finds interesting. Bob then goes to his own blog and writes a post of his own about it, linking back to Alice’s original post. Now Alice’s post will automatically show that Bob has linked to it, and it will provide a short snippet of his text and a link to his post.

What it all works out to is a way of expanding the comment feature such that related discussions on other sites can be included along with the regular comments on a post. Once everything is set up, you’ll see a new link marked ’Links to this post’ next to the comment link for each post. If you click that link you’ll be taken to the post page, where the backlinks are all listed beneath the comments. Clicking the triangles next to each link will display a snippet of text from the page linking to you, as well as some author and date information.

But the task of creating a budget for a new project may be a bit daunting- especially if the project manager has had little or no experience coordinating projects. Some expenses, such as salaries, utilities, rent, or equipment costs, may seem pretty straight forward. But there are many contingencies and unknowns that may affect how and when the project is carried out and ultimately completed.

The most important point to keep in mind is that although a project budget should be based on concrete numbers and accurate assessments of the resources needed to complete the task, the bottom line is that a budget is meant to be an estimate. What Should You Include in Your Project Budget? A detailed, line-item should be divided into categories such as salaries, fringe benefits, travel, supplies, and equipment. Make sure to also include any overhead costs (called 'indirect costs') that will be associated with the project. Here is a brief description of some of the major expenses you will need to include: • Employee compensation: This section includes the salaries and wages of all full, part-time, and temporary employees involved in the project. You should also include any other benefits and incentives that may not be reflected in their take home pay. • Contract Services: Here you should include outsourced services or workers, such as consultants • Equipment/Supplies: This section covers expenses for office supplies, postage, copier supplies, telephone, fax, computer supplies, equipment repair and maintenance, laboratory consumables, etc.

• Travel/Related Expenses: Make sure that you include any air travel, out of town expenses, conference travel expenses as well as daily parking and mileage expenses Cisco Wireless Adapter Driver. . • Overhead or Indirect costs: Your budge should also include overhead expenses (indirect costs), which allow the project to bear a portion of the administrative costs of the day-to-day operation.. An Example of Project Management Budget The following is an example of the typical expenses included in a project budget. To assist you in your budgeting efforts, this sample budget can also be downloaded as a.

Feel free to use it and modify it where needed. PROLECT EXPENSES: EMPLOYEE COMPENSATION: • Salary • Bonus & Commissions • Employee Incentive • Employee Benefits • Temporary Labor Total Salary & Benefits OTHER EXPENSES: • Seminars & Training • Consulting Fees • Legal Fees • Other Professional Fees • Contracted Services • Recruitment • Advertising • Marketing Materials • Travel & Entertainment • Office Expense • Telephone • Computer Lease • Repairs & Maintenance • Utilities • Office Supplies • Dues & Subscriptions • Office Rent • Postage • General Insurance • Taxes & Licenses • Software Licenses Total Other Expenses Total Budgeted Expenses.