$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 Manufacturer Unit price

ww$1$ Electric drill Makita $124\mathrm{.}95$

ww$5$ Skill saw Philips $231\mathrm{.}95$

xy$6$ Screwdriver set Dexter $34\mathrm{.}95$

bb$9$ Fire extinguisher Waddell $50\mathrm{.}00$

Table $2$: ORDERS

Customer Name Product No Units Ordered Order Date

McDowell$$s ww$15018/$Jan$/18$

McDowell$$s xy$612519/$Jan$/18$

McDowell$$s bb$925019/$Jan$/18$

Clearmont bb$950018/$Jan$/18$

Clearmont ww$17519/$Jan$/18$

SuperSave ww$110018/$Jan$/18$

SuperSave ww$55619/$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.

$2|$ 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 specific hard data and soft data would be and how

the data would be used.