Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
momoaal
Starting Member
2 Posts |
 Posted - 2004-06-04 : 04:48:37
|
| Hi ... i hope any one can help me here ! i'm developing my first real application using VB and SQL server 2000 DB ...i dont' knwo how to determine the cost of the application !!for how much i will give my application to the customer ??what are the basis used to determine the application development cost ??i'm NEW in this field ..i mean ... commercial development .. ! i all i did before is small projects or sharing with others .. but this is my first application , i have to do it all from the beginning !!it's a stock control application and a DB for more than 1,000,000 (million) stock items/parts my customer dealing with !!! i'm still in the analysis stage ! so ...... !any help from other experienced developers would be appriciated ! Thanks ;) |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-06-04 : 05:19:07
|
| cost.....dear enough to give you a return to stay doing this sort of work.not too dear to ensure somebody else doesn't think they can make a profit by offering the same service/productcheap enough to ensure somebody buys your work.not too cheap to ensure you're taken advantage of.there is no hard and fast rule....it depends on the work, the marketplace you sell in, the cost environment you develop in....but more importantly the value the customer places on the work and the return on investment they will get from the work.if you can work out the financial benefit to the customer of your application, then maybe you can get an idea of the price-point you should aim for....10%/20%/30% (or whatever) of the benefit the customer derives from your product over a defined time-frame to be paid to you.....and remember....it's far better to sell 50 copies @ $100 rather than 2 copies @ $1000.however it's more financially rewarding to see if you can get all 50 buyers to pay the $1000.good luck! |
 |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-06-04 : 07:14:42
|
| i'm developing my first real application using VB and SQL server 2000 DB ...i all i did before is small projects or sharing with others .. it's a stock control application and a DB for more than 1,000,000 (million) stock items/parts my customer dealing with !!! I would advise geting someone to review your design before you start coding. If you have only worked on small projects you aer unlikely to understand the concepts needed to deal with milions of recs. Although this is still quite small you will probably be getting into situations where you have to consider locking and aggregate query conflicts and will need to perform set based operations and integrate archiving and recovery into the system.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-06-05 : 01:57:52
|
| momo, how did you sell your customer on using you to create this without giving them a cost estimate? If this is custom work for one client, which it sounds like it is, then the question is, "How much is your time (and knowledge/experience) worth?" What do other people with a comparable level of skill charge for their time? And how long do you think it will take to build? (See my blog on Fixed Bid vs. Time & Materials for some more thoughts on the subject.)If you're building an app that you want to sell to multiple clients, then the question is "What will the market bear?" And for that you really need to do some serious business analysis.-----------------------------------------------------Words of Wisdom from AjarnMark, owner of Infoneering |
|
|
|
momoaal
Starting Member
2 Posts |
Posted - 2004-06-06 : 20:18:38
|
| but it's difficult to estimate your (knowledge/experience) !!thanks !! |
|
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2004-06-06 : 20:26:19
|
| FWIW...When I worked for a custom software shop.. It was my task to give an estimate after the analysis was done... Our hard and fast rule...1 entity/table = AUS$1000.. regardless of front end... That is with a lot of overhead......I'd say that number should be between AUS$100 and AUS$300 today.. By the way "Look up" tables don't count.. they are domains after all....and the anaylsis was always based on a minimum of 3NF...DavidM"Always pre-heat the oven" |
|
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2004-06-10 : 19:28:37
|
quote:
Originally posted by momoaal
but it's difficult to estimate your (knowledge/experience) !!thanks !!
Here is my recommended approach:How many years have you been doing design and construction work in relational databases, and how many of those are in SQL Server specifically? How much variety have you experienced over that time?Or ask yourself what sort of reaction* do you have to the following terms:- scripting- normalization- referential integrity- disaster recovery- ETL- Replication- SQL Server Security*Typical reactions: "Yeah, I know that inside and out, I do it all the time" or "Used it once or twice" or "Heard of it, never done it" or "Huh?"-----------------------------------------------------Words of Wisdom from AjarnMark, owner of Infoneering |
|
|
|
|
|
|
|
|
Cost of my Applicatoin ?? VB & SQL Server 2000 !!