CIS 105 Lecture Notes - Lecture 2: Making Money, Complete Control, Toyota Production System
Document Summary
Use spreadsheet to create revenue predictions . How are we making revenue ? you need to convince the banker how much you"re going to sell. you need numbers, statistics, what people are likely to buy. (excel spreadsheet is. Once you predict january, the banker is going to ask what happens in february? . Don"t over inflate anything, the bank will not take you seriously. dial it back to reality. Spreadsheets are a what-if analysis, they are used to determined the future. Sales only happen because someone is bad at spreadsheets and forecasting. Treat others in your database like a chimpanzee, control everything . Just-in-time (jit) inventory management, also know as lean. Any display of information in tabular form, with rows and/or columns named. Select another cell, and then press the f4 key to make that cell reference absolute. you can continue to press f4 to have excel cycle through the different reference types.