Feasibility Analysis Executive Summary for a Video Store

Contents Feasibility abridgment Executive Summary . 2 occupation Plan . 5 scheme Request prospered8 Video Store . 7 pop the question Standards.. 1 Description of the Application . 12 Risk appraisal. 13 Feasibility Study. 14 Functional Requirements . 1 ornamental Requirements .. 22 Appendix A FSSD Financials . 23 Appendix B DFD 26 Appendix C ERD & Data meanspirited Relationships .. 8 Appendix D constitution analytic thinking Scheduling 31 well-fixed8 Videos arranging Feasibility Analysis Executive Summary The First State formation cultivation police squad has created the fol blueing feasibility abridgment for the Lucky8 Videos carcass shake off. The System Request is prone, along with a detailed feasibility study. The highlights of the feasibility analysis include adept Feasibility ? Competition risk high ? proficient feasibility risk low ? represent of materials risk strong suit ? muddle feasibility risk medium Economic Feasibility ? cost and benefits Developm ent disbursements include Developer salaries, server hardw atomic number 18 Operation put downs include Maintenance salaries ( improvementmen/ coder troubleshooters) Intangible benefits include Faster service, more convenient ? Values of be/Benefits Estimated Development Expense $7500 ($2500 server + $5000 broad(a) development salary) Estimated operational Expense $700 support fee Estimated Consumer-Related Expense $20,000 for for individu bothy wholeness lease box (includes imagediscs, Blue-Ray, and bouncys) 2 ?Cash Flow Year 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) ? shag Present Value (NPV) Cur operate Redbox Competitor System Cost $15,000 each Redbox lease unit + $7000 sell $2 $20 per DVD electronic computer Analyst Annual fee $57,202 grocery placeing Manager Annual Salary $90,000 500 1000 items in a Redbox machine $147,202 Redbox in buzz off DVD renting price $1. 20 * X Blue -ray rental price $1. 50 * X feeble rental price $2. 00 * X Lucky8 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 c exclusively up on Investment (ROI) (147,202 101,000) / 101,000 = 0. 457 Break- pull down Point $8200 4 First State System Development championship Plan Description of FSSD A pioneer in comprehensive IT come insourcing since 2008, First State System Development (FSSD) is a full-service IT consulting and outsourcing sign for backupes in and around Wilmington, Newark, and Philadelphia.Our clients represent a crosssection of all industries and rely on FSSD for some(prenominal) different IT services. However, their requirements argon the same engineering must corroborate their calling and operate reliably. FSSD is dedicated to delivering superior , enduring solutions that ar the best fit in mingled with none and infrastructure, apply by the best certified consultants in the industry. Whatever your need is, FSSD result meet it with a liberal woof of onsite and remote IT services that are operational as pre-packaged programs or a la carte, and all under one roof.Comprehensive IT services, broad expertise, and dependable node service are just some examples of the services we offer. FSSD expands your IT capabilities and resources dramatically and ensures that engineering works 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 engineering science that fits their business and supports their business success and growth. Our out sourcing program includes Ne tworking, worry Application Development, web devise, Support, Preventive Care, and nyielding Customer Service. Market leaders in a wide range of i ndustries rely on FSSD services and solutions to power their most sophisticated computing environments. Theres no escaping it engineering is a necessity in todays business and critical to your business success. barely how do you find the right IT solution and make it work for you? The ingenuous news is that you dont have to be an IT expert to be in business. You dont even need an in-house IT department. solely you need is FSSD Technologies. 5FSSD occupys 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 dole out any aspect of your technology needs. Are you ready to make technology work for you? Take a closer look at how FSSD drive out help ? ? ? ? ? ? Outsourced IT Managed Services Software Solutions Technology Assessments Procurement send off & architecture Most companies today rely heavily on technology to storage area their busi nesses emissionning.FSSDs clients are no exception, but they do have a distinct advantage We ensure that their technology drives their business success. We find out their business, and we translate technology. Combined, our knowledge enables us to custom-builtize and deliver sound, strategic IT solutions that function as part of our clients long-term business strategy. Our financial numbers speak for themselves in order to provide you with a clear idea of t how FSSD has been exploitation in the last years. For that reason we are proud to share our relative income statement and balance sheet with you. See appendix A) 6 System Request Lucky8 Video Store Project Sponsor Prem Tandon Business postulate The goal for this figure is to increase Lucky 8 Videos market share for movie and pole rentals by spreading rental booths across the state. Business Requirements Customers of Lucky 8 Video will be able to rent or buy DVD, Blu-ray and video game discs from a carrel in their area . They will then be able to give up the rented disk to the same or a different rental kiosk. Servicemen will be able to update the inventory of available products in the machine.Sales teaching from each Lucky 8 machine will be remotely transmitted back to a central randomness carcass for analysis. severally rental kiosk will contain ? ? ? ? A touch strain interface An internal inventory of discs lineaged in cases A wireless transceiver for transactions and discipline communication A software system for processing node transactions Business Value We anticipate a wider node base because of the ease of use and convenience of using our video rental kiosks. We withal expect increased rentals at our video stores, due to the increased station recognition.Conservative estimates for the total benefits e realwhere the fox 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 Is sues or Constraints ? ? ? ? standard inventory updates will be needful to keep available movies and games recent. The database 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 not be able to return disks to a machine that already has a full inventory.Roles and Responsibilities Name Position Description of Responsibilities Project planning Project control Project communication Resource management Internal toil reporting and administration. Andrew Shearer Project film director Oversees all aspects of the musical arrangements timberland 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 levels so quality improvement efforts will meet or pi nch internal and external customers needs and expectations. catchs basic revenue models, p/l, and cost-tocompletion calculateions and makes decisions accordingly. Understand our pricing model and billing procedures. Accurately forecasts revenue, profitability, margins, bill Alex GrierTechnical Analyst range and utilization. Assures project legal documents are completed and signed. Tracks and reports team hours and expenses on a weekly creation. Manage project budget. Determine project roles of team members establish on project requirements, timeframes and budget. When necessary work with external contractors in appendix 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 plying, software, hardware, and facilities) of projects, based on project specifications. Designing the Companys Processes Business Analysis in IT Analyzing the versatile Business Models Detailed Planning 9 Business Advisors is someone who analyzes the Business Advisor organization and envision of businesses, government departments, and non-profit organizations BAs also assess business models and their integration with technology.Wilson Hsu Systems Analysis Plan a system flow from the groundwork up. Interact with customers to learn and document requirements that are then use to realise 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 drug user manuals. Whenever a development process is conducted, the system analyst is accountable for designing components and providing that tuition to the developer.Database Technical Help programmers during system development, ex provide use cases, flowcharts or even Database design. 10 Proj ect Standards software documentation standards ? Project name, date created and/or modified should appear on the fade of each document. ? 1. 5 spacing should be used ? Fonts must be Arial 12pts. ? Each document created shall be kept in the project binder Coding Standards ? All variable names will have relevant names and be in headless camel case. ? All Class names will be in camel case. ? The project will use fair game oriented design patterns. The code will be split between several different classes. ? Each class will have methods to portion out the logic of the program. ? Comments will be added to all sections of code that need notwithstanding explanation. Procedural standards ? All staff will require meeting either Mondays at 1030 for the team meeting. ? A special team Meeting will be executed every first Friday on the month. ? All changes must be approved by the project manager first prior to their execution. Specification requirements standards ? Name of software packag e. ? Technical explanation of the package. Purpose of software package. ? Due date User interface design standards ? All buttons will be enlarged for use with a touchscreen. ? All text will be large generous for customers with vision impairments to see. ? A color scheme will be used thought-out the entire user interface. ? call ining to the main menu should take no more than two clicks. 11 Description of the Application The application quits customers to order 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 superfluous time resources due to the extensive amount of DVD, Blu-ray, and games in all their platforms. li keliness of risk Medium possibility of risk. Potential impact on the project This will delay the programming part by 15 25%. Ways to address this risk Our team will hire one or two part-time employees in order to enter the information to the database temporarily.The payment of this staff would be enterd by FSSD with no additive charge to the customer. 13 Feasibility Study 1. Client Information. 1. 1. History and ambit 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 operational for a curt over 6 years. Within those 6 years, the business has done exceedingly well, fashioning 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 operationa l for a little over 6 years. Within those 6 years, the business has done exceedingly well, making enough profit to expand with 20 rental kiosks. 1. 2. 2. The Organizational Structure. ? The owner is considered the chief(a) 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 Details cadre Phone Number 302-555-5555 E-Mail Address For documentation emailprotected edu Client desktop Before opening Lucky 8, the owner was the regional manager of sma sh hit in the Delaware Tri-State. He has no formal education with regards to media or entrepreneurship. . The Business Problem Lucky 8 video store has been having a prevail but steady growth in recent years. However, due to the change magnitude growth of video platforms such as Netflix or OnDemand services provided by cable operators, many of the mayor video rental companies are remnant their doors. A clear example of this trend is megahit. 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 real time data sharing between kiosks. A custo m designed system will be built in coffee bean for this user to meet his specific needs. Microsoft Access will be used as the organizations database. FSSD will also provide all the components in order to pee the first kiosk. The user will assume the 15 cost of spare 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 coarse 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 failure 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 send awa y actually get pre-made rental kiosks online. 4. 1. 3. Cost of materials 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 bring in a little under half their inventory from stores like Wal-Mart. The reason Redbox has resorted to purchasing from chains like Wal-Mart is due to the fact that producers like Warner Brothers have been severe 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. Labor 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 expect 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 ascertain 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 ? Reso urces 17 b) Management Ability ? Andrew Shearer displays a management prowess that is requisite for this puzzle and is firmly dedicated to the completion of this project. ? Andrew Shearer has worked on numerous projects similar to the constitute 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. realized cliental base. Available office space. Likelihood of establishing favorable strategic partnerships is high. ? Financial Resources ? ? ? legion(predicate) 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 have-to doe with in the implementation of a kiosk come as you divert based system.The implementation of Redbox kiosks nationwide has brought mountai nous 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 Shop 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 postponement for open availability ? ? Credit bait 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 sum Benefits Development Costs 1 Server $2500 Development Salary broad(a) Development Cost Operational Costs 3 Servicemen $15,000 /yr 1 System Administrator $56,000 /yr agree Operational Cost Consumer-Related Costs 20 Rental Boxes $400,000 supply Consumer-Related Cost entireness Costs hail Benefits Total Costs Cumulative Net Cash Flow 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 depend 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. in one case payment is verified the machine will eject DVD/Game 3. Promote 3. 1. The system will keep track of customer bear on on the basis of previous searches and will use this information to put forward 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 notified 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. Performance 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 political 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 Interest Expense Other Expenses Payroll Expenses Profesional Expenses Rent Repairs & Maintance Salaries & proceeds 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 eld 2008-2011Cash 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 one hundred seventy-five 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/Surplus Total Equi ty Total Liability + Equity 88,022 22,785 39,601 2,558 152,966 3,000 155,966 15,819 15,000 201,196 232,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 memorandum Planning manakin 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 strategy 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 Programming Desig n 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 System Construction 19 19 13-Apr 13-Apr 2-May 2-May 32