$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.