MIS: Mangment information System

Task: It is required to generate a report of a business Management Information System (MIS) using EXCEL. The MIS works on three different databases of a business. The databases show data related to sales, products, and expenses. The report is generated by the MIS that provides for business managers monthly information about various products offered by the business through different sites. Accordingly, the managers can estimate the satisfaction of clients about the offered products and the need for applying some developments. Deliverables: You will submit EXCEL-based report showing the main databases and the outcomes based on enclosed data with the aid of charts. You can use the following items in the generated report. Business Product Name Actual Sales Planned Sales Ratio of Actual Sales to Planned Sales Revenue Site Also, you need to identify which business site that achieves better sales. (Hint: to find the most frequent occurring text in a column: -INDEX(range, MODE(MATCH(range, range, 0 ))))