Read the following Case Study and answer the following questions[Total 20 Marks]

Note: Write Assumptions clearly, if any. Report layout should be represented in diagrammatic way. `

OurMart multinational retailcorporation OurMart multinational retail corporation offers extensive ranges of products within various countries of world. It operates its business operation within many countries of Europe, Asia. Main motto of this company is to help the customers in order to save the money by purchasing products from OurMart. This retail company offers extensive ranges of products, like cell phones, electronic products, clothing products, various health related products, equipment for exercising, ornaments, television sets, video games and many items. OurMart has to compete with several companies of retail business in those operating countries. It offers ecommerce website for operating business activities. OurMart operates its effective business operation within 11,000 stores under 71 banners among 21 countries of World. Apart from this, there are e-commerce websites within II countries. Main aim of OurMart is to help the customers in order to save the money and live more happily. On the other hand, it can be analyzed that financial position of the company is more or less good. Therefore, the international business scenario of OurMart is increasing gradually. This company always tries to meet the needs and demands of the customers of different countries as because every country has different value and choice and socio economic condition. Page 3 of 5 OurMart stores offer some store brands. Store brands are related to some line of products. Store brands can be recognized as a line of products those are branded by the retailer within the brand identity of the company. This can be refereed as product branding or house branding.There are some brands of products. Our choice, Supreme Value, Associate, CoreStays, Dr. Roar, Special fund, are the name of the few brands of OurMart. Therefore, this retail company offers various products under different name. This process can be called as product branding strategy. OurMart therefore offers instores and online facility to the customers. Customers can shop from the online store and as well as traditional retail stores of OurMart. This company claims that they help the customers in order to save money by shopping through retail stores, online medium and mobile devices of the customers. Moreover, customers have demanded for environmentally effective and efficient sustainable products fromOurMart who is taking initiatives. Customers also have the demand about the information of the entire lifecycles of the product. OurMart is a multinational conglomerate of retail industry and it offers both hard and soft products. Hard retail therefore involves electronics, furniture, sporting products etc. On the other hand, soft retail industry involves by clothing, fabrics etc.Every retailer tries to make differences in the strategy of their business operation. Their strategy of business operation is very important in order to sustain within the industry. There are different types of retailers. Some companies operate retail business by operating department stores. Department stores refer to very large stores who offer wide variety of products and services. Some companies also offer huge variety of products and services by giving discount on products. This is the main competitive factor of these types of companies. There can be Demographic types of retail business. Demographic retailers focus only upon a particular segment of product or service. Therefore, OurMart operates business by operating sale by departmental store and discount store. OurMart has achieved a good position within the competitive market. OurMart has achieved a secured place within the market. Market share of OurMart was 65.4% in 2012 within the U.S market of retail industry. Veracity and ALLmartAesco, Esda, Cainsbury are the main competitors of OurMart in the retail sector globally.OurMart therefore spent 1.5% for the information system of discount stores. It is comparatively higher than other competitors of the market. OurMart therefore utilizes effective technology in order to decrease the inventory cost. This process also helps OurMart to increase the sale within the competitive market. Therefore, diversification of the products of OurMart is very effective that helps to sustain in the competitive market. OurMart wants to go for a MIS Reporting system to support efficient and effective decision making for the information stored in its already existing not integrated computerized systems globally. They seek recommendations and reports requirements for better management of the company for all the business areas mentioned above which will help the top management, idle management and operations staff to improve business performance for their area of work.

Read the above Case Study and understand the issue, Problems and opportunities, alternatives recommendations for the given problem and possible solution related MIS reports. Page 4 of 5

Q3.1 Draw Report layout for any critical 3 reports for the following points mentioned. Report Layout with imagined data of 2 rows based on above case study for following 13 points:

1.Stakeholder Category (TM, MM, Op must)

2.Specific Stakeholder Designation

3.Business Objective expected from the MIS-report (for MI,M2,M3 modules only)

4.Measurable KPI(generally as a field value) for the Business Objective and the MIS-report (for M1,M2,M3 modules only)

5.Report Title

6.Purpose/Goal of Report KPI columns/facts/measure values & its UOM (at least 2 KPI must)

7.Report other significant attributes/Columns/fields (at least 5 must)

8.Filter fields (at least three must)

9.Row wise attributes

10.Summary KPI and statistic : Summation/functions (eg summation, avg as required, min 3 must)

11.Sorting on 2 attributes

12. Unique selling feature

Q3.2 For each of the above three reports, mention which report style will be applicable from: drag n drop, graphs, map rollovers, pdf, auto generated emails of reports, dashboards, scorecards, any better ways of report presentations. Show in diagrammatic report layout.

Q3.3 Mention and explain which category of report it is? and why: historical analysis, current data analysis and predictive analytics