Following is a database for products and sales for a wholesale power equipment company called PowerSalesco....

  

Transcribed Image Text:

Following is a database for products and sales for a wholesale power equipment company called PowerSalesco. Company: PowerSales Co Database: SALES Table 1: PRODUCTS Product No ww1 ww5 xy6 bb9 PName Electric drill Skill saw Screwdriver set Fire extinguisher Table 2: ORDERS Customer Name McDowell's McDowell's McDowell's Clearmont Clearmont SuperSave SuperSave Product No ww1 xy6 bb9 bb9 ww1 ww1 ww5 Manufacturer Makita Philips Dexter Waddell Units Ordered 50 125 250 500 75 100 56 Unit price 124.95 231.95 34.95 50.00 Order Date 18/Jan/18 19/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 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) (20) Following is a database for products and sales for a wholesale power equipment company called PowerSalesco. Company: PowerSales Co Database: SALES Table 1: PRODUCTS Product No ww1 ww5 xy6 bb9 PName Electric drill Skill saw Screwdriver set Fire extinguisher Table 2: ORDERS Customer Name McDowell's McDowell's McDowell's Clearmont Clearmont SuperSave SuperSave Product No ww1 хуб bb9 bb9 ww1 ww1 ww5 Manufacturer Makita Philips Dexter Waddell Units Ordered 50 125 250 500 75 100 56 Unit price 124.95 231.95 34.95 50.00 Order Date 18/Jan/18 19/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 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 specific hard data and soft data would be and how the data would be used. Following is a database for products and sales for a wholesale power equipment company called PowerSalesco. Company: PowerSales Co Database: SALES Table 1: PRODUCTS Product No ww1 ww5 xy6 bb9 PName Electric drill Skill saw Screwdriver set Fire extinguisher Table 2: ORDERS Customer Name McDowell's McDowell's McDowell's Clearmont Clearmont SuperSave SuperSave Product No ww1 xy6 bb9 bb9 ww1 ww1 ww5 Manufacturer Makita Philips Dexter Waddell Units Ordered 50 125 250 500 75 100 56 Unit price 124.95 231.95 34.95 50.00 Order Date 18/Jan/18 19/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 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) (20) Following is a database for products and sales for a wholesale power equipment company called PowerSalesco. Company: PowerSales Co Database: SALES Table 1: PRODUCTS Product No ww1 ww5 xy6 bb9 PName Electric drill Skill saw Screwdriver set Fire extinguisher Table 2: ORDERS Customer Name McDowell's McDowell's McDowell's Clearmont Clearmont SuperSave SuperSave Product No ww1 хуб bb9 bb9 ww1 ww1 ww5 Manufacturer Makita Philips Dexter Waddell Units Ordered 50 125 250 500 75 100 56 Unit price 124.95 231.95 34.95 50.00 Order Date 18/Jan/18 19/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 18/Jan/18 19/Jan/18 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 specific hard data and soft data would be and how the data would be used.

Answer rating: 100% (QA)

Operational Report Daily Sales Summary Date 20231114 Report Daily Sales Summary Company PowerSalesCo Purpose To provide a summary of daily sales for all products by customer Audience Operations manage... View the full answer