100%(3)3 out of 3 people found this document helpful
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 monthlyand quarterly projects that yield annual projects
Use Excel Inputs o January Saleso COGS Percentageo Fixed Cost Dollarso Bonus Assumptions Dollarso Monthly Sales Percentage ChangeOutputso Sales by Month & Categoryo Cost of Goodso Bonus Payouto Total Fixed Costs o Total Expenseso Taxeso Net Profito Annual ProjectionsFormulas/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 2ndcolumn. =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 SEEKSet Cell: Cell you know the end value ofTo Value: Set end valueBy Changing Cell: Cell you want to adjust (ALL ELSE EQUAL)Svac 21
Chapter TwoInformation 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 liveso Information systems are increasingly ingrained in our business and professional livesOverview 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 toproduce outputso Most systems are open systems: means that they interact with their environmentso Feedback: body sweating because it is hoto Subsystems: systems are often composed of them, system part of a larger systemo Equifinality: is the idea that in an open system there are many different potential paths tothe final outcomeDifferent ways to end up in the same placeo Systems often have a feedback loop where information from the environment is sensed by the systemMay change behavior based on feedback Foundations of Information Systemso Information system does not require a computerComputerized is focus of class which do involve a computerNon-computerized systems will be called manual information systemso People are the most important component of any information system
o Information processing cycleInput: 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 canbe understood by its eventual user Control: enforcement of correct processing procedures o