In this assignment I will be applying a range of techniques to analyse data effectively for business purposes. In doing this I will be creating information that can be used for decision making by summarising, data using representative values. I will be using the results to draw valid and useful conclusions that can be used in a business context.
In addition to this I will also be analysing data using measures of dispersion, and I will use this to inform a given business scenario. Finally I will demonstrate how to calculate quartiles, percentiles and correlation coefficients and will use them to draw useful conclusions in a business context.
In this assignment I will be producing information in appropriate formats for decision making in an organisational context. I will be using data from a given business scenario, and will prepare a range of graphs using spreadsheets. This will include line, pie, bar charts and histograms and we will draw valid conclusions based on the information derived. I will use trend lines in spreadsheet graphs to assist in forecasting for specified business information and thus facilitate decision making. Finally I will prepare a business presentation using suitable software and techniques to disseminate information effectively and persuasively.
In this assignment I will look at the use of information to make decisions at not only operational but also tactical and strategic levels in an organisation. In doing this I will be reviewing management information systems (MIS) and suggesting appropriate information processing tools for operational, tactical and strategic levels of the organisation. I will also review and evaluate inventory control systems in an organisation.
I will prepare a spreadsheet to enable material requirements planning and demonstrate how to calculate the economic order quantity (EOQ). Finally I will prepare a project plan for an activity and determine the critical path, use financial tools such as discounted cash flow and internal rate of return (IRR function) to evaluate the financial viability of the proposed investment.