Konigi Schedule & Cost Summary Calculator About This Document
This Cost Estimate and Scheduling spreadsheet provides a lightweight method for learning to estimate time to complete a web design project, and calculating cost for completion. The intended audience is freelancers or individual contractors. The purpose of the document is to get acquainted with Excel as a tool for cost estimation, with the hopes that you will learn to use and modify it to suit your needs. This is only a learning tool.
Disclaimer
Use of this spreadsheet is at your own risk. Michael Angeles and Konigi provide no guarantee for the use of this spreadsheet. By electing to use this spreadsheet, the user acknowledges that any errors are the sole responsibility of the use due to data entry, formula creation, calculation, or any use of this spreadsheet on the user's part. For instructions on using this document, please refer to the information at: http://konigi.com/tools/schedule-and-cost-summarycalculator
ovides to st for or nt is to tion, fy it to
l se of eet, e a et on
er to
y-
[PROJECT NAME] Schedule and Cost Summary Phase
Hours (lo)
Discovery and Research
Hours (hi) Hours (mean)
Cost
Start date Days (6hr day)
Due Date
0
0
0 0 0 0 0 0 0 0 0 0 0 0
$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
1-Jan
0
0
0 0 0
$0.00 $0.00 $0.00
0.00 0.00 0.00
1-Jan
0
0
0 0 0
$0.00 $0.00 $0.00
0.00 0.00 0.00
1-Jan
Use Cases User flow diagrams UI Spec (Wireframes, Storyboards) Usability testing
0 0
$0.00 $0.00
0.00 0.00
User research Data gathering and research User interviews or surveys Personas Mental model; Goal and needs matrix Business research Competitive Study Business Needs Analysis Screen audit and inventory Heuristic analysis Documentation
Information Architecture Information organization IA Deliverables
Interaction Design
Visual design
0
0
0 0 0 0
$0.00 $0.00 $0.00 $0.00
0.00 0.00 0.00 0.00
1-Jan
0
0
0 0 0 0 0
$0.00 $0.00 $0.00 $0.00 $0.00
0.00 0.00 0.00 0.00 0.00
1-Jan
0
0
0 0 0
$0.00 $0.00 $0.00
0.00 0.00 0.00
1-Jan
0
0
0
0.00 $150.00 $100.00 $75.00 6
Design comps Design iterations Style Guide
Site development Graphics production XHTML CSS Programming
Quality Assurance Testing Bug fixes Hours Hourly rate (Type A) Hourly rate (Type B) Hourly rate (Type C) Hours/day
Total cost Holidays 24-Dec 25-Dec 28-Dec 31-Jan
$0.00
ID Screen label 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
Hours Start date
Due date
Status
55 56