TABLE OF CONTENTS
1.
PROPOSAL NUMBER:
01-E5.03-1223
2.
SUBTOPIC TITLE: Innovative Tools
and Techniques for Conservation of Natural Resources
3.
PROPOSAL TITLE: Intelligent Systems for commercial
water-usage reduction and control
4.
SMALL BUSINESS CONCERN (SBC):
NAME: Intelligent Sprinkler Systems
MAILING ADDRESS: Old Dominion University,
Education Building, Room 250-6
CITY/STATE/ZIP: Norfolk, Virginia
23529
PHONE: 757-479-0847
FAX: 757-479-0848
Number of
employees: 6
5.
Amount Requested $ 478,553
duratioN: 6 months
6. certifications: offeror certifies that:
As defined in Section 1 of the Solicitation, the offeror
certifies:
a. Eligibility
of the Principal Investigator Yes
As defined
in Section 2 of the Solicitation, the offeror qualifies as
a:
b. SBC Yes
Number
of employees: 6
c. Socially
and economically disadvantaged SBC
No
d. Woman-owned SBC No
As
described in Section 3 of this solicitation, the offeror meets the following
requirements completely:
e. All eleven parts of the
technical proposal included in part order
Yes
f. Subcontracts/consultants
proposed?
Yes
i) If yes, limits on subcontracts/consultants met
Yes
ii) If yes, copy of agreement enclosed
Yes
g. Government equipment or
facilities required?
No
i) If yes, signed statement enclosed in Part 8
No
7.
ACN NAME: Kevin Matthews
8.
ENDORSEMENTS:
PRINCIPAL INVESTIGATOR:
NAME: Linda Martinez
TITLE: Project Manager
PHONE: 757-693-4832
E-MAIL: brunelle@cs.odu.edu
DATE: November 18, 2002
Subtopic
Number
NAME: Intelligent Sprinkler
MAILING ADDRESS:
CITY/STATE ZIP:
PHONE: 757-683 - 4832
NAME: Linda Martinez
ADDRESS:
CITY/STATE ZIP:
The
proposed innovation is a water sprinkler that uses at a golf course or
commercial areas.
This device is referred to as the Intelligent Sprinkler (IS). IS will monitor the
ground for the amount of rain and ground water, amount of nutrients needed,
ground slope and soil type, and the grass and plant types. The computer will
collect the ground data regularly and store the information in its
database. The
computer software will take these data into consideration and determine the
right amount of the water the ground will need. IS will definitely save the golf courses water
when it is used.
Intelligent Sprinkler has developed a commercial marketing
plan that will start with over 350 golf courses in
3. TECHNICAL PROPOSAL
3.1 Identification and Significance of the Innovation
The proposed innovation is a water conservation product that will use current technology available for sprinkler systems today along with a computer to monitor and control the amount of water a lawn needs. This device is referred to as the Intelligent Sprinkler (IS).
IS has targeted its product toward golf courses. IS has researched the water conservation plans put in affect by most businesses in the Virginia area and has found that golf courses are primarily exempt from water restrictions. Its primary goal is to protect our precious resource from becoming exhausted. By finding ways for golf courses to conserve water we are protecting our precious resource.
IS will
collect data about the golf course via a touch pad device. The data is then
stored inside of a database. This information is then ran through a series
of programs that will determine the amount of water that will be needed for a
given watering cycle for a given golf zone. This controlling feature of IS, prevents the
over use of ground water therefore helping to prevent the salt water encroaching
into and contaminating our freshwater supply. This feature is also helping to
keep water available for human consumption. Because, It is estimated that 50% of the
drinking water comes from ground water. Lastly, by limiting the amount of ground water
usage we are helping to prevent the affects of subsidence, sink holes, that can
occur on a golf course from too much ground water withdrawal.
IS will also provide the same means for the golf course superintendents to control the amount of fertilizer and weed control that goes into the ground. In addition, this important aspect will indirectly improve the quality of our recycled water. According to the Environment Protection Agency, “Mixing and distributing pesticides and fertilizers with irrigation water can cause ground water contamination if more chemicals are applied than crops can use”. This assertion can also be applied to our golf courses.
Diagram 3.1.1 – The hydrologic cycle shows importance of
keeping water table at a maximum and the
prevention of contamination.
The Earth is a terrarium system that stores water within its atmosphere, surface area, and soil. It contains a finite amount of water, which is constantly being recycled. This finite amount of water consists of around 326 quintillion gallons. However, only 1% of this amount is considered usable for human consumption, industrial, and agricultural use.
Diagram 3.1.2 – Amount of consumable water compared
to that
Of undrinkable water.
The occurrences of drought conditions within our nation are also a concern. When drought conditions exist, we are at risk economically, socially, environmentally. IS is also concerned and can help by monitoring the drought conditions within a given area. If drought conditions exist, periods of low rain, then IS minimizes the amount of water consumption by a golf course.
 |
 |
