1) (20) Following is a database for products and sales for a wholesale power equipment company called PowerSalesco. Company: PowerSalesCo Database: SALES Table 1: PRODUCTS Product No PName ww1 Electric drill ww5 Skill saw Screwdriver set Fire extinguisher Manufacturer Makita Philips Dexter Waddell Unit price 124.95 231.95 34.95 50.00 bb9 Units Ordered 50 125 Table 2: ORDERS Customer Name McDowell's McDowell's McDowell's Clearmont Clearmont SuperSave SuperSave 250 Product No ww1 bb9 bb9 ww1 ww1 ww5 Order Date 18/Jan/18 19/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 500 75 100 56 a) (15) From the above database, design formal reports, with appropriate headings, according to the requirements below. Each report will be on a new page and will contain some data from the above database in appropriate format. i) (10) Design the output (including layout and information details) for one (1) operational report* and one (1) managerial report* *In designing your reports focus on the characteristics of the report and the audience you are servicing. You may make assumptions on any additional data that may provide more meaningful information - so long as you state your assumptions. 1 Page ii) (5) Describe (point form) each of the two types of reports in terms of how the information is used to support the decisions by each level of management. b) (5) Assume these reports (from(a) above) are used as input to an executive information system. Provide examples of the types of decisions made by this level of management. What additional insights could be derived from this information at this strategic level of reporting? Consider both hard data and soft data. Explain clearly, using examples, what the specifichard data and soft data would be and how the data would be used. 1) (20) Following is a database for products and sales for a wholesale power equipment company called PowerSalesco. Company: PowerSalesCo Database: SALES Table 1: PRODUCTS Product No PName ww1 Electric drill ww5 Skill saw Screwdriver set Fire extinguisher Manufacturer Makita Philips Dexter Waddell Unit price 124.95 231.95 34.95 50.00 bb9 Units Ordered 50 125 Table 2: ORDERS Customer Name McDowell's McDowell's McDowell's Clearmont Clearmont SuperSave SuperSave 250 Product No ww1 bb9 bb9 ww1 ww1 ww5 Order Date 18/Jan/18 19/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 500 75 100 56 a) (15) From the above database, design formal reports, with appropriate headings, according to the requirements below. Each report will be on a new page and will contain some data from the above database in appropriate format. i) (10) Design the output (including layout and information details) for one (1) operational report* and one (1) managerial report* *In designing your reports focus on the characteristics of the report and the audience you are servicing. You may make assumptions on any additional data that may provide more meaningful information - so long as you state your assumptions. 1 Page ii) (5) Describe (point form) each of the two types of reports in terms of how the information is used to support the decisions by each level of management. b) (5) Assume these reports (from(a) above) are used as input to an executive information system. Provide examples of the types of decisions made by this level of management. What additional insights could be derived from this information at this strategic level of reporting? Consider both hard data and soft data. Explain clearly, using examples, what the specifichard data and soft data would be and how the data would be used
