Feasibility Analysis Executive Summary for a Video Store

limit Feasibility epitome Executive epitome . 2 transmission line Plan . 5 strategy put across favored8 Video Store . 7 work out Standards.. 1 Description of the Application . 12 Risk sagaciousness. 13 Feasibility Study. 14 Functional Requirements . 1 Non useable Requirements .. 22 Appendix A FSSD Financials . 23 Appendix B DFD 26 Appendix C ERD & Database Relationships .. 8 Appendix D frame Analysis Scheduling 31 Lucky8 Videos administration Feasibility Analysis Executive Summary The First State dust nonplus ingrowth team has created the following feasibility analysis for the Lucky8 Videos System Project. The System Request is accustomed, along with a detailed feasibility study. The highlights of the feasibility analysis embarrass Technical Feasibility ? Competition run a risk high ? Technological feasibility risk low ? address of materials risk medium ?Location feasibility risk medium Economic Feasibility ? monetary values and benefits evolution disbursement s include Developer salaries, server firmlyw be Operation Expenses include Maintenance salaries (servicemen/programmer discommodeshooters) Intangible benefits include winged service, more satisfactory ? values of hails/Benefits Estimated Development Expense $7500 ($2500 server + $5000 total development salary) Estimated operative Expense $700 maintenance fee Estimated Consumer-Related Expense $20,000 for each renting box (includes videodiscs, Blue-Ray, and Games) 2 ? gold Flow stratum 1 $8200 Year 2 $700 + ($20,000 * X) Year 3 $700 + ($20,000 * X) Year 4 $700 + ($20,000 * X) Year N $700 + ($20,000 * X) ? Net introduce Value (NPV) Current Redbox Competitor System Cost $15,000 each Redbox renting unit + $7000 merchandise $2 $20 per videodisc Computer Analyst Annual Salary $57,202 market Manager Annual Salary $90,000 500 1000 items in a Redbox machine $147,202 Redbox income DVD rental worth $1. 20 * X Blue-ray rental price $1. 50 * X Game rental price $2. 00 * X Luck y8 System Cost $20,000 each Lucky8 rental unit 3 Servicemen at $15,000/yr 1 System administrator at $56,000/yr $101,000Lucky8 income DVD rental price $1. 20 * X Blue-ray rental price $1. 50 * X Game rental price $2. 00 * X 3 Net Present Value = 147,202 101,000 = $46,202 Return on Investment (ROI) (147,202 101,000) / 101,000 = 0. 457 Break-even Point $8200 4 First State System Development Business Plan Description of FSSD A pioneer in comprehensive IT outsourcing since 2008, First State System Development (FSSD) is a plentiful-service IT consulting and outsourcing firm for professiones in and nearly Wilmington, Newark, and Philadelphia.Our clients represent a crosssection of all industries and rely on FSSD for m whatever different IT operate. However, their gather upments be the homogeneous technology must support their condescension and operate reliably. FSSD is sacred to delivering superior, enduring solutions that are the best match amid tune and infrastructure, imple mented by the best conscious consultants in the industry. Whatever your convey is, FSSD depart meet it with a gigantic selection of onsite and remote IT services that are forthcoming as pre-packaged programs or a la carte, and all under one roof.Comprehensive IT services, broad expertise, and dependable customer service are just some examples of the services we offer. FSSD expands your IT capabilities and resources dramatically and ensures that technology whole kit for you. FSSDs comprehensive IT services outsourcing is the perfect fit for our clients. Our broad expertise expands the IT capabilities of these companies, giving them technology that fits their crinkle and supports their tune success and growth. Our out sourcing program includes Networking, Business Application Development, Web Design, Support, Pr occurrenceive Care, and nyielding Customer Service. mart leaders in a wide range of industries rely on FSSD services and solutions to power their nigh sophisticated c omputing environments. Theres no escaping it technology is a necessity in todays business and critical to your business success. But how do you find the right IT solution and make it work for you? The good stark nakeds is that you dont save to be an IT expert to be in business. You dont even need an in-house IT section. all(prenominal) you need is FSSD Technologies. 5FSSD subscribe tos the worry out of IT management. Our comprehensive IT outsourcing, technology consulting, and managed IT services immediately broaden your IT capabilities, giving you the power and flexibility to handle any aspect of your technology needs. Are you ready to make technology work for you? Take a next look at how FSSD mickle help ? ? ? ? ? ? Outsourced IT Managed Services Software Solutions Technology Assessments Procurement Design & architecture Most companies today rely heavily on technology to keep their businesses manoeuverning.FSSDs clients are no exception, and they do have a distinct advan tage We ensure that their technology drives their business success. We pick up their business, and we ascertain technology. Combined, our knowledge enables us to customize and deliver sound, strategical IT solutions that function as part of our clients long-term business strategy. Our financial numbers speak for themselves in order to offer you with a clear root of t how FSSD has been growing in the last years. For that reason we are proud to share our comparative income argument and balance sheet with you. See appendix A) 6 System Request Lucky8 Video Store Project Sponsor Prem Tandon Business Need The goal for this project is to increase Lucky 8 Videos market share for icon and racy rentals by spreading rental carrells across the state. Business Requirements Customers of Lucky 8 Video get out be able to rent or buy DVD, Blu-ray and video game discs from a kiosk in their area. They will hence be able to return the rented disk to the same or a different rental kiosk. Se rvicemen will be able to up accompaniment the origin of available products in the machine. sales knowledge from each Lucky 8 machine will be remotely patrimonial back to a central information clay for analysis. individually rental kiosk will finish ? ? ? ? A touch screen interface An internal inventory of discs stored in cases A wireless transceiver for proceeding and information communication A software system for processing customer transactions Business Value We anticipate a wider customer base because of the ease of use and convenience of using our video rental kiosks. We also expect increase rentals at our video stores, due to the increased brand recognition.Conservative opines for the total benefits eitherplace the project lifespan ? ? ? ? $250,000 savings from faster service $180,000 reduction in labor costs $1,138,000 increased sales $220,500 total net cash flow 7 Special Issues or Constraints ? ? ? ? Regular inventory up meshings will be required to keep availabl e movies and games recent. The infobase of products in the machines will also need to be updated when new releases are added to the inventory. Rental kiosks locations will be limited to areas that receive wireless service. Customers will non be able to return disks to a machine that already has a full inventory.Roles and Responsibilities Name arrange Description of Responsibilities Project planning Project control Project communication Resource management familiar project reporting and administration. Andrew Shearer Project manager Oversees all aspects of the organizations quality or business improvement efforts, such as developing and administering the program, training and coaching employees, and facilitating change throughout the organization. Responsible for establishing strategic plans, policies, and procedures at all directs so quality improvement efforts will meet or exceed internal and external customers needs and expectations. Understands basic revenue models, p/l, and cost-tocompletion projections and makes decisions accordingly. Understand our pricing model and billing procedures. accurately forecasts revenue, profitability, margins, bill Alex GrierTechnical Analyst rates and utilization. Assures project legal documents are completed and signed. Tracks and reports team hours and expenses on a weekly basis. Manage project budget. Determine project roles of team members based on project requirements, timeframes and budget. When demand work with external contractors in addition to internal resources.Define skill sets (competencies) required for the project based on project specifications and requirements. Abram Watson Business Analyst Determine resource requirements (including rounding, software, hardware, and facilities) of projects, based on project specifications. Designing the participations Processes Business Analysis in IT Analyzing the Various Business Models Detailed homework 9 Business Advisors is someone who analyzes the Business Adv isor organization and design of businesses, government departments, and non-profit organizations BAs also assess business models and their integrating with technology.Wilson Hsu Systems Analysis Plan a system flow from the ground up. Interact with customers to learn and document requirements that are then utilize to produce business requirements documents. Write technical requirements from a critical phase. Interact with designers to understand software limitations. Esteban Solorzano Vivar Perform system testing. Deploy the completed system. Document requirements or contribute to user manuals. Whenever a development process is conducted, the system analyst is responsible for designing components and providing that information to the developer.Database Technical Help programmers during system development, ex provide use cases, flowcharts or even Database design. 10 Project Standards Documentation standards ? Project name, date created and/or modified should appear on the top of eac h document. ? 1. 5 spacing should be use ? Fonts must be Arial 12pts. ? Each document created shall be kept in the project binder tag Standards ? All variable names will have relevant names and be in brainless camel case. ? All Class names will be in camel case. ? The project will use object lens oriented design patterns. The scratch will be split between several different classes. ? Each class will have methods to divide the logic of the program. ? Comments will be added to all sections of code that need further explanation. Procedural standards ? All staff will require meeting e really Mondays at 1030 for the team meeting. ? A special team Meeting will be executed every commencement exercise Friday on the month. ? All changes must be approved by the project manager first prior to their execution. Specification requirements standards ? Name of software package. ? Technical description of the package. Purpose of software package. ? Due date User interface design standards ? All buttons will be en life-sizedd for use with a touchscreen. ? All text will be large enough for customers with vision impairments to see. ? A color scheme will be used thought-out the entire user interface. ? Returning to the main menu should take no more than two clicks. 11 Description of the Application The application allows customers to frequent through discs available in the machine. Customers are able to add movies and games to a shopping cart. The customer will be prompted to enter their zip code and email address.This information is used to send a receipt to the customer and for credit verification. The disks are then dispensed from the machine. 12 Risk Assessment Risk1 The creation and implementation of the database portion of the system may consume additional time resources due to the extensive amount of DVD, Blu-ray, and games in all their platforms. comparableliness of risk Medium possibility of risk. Potential impact on the project This will delay the computer progra mming part by 15 25%. Ways to address this risk Our team will remove one or two part-time employees in order to enter the information to the database temporarily.The payment of this staff would be assumed by FSSD with no additional charge to the customer. 13 Feasibility Study 1. lymph node Information. 1. 1. History and Background of the Organization. The organization is a fully functional video rental store by the name of Lucky 8. The business started as a family run business and has since expanded. Lucky 8 has been running(a) for a little over 6 years. Within those 6 years, the business has done exceedingly well, make enough profit to expand with 20 rental kiosks 1. 2. Description 1. 2. 1. The Organization. The organization is a fully functional video rental store by the name of Lucky 8.The business started as a family run business and has since expanded. Lucky 8 has been operational for a little over 6 years. Within those 6 years, the business has done exceedingly well, maki ng enough profit to expand with 20 rental kiosks. 1. 2. 2. The organizational Structure. ? The owner is considered the primary manager however, the responsibilities for managing the three stores are divided among crew members. Each Lucky 8 store also has an on-site assistant manager. Cashier, stock, and sales associates are on the same hierarchy level in the organizational structure. 14 1. 3.The Client Information All communications take place with the business owner, and all information regarding the project must be discussed with him. Any changes or additions to the project must be presented to the owner for approval, and he is solely responsible for the final acceptance criteria Owner Name Prem R. Tandon Contact enlarge Cell Phone Number 302-555-5555 E-Mail Address For documentation emailprotected edu Client Background Before go-ahead Lucky 8, the owner was the regional manager of Blockbuster in the Delaware Tri-State. He has no formal occurrences of life with regards to med ia or entrepreneurship. . The Business Problem Lucky 8 video store has been having a moderate but steady growth in recent years. However, due to the increasing growth of video platforms such as Netflix or OnDemand services provided by cable operators, many of the mayor video rental companies are resolution their doorsteps. A clear example of this trend is Blockbuster. However, not all are bad news. A new video rental system has been implemented in recent times with great success by the public. This is video rental kiosks. That is the technology strategy that Lucky 8 wants to target. 3.Proposed New System Lucky 8 video store currently has no system in place to monitor or provide the rental of DVDs, Blu-rays, or games trough kiosks. The proposed system would offer functionality in the areas of inventory management, order tracking, staff management, reporting, and current time data sharing between kiosks. A custom designed system will be built in JAVA for this user to meet his speci fic needs. Microsoft Access will be used as the organizations database. FSSD will also provide all the components in order to hit the first kiosk. The user will assume the 15 cost of additional kiosks he will require in the future.However, FSSD will provide the technical assistance to install the system in the new kiosk with no extra charge. 4. Feasibility Analysis 4. 1. Technical Feasibility 4. 1. 1. Competition risk high ? ? ? Redbox has an estimate of 33,000 kiosks across the country and has a well-established customer base. Redbox averages an estimate of 35,000 customers a day at their terminals. Blockbuster has been around since 1985. Blockbuster has an estimate of 10,000 rental kiosks across the country. However, Blockbuster filed for bankruptcy September 23, 2010. 4. 1. 2. Technological feasibility risk low ? The technology is already on the market there should be no doubt this is feasible. You suffer actually bargain for pre-made rental kiosks online. 4. 1. 3. Cost of mat erials risk medium ? ? The rental kiosks are estimated to cost between 15,000 and 20,000. Companies like Redbox get a little over half their inventory from producers like Warner Brothers. However, they wager in a little under half their inventory from stores like Wal-Mart. The reason Redbox has resorted to buying from chains like Wal-Mart is due to the fact that producers like Warner Brothers have been trying to regulate and restrict access to movies for Redbox. Due to the fact that buying merchandise from chains like Wal-Mart, KMart, or any other seller that has a large inventory is possible, getting our merchandise wont be a problem 16 4. 1. 4. constancy feasibility risk low ? For companies like Redbox who have an estimate of 33,000 kiosks their cost of maintenance and labor is very expensive and tedious. However, for a small start-up company like you the cost of maintenance wont be too high. ? ? You can actually purchase pre-made rental kiosks online. One or two servicemen will be required to keep the kiosks up to date 4. 1. 5. Location feasibility risk medium ?Since the idea of DVD rental kiosks, the locations in which theyve been placed have benefitted a great deal because of them. The kiosks bring in business for grocery stores, McDonalds, Walgreens, and many other franchises across the country. ? ? Because of the profitability of having a kiosk on your front door step these franchises offer their space for free. The only risk is Redbox is in numerous locations and stores may be hard pressed to accept your kiosk over a renowned Redbox. 4. 2. Economic Feasibility See attached spread sheet for economic feasibility analysis. 4. 3.Organizational Feasibility It is concerned with determining whether the business itself has sufficient skills and resources to bring their product or service to the market table successfully. a) Three Primary Factors ? Management Expertise ? acceptability ? Resources 17 b) Management Ability ? Andrew Shearer displays a management prowess that is requisite for this position and is firmly consecrate to the completion of this project. ? Andrew Shearer has worked on numerous projects similar to the build of this with an outstanding success rate. We have no trouble appointing him as a fit candidate for this project. ) Resource Allocation ? Nonfinancial Resources ? ? ? ? ? ? Three Lucky 8 home stores. Large media collection. Well versed in media sales. Established cliental base. Available office space. Likelihood of establishing complaisant strategic partnerships is high. ? Financial Resources ? ? ? Numerous liquid assets. Minimum $1,000,000 budget for expansion. Steady profits. d) Acceptability. ? If we build it, will they come? ? The users of the system have already expressed a strong beguile in the implementation of a kiosk come as you please based system.The implementation of Redbox kiosks nationwide has brought mountainous profitability to not only the business, but the proximity business owners. Why not Lucky 8? ? Very convenient for consumers who are already on their way to a local store like Wal-Mart, Walgreens, or computer storage Rite. ? Our $1 rental price is much cheaper than other media rental stores. 18 ? Concerns ? If a kiosk is full you must drive to another kiosk or wait for open availability ? ? Credit wag or debit card access is required Summary ? The advantage we have is that the idea has already been produced and yielded success, so how can we fail?The benefits of the project far outweigh the risks. If we build it they will come. 19 Lucky8 Cost Benefit Analysis 4/18/2012 2012 Benefits Faster Service Increased Convenience Increased Sales union Benefits Development Costs 1 Server $2500 Development Salary Total Development Cost available Costs 3 Servicemen $15,000 /yr 1 System Administrator $56,000 /yr Total Operational Cost Consumer-Related Costs 20 Rental Boxes $400,000 Total Consumer-Related Cost Total Costs Total Benefits Total Costs Cumulative Net Cash F low Return on Investment(ROI) Break-even Point 31. 18% 3. 32 years 013 $50,000 $45,000 $130,000 $225,000 2014 $50,000 $45,000 $161,000 $256,000 2015 $50,000 $45,000 $192,000 $287,000 2016 $50,000 $45,000 $225,000 $320,000 Total $250,000 $180,000 $708,000 $1,138,000 $2,500 $5,000 $7,500 $0. 00 $0. 00 $0. 00 $0. 00 $0. 00 $0. 00 $0. 00 $0. 00 $0. 00 $0. 00 $0. 00 $0. 00 $2,500 $5,000 $7,500 $56,000 $56,000 $45,000. 00 $56,000 $101,000 $45,000. 00 $56,000 $101,000 $45,000. 00 $56,000 $101,000 $45,000. 00 $56,000 $101,000 $180,000. 00 $280,000 $460,000 $400,000. 00 $400,000. 00 $463,500 ($463,500) ($463,500) $0. 00 $0. 00 $101,000 $124,000 ($339,500) 0. 00 $0. 00 $101,000 $155,000 ($184,500) $0. 00 $0. 00 $101,000 $186,000 $1,500 $0. 00 $0. 00 $101,000 $219,000 $220,500 $400,000 $400,000 $867,500 $270,500 20 Functional Requirements 1. Search and Browse 1. 1. The System will allow customers to browse movie/game choices by predefined categories 1. 2. The System will allow customers to sea rch for movie/game chooses by title, maker and genre. 1. 3. The System will allow customers to see s short sample of a movie/game selection. 1. 4. The System will enable customers to add game/movie to a favorites list. Purchase 2.Purchase 2. 1. The System will enable customers to create a customer account that will store customer data and payment information 2. 2. The System will enable customers to specify the game/DVD to rent/purchase 2. 3. The System will collect and verify payment information. Once payment is verified the machine will eject DVD/Game 3. Promote 3. 1. The system will keep track of customer interest on the basis of previous searches and will use this information to promote DVDs/Games during future visits 3. 2. Marketing department can create promotions and specials on the Web site. . 3. Based on customers previous purchases, DVD/Game chooses can be targeted to the customer on future visits to the Website. 3. 4. On the basis of customer interests, customers can be n otified of special offers on DVD/Games that can be purchased at a reduced rate. 21 Nonfunctional Requirements 1. Operational 1. 1. The Digital database will be constructed to facilitate searches by title, genre, publishers and series 1. 2. In the event of a failure during a transaction the customer will be able to start over. 2. capital punishment 2. 1.Database/transaction speeds will be monitored and kept at an acceptable operating level. 2. 2. Browsing speed should take no more then 10-20 seconds. 3. Security 3. 1. Customer information will be secured 3. 2. Payment information will be encrypted and secured. 3. 3. Customers will not have access to encrypted information(other customers previous searches and account information) 4. Cultural and semipolitical 4. 1. An additional language will be provided if necessary for Spanish speaking customers. (Espanol) 22 Appendix A FSSD Financials 23 FSSD Income Statement Year 2008 2011 Income StatementRevenue Consulting Fees Network Design Fees Software Design Fees Total Revenue Expense Advertising Cost of Goods Sold Labor Cost of Goods Sold Hardware Depretiation Income Tax Expense insurance policy Interest Expense different Expenses Payroll Expenses Profesional Expenses Rent Repairs & Maintance Salaries & Wages Utilities Total Expenses Net Income 45,765 129,874 178,956 17,895 7,896 12,462 15,792 67,529 67,487 25,045 38,000 7,894 148,645 25,841 789,081 66,343 68,945 158,478 297,456 29,854 8,412 49,045 28,745 112,456 124,529 38,045 48,000 9,845 248,512 48,562 1,270,884 165,057 97,458 74,895 359,126 45,987 11,046 15,123 42,045 115,621 152,456 32,556 105,000 16,456 359,784 58,741 1,586,294 204,046 97,805 209,563 489,954 67,235 25,987 18,564 59,785 156,254 249,563 41,856 120,000 29,874 584,126 78,456 2,229,022 385,858 210,485 287,454 357,485 855,424 405,673 397,812 632,456 1,435,941 546,512 468,974 774,854 1,790,340 789,056 678,945 1,146,879 2,614,880 2008 2009 2010 2011 24 FSSD comparative BALANCE SHEET YEARS 2008-2 011Cash Accounts Receivable Notes Receivable Other Receivables Inventory Securities Total Current Assets 2008 ASSETS 53,039 192,484 882 25,363 23,539 5,000 300,307 2009 18,382 195,112 139 35,304 30,876 10,000 289,813 2010 130,442 206,395 2,965 27,143 20,158 20,000 407,103 2011 59,788 270,606 clxxv 32,789 16,116 25,000 404,474 Fixed Assets ALLOWANCE FOR depretiation Net Fixed Assets Investment Miscelaneus Receivables Differes Charges Other Assets Total Assets 16,601 (179,370) 237,231 537,538 LIABILITIES 92,168 20,037 54,505 6,572 173,282 1,000 174,282 34,075 15,000 191,788 240,863 537,538 440,116 (212,915) 267,639 557,452 529,554 (261,915) 267,639 674,742 589,509 (320,463) 269,046 673,520 Accounts Payable Notes Payable Other Payables Accruals Total Current Liabilities Deferred Liabilities Other Liabilities Total Liabilities Profit Common Stock Retained Earnings/ redundancy Total Equity Total Liability + Equity 88,022 22,785 39,601 2,558 152,966 3,000 155,966 15,819 15,000 201,196 23 2,015 516,984 47,376 27,764 34,399 34,110 243,649 4,000 247,649 80,366 15,000 260,631 355,997 674,742 106,380 25,101 83,714 15,540 230,735 10,000 240,735 57,400 15,000 309,866 382,266 673,520 25 Appendix B DFD 26 27 Appendix C Relationships ERD & Database 28 29 30 Appendix D Scheduling System Analysis 31 ID Project Name Days Start End 1-Feb 8-Feb 15-Feb 22-Feb 29-Feb 7-Mar 14-Mar 21-Mar 28-Mar 4-Apr 11-Apr 18-Apr 25-Apr 2-May 1. 0 Development Schedule Planning Phase Project Initiation Project Management 91 1-Feb 2-May 1. 1 1. . 1 1. 1. 2 27 11 16 1-Feb 1-Feb 10-Feb 28-Feb 12-Feb 26-Feb 1. 2 1. 2. 1 1. 2. 2 1. 2. 3 Analysis Phase Analysis system Requirements Gathering System Proposal 19 5 9 5 28-Feb 28-Feb 4-Mar 13-Mar 18-Mar 4-Mar 13-Mar 18-Mar 1. 3 1. 3. 1 1. 3. 2 1. 3. 3 1. 3. 4 Design Phase Design Strategy Architecture Design Database & File Speculations programme Design 26 1 8 8 9 18-Mar 18-Mar 19-Mar 27-Mar 4-Apr 13-Apr 19-Mar 27-Mar 4-Apr 13-Apr 1. 4 1. 4. 1 Implementation S ystem Construction 19 19 13-Apr 13-Apr 2-May 2-May 32