microsoft Project

profilekharsan
HW8DataFile1.xls

Sheet1

Business Startup 90 days
Construct Business Plan 43 days
Research Marketable Propulsion Options 30 days Mechanical Engineers,Electrical Engineers,Chemists,Physicists,Administrative Staff
Focus Options Into Business Vision 15 days 3 Administrative Staff
Research Existing Hyd. Businesses 10 days 3 Administrative Staff
Focus Hydrogen Goals 15 days 5 Administrative Staff
Prepare Goal Presentation to Public 15 days 6 Public Relations Rep.
Announce Business Intentions to Public 1 day 7 Public Relations Rep.
Financial Research 40 days 4
Research Potential Costs 10 days Accountant
Develop Budget 15 days Accountant
Contact Potential Investors 15 days 11 Public Relations Rep.
Contact Governmental Grant Agency 15 days 11 Public Relations Rep.
Research Business Loans 15 days 11 Public Relations Rep.
Appeal to Local Community Representatives 30 days 10SS Public Relations Rep.
Re-evaluate Budget with Known Finances 10 days 12,13,14,15 Administrative Staff,Accountant
File Governmental Applications etc. 60 days 16
Employ Lawyer for Legal Guidance 5 days Administrative Staff
Acquire Business License 2 days 18 Lawyer
Apply for EPA Permits 60 days 18 Lawyer,HASMAT Specialists
Facility Location and Layout 23 days 16
Define Minimum Required Specifications 10 days Structural Engineer
Scout Potential Locations 10 days 22 Structural Engineer
Apply for Lease 2 days 23 Accountant
Apply for Required Permits 5 days 24 Lawyer
Lease Facility and Land 1 day 25 Lawyer,Accountant
Hire Workforce 17 days 16 Administrative Staff
Design and Submit Want-ad in Newspaper 1 day Administrative Staff
Review Applicants 5 days 28 Administrative Staff
Administer Placement Testing 3 days 29 Administrative Staff
Schedule Interviews 5 days 30 Administrative Staff
Hire Qualified Applicants 2 days 31 Administrative Staff
Pre-R&D 30 days 31
Acquire Experimental Resources 17 days
Determine Required Resources 5 days Mechanical Engineers,Chemists,Physicists
Locate Vendor 5 days 35 Sales
Purchase Resources 15 days 20 Administrative Staff
Equipment Gathering 17 days
Determine Required Equipment 5 days Mechanical Engineers,Machinists,Physicists
Contact Equipment Dealers 5 days 39 Sales
Purchase Equipment 15 days 20 Administrative Staff
Research Prototype Options 30 days
Research Current Hydrogen Technology 10 days Mechanical Engineers,Electrical Engineers,Chemists,Physicists
Brainstorm Prototype Designs 5 days 43 Mechanical Engineers,Electrical Engineers,Chemists,Physicists
Marketing Analysis 4 days 43 Accountant
Choose Initial Prototype Design 10 days 44,45 Mechanical Engineers,Electrical Engineers,Chemists,Physicists,Administrative Staff
Run Virtual Simulation 5 days 46 Mechanical Engineers,Electrical Engineers,Chemists,Physicists
Setup Facilities 15 days 41,37,26
Locate and Hire Moving Company 1 day Administrative Staff
Move Equipment to Desired Space 5 days 49 Moving Company
Move in Office Equipment 2 days 50 Moving Company
Move in Other Resources (Metal, Hydrogen etc.) 15 days 50 Moving Company
Check Any Missing Items 2 days 52,51 Administrative Staff
Begin Research and Development 0 days 33
R&D 269 days 53
Construct Prototype 80 days Mechanical Engineers,Electrical Engineers,Chemists,Physicists,Machinists
Modify Conventional Automobile 30 days Mechanical Engineers,Electrical Engineers,Chemists,Physicists,Machinists
Construct Internal Combustion Engine 30 days Mechanical Engineers,Electrical Engineers,Chemists,Physicists,Machinists
Build Working Prototype From Auto and Engine 30 days 58SS,57SS Mechanical Engineers,Electrical Engineers,Chemists,Physicists,Machinists
Test Prototype 119 days 59
Choose and Prepare Driver 1 day Administrative Staff
Rent Time at Local Test Track 3 days 61 Administrative Staff
Perform Real-time Testing 3 mons 62 Driver[300%]
Evaluate Prototype Testing and Abilities 5 days 63FF,62 Physicists,Mechanical Engineers
Determine Prototype Flaws 5 days 64FF Mechanical Engineers,Electrical Engineers,Chemists,Physicists,Machinists
Modify Prototype 70 days 65
Correct Prototype Design Flaws 30 days Mechanical Engineers,Electrical Engineers,Chemists,Physicists,Machinists
Repeat Testing Until Acceptable Prototype is Constructed 30 days 67SS Driver,Machinists,Electrical Engineers,Chemists,Physicists,Mechanical Engineers
Apply for U.S. Patents for Prototype 30 days 68 Administrative Staff,Lawyer
Market Prototype 90 days 69
Research Market 5 days Sales
Research Demographics 5 days Sales
Contact Automobile Manufacturers 15 days 72,71 Sales
Demonstration of Prototype 5 days 73 Driver,Public Relations Rep.
Sign Contracts with Dealers 1 day 74 Administrative Staff,Sales
Commercial 85 days 71,72
Hire Film Agency 2 days Administrative Staff
Decide on Desired Commercial 2 days 77 Advertising Agency
Run the Commercial for a Duration 30 days 78 Advertising Agency
Keep the Commercial Running if Successful 3 mons 79 Advertising Agency
Pre-Production 18 days 75
Locate New Facilities 5 days Structural Engineer
Follow-up for Additional Government Funding 5 days Accountant
Apply for Loan 5 days Accountant
Contact Industrial Suppliers for Needed Resources 5 days Administrative Staff
Lease Manufacturing Facilities 2 days 82 Administrative Staff
Hire Manufacturing Workforce 5 days 86 Administrative Staff
Purchase/Lease Manufacturing Equipment 2 days 86 Administrative Staff
Setup Manufacturing Facilities 15 days 88
Locate and Hire Moving Company 1 day Administrative Staff
Move Equipment to Desired Space 5 days 90 Moving Company
Move in Office Equipment 2 days 90 Moving Company
Move in Production Supplies 15 days 90 Moving Company
Setup Inventory Control 3 days 93,92,91 Administrative Staff
Begin Production 0 days 94
Production 300 days 94
Produce Product as Necessary 3 mons Machinists[300%]
Sell Product to Dealers 1 mon Sales
Receive Feedback on Product 6 mons 97 Public Relations Rep.
Expand Sales Market 6 mons 97 Sales
Post-Production Modifications 45 days 99
Review Feedback on Product 5 days Mechanical Engineers,Electrical Engineers,Chemists,Administrative Staff,Sales,Physicists
Correct Flaws in Product 30 days 102 Mechanical Engineers,Electrical Engineers,Chemists,Physicists
Modify Product Design and Continue Production 30 days 103 Mechanical Engineers,Electrical Engineers,Chemists,Physicists,Machinists

Sheet2

Sheet3