Diagram 3.1.2 – Drought Conditions are wide spread.
The goal of Intelligent Systems is to provide a means for golf course superintendents to control and regulate based upon software the exact amount of water and nutrients their golf courses need.
To reach this goal IS must:
To achieve these goals, IS must:
IS will target its initial installation to specific golf course, namely Red Wing Golf Course of Virginia Beach, VA. This course will be implementing a new sprinkler system during the next year and is a city golf course.
Intelligent Sprinklers Prototype
 |
|
The touchpad device, database, and software will reside at the RedWing Golf house
 |
 |
The zone monitors and the tanks will reside at the 1st hole
layout of redwing golf course
Phase 1 Implementation Plan
The IS project plan consists of a three-phase plan with a variety of deliverables in Phase I. The early stages of Phase I involved extensive research by the project team to determine the exact software specifications needed for approval.
Phase I involved developing a plan. IS took the research and presented a plan that would provide a unique design strategy suitable for our market. IS then determined the scope of the project. IS then determined the available resources. Once the plan was put into place it was reviewed and revised.
The research involved consisted on interviewing experts, reviewing of trade periodicals specifically golf related, and the use of internet sources. We utilized the local merchants to determine rates of sprinkler system hardware. We used experts in software development to come up with a cost/budget for the software development.
IS then entered the feasibility part of the plan. IS used the local resources to determine if the plan was feasible. We used technical documentation, management documentation and social feasibility as our cornerstone for the delivery of the presentation. IS then put together a plan for the required staffing, see flow chart below. IS determined that the initial staff was sufficient for the early development of the project however, IS needed a few more expertise in specific areas. These areas included engineers and contract managers. The specific software specifics were then drawn up. The IS team can now begin the development of the prototype. Once the prototype is complete the project team will run preliminary test to determine if the product needs any major changes. If no major alterations are needed the preliminary testing portion of prototype is complete.
The project team will then utilize the 1st hole of the Red Wing golf course,
Phase I Evaluation Methods and Tools
In order for Phase I to be considered a success, IS must prove the scientific and technical merit and feasibility of the system and it’s benefit to the funding agency. Form measurement purposes, IS will employ to following methods and tools of evaluation.
Phase 0
(proven) Staffing Plan
Phase I Staffing Plan
There is currently no product on the market or in development that can do what we are proposing to do. There are products that attempt to save water by means of timers and sensors. However, our proposal includes software and a database to control the amount of water and nutrients a lawn needs.
The water amount used on golf courses are exempt from water conservation laws because of their nature of business. This endeavor may help in the water conservation efforts by controlling and minimizing the amount of water they use. Statistical data can be obtained from this device and stored within our database that will help city, state, and federal government agencies and water conservation organizations determine how much water is consumed by golf course businesses. It will also provide golf courses with evidence that they are attempting to conserve water by every means possible.
Currently IS is conducting interviews with members of water conservation experts and golf course superintendence to determine the most effective way of implementing this system so that both parties are working toward a common goal of conserving water.
3.5 Key Personnel and Bibliography of Directly Related
Work
IS Personnel
Bibliographies:
Linda Martinez,
Project Manager
Linda Martinez the project manager for
the Intelligent Sprinkler System. She is also
a student
at
2002 with a bachelor of
computer science degree. She is currently employed as
a
senior system analyst at Management Technology Incorporated. She does database
programming along with application programming using C
and powerbuilder. She
also does some web programming
using java, javascipts, and HTML.
Justin Haffey,
Assistant Project Manager
Justin Haffey is the assistant project
manager for the Intelligent Sprinkler System. He is also the web developer. He is a Computer
Science student at
Norman Martin,
Resource Manager
Martin Cohen is the resource manager. He
was born on
Huntington, L.I., N.Y. to Irving
and Gilda Cohen. Moved to
living in
Dong Ngo, Marketing Manager
Dong Ngo is our Marketing Manager. He is currently majored in Computer Science and Computer Engineering. He plans to graduate in May of 2004.
Kevin Mathews,
Finance Officer
Kevin is a senior majoring in Computer Science. He is planning on graduating in May 2003. Upon graduation, he would like to stay in the area
Muhammad J
Sattar, Marketing and Researcher
Muhammad Sattar is on our Marketing staff and does our research. He is Majoring in Computer Science, Computer Engineering minor. He is a system programmer and also does Object Oriented Programming. He is graduating on December 2002.
Phase I Personnel
Technical Requirements
Project
Manager
Designs, plans, and coordinates work teams. Provides technical support to project team members. Handles complex application features and technical designs. Requires a bachelor’s degree in a related area and at least 10 years experience with managing projects and managing contractors. Will be involved with all aspects of IS.
Financial
Assistant
Responsible for financial analysis of IS project and statistical studies. Requires a bachelor’s degree and 2 years of experience in a related field. Must be familiar with the technology field.
Software
Developer
Reviews, analyzes, and modifies IS programming systems including coding, testing, debugging and documenting programs. Designs, modifies, develops, writes and implements software programming applications required by IS. Supports and or installs software applications. Requires 1-year experience with Microsoft access database. Requires a bachelor’s degree in computer science.
Web Developer
Reviews, analyzes, and modifies IS web programming systems including coding, testing, debugging and documenting programs. Designs, modifies, develops, writes and implements web applications required by IS. Requires 1-year experience with web development. No degree required.
Research
Specialist
Performs a combination of skilled and highly skilled procedures or analyses involving complex methods or a complex series of steps for IS. Incumbents have responsibility for overseeing or conducting critical parts of research projects such as complex statistical analyses or laboratory procedures carried out with materials which may require constant monitoring for difficult to observe changes which often involves the assay, measurement or manipulation of very small samples whose presence is not readily detected. Requires bachelor’s degreee in related area.
Marketing
Director
Proven success in marketing and
communications at the development, strategic and implementation levels; evidence
of marketing planning ability; excellent written and oral communication skills;
understanding of golf courses preferred. BA or equivalent in relevant field required.
The ideal candidate is an enthusiastic, creative and proactive team player.
Report directly to supervisor.
Contract
Manager
Responsible for purchasing and negotiating materials, equipment, and supplies from vendors. Evaluates vendor quotes and services to determine most desirable suppliers. Creates, writes, negotiates and reviews hardware or software licensing contracts, purchasing contracts for required materials, and implementation contracts for IS. Reports to manager. Must have 8 years of contract administration.
Documentation
Specialist
Prepares and/or maintains documentation
pertaining to programming, systems operation and user documentation of IS. Translates business
specifications into user documentation. Plans, writes, and maintains systems and user
support documentation efforts, including help screens. Requires a related
degree in the field.
Must have background in the technology area. Works under
immediate supervision; typically reports to a supervisor.
Engineer
Responsible for design, development, implementation, and analysis of technical products, systems and hardware for IS. Develop specifications for the interface devices for the IS system. Requires a bachelor’s degree in engineering and 2 years of experience in the field or in a related area. Has knowledge of commonly used concepts, practices, and procedures utilized within the technology field. Works under general supervision; typically reports to a manager.
3.6 Relationship with Phase II or Future R/R&D
Phase I research effort consists of a feasibility study and the investigation of possible techniques for the development of a prototype training module. Upon completion of phase I and phase II successfully the Project team will hire the necessary personnel as well as obtain all required resources. A Program Design Review and Critical Design Review will be implemented before the final management plan gains the approval. To achieve a successful product the team must complete software and hardware testing. When the testing is completed, the team can begin to install the product and test in the real environment.
Prior to
testing completion of the installation, a Factory Acceptance Test, Program
Design Review and Critical Design Review will be conducted to ensure product
quality. Once
all testing methods have been done and thoroughly analyzed, as well as all
necessary modification, the team can proceed to the production phase, Phase
III.
Prior to
production the team will complete the user manual, the most important interface
between the product and the customer, including an easy to use trouble-shooting
guide. Testing
of the fully assembled Intelligent Sprinkler will be conducted in a model
3.7 Company
Information and Facilities
The labs of Old Dominion University and classrooms will be used for conducting of flow assessment for research and development in Phase I and Phase II. All meetings, programming, and presentations will take place within these facilities. The necessary hardware resources accounted in the proposed budget will be arranged as well. These include computer hardware and software, Internet connection, and prototype development materials.
3.8 Subcontracts and Consultants
The
Intelligent Sprinkler System is planning to utilize the service of contractors
in Phases II and III. CELESTICA is willing to serve us as our main contractor.
It is a world leading company in electronics manufacturing services (
If CELESTICA
fails to provide services, alternative contractors will be managed. We will look
forward to NASO Corporation for Phase II and III support. They are providing more than
thirty years of leadership in Contract Electronics Manufacturing (CEM), Rapid
Prototyping, Machine Shop, and Electro-mechanical Engineering and
Design.
No consultants are necessary for the design and production of the Intelligent Sprinkler.
3.9 Commercial
Applications Potential
The potential for
commercial Sprinkler System applications depend on golf courses and water
conservation groups. The initial
marketing strategy of the project will focus on local golf courses as they need
a well maintained irrigation system and prevent wasting of water. It will also
focus on highly populated area as they are suffering from chronic water
shortages with no immediate relief in the forecast. In future lawn owner will be
also benefited by this. Intelligent Sprinkler will realize profit of $215,508,
if units are sold at an average cost of one million per
unit.
In conjunction with this
strategy, Intelligent Sprinkler will be marketed to golf courses and
conservation organizations for data gathering and analysis
purposes.
There are some possible
risks to the Intelligent Sprinkler System.
It may be expensive for average house hold use and technology may make
ground stuff nervous. The probability of this is low, but the consequences would
be severe. The solution is to
utilize the expertise in this area to gain a clientele with golf courses by
explaining the advantages and the safe sides of the technology with an immediate
need for water conservation methods. Various models will also be available to
alleviate costs.
Competition is another possible risk to this project. Currently competition includes low and cheap technology solutions, such as regular sprinkler with timing, fertilizer tank and weed control. Research shows that no other complete sprinkler systems have database system to monitor watering. The Intelligent Sprinkler should out perform other existing systems.
3.10
Similar Proposals and Awards
There are some similar proposals and awards that have been
made to the Computer Productivity Initiative of Old Dominion University. Flow
Assessment System (FAS) is one of them. This and other proposals can be found at
http://www.cs.odu.edu/~cpi/previous.html.
Flow Assessment Systems (FAS) offer a convenient,
cost-effective means of monitoring water usage in all aspects of the
home-showers, baths, faucets, toilets, washing machines, dishwashers, etc. FAS
offer a centralized monitoring device that receives data via a wireless network
from sensors located throughout the home at various water outlets. The sensors
track the total flow of water from these outlets and transmit the data to the
centralized device. Statistical analyses are developed from the transmitted data
and the user is able to monitor their water usage via a friendly interface.
Examples of data the user can monitor include total daily/weekly/monthly/yearly
water usage, total water usage from a specific source (i.e. the kitchen, master
bathroom, washing machine), and historical analyses of water usage.
The user also has the ability to
store ideal water usage specifications. The water-monitoring device will inform
the user whether their water usage falls within those guidelines. This feature
is extremely desirable in areas where frequent drought conditions require that
mandatory restrictions be placed on residential water usage. This feature allows
the user to not only meet the mandatory restrictions and avoid potential
penalties, but they also save on utility costs. The consumer not only saves
water, but also will see potentially substantial monetary savings.
Proposal Number:
01-E4.03-1111
Small Business Concern:
NAME: Intelligent Sprinkler
MAILING ADDRESS:
CITY/STATE/ZIP:
PHONE: 757-683-4832
DIRECT LABOR:
Category
Hours
Rate
Cost
Engineering
820
21.60
17,712
Software Development
1590
24.00
38,160
Project Management
2400
28.85
69,240
Financial Analyst
940
24.00
22,560
Contracts Manager
1100
19.20
21,120
Documentation Specialist
900
14.40
12,960
Web Development
520
14.40
12,960
Research Specialist
860
16.80
14,448
Marketing Director
1080
19.20
20,736
Lawyer
20
250.00
5,000
TOTAL DIRECT LABOR:
(1)
$
234,896
OVERHEAD COST
__40__% of Total Direct Labor
or $ 234,896_
OVERHEAD COST:
(2)
$ ______93,958
OTHER DIRECT COSTS (ODCs):
Category
Workstations (10)
$
8,000
Monitors (10)
15,000
Printer (2) 300
Internet Connections (10)
1,800
Paper, ink etc 1,500
MS Project (4)
2,000
MS Visual C++ (3)
330
MS Office (5) Windows 2000
925
Adobe Design Collection (2)
2,000
Sensor Software
300
Other Software
2,000
Pipes and Fittings
100,000
Electrical Wiring
200,000
Pump Station
69,000
Sprinkler Heads
9,750
Computer 800
Touch-pad Monitor
500
Controller 500
Monitor Cables
50
Wind Sensors
1,080
Soil Temperature Sensors
360
Humidity Sensors
1,080
Sun Duration Sensors
2,700
Soil Moisture Sensors
2,700
Automatic Rain Shut-off
360
Water Valves 1,368
Sprinkler Timers
2,700
PH Meter Testers
342
Soil Test Kits
540
Fertilizer Tank
2,250
Liquid Fertilizer
1,440
Clay Buster
90
Weed Killer 360
Miscellaneous
20,000
TOTAL OTHER DIRECT COSTS:
(3)
$
452,125
(1)+(2)+(3)=(4)
SUBTOTAL:
(4)
$
780,979
GENERAL & ADMINISTRATIVE (G&A) COSTS
_ 40__% of Subtotal or $ _ 780,979__
G&A COSTS:
(5)
$
312,391
(4)+(5)=(6)
TOTAL COSTS
(6)
$
1,093,370
ADD OTHERS or SUBTRACT COST SHARING
OTHER/COST SHARING:
(As applicable)
(7)
$
(6)+(7)=(8)
AMOUNT REQUESTED:
(8)
$
1,093,370
Phase I will require 6
months to complete.
This includes prototype development and testing for proof of concept, as
well as initial design of the Intelligent Sprinkler. Personnel required
to complete IS prototype design and
development include one Engineer (820 man-hours) for software development of the
computer interface between the sprinkler system and the computer; three software
developers (1590 man-hours) for database and software design and developer;
Project manager (2400 man-hours); One financial manager (940 hours); A contract
Manager (100 man-hours); A documentation specialist (900 man-hours) and a web
developer (520 hours). IS’s phase 2 will need a marketing director
(1080 man-hours) and a lawyer to handle legal issues and formal paperwork (20
man-hours).
The prototype will be implemented on the 1st hole of the Red Wing golf course,
*Please refer to Appendix B for the detailed Budget Proposal
APPENDIX A: DETAILED PROJECT IMPLEMENTATION PLAN
Appendix A1: Phase I Implementation Plan
1000 Preliminary Planning |
Start Date |
End Date |
|
1100 Develop Plan |
27 Aug 02 |
30 Aug 02 |
|
1200 Present Plan |
27 Aug 02 |
30 Aug 02 |
|
1300 Select Design Strategy |
30 Aug 02 |
3 Sept 02 |
|
1400 Determine Project Scope |
3 Sept 02 |
10 Sept 02 |
|
1500 Determine Available Resources |
3 Sept 02 |
10 Sept 02 |
|
1600 Review Plan |
10 Sept 02 |
12 Sept 02 |
|
1700 Revise Plan |
10 Sept 02 |
12 Sept 02 |
|
1800 Plan Approved |
12 Sept 02 |
13 Sept 02 |
2000 Research |
|
|
|
2100 Review Internet Sources |
13 Sept 02 |
15 Sept 02 |
|
2200 Interview Experts |
13 Sept 02 |
15 Sept 02 |
|
2300 Review Trade Periodicals |
13 Sept 02 |
15 Sept 02 |
|
2400 Preliminary Research Complete |
15 Sept 02 |
16 Sept 02 |
3000 Feasibility |
|
|
|
3100 Determine Financial Feasibility |
16 Sept 02 |
25 Sept 02 |
|
3200 Determine Technical Feasibility |
16 Sept 02 |
25 Sept 02 |
|
3300 Determine Societal Feasibility |
16 Sept 02 |
25 Sept 02 |
|
3400 Determine Management Feasibility |
16 Sept 02 |
25 Sept 02 |
|
3500 Assemble Presentation |
25 Sept 02 |
1 Oct 02 |
|
3600 Practice Presentation |
1 Oct 02 |
10 Oct 02 |
|
3700 Deliver Presentation |
10 Oct 02 |
11 Oct 02 |
4000 Milestone |
|
|
|
4100 Develop Schedules |
11 Oct 02 |
20 Oct 02 |
|
4200 Determine Required Staffing |
11 Oct 02 |
20 Oct 02 |
|
4300 Develop Project Plan |
20 Oct 02 |
25 Oct 02 |
|
4400 Determine Preliminary Budget |
20 Oct 02 |
25 Oct 02 |
|
4500 Assemble Presentation |
25 Oct 02 |
30 Oct 02 |
|
4600 Practice Presentation |
30 Oct 02 |
7 Nov 02 |
|
4700 Deliver Presentation |
7 Nov 02 |
8 Nov 02 |
5000 Approval |
|
|
|
5100 Finalize Deliverable Elements |
8 Nov 02 |
20 Nov 02 |
|
5200 Complete Deliverable Elements |
8 Nov 02 |
20 Nov 02 |
|
5300 Revise Deliverable Elements |
8 Nov 02 |
20 Nov 02 |
|
5400 Assemble Presentation |
20 Nov 02 |
30 Nov 02 |
|
5500 Practice Presentation |
30 Nov 02 |
12 Dec 02 |
|
5600 Deliver Presentation |
12 Dec 02 |
13 Dec 02 |
Appendix A2: Phase II Implementation Plan
6000 Finalize Specification |
Start Date |
End Date |
|
6100
Research |
13 Dec 02 |
20 Dec 02 |
|
6200
Budget |
13 Dec 02 |
20 Dec 02 |
|
6300
Contracts |
13 Dec 02 |
20 Dec 02 |
|
6400
Schedule |
13 Dec 02 |
20 Dec 02 |
|
6500
Approval |
20 Dec 02 |
22 Dec 02 |
|
6600
Final Specification |
22 Dec 02 |
23 Dec 02 |
7000 Build Simulation |
|
|
|
7100
Coding and Development |
23 Dec 02 |
10 Jan 03 |
|
7200
Preliminary Testing |
10 Jan 03 |
20 Jan 03 |
8000 Demonstration |
|
|
|
8100
Rigorous Testing |
20 Jan 03 |
30 Jan 03 |
|
8200
Evaluate Test Results |
20 Jan 03 |
30 Jan 03 |
|
8300
Identify Bugs and Fixes |
20 Jan 03 |
30 Jan 03 |
|
8400
Change and Modify |
20 Jan 03 |
30 Jan 03 |
9000 Funding |
|
|
|
9100
Arrange Demonstrations |
30 Jan 03 |
7 Feb 03 |
|
9200
Contact Potential Customers |
30 Jan 03 |
7 Feb 03 |
|
9300
Obtain Funding |
30 Jan 03 |
7 Feb 03 |
Appendix A3: Phase III Implementation Plan
1000 Implement Management Plan |
Start Date |
End Date |
|
1100
Resources and Hiring Process |
7 Feb 03 |
28 Feb 03 |
|
1200
Organization Approval |
7 Feb 03 |
28 Feb 03 |
2000 Develop Software |
|
|
|
2100
Software Integration |
28 Feb 03 |
10 Mar 03 |
|
2200
Software Testing |
10 Mar 03 |
25 Mar 03 |
|
2300
Evaluate Test Results |
10 Mar 03 |
25 Mar 03 |
|
2400
Identify Bugs and Fixes |
10 Mar 03 |
25 Mar 03 |
|
2500
Change and Modify |
10 Mar 03 |
25 Mar 03 |
|
3000 Contracts |
|
|
|
3100
Equipments Contract |
25 Mar 03 |
15 Apr 03 |
|
3200
Equipment Frame Contract |
25 Mar 03 |
15 Apr 03 |
|
3300
Service Contract |
25 Mar 03 |
15 Apr 03 |
|
3400
Finalization of Contract |
25 Mar 03 |
15 Apr 03 |
|
4000 Install and Testing |
|
|
|
4100
Equipment Installation |
15 Apr 03 |
30 Apr 03 |
|
4200
Integration Testing |
15 Apr 03 |
30 Apr 03 |
|
4300
Evaluate Test Results |
15 Apr 03 |
30 Apr 03 |
|
4400
Identify Bugs and Fixes |
15 Apr 03 |
30 Apr 03 |
|
4500
Change and Modify |
15 Apr 03 |
30 Apr 03 |
|
5000 Production Phase |
|
|
|
5100
Project Shut Down Management |
30 Apr 03 |
10 May 03 |
|
5200
Develop Mass Production Organization |
30 Apr 03 |
10 May 03 |
|
5300
Mass Production |
30 Apr 03 |
10 May 03 |
Appendix B1:
Phase I
Phase II
Phase III
Total
|
# |
Personnel |
Cost |
Cost |
Cost |
Cost |
|
|
Salaries |
|
|
|
|
|
1 |
Project Manager |
$19,387 |
$58,162 |
$19,387 |
$96,936 |
|
1 |
Financial Assistant |
$3,360 |
$24,192 |
$4,032 |
$31,584 |
|
3 |
Software Developer |
$10,080 |
$145,152 |
$5,040 |
$160,272 |
|
1
|
Web Dev. |
$1,210 |
$8,064 |
$1,210 |
$10,484 |
|
1
|
Research Specialist |
$11,290 |
$33,869 |
$1,882 |
$47,041 |
|
1 |
Marketing Director |
|
$25,805 |
$3,226 |
$29,031 |
|
1 |
Contract Manager |
$538 |
$25,805 |
$3,226 |
$29,569 |
|
1 |
Documentation Specialist |
$1,210 |
$14,515 |
$2,419 |
$18,144 |
|
1 |
Engineer |
$7,258 |
$14,515 |
$3,024 |
$24,797 |
|
1 |
Lawyer |
|
$3,750 |
$1,250 |
$5,000 |
|
|
Personnel Total |
$54,333 |
$353,829 |
$44,696 |
$452,858 |
|
|
Support Personnel |
|
|
$245,000 |
$245,000/yr |
|
|
Sprinkler Hardware |
$26,720 |
$371,250 |
$20,000 |
$417,970 |
|
|
Contractor for Installation |
|
|
$200,000 |
$200,000 |
|
|
Prototype |
|
$15,969 |
|
$15,969 |
|
|
Travel |
|
$1,000 |
$5,000 |
$6,000 |
|
|
Miscellaneous |
|
|
|
|
|
|
Workstations (10) |
$8,000 |
|
|
$8,000 |
|
|
Monitors (10) |
$1,500 |
|
|
$1,500 |
|
|
Printer (2) |
$300 |
|
|
$300 |
|
|
Internet connections (10) |
$600 |
$900 |
$300 |
$1,800 |
|
|
Paper, ink, etc. |
$500 |
$500 |
$500 |
$1,500 |
|
|
MS Project (4) |
$2,000 |
|
|
$2,000 |
|
|
MS Visual C++ (3) |
$330 |
|
|
$330 |
|
|
MS Office (5) Windows 2000 |
$925 |
|
|
$925 |
|
|
Adobe Design Collection (2) |
$2,000 |
|
|
$2,000 |
|
|
Sensor Software |
$300 |
|
|
$300 |
|
|
Software Database |
$0 |
|
|
$0 |
|
|
Other Software |
$2,000 |
|
|
$2,000 |
|
|
Miscellaneous Total |
$18,455 |
$1,400 |
$800 |
$20,655 |
|
|
Phase Total |
$99,508 |
$743,448 |
$515,496* |
$1,358,452 |
Appendix B2: Personnel Budget
|
# |
Personnel |
Months |
Hrs |
Rate/ Hrs |
Annual Salary |
40% Overhead |
Total |
|
1 |
Project Manager |
18 |
2400 |
$28.85 |
$60,000 |
$27,696 |
$96,936 |
|
1 |
Financial Assistant |
18 |
940 |
$24.00 |
$50,000 |
$9,024 |
$31,584 |
|
3 |
Software Developer |
17 |
1590 |
$24.00 |
$50,000 |
$45,792 |
$160,272 |
|
1
|
Web Dev. |
15 |
520 |
$14.40 |
$30,000 |
$2,996 |
$10,484 |
|
1
|
Research Specialist |
17 |
860 |
$16.80 |
$35,000 |
$13,441 |
$47,041 |
|
1 |
Marketing Director |
9 |
1080 |
$19.20 |
$40,000 |
$8,295 |
$29,031 |
|
1 |
Contract Manager |
10 |
1100 |
$19.20 |
$40,000 |
$8,449 |
$29,569 |
|
1 |
Documentation Specialist |
18 |
900 |
$14.40 |
$30,000 |
$5,184 |
$18,144 |
|
1 |
Engineer |
11 |
820 |
$21.60 |
$45,000 |
$7,085 |
$24,797 |
|
1 |
Lawyer |
|
20 |
$250 |
|
|
$5,000 |
|
|
Personnel Total |
|
|
|
|
|
$452,858 |
|
# |
Support Personnel |
|
|
|
|
|
Annual Salary |
|
1 |
Manager |
|
|
|
|
|
$
60,000 |
|
1 |
Programmer |
|
|
|
|
|
$
50,000 |
|
1 |
Marketing Director |
|
|
|
|
|
$
40,000 |
|
1 |
Engineer |
|
|
|
|
|
$
45,000 |
|
1 |
Assistant |
|
|
|
|
|
$
25,000 |
|
1 |
Secretary |
|
|
|
|
|
$
25,000 |
|
|
Support Total |
|
|
|
|
|
$245,000 |
Appendix B3: Miscellaneous Resources
|
SW Dev. Equipment |
Cost/Unit |
# |
Cost |
|
Workstations |
$800 |
3 |
$2,400 |
|
Monitor |
$150 |
3 |
$450 |
|
Printer |
$150 |
1 |
$150 |
|
Internet connections |
$10/mon. |
3 |
$540 |
|
Paper, ink, etc. |
|
|
$300 |
|
SW Dev Equip. Total |
|
|
$3,840 |
|
Software |
|
|
|
|
MS Project |
$500 |
3 |
$1,500 |
|
MS Visual C++ |
$110 |
3 |
$330 |
|
MS Office Windows 2000 |
$185 |
2 |
$370 |
|
Adobe Design Collection |
$999 |
2 |
$2,000 |
|
Sensor Software |
$150 |
3 |
$450 |
|
Database Software |
$0 |
2 |
$0 |
|
Other Software |
$1,000 |
3 |
$3,000 |
|
Software Total |
|
|
$7,650 |
|
Sprinkler Hardware |
|
|
|
|
Pipes and Fittings |
$3.50/ ft. $4-6/ ea. |
|
$100,000 |
Electrical Wiring |
$0.50 |
375,000/ft + |
$200,000 |
|
Pump Station |
$69,000 |
1 |
$69,000 |
|
Sprinkler Heads |
$15 |
650+ |
$9,750 |
|
Computer |
$800 |
1 |
$800 |
|
Touch-pad Monitor |
$500 |
1 |
$500 |
|
Controller |
$500 |
1 |
$500 |
|
Monitor Cables |
$50 |
1 |
$50 |
|
Wind Sensors |
$120 |
9 |
$1,080 |
|
Soil Temperature Sensors |
$20 |
18 |
$360 |
|
Humidity Sensors |
$120 |
9 |
$1,080 |
|
Sun Duration Sensors |
$150 |
18 |
$2,700 |
|
Soil Moisture Sensors |
$50 |
56 |
$2,700 |
|
Automatic Rain Shut-off |
$20 |
18 |
$360 |
|
Water Valves |
$38 |
36 |
$1,368 |
|
Sprinkler Timers |
$50 |
54 |
$2,700 |
|
PH Meter Testers |
$19 |
18 |
$342 |
|
Soil Test Kits |
$30 |
18 |
$540 |
|
Fertilizer Tank |
$ 125/ per 10 gal. |
18 |
$2,250 |
|
Liquid Fertilizer |
$
80/ per 10 gal. |
18 |
$1,440 |
Clay Buster |
$10/ per 80qts. |
9 |
$90 |
|
Weed Killer |
$20/ per 2 gal. |
18 |
$360
|
|
Miscellaneous |
|
|
$ 20,000 |
|
Sprinkler HW Total |
|
|
$417,970 |
|
Miscellaneous Total |
|
|
$429,460 |
|
Prototype |
Cost Unit |
# |
Cost |
|
Pipes and Fittings |
$3.50/ ft. $4-6/ ea. |
|
$3,500 |
Electrical Wiring |
$0.50 |
|
$5,500 |
|
Pump Station |
$4,000 |
1 |
$4,000 |
|
Sprinkler Heads |
$15 |
20 |
$300 |
|
Computer |
$500 |
1 |
$500 |
|
Touch-pad Monitor |
$500 |
1 |
$500 |
|
Controller |
$500 |
1 |
$500 |
|
Monitor Cables |
$50 |
1 |
$50 |
|
Wind Sensors |
$120 |
1 |
$120 |
|
Soil Temperature Sensors |
$20 |
1 |
$20 |
|
Humidity Sensors |
$120 |
1 |
$120 |
|
Sun Duration Sensors |
$150 |
1 |
$150 |
|
Soil Moisture Sensors |
$50 |
3 |
$150 |
|
Automatic Rain Shut-off |
$20 |
1 |
$20 |
|
Water Valves |
$38 |
1 |
$38 |
|
Sprinkler Timers |
$50 |
3 |
$150 |
|
PH Meter Testers |
$19 |
1 |
$19 |
|
Soil Test Kits |
$30 |
1 |
$30 |
|
Fertilizer Tank |
$ 50/ per 4 gal. |
1 |
$50 |
|
Liquid Fertilizer |
$
8 / per gal. |
1 |
$32 |
Clay Buster |
$10/ per 80qts. |
1 |
$10 |
|
Weed Killer |
$10/ per gal. |
1 |
$10
|
|
Miscellaneous |
|
|
$ 200 |
|
Prototype Total |
|
|
$
15,969 |
*For
phase III, we plan to get grants and other money from investors