1 / 15

Chapter 7: Knowledge with Information Systems

This chapter delves into the crucial intersection of knowledge and information systems in financial forecasting, focusing on consumer behavior analysis within the Class App Store. It highlights the role of business analysts in the app development process, examining pros and cons of onshore vs. offshore outsourcing. Key concepts include expense estimation for iPhone app development, performing sensitivity analyses, and utilizing Google Analytics for tracking consumer engagement. Additionally, it provides practical tools for forecasting sales revenue through logical assumptions and spreadsheet design, essential for successful app business strategies.

nguyet
Télécharger la présentation

Chapter 7: Knowledge with Information Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Chapter 7: Knowledge with Information Systems Financial Forecasts

  2. Agenda • Analyzing consumer behavior in the ClassAppStore • Discuss the role of a business analyst in the development process • List pros and cons of on and off-shore outsourcing • Estimate expenses for iPhone App Development • Perform a sensitivity analysis • Practice midterm

  3. Analyzing Consumer Behavior • Track through sales records • What people have bought • Track through clickstream records • What people have looked at • Track clickstream with Google Analytics • Add Google Analytics tracking to your website UA-18919251-4 for Ohio University • More Actions > Manage Site > General > Statistics

  4. Business analysts act as intermediaries betweenbusiness units and developers Marketing Accounting Business Analyst (MIS Major) Developer Human Resources Finance

  5. Outsourcing Diagram • Major Reasons for Outsourcing Activities • Cost reduction • Focus on core competencies • Increase quality (products or services) • Lack of internal skills or expertise • Entry barriers (equipment, technology, etc.) • Capacity

  6. Estimating Costs

  7. What Will You Earn Each Year? Year 1 • You think you will sell 700 units of the app in Year 1 @ $2/unit • Apple collects 30% of each sale as commission Year 2 • You predict that sales will double in Year 2 (still @ $2/unit) Year 3 • You predict that Year 3 sales will double over Year 2 sales (still @ $2/unit)

  8. Now What Will You Earn Each Year? Year 1 (more realistic) • You must pay the Developer $3,500 to develop your app. This includes maintenance and bug fixes for the first year. • You think you will sell 700 units of the app in Year 1 @ $2/unit • Apple collects 30% commission on sales Year 2 (more realistic) • You must pay the Developer $1,000 to maintain your app. • You predict that sales will double in Year 2 (still @ $2/unit) Year 3 (more realistic) • You must pay the Developer $1,000 to maintain your app. • You predict that Year 3 sales will double over Year 2 sales (still @ $2/unit)

  9. Group assumptions because they may change

  10. Use formulas to generate information

  11. Using formulas enables automatic adjustments

  12. Sensitivity analyses show multiple assumption values and resulting outcomes simultaneously

  13. Use graphic design principles to format spreadsheets

  14. Summary/Conclusion • MIS professionals tend not to program; they serve as intermediaries between the business unit and the programmers. • On and offshore outsourcing is a popular alternative when a business does not have a dedicated programming staff. • A business has numerous startup costs such as incorporation, advertising, and so forth, which need to be forecast. • Fixed costs are incurred even if no products are sold; whereas variable costs are incurred only when a sale is made. • Contribution margin is the money realized by the business after paying variable costs.

  15. Summary/Conclusion • Spreadsheets should adhere to graphic design principles. • Spreadsheets generate new information by use of formulas. • Well designed spreadsheets group input variables into an assumptions area. Ideally, the assumptions area is the only place that numbers are typed. • Formulas may be copied. However, cells that should not change in a formula should be named. • Your exposure can be analyzed in a sensitivity analysis using a data table.

More Related