A Business Process Map Notation (BPMN) Organizer

  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 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 McDowell’s ww1 50 18/Jan/18 McDowell’s xy6 125 19/Jan/18 McDowell’s 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. 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. 2) (11) Now consider you are the business analyst for the HR Department of PowerSalesCo. You have been asked by the company CEO to review the Recruitment and Hiring process as part of the company's Human Resources Information System (HRIS). The following detail process map and modeling diagram using Business Process Modeling Notation (BPMN) has been developed and documented by a third-party consultant. The processes include: a) Advertise for the Position b) Source and Screen Applicants c) Hire the New Resource i) Review all three processes of the Recruitment and Hiring (above) including the Detail Process Map for Recruiting and Hiring (See Page 4). Utilize the BPMN* template to map the processes as part of your analysis. Identify the specific tables in the HRIS DBMS that are impacted by the process step. Write a brief narrative using Business Process Narrative approach and annotate (by underlining) the key procedures as part of the current As Is process. * A Business Process Map Notation (BPMN) Organizer