UQSRC 2/10/2012 How To Use Spreadsheet
How to Use the Spreadsheet
The “Budget Entry” worksheet is the ONLY one where costing information is entered.
NOTE: You must enable macros on Excel for this to work. Office 2000/2003: Tools -> Macros -> Security -> Medium level (you can
choose whether to enable or disable macros upon Excel startup). Restart the program if the macros were already disabled.
Office 2007: Office button -> Excel Options -> Trust Centre -> Trust Centre Settings -> Macro Settings -> Enable all macros (you
can disable them again when not using this spreadsheet). Restart the program if the macros were already disabled.
1. Header Section: Enter information in Pale Yellow Sections only
· Project Title; Project Investigator Name; School or Centre (drop-down list); Client Name (cells B4 to B7)
· Start Date (dd/mm/yyyy); End Date (dd/mm/yyyy) (cells B9 to B10).
· Please ensure that the dates are correct, then hit the "Create New Yrs" button to create the full set of entry tables for each
year of the project. If you need to reset the number of year entry tables, hit the "Reset All" button (NOTE: you will lose all the
data entered except for the first year, BE CAREFUL WHEN SETTING DATES!).
2. Indirect Cost Rates Section: Enter information in Pale Yellow Sections only
· Choose type of project from drop-down list (cell B14). The indirect cost rates used in the calculations are contained in
B15/16.
· Some faculties use their own salary/non-salary indirect cost rates (BE&E = 60%/0% fwds calculation, Law = 35% off total).
These are determined by what School/Faculty is chosen in the Header section.
3. Other Cost Rates Section: Enter information in Pale Yellow Sections only
· Oncosts include payroll tax, worker's comp, superannuation, recreation leave, long service leave, and maternity leave. Set
by HR every year (http://www.hrd.qut.edu.au/staff/salary/salary/).
· If project extends over more than one year, enter in annual salary increase % based on HR advice on likely increase over
each 12 month period of the project (cell B17, default setting is 4%). Can set to 0 if you don't want to apply an increase.
a795c7a3-452d-4ed8-a1e9-3d20869dac33.xls Page 1
UQSRC 2/10/2012 How To Use Spreadsheet
· Choose whether project is "In-load" (within allocated QUT workload) or "Out-of-load" (in addition to allocated QUT
workload). See MOPP 7.1.11 for more details. This will only affect the distribution of profit margins (if any), as displayed in the
"Mark-up Profit Distribution" table in the "Budget-SUMMARY" worksheet.
· Enter the desired mark-up percentage for non-salary costs. You can use the "Mark-up Calculator" worksheet to help you
identify what this rate would be (hyperlinks from mark-up entry box titles). Use the forward calculation mark-up percentage in
the appropriate non-salary mark-up entry box on the "Budget-ENTRY" worksheet.
· The Mark-up entry boxes are used primarily for adding profit margins. Indirect cost rates are set by faculty/QUT policy.
4. Step 1: Staff names (column A); funding source (column B); position level (column C). Optional mark-up.
· Check worksheets for position level code in the relevant area (use Academic Salaries, General Staff Salaries buttons to go
to worksheet). If funding source is "Other" (i.e. non-APAI/APDI grants, scholarships), fill in the allocated funding amount in
column D.
· If salary mark-up is required, select the mark-up type (percentage or monetary cost per unit) in column E and enter in the
value in column F. For "%", enter in the amount as if it were a whole number (i.e. 35%). For "$", enter in the total cost per unit
desired (i.e. $100/hour).
· If more lines are needed for staff working on the project, use the "INSERT LINES" button. If you need to delete lines, use
the "DELETE LINES" button.
· If staff are getting an annual promotion to the next position level step, add a new line and choose the appropriate level step
for that year.
· For multiple-year projects, the mark-up profit margin on salaries is decreased by the annual salary increase, so you must
add at least enough mark-up percentage to cover the annual salary increases by the end of the project, otherwise you will end
up with a deficit. i.e. you must have at least a forward calculation markup percentage = (annual salary increase) ^(#years of
project - 1)
5. Step 2: Unit of time definition (fortnightly, daily, hourly, casual), and number of units dedicated to the project per
staff member.
· This is the staff time allocation used on the project per calendar year. If you are using casuals on the project they are charged at
an hourly rate. Try to keep the units consistent along the same personnel line, especially if you are applying a salary mark-up as a
total cost per unit ("$").
· If "Other" funding is for different amounts in different years, fill out an individual personnel line for each "Other" funding year and
fill out the funding amount for that year in column D of Step 1, then enter the time allocated under that year heading in the Step 2
table.
a795c7a3-452d-4ed8-a1e9-3d20869dac33.xls Page 2
UQSRC 2/10/2012 How To Use Spreadsheet
o i.e. 2 years of grant funding, year 1 $2000 & year 2 $3000 = 2 personnel lines with the same name, different "other
funding amt" values in Step 1 column D, and different Step 2 entries under the relevant years.
6. Summary of Personnel Marked-Up Costs for 1st Year
· A reality-check display table to see if you get the desired marked-up salary amount from the entries in Step 1 columns E &
F. Shows marked-up cost per unit, marked-up total cost, and the actual profit margin mark-up (what you earn on top of the
base salary rate).
· Also displays the time per year allocated to the project.
7. Year Costing Tables: Other (non-salary) costs are entered in the costing/calendar year tables located below the
"Summary" table.
· Enter in total cost of item in column B, then the amounts within that total coming from Industry and Other sources in
columns C and D (University amount in column E is to make up any shortfalls).
· You can use the Step 2 units table headings hyperlinks to jump to the corresponding year costing table. Use the "Return to
Top" hyperlinks above and below each year costing table to jump back up to the top of the page.
· Use the "In-Kind Equipment Fees' worksheet to calculate the cost of using existing equipment/facilities at QUT (values will
be automatically added to the Budget-ENTRY worksheet). Item costing descriptions are suggestions only. You can access the I-
K worksheet via the hyperlink in the Equipment category in each year costing table.
· Indirect costs at the bottom of each year costing table are calculated per category. Mark-ups are calculated based on direct
+ indirect costs.
8. The Project-DETAILS worksheet allows you to look at the costs of the project without separating out
direct/indirect/mark-up costs.
· Use the "Refresh Table" button to fill the rows with data from the Budget-ENTRY worksheet, and "Clear Table" button to
reset and clear the table.
· This is a helpful reference for the total cost of an item including all mark-ups and indirect costs (industry only).
a795c7a3-452d-4ed8-a1e9-3d20869dac33.xls Page 3
UQSRC 2/10/2012 How To Use Spreadsheet
9. The Budget-SUMMARY worksheet contains the "Cost to Industry", "Cost to QUT" and "Cost to Other Funding
Sources" tables which summarizes the budget for the Client, QUT, and other contributions, per calendar year and for the
entire project.
10. The distribution split of the mark-up is provided in "Mark-up Profit Distribution" on the Budget-SUMMARY
worksheet.
· If the project is "IN-LOAD", all the mark-up profit goes to the cost centre (faculty/QUT). If the project is "OUT-OF-LOAD",
the mark-up profit is split between the cost centre and the workgroup as entered by the user in the entry box below the
distribution table. You will be able to alter the split for different years if desired.
· i.e. If you want to split the profit 25% workgroup/75% faculty, enter 25% in the yellow entry box.
11. The "Client-Summary" worksheet contains the budget summary for client costs without detailing indirect cost
charges or markups.
· Budget-ENTRY, Project-DETAILS and Budget-SUMMARY are for INTERNAL USE ONLY, you can print out and use Client-
Summary tables for proposals.
· You can type in project details in the yellow box below the table (i.e. scope, contact details, etc).
HANDY TIPS:
· You can copy and paste values to the yellow cells from all other cells. Use "Paste Special", "Values" to copy the actual
values, not the formulae or formatting.
· Use the hyperlinks to jump from section to section and avoid excessive scrolling.
· With cursor, roll over cells with red triangles in the top right-hand corner for some helpful comments.
Research Budget Examples
1. Researcher develops project budget for presentation to Client
o Project involves: 10 hours of LEVE1 position level (in-load)
60 hours of HEWA2-4 position level (in-load)
$200 general supplies
$500 phone/fax
$1000 travel
40% desired mark-up on salaries only
a795c7a3-452d-4ed8-a1e9-3d20869dac33.xls Page 4
UQSRC 2/10/2012 How To Use Spreadsheet
o What is the total cost of the project for the client?
o How much are the indirect costs going to the Faculty/QUT?
o What percentage of the project total is the mark-up?
2. Researcher develops same project as above but with “commercial” charge out rates of $150 per hour for LEVE1 and
$100 for HEWA2-4
o What is the total cost of the project for the client?
o What is the profit margin?
o How much are the indirect costs?
o How much gets paid to the work group?
o How much goes to the School/Centre?
3. Researcher develops a project that has an overall cost of $20000 for the researcher's time, including indirect costs
and GST.
o How would you best enter the numbers into the personnel section, keeping in mind that the budget spreadsheet will
automatically calculate indirect costs and GST for you?
o What is the base salary before oncosts?
o How much are the indirect costs?
a795c7a3-452d-4ed8-a1e9-3d20869dac33.xls Page 5
EXTERNAL PROJECT BUDGET PREPARATION ***Hover mouse over boxes with red triangles to view helpful comments***
HEADER SECTION: EDIT YELLOW BOXES ONLY
Project Title
Project Investigator
School/Centre Faculty of
Client Name
Start Date (dd/mm/yyyy) 1/01/2010
End Date (dd/mm/yyyy) 1/1/2012
# Calendar Years involved 3
INDIRECT COST (I/C) RATES:
What kind of project is it?
I/C RATE (SALARY) - OFF TOTAL:
I/C RATE (NON-SALARY) - OFF TOTAL:
OTHER COST RATES:
ON-COSTS (Salaries only): 26.9575%
Annual salary increase: 4.00%
In-load or Out-of-load:
MARK-UP - NON-SALARY (%): 0
STEP 1: PERSONNEL FUNDING SOURCE, POSITION LEVEL & SALARY MARK-UP
Personnel (Salaries) Funding Source Position Level Other Funding Amt Mark-Up Type Mark-Up Applied/Unit
%
%
%
%
%
%
%
%
%
%
Academic General Staff
Salaries Salaries
STEP 2: TIME ALLOTMENT FOR PROJECT
Calendar Yr 2010
Personnel (Salaries) Units # Units
SUMMARY OF PERSONNEL MARKED-UP COSTS FOR 1ST YEAR: (for interest & reality-check only)
Calendar Yr 2010
Personnel (Salaries) Cost/Unit Total Cost Total Mark-Up ∆ Yrly Time Allocation %
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
$0.00
Return to Top
COSTING/CALENDAR YEAR 2010
DIRECT COSTS University component is academic staff salary provided as in-kind to the project
Personnel (Base Salaries + On-costs) Total Met by Industry Met by Other Met by University
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
Total Personnel (a) $0.00 $0.00 $0.00 $0.00
Teaching Relief Total Met by Industry Met by Other Met by University
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
i.e. 3 hours lecture $0.00 $0.00 $0.00 $0.00
Total Teaching Relief (b) $0.00 $0.00 $0.00 $0.00
Equipment Total Met by Industry Met by Other Met by University
General Supplies & Services $0.00 $0.00
$0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
In-kind (University only) $0.00 $0.00 $0.00 $0.00
Total Equipment (c) $0.00 $0.00 $0.00 $0.00
Maintenance Total Met by Industry Met by Other Met by University
Consumables $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
Total Maintenance (d) $0.00 $0.00 $0.00 $0.00
Travel Total Met by Industry Met by Other Met by University
Transportation/accomodation costs $0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
Total Travel (e) $0.00 $0.00 $0.00 $0.00
Other Total Met by Industry Met by Other Met by University
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
$0.00 $0.00 $0.00 $0.00
Total Other (f) $0.00 $0.00 $0.00 $0.00
TOTAL DIRECT COSTS (g) $0.00 $0.00 $0.00 $0.00
INDIRECT (I/C) COSTS (GOING TO FACULTY/QUT) - BASED ON INDUSTRY DIRECT COSTS ONLY
Total Personnel I/C Costs $0.00 $0.00
Total Teaching Relief I/C Costs $0.00 $0.00
Total Equipment I/C Costs $0.00 $0.00
Total Maintenance I/C Costs $0.00 $0.00
Total Travel I/C Costs $0.00 $0.00
Total Other I/C Costs $0.00 $0.00
TOTAL INDIRECT COSTS (h) $0.00 $0.00 N/A N/A
MARK-UP ON COSTS (INCLUDES ONCOSTS (WHERE APPLICABLE) + INDIRECT COSTS ON MARK-UP)
Salary Mark-up Total Industry Other University
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
$0.00 $0.00
Total Non-Salary Mark-up (i) $0.00 $0.00
$0.00 $0.00 N/A N/A
TOTAL COSTS (k) $0.00 $0.00 $0.00 $0.00
Return to Top
LEVA-1 School/Centre Name Faculty name Faculty I/C Rate (Salary) Faculty I/C Rate (Non-Salary)
LEVA-2 BEE Research Portfolio BE&E 37.5% 0% *for commercial research only
LEVA-3 BEE External Relations Portfolio BE&E normal rates normal rates *for consultancies only
LEVA-4 School of Design BE&E 37.5% 0% *for commercial research only
LEVA-5 School of Engineering Systems BE&E 37.5% 0% *for commercial research only
LEVA-6 School of Urban Development BE&E 37.5% 0% *for commercial research only
LEVA-7 Project Management Academy BE&E 37.5% 0% *for commercial research only
LEVA-8 ACID (BEE-initiated) BE&E 37.5% 0% *for commercial research only
LEVB-1 Airport Metropolis BE&E 37.5% 0% *for commercial research only
LEVB-2 ARCAA (BEE-initiated) BE&E 37.5% 0% *for commercial research only
LEVB-3 Auto CRC (BEE-initiated) BE&E 37.5% 0% *for commercial research only
LEVB-4 Centre for Subtropical Design (BEE-initiated) BE&E 37.5% 0% *for commercial research only
LEVB-5 CIEAM (BEE-initiated) BE&E 37.5% 0% *for commercial research only
LEVB-6 CRC Construction Innovation (BEE-initiated) BE&E 37.5% 0% *for commercial research only
LEVC-1 CRC SI (BEE-initiated) BE&E 37.5% 0% *for commercial research only
LEVC-2 IHBI (BEE-initiated) BE&E 37.5% 0% *for commercial research only
LEVC-3 MERF (BEE-initiated) BE&E 37.5% 0% *for commercial research only
LEVC-4 Rail CRC (BEE-initiated) BE&E 37.5% 0% *for commercial research only
LEVC-5 Brisbane Graduate School of Business Business
LEVC-6 Accountancy Business
LEVD-1 Advertising, Marketing & Public Relations Business
LEVD-2 Economics & Finance Business
LEVD-3 International Business Business
LEVD-4 Management Business
LEVE-1 AUS Centre for Philanthropy & Nonprofit Studies Business
SSG1-2 National Centre for Econometric Research Business
SSG4-2 CIEAM (Business-initiated) Business
HEC15-1 CCI Creative Ind.
HEC15-2 Faculty of Creative Ind. Creative Ind.
HEC15-3 Centre for Learning Innovation Education 40.0% 40% *for consultancies only
HECSU-1 Cultural & Language Studies in Education Education 40.0% 40% *for consultancies only
HECSU-2 Learning & Professional Studies Education 40.0% 40% *for consultancies only
HECSU-3 Math, Sci & Tech Ed Education 40.0% 40% *for consultancies only
HECSU-4 Human Movement Studies Health
HECSU-5 Nursing Health
HEWA1-1 Optometry Health
HEWA1-2 Public Health Health
HEWA1-3 Psychology & Counselling Health
HEWA1-4 Social Work & Human Services Health
HEWA1-5 CARRS-Q Health
HEWA1-6 CPCRE Health
HEWA1-7 NCCH Health
HEWA1-8 Software Engineering & Data Communications IT
HEWA2-1 Information Systems IT
HEWA2-2 Microsoft QUT eResearch Centre IT
HEWA2-3 Law Law 35.0% 35%
HEWA2-4 Justice Law 35.0% 35%
HEWA2-5 Legal Practice Unit Law 35.0% 35%
HEWA2-6 Law & Justice Research Centre Law 35.0% 35%
HEWA2-7 Life Sciences Science
HEWA3-1 Math Sciences Science
HEWA3-2 Natural Resource Sciences Science
HEWA3-3 Phys & Chem Sciences Science ADDITIONAL 10% (?)
HEWA3-4 ACID (other-initiated) N/A
HEWA3-5 Auto CRC (other-initiated) N/A
HEWA3-6 Centre for Tropical Crops & Biocommodities N/A
HEWA3-7 CRC SI (other-initiated) N/A
HEWA3-8 iCi N/A
HEWA3-9 IHBI N/A
HEWA3-10 ISI N/A
HEWA4-1 ISR N/A
HEWA4-2 NPB CRC N/A
HEWA4-3 Rail CRC (other-initiated) N/A
HEWA4-4 Smart Services CRC N/A
HEWA4-5 Sugar Research Inst. N/A
HEWA4-6
HEWA4-7
HEWA4-8
HEWA5-1
HEWA5-2
HEWA5-3
HEWA5-4
HEWA5-5
HEWA6-1
HEWA6-2
HEWA6-3
HEWA6-4
HEWA7-1
HEWA7-2
HEWA7-3
HEWA7-4
HEWA8-1
HEWA8-2
HEWA8-3
HEWA8-4
HEWA8-5
HEWA9-1
HEWA9-2
HEWA9-3
HWA10-1
HWA10-2
APAI
APDI
Other
PROJECT BUDGET - DETAILS (INTERNAL USE ONLY)
Project Title General
Project Investigator
School/Centre
Client Name
Start Date 1/1/2010
End Date 1/1/2012
Use the buttons to the left to clear and repopulate the table below.
Clear Table Refresh Table
Category Cal Yr 2010
Personnel Position Level Fund Source Rate
Personnel Total:
Teaching Relief Items From Industry From Other
Teaching Relief Total: $0.00 $0.00
Equipment Items From Industry From Other
Equipment Total: $0.00 $0.00
Maintenance Items From Industry From Other
Maintenance Total: $0.00 $0.00
Travel Items From Industry From Other
Travel Total: $0.00 $0.00
Other Items From Industry From Other
Other Total: $0.00 $0.00
TOTAL COST (ex GST): $0.00 $0.00
GST: $0.00 $0.00
GRAND TOTAL: $0.00 $0.00
DISTRIBUTION Cal Yr 2010 TOTAL
TOTAL DIRECT COSTS:
TOTAL INDIRECT COSTS: #VALUE! #VALUE!
PROFIT MARGIN:
TOTAL COST (ex GST): #VALUE! #VALUE!
USE ONLY)
o the left to clear and repopulate the table below.
Cal Yr 2010 PROJECT
Units Yr Subtotal TOTAL
$0.00
$0.00 $0.00
From QUT Yr Subtotal TOTAL
$0.00 $0.00
$0.00 $0.00 $0.00
From QUT Yr Subtotal TOTAL
$0.00 $0.00
$0.00 $0.00 $0.00
From QUT Yr Subtotal TOTAL
$0.00 $0.00
$0.00 $0.00 $0.00
From QUT Yr Subtotal TOTAL
$0.00 $0.00
$0.00 $0.00 $0.00
From QUT Yr Subtotal TOTAL
$0.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
$0.00 $0.00 $0.00
PROJECT BUDGET SUMMARY (for internal use only)
Project Title
Project Investigator
School/Centre
Client Name
Start Date 1/1/2010
End Date 1/1/2012
Cost to Industry
Cal Yr 2010 TOTAL
Total Personnel $0 $0
Total Teaching Relief $0 $0
Total Equipment $0 $0
Total Maintenance $0 $0
Total Travel $0 $0
Total Other $0 $0
TOTAL COSTS $0 $0
GST $0 $0
TOTAL COSTS + GST $0 $0
TOTAL INDIRECT COSTS $0 $0
AVAILABLE PROJECT FUNDS $0 $0
Cost to QUT
Cal Yr 2010 TOTAL
Total Personnel $0 $0
Total Teaching Relief $0 $0
Total Equipment $0 $0
Total Maintenance $0 $0
Total Travel $0 $0
Total Other $0 $0
TOTAL COSTS $0 $0
Cost to Other Funding Sources
Cal Yr 2010 TOTAL
Total Personnel $ - $ -
Total Teaching Relief $ - $ -
Total Equipment $ - $ -
Total Maintenance $ - $ -
Total Travel $ - $ -
Total Other $ - $ -
TOTAL COSTS $0 $ -
Mark-up Profit Distribution (Industry only)
Cal Yr 2010 TOTAL
Total Profit: $0.00 $0.00
% of Project Total:
Amount going to Cost Centre: $ - $ -
Amount going to Workgroup: $ - $ -
Enter percentage split of mark-up here (out of load project only):
Cost Centre %: 50%
Workgroup %: 50%
PROJECT BUDGET SUMMARY - TOTAL CLIENT COSTS
Project Title
Project Investigator
School/Centre
Client Name
Start Date 1/1/2010
End Date 1/1/2012
Total Cost to Client
Item Cal Yr 2010 TOTAL
Total Personnel $0 $0
Total Teaching Relief $0 $0
Total Equipment $0 $0
Total Maintenance $0 $0
Total Travel $0 $0
Total Other $0 $0
TOTAL COSTS $0 $0
GST $0 $0
TOTAL COSTS + GST $0 $0
Project Description:
S
MARKUP % CALCULATOR
Please ensure that the correct calculation direction is used.
Backwards Calculation:
Marked-up profit margins are calculated as a subtraction from the grand total sum (backwards calculation):
Total Marked-up Amount x (1 - Mark-up Percentage) = Base Amount
i.e. Indirect Cost percentage rates are used in this way (25% consultancy/16% commercial research).
Base Amount Marked-Up Amt Desired
Base Amount Mark-up % Desired
Example Numbers:
Base = $202.50 Marked-up Amt = $225
Base = $202.50 Mark-up % = 10%
Return to Budget-ENTRY worksheet
Forwards Calculation:
Marked-up profit margins are calculated based on the initial salary and added on top (forwards calculation):
Base Amount x (1 + Mark-up Percentage) = Total Marked-up Amount
i.e. Salary loading percentages are used in this way (base salary + 40% loading = base salary*(1+0.4) = total
Base Amount Marked-Up Amt Desired
Base Amount Mark-up % Desired
Example Numbers:
Base = $100 Marked-up Amt = $140
Base = $100 Mark-up % = 40%
Conversion between Backwards and Forwards Calculations' Mark-up Percentages:
NOTE: Hit "Enter" on the keyboard after you enter the percentage value in either of the entry boxes, then hit the button
Forwards Calc Value
Convert Mark-Up
Convert Mark-Up
To find out what multiplier percentage value is needed for forward calculation, the following formula is used:
Mark-up multiplier value = (Total Marked-up Amount / Base Amount) - 1 = Actual Mark-up Percentage / (1 - A
Then the Mark-up multiplier value is applied within the budget as follows:
Base Amount x (1 + Mark-up multiplier value) = Total Marked-up Amount
Calculated Actual Mark-up % = (Total Marked-up Amount - Base Amount) / Total Marked-up Amount
The formulae apply to indirect costs as well - budget calculation indirect cost rates of 33.33% for consultancy
actual indirect cost rates of 25%/16% as outlined in MOPP 7.1.12.
0.25 / (1 - 0.25) = 0.3333
0.16 / (1 - 0.16) = 0.1905
rect calculation direction is used.
culated as a subtraction from the grand total sum (backwards calculation):
Mark-up Percentage) = Base Amount
s are used in this way (25% consultancy/16% commercial research).
Calculated Mark-up % Calculated Marked-Up Amt
Calculated Marked-Up Amt Calculated Mark-Up Margin
$ - $ -
Results:
Calculated Mark-up % = 10% Calculated Marked-up Amt = $225
Calculated Marked-up Amt = $225 Calcualted Mark-Up Margin = $22.50
culated based on the initial salary and added on top (forwards calculation):
rcentage) = Total Marked-up Amount
are used in this way (base salary + 40% loading = base salary*(1+0.4) = total salary).
Calculated Mark-up % Calculated Marked-Up Amt
Calculated Marked-Up Amt Calculated Mark-Up Margin
$ - $ -
Results:
Calculated Mark-up % = 40% Calculated Marked-up Amt = $140
Calculated Marked-up Amt = $140 Calculated Mark-Up Margin = $40
ds and Forwards Calculations' Mark-up Percentages:
r you enter the percentage value in either of the entry boxes, then hit the button
Backwards Calc Value
Convert Mark-Up
Convert Mark-Up
ntage value is needed for forward calculation, the following formula is used:
Marked-up Amount / Base Amount) - 1 = Actual Mark-up Percentage / (1 - Actual Mark-up Percentage)
e is applied within the budget as follows:
ltiplier value) = Total Marked-up Amount
Total Marked-up Amount - Base Amount) / Total Marked-up Amount
sts as well - budget calculation indirect cost rates of 33.33% for consultancy and 19.05% for commercial research are based up
16% as outlined in MOPP 7.1.12.
Mark-up Percentage)
9.05% for commercial research are based upon