5 BASIC BUDGET DO NOT complete ROI or NPV Home Insert Draw Page Layout Formulas Data Review View Tell me Arial v 10 AA Wrap Text v General Paste BI UV DVAv Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Format Formatting as Table Styles E49 X V fx B C D E F G H K M IN O P Q R NOTE: This proforma ASSUMES a software project, thus the type of software contract labor. If not, fill in your type of contract labor types and plug in the respective cost The remainder of the costs also assume a Software development project. Hardware, Software, Supplies and Indirect Costs. Modify, add or delete, at will. 10 Do NOT try and force the model to equal your original estimate; however, the answer should be close. 11 12 PROPOSAL Assumptions 13 14 Length of Proj. ( in Months) 0 15 Contingency Reserve Percent 0% 16 Management Reserve Percent 0% 17 Tax base ( in percent) 0.00% 18 19 Salaries & Wages Salary/Yr Salary/Mo. 20 Project Manager $0 $0 21 Schedule $0 $0 22 Cost Manager $0 SO 23 Ops & Cust Support $0 $0 24 Risk Analyist $0 $0 25 Earned Value 26 27 Contract Labor 28 Sr Web Developer 29 Web Developer $0 30 Applications Design 182 31 A and Testing Engr 32 33 You will need to break down your project's total cost into different categories like materials, labor etc. and submit your numbers in the template provided. 34 Since this is a simulated project, the numbers are estimates. 35 36 Please complete the first two tabs. The contingency can be anywhere from 5% to 20% and the management reserve can be around 10%. 37 38 39 40 41 42 43 44 45 46 47 48 Basic Assumptions Basic Budget EXAMPLE ROI & NPV +OFF NAP ? C... 5 BASIC BUDGET DO NOT complete ROI or NPV Insert Draw Page Layout Formulas Data Review View Tell me Arial v 9 AA Share Comment 27 V e Wrap Text v General It v B IU FV GAV Merge & Center v $ ~ % " Conditional Format Cell Insert Delete Formatting as Table Format Sort & Styles Find & nalyze X V fx Filter Select Data B C D G H K M N P Q R S Units Cost ea. Totals Project Manager $0 Scheduler SO Cost Manager QA & Cust Support SO Risk Analyist . You will need to break down your project's total cost into different categories like materials, labor Earned Value SO o and submit your numbers in the template provided. Project Management SUB-TOTAL Since this is a simulated project, the numbers are estimates. Please complete the first two tabs. The contingency can be anywhere from 5% to 20% OUSOURCED Contract Labor Sr Web Developer of o and the management reserve can be around 10%. Web Develope Applications Design QA and Testing Engr OUTSOURCING SUB TOTAL: TOTAL Outsourced Labor Sub-Total: HARDWARE (Capital Assets) Servers Workstations UPS TOUCHSCREEN COMPUTER SUPPLY Upgrades and over-runs Hardware SUB-TOTAL: SOFTWARE (Capital Assets) OS and Licenses Technical & Server Support Software SUB -TOTAL: SUPPLIES & Misc. G&A Office Supply 1,000 Virtual team communications G&A & Supplies SUB-TOTAL INDIRECT Costs Utilities Cloud, Data, backup service Internet Bandwidth (colocation) Rent Indirect SUB-TOTAL TOTAL COST: 0% Reserves (@x% of Total Cost) 0.00% Equip. Tax (x% of Equip & Supplies): + 100% + Basic Assumptions Basic Budget EXAMPLE ROI & NPV MacBook Pro