The following information is a description of how to use the information system used to run the Digby Company. This system includes past data and formulas that will be used to make future decisions by Digby. The document includes descriptions of all the worksheets on the information system, which are:
1. Main Page
2. Segment Data
3. Research and Development
4. Marketing
5. Production
6. Finance
7. TQM
8. Human Resources
REFERENCES
Our information used to create this MIS system was all found on at http://capsim.com/menuApp/studentMain.cfm. This includes all tables and charts used to create any formulas provided.
SUMMARY OF SYSTEM
1. Charts- This system relies heavily on using tables and charts to find information for the correlating formulas. On each spreadsheet there is a table included that will help determine the decisions that need to be made. To keep things more simple, any chart that includes the information about our competition, Digby’s information will be highlighted in pink. This way there will be no confusion as to which information is for which company.
2. Formulas- Formulas are crucial in this system to determine what the future decisions for the company should be. Many formulas are included on almost every spreadsheet to help determine whether a decision is going to help the company or hurt the company. In attempt to keep the formulas simple, all information that must be entered into the formula is provided on the table given. Using the formulas is simple; just enter the numbers asked for and the answer will be calculated.
SYSTEM COMPONENTS
1. Main Page- The main page of the information system includes a table of the year end statistics for 2017 (round 4). Highlighted in pink is our specific statistics for Digby. Also included on this page is the Balanced Scorecard chart, which includes all customer related data and product related data which we are scored on throughout the simulation.
2. Segment Data- All