Preview

MIS Deliverable

Powerful Essays
Open Document
Open Document
1062 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
MIS Deliverable
INTRODUCTION
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

You May Also Find These Documents Helpful

  • Satisfactory Essays

    Bsbwor501 Final Exam

    • 397 Words
    • 2 Pages

    (TCO 1) Which of the following describes the function of the Formula Bar (as it applies to Excel…

    • 397 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    My company can make a massive use of spread sheets, for this I will use Microsoft Excel as this is the software that easily available. With this software I will be able create many things including a Cash Flow diagram (Appendix 1). This will allow me to then work out efficiently the costs of the business, the income of the business and the cash flow throughout the months. This software will also allow me to have formulas to make sure that the totals are correct, due to using the of the if I was to decide that I wanted to pay lower wages or found a supplier with lower prices I could change the figures in my spread sheet and the formula would then change the totals automatically. The formulas that I have used is the ‘SUM’ function to add up the totals and also then used them to add up my Net Cash Flow and my opening and closing bank balances (Appendix 2). This piece of software is very useful as it means I will have no calculations to do myself and will reduce the possibility of mistakes. It also makes the figures and all of my profits/losses and costs very clear, easy to understand and interpret. The disadvantages are that if you do not have some experience in using excel it can be hard to understand and mistakes can be made, even with experience in using it.…

    • 1872 Words
    • 8 Pages
    Good Essays
  • Good Essays

    Cango Financial

    • 1115 Words
    • 5 Pages

    The success of a business depends on its ability to remain profitable over the long term, while being able to pay all its financial obligations and earning above average returns for its shareholders. This is made possible if the business is able to maximize on available opportunities and very efficiently and effectively use the resources it has to create maximum value for all involved stakeholders. One way the performance of a company can be measured on critical areas such as profitability, its ability to stay solvent, the amount of debt exposure and the effectiveness in resource utilization, is performing financial analysis where a set of ratios provides a snapshot of company performance and future prospects. Financial analysis is also a very useful technique that forms a basis for making key decisions about company operations. In addition to internal company members, these ratios are used by potential investors and shareholders to make investment decisions about the company.…

    • 1115 Words
    • 5 Pages
    Good Essays
  • Satisfactory Essays

    Excel Chapter 8 Test

    • 599 Words
    • 10 Pages

    A what-if analysis tool that can help you find an optimal value for a formula in one cell—subject to constraints on the values of other formula cells on a worksheet.…

    • 599 Words
    • 10 Pages
    Satisfactory Essays
  • Powerful Essays

    The Syllabus on Info 3010

    • 2401 Words
    • 10 Pages

    Course Prerequisites: MATH 1140 Course Goals This course is designed to teach students the elements of: Data Analysis; Spreadsheet modeling and optimization Models of deterministic linear programming Probability theory and expected value for decision making under uncertainty Visual Basic for Applications in Excel and for simulation analysis Student Learning Objectives: As the result of this course students should be able to: 1. Execute the 7-step modeling process in any relevant business…

    • 2401 Words
    • 10 Pages
    Powerful Essays
  • Satisfactory Essays

    7. because it’s a date; all dates are numbers formatted to appear in standard date formats…

    • 193 Words
    • 1 Page
    Satisfactory Essays
  • Good Essays

    Even an appropriate chart type is selected, issues such as scaling, suitable titles and legend types must be considered carefully to ensure effective communication of the data so that it can be interpreted to aid decision making. Data is usually presented in digital table form, sometimes printed out only from the spreadsheet. While this presentation style provides detailed figures, it is not the efficient way to provide and disseminate information. It may be emphasizing some key information, or to emphasize the relationship between certain data or to identify trends. Appropriately presenting data in the form of graphs or graphs can be a useful analysis tool and this can facilitate the decision-making process if the data is effectively interpreted. It allows the user to create charts or graphs that look very professional and let decision makers review data…

    • 661 Words
    • 3 Pages
    Good Essays
  • Powerful Essays

    Charts / graphs / Excel spread sheet / pictures / art / source info / etc. as appropriate;…

    • 1866 Words
    • 5 Pages
    Powerful Essays
  • Satisfactory Essays

    Bis 220

    • 454 Words
    • 2 Pages

    In opening a new business we must take a look at the types of information systems to use to launch our business out the public. As a new nostalgic record store we must see ways for us to buy and sell records. In this summary I will be proposing two types of information systems with descriptions of each type and why it would be best suited for our record store.…

    • 454 Words
    • 2 Pages
    Satisfactory Essays
  • Satisfactory Essays

    You may use the Excel workbook NCC.xls (available on the course page) to analyze this case, although the analysis can be done without it.…

    • 426 Words
    • 2 Pages
    Satisfactory Essays
  • Good Essays

    In this assignment I will be explaining the issues and constraints in relation to the use of business information in Asda. I will be outlining the operational issues within the company.…

    • 1048 Words
    • 5 Pages
    Good Essays
  • Best Essays

    Nissan Leaf

    • 3003 Words
    • 13 Pages

    The Nissan Leaf is the first to enter the all-electric vehicle market. However, due to the current recession and the research and development costs put into designing the Leaf, our financial performance has been declining. Furthermore, there is still a lack of consumer faith in all-electric vehicles due to unsuccessful launches of other electric vehicles and competitors are ready to launch their own all-electric vehicle models. Our main objectives are to increase awareness of the leaf and attain 40% of the all-electric vehicle market by the end of 2012. The purpose of this report is to address the above issues and provide an action plan.…

    • 3003 Words
    • 13 Pages
    Best Essays
  • Powerful Essays

    3.1 Produce graphs using spreadsheets and draw valid conclusions based on the information derived ……………………………………………………………………………………………………………………17-18…

    • 6359 Words
    • 26 Pages
    Powerful Essays
  • Satisfactory Essays

    Non-Deliverable Forward

    • 584 Words
    • 3 Pages

    In finance, a non-deliverable forward (NDF) is an outright forward or futures contract in which counterparties settle the difference between the contracted NDF price or rate and the prevailing spot price or rate on an agreed notional amount. It is used in various markets such as foreign exchange and commodities. NDFs are prevalent in some countries where forward FX trading has been banned by the government (usually as a means to prevent exchange rate volatility…

    • 584 Words
    • 3 Pages
    Satisfactory Essays
  • Satisfactory Essays

    Deliverables

    • 4227 Words
    • 17 Pages

    Lakshmi Narayan MiTTAL born 15 June 1950 is a London-based London based Indian billionaire industrialist Born in Sadulpur village, in the Churu district of Rajasthan, India, and resides in Kensington, London. His father started a steel Mill in Hardoi, Uttar Pradesh, and nearly 80% of the Mill's production used to be sold through the firm owned by Lala Gulab Chand. They eventually moved to Calcutta where his father, Mohan became a partner in a steel company and made a Mohan, fortune.…

    • 4227 Words
    • 17 Pages
    Satisfactory Essays