underlying calculations that are the bases for the projection Methodology is to

Underlying calculations that are the bases for the

This preview shows page 36 - 40 out of 61 pages.

underlying calculations that are the bases for the projection  Methodology is to develop a complete breakdown of monthly and quarterly projects that yield annual projects
Image of page 36
 Use Excel  Inputs o January Sales o COGS Percentage o Fixed Cost Dollars o Bonus Assumptions Dollars o Monthly Sales Percentage Change  Outputs o Sales by Month & Category o Cost of Goods o Bonus Payout o Total Fixed Costs o Total Expenses o Taxes o Net Profit o Annual Projections Formulas/Functions =VLOOKUP(Reference Cell, Table Range, Column, Exact Match?)I.e. =VLOOKUP(F5, E25:F27, 2, TRUE)Searches for value in F5 in E25:F27, if it finds a close match, it returns the value in the 2 nd column. =IF(Function, If True, If False) I.e. =IF(H5>C25, H5, C25) If H5 is greater than C25, the formula will return H5. Otherwise it will return C25. =MIN(C1:C25) Returns the lowest value in the cell range =MAX(C1:C25) Returns the highest value in the cell range =AVG(C1:C25) Returns the average of all values in the cell range =SUM(C1:C25) Returns the sum of all values in the cell range GOAL SEEK Set Cell: Cell you know the end value ofTo Value: Set end valueBy Changing Cell: Cell you want to adjust (ALL ELSE EQUAL) Svac 21  
Image of page 37
  Chapter Two  Information system (IS): combination of technology, data, people and processes that is directed toward the collection, manipulation, storage, organization, retrieval, and communication of information  Why all business professionals need to be IS managers o Each of us acts with many information systems in daily lives o Information systems are increasingly ingrained in our business and professional lives  Overview of systems: o System: is a set of interacting components, working together to form a complex, integrated whole in order to achieve some goal by taking inputs and processing them to produce outputs o Most systems are open systems: means that they interact with their environments o Feedback: body sweating because it is hot o Subsystems: systems are often composed of them, system part of a larger system o Equifinality: is the idea that in an open system there are many different potential paths to the final outcome  Different ways to end up in the same place o Systems often have a feedback loop where information from the environment is sensed by the system  May change behavior based on feedback  Foundations of Information Systems o Information system does not require a computer  Computerized is focus of class which do involve a computer  Non-computerized systems will be called manual information systems o People are the most important component of any information system
Image of page 38
o Information processing cycle  Input: collection of data and its conversion into a form that allows processing  Processing: manipulation and transformation of data  Storage: holding place for data so that it can be retrieved at a later time  Output: transformation of processed data into a form that can be understood by its eventual user  Control: enforcement of correct processing procedures o
Image of page 39
Image of page 40

You've reached the end of your free preview.

Want to read all 61 pages?

  • Spring '14
  • YvonneGalusha

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture