1) (20) Following is a database for products and sales for a wholesale power equipment company called Power Sales co.

Company: Power Sales Co Database: SALES Table 1: PRODUCTS

Product No	PName	Manufacturer	Unit price
ww1	electric drill	Makita	124.95
ww5	skill saw	Philips	231.95
xy6	screwdriver set	Dexter	34.95
bb9	fire extinguisher	Waddell	50.00

Table 2: ORDERS

Customer Name	Product No	Units Ordered	Order Date
McDowells	ww1	50	18/Jan/18
McDowells	xy6	125	19/Jan/18
McDowells	bb9	250	19/Jan/18
Clearmont	bb9	500	18/Jan/18
Clearmont	ww1	75	19/Jan/18
SuperSave	ww1	100	18/Jan/18
SuperSave	ww5	56	19/Jan/18

a) (15) From the above database, design formal reports, with appropriate headings, according to the requirements above. 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. 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 specific hard data and soft data would be and how the data would be used.