Phase III Instructions

1. Enter the data given above into the access program that you created with one of the following options:
   1. Import the data (Recommended; you may create a new Access file to import the data and then link the tables based on their relationships as determined in Phase I & II)
   2. Create a form with a sub-form for sales, purchases, cash receipts, and cash disbursements before entering data by transaction
   3. Manually enter the data into each table
2. Create an inventory performance report that shows the answer to the following questions:
   1. Which inventory category generated the most gross profit?
   2. Which inventory type generated the most gross profit?
   3. Which inventory category generated the most sales revenue?
   4. Which inventory type generated the most sales revenue? (Hint: you may create a query that includes all the information needed for the report, and then create a report based on that query. You may include graphs that may help you answer above questions in your report.)
3. Based on your models and your understanding of the business, a) identify at least FOUR the threats or vulnerabilities of Brock Ltd.; b) describe the potential consequences of each identified risk exposure; c) recommend actions to mitigate those risks. A sample answer is given in the table below.

   	Threat or Vulnerability	Potential Consequences	Recommendations
   Example	The cashier records sales transactions while handling cash	The cashier may steal cash from the company and change the record to cover the theft	Assign the duties of receiving cash and recording sales to separate employees

4. Identify at least THREE opportunities of using information technology to improve the business processes in the purchase and revenue cycle of Brock Ltd. (Use point form)
5. List at least TWO audit techniques that may be used to audit the program that you created, and explain how to apply those techniques to perform the audit. (Use point form)
6. Use Power BI to Get Data from your Access database and create the following:

a. A dashboard that shows the following:

1. A card visualization of how many customers there are
2. A card visualization of how many different product types there are
3. A card visualization of how many different product categories there are
4. A stacked bar chart showing the number of inventory types provided by each supplier

b. Create a map of customer locations based on city.

Submission:

Upload the following to Term Project Final under the Online Submissions module on Sakai by 11:59 p.m on Thursday, April 8, 2021.

i. The inventory performance report in Requirement #2 (print to PDF format)

ii. Your answers to Requirements 3, 4, and 5

iii. A screenshot of the dashboard in Requirement #6 (a)

iv. A screenshot of the map of customer locations in Requirement #6 (b)

v. The Access file that you used to create the inventory performance report required by 2.

vi. The Power BI file that you used to complete requirement #6.

Background Information Brock Ltd. sells home furniture purchased from various furniture manufacturers to customers through the companys sales force in the GTA, Ontario, Canada. Purchases The purchasing clerk runs an inventory report everyday to identify the items that should be purchased based on the reorder point of each inventory item. When employees from various departments need to purchase something, they fill in a purchase requisition form and send it to the purchasing clerk. Brock Ltd. creates a purchase order for each purchase of inventory items, office supplies, or services. For each purchase order, there is one receipt. For each receipt, there is one purchase order. All the vendors are required to create one invoice for each purchase order after goods are delivered and received in good condition. Accounts Payable The accounts payable clerk prepares checks for payments to various venders. Brock normally pays for purchases at the end of each month for all the purchases from each vendor during the month. If multiple purchases from the same vendor were made, the accounts payable clerk will combine payments. However, each purchase invoice is either unpaid or paid in full. If an invoice is received after the checks are prepared, they will hold it until the end of the following month before sending payment. The accounts payable clerk stamps each invoice with the check number, the check amount, and the date paid. After the check is prepared and sent out to the vendor, they package all of the source documents and file them. Some cash disbursements involve parties other than vendors (e.g. bank loans). Sales Each type of furniture inventory is given a unique identification number and a suggested selling price. Each sale includes one or more pieces of furniture and can be paid for in one of the following three ways: (1) immediately in cash; (2) on the 15th of the following month; (3) over the period of six months. When customer data is initially entered into Brocks information system, the customer is immediately assigned to a salesperson. When a salesperson is hired, he or she is immediately assigned to a group of customers. No more than one salesperson participates in making a particular sale. A salesperson may negotiate with a customer and agree on a selling price that is lower than that furnitures suggested selling price, especially if the customer is a high-volume customer or if that furniture is a slow seller (i.e., it has been in stock for a long time).

Salesperson commission rate is determined per contractual arrangement with each salesperson and, for a particular salesperson, it is the same percentage rate no matter what items he or she sells. Salespersons responsibilities include determining whether credit card sales are approved, approving credit sales, and approving sales returns. Cash Receipts Although the vast majority of cash receipts come from customers (any particular cash receipt would be from only one customer) for sales, some cash receipts come from other sources (e.g. interests received from banks). Every cash receipt is processed by exactly one of Brocks several cashiers and is deposited into one of Brocks bank accounts. Other Information about furniture, employees, and customers often needs to be entered into the database before any transactions involving them have occurred.

AutoSave OFF OFF ROSUE Bank Account a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibrl (Body) v 11 ~ Al A et Wrap Text Number Insert v Y , v Delete Paste BIU v Av = = = Merge & Center v Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter Format v Find & Select Sensitivity V C5 fx 20000 c E G H I K M N o P A S T U V W X Y Z AA 1 Bank_Act Bank_Nami Bank_Balar Bank_Type Bank_Location 2 1001 TD 5,000.00 Chequine TD-Downtown St. Catharines 3 2002 TD A Savings TD Downtown St. Catharins 4 2003 Scotia 5.000.CO Chequing Scotia Bank Downtown Toronto 5 1004 Scotia 20,000.COISavines Scotia Benk - Downtown Toronto 2005 EMO 20.000.CO Cheguing AMD North York, Taranto 7 200G MO 14,958.CO Savings - USUMO - North York, Toronto 8 1007 Scotia 0.00 Chequine - Setia Bank - Downtown Toronto 2008 CIBC son.co Chequing CIBC Downtown Taranto 10 11 12 13 14 15 16 17 12 19 20 21 22 23 24 25 26 27 22 29 30 31 32 33 34 35 36 37 38 39 40 41 42 44 Bank Account + # EP - + 100% % AutoSave OFF OFF A SUE Cash Disbursements a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibrl (Body) v 11 ~ Al A eh Wrap Text Number Insert v Y , v Delete Paste BIU Av = = = Y Merge & Center Ideas Conditional Format Cell Formatting es Table Styles - Sensitivity Sort & Filter Format v Find & Select V C5 f520 H I K M N o P A S T U V W X Y Z AA G G 1 CD_Num CD_Date CD Amoun Ven_Num Empl_Nur Bank Acct_Num 2 1 AWAY 7,707.55 500002 109 1003 3 2 1,274.67 500001 109 1003 4 3 Attitute 256.20 tee G00014 209 1001 5 4 AHAHALAM 520.00 600015 109 1001 E SAU 375.26 500016 109 1003 7 GA 2,166.20 LUO003 209 1001 400 87 AMALAN 2,330.81 500005 109 1003 8 AA 2,252.CO 500008 109 1001 10 9 9 tttttt 256.80 G00014 210 1003 11 10 AHHAHAY W 560.00 600015 110 1001 12 11 R 11,623.32 600002 111 1001 13 12 hitt 2,266.20 LUO003 209 1001 14 13 AWAY 256.80 600011 110 1003 15 14 A 570.00 500015 110 1003 16 15 A 1,274.67 G00001 209 1001 17 2001 16 AMALA 7,138.10 500004 111 1001 18 17 A 255.80 500014 109 1003 19 18 550.00 G00015 210 1001 20 19 AHLAWAY 2,330.81 500005 109 1003 21 20 ALAM 6,829.28 500002 109 1003 22 21 in 2,737.10 GOOOD2 209 1001 2. 23 22 AM 286.32 500014 110 1003 24 23 525.00 500015 209 1001 25 24 Autite 2,100.20 LUO003 211 1001 25 26 25 ALALAY 3,933.24 500004 110 1001 27 26 A 278.56 600014 109 1001 22 27 586.CO 600015 211 1003 29 A. 28 AHAHALAW 4,339.53 500002 111 1003 30 29 A 1,748.10 500004 109 1003 31 32 33 34 35 36 37 38 39 40 41 42 44 Cash Disbursements + # EP - + 100% % AutoSave OFF OFF ROSUE Cash_Receipts a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments v 11 Calibrl (Body) X [G ~ Al A ab Wrap Text Number Insert v Y , v Delete Paste Av = = = Y Merge & Center Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter # Format Find & Select Sensitivity BIU f 1559.99 V C6 H . K L M N o 5 T U V W X Y 1100011 D F 1 1 CR_Num CR Date CR Amount Bank Act Num CustNum Empl Num 2 100002 2019-01-02 2,200.00 1001 10000001 110 3 100003 2019-01-02 509.95 1003 20000920 111 4 100004 2019-01-05 1,220.00 1001 10000004 110 5100005 2019-01-05 3.990 00 1001 10000307 110 10000e 2019-011211,559.99 1003 1000OODS 110 7 100007 2019-01-16 2.530.00 1001 10000023 111 A 100308 2019-01-22 2.800.00 1001 1000000 110 100009 2019-01-31 1,550.00 1001 10000003 111 10 100010 2019-02-03 1,193.33 1003 10000020 110 100011 2019-02-09 1,500.00 1003 10000017 111 12 100012 2019-02-11 5,000.00 1001 10000310 110 13 100013 2019-02-24 2,970.00 1003 10000028 110 14 100011 2019-02-28 609 95 1001 10000030 110 15 100018 2019 0228 1,182.33 1003 10000026 111 16 100016 2019-03-17 319.99 1003 10000019 111 17 100017 2019-03-25 2,769 99 1001 10000001 110 12 100018 2019 03 31 509.95 1003 10000320 110 19 100019 2019-03-21 1,193.33 1001 10000020 110 20 100320 100020 2019-04-01 1,550 00 1001 10000014 110 21 10002: 2019-04 OS 5.859.70 1003 10000316 111 22 100022 2019-04-11 2,530.00 1001 10000003 110 23 100323 2019-04-15 77000 1003 10000016 110 24 100924 2019-04 19 3,506.80 1001 10000016 111 25 100025 2019-04-23 4,400.00 1001 10000023 110 26 100026 100326 2019-04-30 609 95 1003 10000020 110 27 100927 2019-0430 1,182.33 1001 10000026 111 24 100028 2019-05-01 1,320.00 1003 20000340 110 29 100020 100328 2019-05-13 639 98 1001 10000006 110 30 100030 2019-05 28 2.420.00 1001 10000013 111 31 100031 2019-05-32 609.95 1003 10000020 111 32 100032 2019-05-31 1,183 33 1001 10000326 110 33 100033 2019-05-02 3,506.30 1003 10000017 34 100034 2019-03-10 1,559.99 1001 10000003 110 35 100335 2019-05-12 5,816 80 1003 1000000 110 36 100036 2019-05-15 2,537.80 1003 10000042 111 37 100037 2019-06-20 1,210.00 1001 10000017 110 38 100038 2019-07-10 1,910 00 1001 20000301 109 39 100039 2019-08-13 588.00 1003 20000010 111 40 100040 2019-09-10 SG0.00 1001 30000002 111 41 42 43 44 Cash Receipts + 110 ED - + 100% % AutoSave OFF OFF ROSUE Customer a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments v 11 Calibrl (Body) ~ Al A X [G ab Wrap Text Number Insert v Y , v Delete Paste BIU 7 Av = = = Y Merge & Center Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter Sensitivity Format v Find & Select V C5 f 101 E G H I K M N o A S T U V W X Y Z AA 15614 1 Cust_Num Cust_Name AR_Balance Cust_Addr: Cus._city Cust_Posts Empl_Num Cus: Province 2 10000001 Hanson's F1,800,00 123 Ontari Sl Catherir L2R3KB 101 Ontario 3 100000DZ Great West 253.00 456 Main St. CatharirL2R2G7 101 Ontaria 4 20000003 Urban Cust 0.CO 2 Lake Stras Hamilton L4K 7H8 102 Ontario 5 1000000 NX Furnit101.00 188 Yong Toronto 103 Ontaris E 100cos Smart Cust 55.CO S6York Sir Taranto LSK2K7 104 Ontaria 7 1000CONG The Fumit 1,200.00 289 Lakesh St. CatharirL2R563 105 Ontario 8 10000007 Med Furnit 0.00 22B Glenric Sl Catherir L2S 4N1 102 Ontario 9 10000008 ACTIVE O.CO 5491 C. PH Niagara FalL2RXKD 102 Ontaria 10 1000000S AMELLA ISL 500.00 3391 S. F.E Kingston L2R 368 106 Ontaris 11 10000010 ANN FRANC 125.00 3149 W. H. Kingston L47H9 105 Ontario 12 10000011 AQUA BEAC a.co 14830 CAP Massaug: LSG 1F5 104 Ontaria 13 10000012 BARE NECE: 0.00 20751 FALI Mlaus LSK 29 102 Ontario 14 10000013 BEACH ROL 0.00 2820 NEW Hamilton L2R561 101 Ontario 15 10000014 BEACH MAS 2.CO 5297 GULF Hamilton LZS 4N2 103 Ontaria 16 10000015 BEACHSIDE 0.CO 234 FIRST S Toronto L2R 31 105 Ontario 17 10000016 BIRTHDAYS 600.00 1171 DUCH Whitby L2R 369 101 Ontaria 18 10000017 CANYON BE 2.000.co 2728 UNIO Whitby L4K 7H1 102 Ontaria 19 10000018 CLUB SPOR 59.00 28120 SW Toronto LSG 1F5 103 Ontario 20 10300019 OCCPER FIT 0.00 12100 PRE Mississaug: 15K2K9 105 Ontario 21 10000020 DIANE'S 145.00 2 18 MAIN! Guelph L2RSGS 103 Ontaria 22 10000021 DIANES 80.CO 920 AVUCA Kitchener L2S 4N3 103 Ontario 23 10000022 DIANES 60,00 705 MONT. Waterloo L2R3K1 103 Ontario 24 10000023 EVERYTHIN 200.CO 19501 BISC Taranto L2R 361 105 Ontaria 25 10000024 EVERYTHIN 0.CO 8500 BEVE Hamilton L4K 21 105 Ontario 26 10000025 EVERYTHIN 0.00 300 MONT Mississaug, 156 157 105 Ontario 27 10000026 EVERYTHIN 340.00 104 THE SH Toronto LSK 2K1 105 Ontario 28 10900027 EVERYTHIN 0.CO 6121 WEST Ottawa L2RSGO 105 Ontario 29 10000028 EVERYTHIN 0,00 10000 RES Peterborou L2S 1N4 105 Ontario 30 10000029 EVERYTHIN 654.00 23160 FAS Kitchener L2R3K2 105 Ontaria 31 10000030 EVERYTHIN 0.00 825 DULAN Wirdsor L2R 365 105 Ontario 32 10000031 EVERYTHIN 125.00 10300 LIT Whitby 14K7H3 105 Ontario 33 10000032 EVERYTHIN 540.00 20530 N. R Barrie LSG 178 105 Ontario 34 10000033 GREATSHA 432.CO 8025 JERIC Waterloo LSK 268 106 Ontario 35 10300034 ISLAND OU 20.00 12BW.BE/Kitchener L2R567 106 Ontario 36 10000035 ISLAND 570 a.co 24514 SPIC Hamilton L2S 4N5 106 Ontario 37 1000003G ISLAND STY 0.CO 782 QUIET Barne L2R 31 106 Ontario 38 10000037 JERRIESHO 3,550.00 290A SUNR SL CatherirL2R 362 104 Ontario 39 10000038 JUST KEEPS 9.CO 3413 CAPT Kitchener L43 7H3 104 Ontario 40 10000039 LINGERIELI 6,750.00 820 KENILV Peterborou LSG 1F9 104 Ontario 41 10000010 UZ FASHICI 254,00 3723 PHOE Barrie L5K2K3 104 Ontario 42 10000041 MEGS 452.CO 207 LASKI Niagara FalL2R568 102 Ontaria 43 10000042 NOMWD SU 0.CO 4655 N. OC Waterloo L2S 4N6 103 Ontario 44 10000043 NUBIA SWI 0.00 215 CAPITI Peleshoto 1234 101 Online Customer + # EP - + 100% % AutoSave OFF OFF ROSUE Customer a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibrl (Body) X [G v 11 ~ Al A ab Wrap Text Number Insert v Y , v Delete Paste BIU Av = = = Y Merge & Center v $ %) Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter # Format Find & Select Sensitivity V C5 f 101 I K M N P A S S T U W X Y Z AA B E F BUTULDUZ EVERYTHIN 1354.00 2516U FASKEche L232 31 10300030 EVERYTHIN 0.CO 825 DULAN Wirdsor L2R 365 32 10300031 EVERYTHIN 125.00 10300 LITT Whitby L4K2H3 33 10000032 EVERYTHIN 540.00 20530 N. R Barra LSG 1FR 34 10000033 GREAT SHA 452.CO 8025 JERIC Waterloo LSK 2K9 35 10300034 ISLAND OU 20.00 428 W. Be Kitchener L2R567 36 10000035 ISLAND SPC a.co 14514 SPIC Hamilton L2S 4N5 37 1000003G ISLAND STY 0.CO 782 QUIET Barrie L2R2K1 38 10900037 JERRIESHO 3,550.00 2904 SUNR St. CatharirL2R 362 39 10000038 JUST KEEPS 0.00 3413 CAP Kitchener 14K 7H3 40 10000039 LINGER ELI 6,750.CO 220 KENI LU Peterboro LSC 1F3 41 10000040 LZ FASHICI 254.00 3723 PHOE Barrie LSK 2K3 42 10000041 MEGS 462.00 307 LASKI Niagara FalL2RSGA 43 10000042 NOMAD SU 0.CO 4555 N. OC Waterloo L2S 4N5 44 10300043 NUDIA SWI 0.00 215 CAPITC Peterborou L2R 34 45 10000044 POSH ESSE O.CO 65R CENTR Ottawa L2R 361 46 20000045 RK'S SURFS 320.CO 233 16THE St. Catharir L4K 7H4 47 10000046 SEA GIRL 20.00 2054 NE 2 Kitchener LSG1F5 48 10000047 SOUTH MO 35.00 815 ALICEA Whitby LSK2K3 49 10000048 SPLASH SUI 0.CO 6509 5. TAI Barrie L2RSG9 50 10000049 SPLASH SUI 0.00 120 S. US 4 St. Catherir L2S 4N7 51 10000050 SPORTY LAC 210.00 4427 COM Kitchener L2R 35 52 10900051 STYLE IN 120.00 27 S.FORT Peterborou L2R 361 53 10300052 SUIT YOURS 0.00 1640 N.W. Ottawa LK 75 54 10000053 SWIM CITY 0.00 3170 GULF Hamilton LSG 1F2 55 10900054 SWIM MAR 365.CO 4223 5. TAI Waterloo LSK 2K1 56 10300055 SWIM MAR 210.00 1500 PLAC Kitchener L2R561 57 10000056 THE VENETI 180.CO 2325 W. Sl Whitby L2S 4NR 52 20000001 PETERSONI SOD.CO 5451 Vem Montreal H9, 2BL 59 20000010 EUROFUNI 0.00 235 Kirklar Montreal H9W 1K6 60 30000001 BAYFIELDF 0.00 78 Jones St Frederictor ESL 2F2 H 109 unta 105 Ontaria 105 Ontario 105 Ontaria 106 Ontario 106 Ontario 106 Ontaria 106 Ontario 104 Ontario 104 Ontaria 104 Ontario 104 Ontario 102 Ontaria 103 Ontario 101 Ontario 101 Ontaria 102 Ontario 103 Ontario 104 Ontaria 102 Ontario 101 Ontario 101 Ontaria 102 Ontario 103 Ontario 103 Ontaria 104 Ontario 104 Ontario 104 Ontaria 113 Quebec 114 Quebec 115 New Brunswick 62 63 G4 65 66 G7 68 69 70 71 72 73 Customer + - + 100% View Il ) 7% O Fri 4:00 PM a th che x + Excel File File Edit Insert Format Tools Data Window Help AutoSave CEF CE SUE Employees Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body 11 VA A = = = General C Paste BIU Share P Comments G Update Insert O Conditional Formatting Format e Table 1 Cell Styles 4 2 Delete Editing Ideas Sensitivity Farmatu !!! Sites Gurnaar CS fcKinney C G H K L M N Q R S LI V pr doing so. ain or lose credits. i Empl Num Empl First Empl Last Empl_DOS Empl SIN Commiszlo Position 2 101 Nex Phillips HWWM 4.11.08 0.1 Salesperson 102 Jason Hill HALA 5.12.08 0.12 Salespersan 4 103 Heather Raiborn Att 1.25E08 0.00 Sal person 5 104 Paul Kirney HW 5.42E+08 0 11 Salesperson 6 105 Rob Harrison HALA 2.15.08 0.1 Salespersen 106 Victor Thomas tutt 2.45E+09 tatt 0.09 Salesperson 107 Natalie Maines HWM 6.12.08 Accounts Payable 9 108 Emily Robinson HALA 5.45E08 a Accounts Payable 10 109 Rod Stewart tutt 3.25E+02 Cashier 11 110 Joe Walsh HW 6.39[08 Costier 111 Gary Allen A B.SSE 08 a Accounts Receivable 112 Taylor Swift Hut 6.48E+02 Accounts Receivable 14 | i10 Hy f| S 5 HAMN 5.46[*08 0.09 Salesperson 114 Jessica Phillips A 2.46108 0.1 Salespersen 115 Matthew Roberts Att 4.52E04 0.1 Salesperson 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Employees d in Phase I & II) 100% d. Which inventory type generated the most sales revenue? (Hint: you may create a query that includes all the information needed for the report, and then create a report based on that query. You may include graphs that may help you answer above questions your report.) 3. Based on your models and your understanding of the business, a) identify at least FOUR the threats or vulnerabilities of Brock Ltd.; b) describe the potential consequences of >> View Data Il Excel File File Edit Insert Format Tools AutoSave CEF CE SUE Home Insert Draw Page Layout Formulas Data Window Help Furniture Inventory 9 ) 7% Fri 4:00 PM a th the > AutoSave OFF OFF ROSUE Inventory_Purchases a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibrl (Body) v 11 ~ Al A et Wrap Text General Insert v Y , v Delete Pastc BIU Av = = = Y Merge & Center Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter Sensitivity Format v Find & Select V C5 fx 2 F G H I K M N o P A S T U V W X Y Z AA B E i Item_Num Pur_Order Actual_Pur Actual_Pur_Price 2 1001 100058 5 5 1.186.19 3 2001 100055 5 1,486,49 4 2001 100076 2 1,486.49 5 1002 100060 2 891.15 2002 100057 2 2 891.15 7 2002 100080 2 991.15 A 1003 100058 2 216.21 2003 100066 2 216.21 10 2003 100077 2 216.21 11 1003 100084 2 216.21 12 2002 100053 214.05 13 2002 100067 2 214.05 14 2002 100080 2 2 211.05 15 3001 100071 2 1,114.86 2 16 3001 100081 2 1.114.86 17 3002 100071 2 2 891.89 12 3002 100081 891.89 19 3002 100085 2 991.99 20 3003 100062 2 1,189.19 21 3003 100074 2 1,189.19 22 2004 100071 2 1.635.14 23 3005 100063 2 1,200.00 24 4001 100065 2 817.57 25 4001 100075 2 917.57 26 1001 100084 2 817.57 27 4002 100065 2 1,180.27 2 28 4002 100075 2 1.120.27 29 4002 100077 2 1,180,27 30 4002 100084 2 1,180.27 31 6001 100059 260.14 32 6001 100070 5 260.14 33 4093 10085 550 10.00 34 2002 1000 214 5.00 35 36 37 38 39 40 41 42 44 Inventory Purchases + # B - + 100% AutoSave OFF OFF ROSUE Inventory_Sale a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibrl (Body) v 11 ~ Al A et Wrap Text Number Insert v Y , v Delete Paste v Y BIU Av = = = Merge & Center Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter Sensitivity Format v Find & Select V C5 fx 2000 E F G H I K M N o P A S T U V W X Y Z AA 20 i Item_Num Salc_lnv_N Actual_Sale Actual Sale_uty 2 1001 10001 2,200.00 1 3 2001 10018 2,200.00 1 4 2001 10021 2,200.CO 2 5 1001 10034 2.000.co 5 2002 10007 1,200.CO 2 7 2002 10011 1,250.00 4 8 13 1002 10013 1,318.30 1 9 2002 10023 1,218.00 2 10 2002 10034 1,319.00 6 11 1003 10015 319.99 1 12 2003 10024 3119.59 2 13 2002 100OZ 216.80 6 14 2002 10009 300.00 6 15 2002 10018 315.80 E 16 2002 10035 300.00 17 1000 2004 10002 1,758.50 1 1 12 2004 1000 1,500.00 1 19 2004 10019 1,759.90 1 2004 10035 1,750.00 1 1 21 3001 10005 1.650.00 1 22 2001 10012 1.650.00 1 3001 10017 1.650.00 1 24 3001 10028 1,650.00 1 1 25 3001 10030 1,000.00 3 26 3002 10003 1,220.00 1 1 27 3002 10012 1,320.00 1 28 3002 10019 1,320.00 1 29 3002 10022 1,320.00 1 30 3003 10004 1,700.00 1 3 2003 10029 1,760.00 1 32 3003 10025 1,760,00 1 33 3004 10004 2,200.00 1 34 2004 1000g 1,690.CO 1 35 3004 10009 2,200.00 1 36 3004 10025 2,420.00 1 37 2004 10029 2,420.00 1 38 3005 10005 1.559.99 1 39 2005 10010 1.500.CO 1 40 3005 10016 1,559.99 1 41 3005 10027 1,559.99 1 2006 10032 120.00 5 43 2006 10036 150.CO 44 3007 10033 70.00 8 Inventory Sale + 23 # EP - + 100% % AutoSave OFF OFF ROSUE Inventory_Sale a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibrl (Body) X [G v A A v 11 Insert v Number et Wrap Text Y , v Delete Paste B I U Av Y = = = Merge & Center v Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter Sensitivity Format v Find & Select V C5 fx 2000 E F G . I M N o P A S S T U W X Y Z AA 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 3002 3002 3002 3003 3003 3003 3004 3004 3004 3004 3004 3005 3005 2005 3005 300G 3006 3007 4001 4001 4001 4002 4002 4002 4002 4003 4004 400S 5001 5001 6001 B 10012 1.320.00 10019 1.320.00 10022 1,320.00 10004 1,700.CO 10029 1,760.00 10025 1,760.00 10004 2,200.00 10008 1.650.00 10009 2,200.00 10025 2,420.00 10028 2.420.00 10005 1,559.99 10010 1,500.CO 10016 1,559.99 10027 1,559.99 10032 120.00 10036 150.00 10033 70.00 10015 1,210.00 10019 1.210.00 10029 1,210.00 10009 1,600.CO 10020 1,746.80 10025 1,745.80 10028 1,745.20 10030 830.00 1000 50.00 10031 300.00 10006 880.00 10013 88.00 10014 385.CO 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 5 5 & 1 1 1 1 1 1 1 2 5 1 1 1 44 45 46 47 49 49 50 52 52 53 54 55 56 57 58 59 GO 61 62 2 64 65 G6 67 68 G9 Inventory Sale + # EP - + 100% AutoSave OFF OFF ROSUE Purchases a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibrl (Body) v 11 ~ Al A ab Wrap Text General X [G Insert v Y , v Delete Paste BIU Av = = = Y Merge & Center $ Ideas Conditional Format Cell Formatting es Table Styles - Sensitivity Sort & Filter Format v Find & Select V C5 . I K M N o P A S T U V W X Z AA G Pur_Order. Pur_Dac Pur_DescriPur_Amour Ven_Num CD_Num Empl_Num 2 10086 AHAWA 6,570.25 600003 107 3 10005S ATAU Phone and 256.80 690014 3 108 4 100057 notte Hydro 520.00 600015 4 107 5 100058 ALWAY AL 7,864.85 600002 1 1 108 100059 ATAU 1,300.68 600001 2 107 7 1000GD 2.210.41 G00003 6 108 8 100051 AUW Utilities 375.86 600015 5 108 100052 AM 2,378.38 500005 7 108 10 100063 2.400.00 600009 8 108 11 100051 AWAY Phoneard 256.00 600014 9 107 12 100055 Hydro 50.00 600015 10 107 13 100OGG 21.860.53 G00002 11 107 14 100067 ARALAY 2.210.11 600003 12 108 15 100058 A Phone and 256.80 600014 107 16 100069 H Hydro 570.00 600015 107 17 100070 AAAA 1,300,68 600001 15 107 12 100071 AU 7,283.78 600004 16 108 19 100072 in Phoneard 256.80 600014 27 108 20 100073 A Hydro 550,00 600015 18 108 21 100074 2,378.38 630005 19 107 22 100075 ne 3,995.68 G00002 20 108 23 100076 ARAU 2,972.97 600002 20 107 24 100077 A 2,792.96 600002 21 107 25 100079 Tit Phoneard 286.32 600014 22 108 26 100079 A Hydro 525.00 23 23 108 27 1000RO A 2,210.41 600003 24 107 22 100091 4.013.51 600004 25 107 29 100002 AALAY Phoneard 278.56 600014 26 108 30 100083 A Hydro 586.00 600015 27 108 31 100034 Att 4,428.09 G00002 28 107 32 100085 AM 1,783.78 630004 108 33 34 35 36 37 38 39 40 41 42 600015 44 Purchases + # EP - + 100% % AutoSave OFF OFF A SUE Sales_Cash_Receipt a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 11 X [G ~ Al A et Wrap Text Insert v Number Y , v Delete Paste BIU 7 Av Y = = = Merge & Center v Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter Sensitivity Format v Find & Select V C5 fx 609.95 E F G H I K M N o P A S S T U V W X Y Z AA 10000 1 Sale_Inv_N CR_Num Amount Applied 2 10001 100002 2,200.00 3 10002 100003 609.95 4 10002 100019 5 10002 609.95 10002 100025 AORE 100031 609.55 7 10003 100004 1,220.00 8 10004 100005 3.500.00 1000S 100005 1,559.19 10 10006 100007 2,530.00 11 10007 100C0B 2.600.00 12 10008 100009 1,650.00 13 1000S 101010 1,283.33 14 10009 100015 1,183.33 15 10009 100019 1,183.33 16 10009 100027 1,283.33 17 10009 100032 1,183.33 12 10010 100011 1,500.00 19 10011 100012 5,000.CO 20 10012 100013 2,970.00 21 10013 100014 609.55 22 10014 100023 770.00 23 10015 100016 319.99 24 10016 100017 2,769.99 25 10017 100020 1,650.00 26 10018 100021 5,859.70 27 10019 100022 2,530.00 22 10020 100024 3,300.00 29 10021 100 100025 1,100.00 30 10022 100028 1,320.00 10023 100036 2,637.20 32 10024 100029 639.98 33 10025 100030 2,423.co 34 10026 100033 3,500.00 35 10027 100034 1,559.99 36 10028 100035 5.215.20 37 10029 100037 1,210.00 38 10030 10003B 1.810,00 39 10002 100039 588.CO 40 10033100040 560.CO 41 42 44 Sales Cash Receipt + + # B - + 100% % AutoSave OFF OFF ROSUE 2 Sales a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibrl (Body) v 11 ~ Al A ab Wrap Text Number Insert v Y , v Delete Paste B IV. v Y Av = = = Merge & Center v Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter Sensitivity Format v Find & Select V C5 fx 3900 F G H I K M N o P A S T U V W X Y Z AA B i Sale_Inv_N Salc_Date Sale Amou Cust_Num Empl_Num 2 10001 AHLAWAN 2,200.00 10000001 102 3 10002 3,659.70 10000020 203 4 10009 Ant 1,220.CO 20000004 203 5 10004 AHLAWAN 3,500.col 10000007 102 10005 A 1,555.19 1000000 104 7 1000G A 2,530.00 30000023 205 8 10007 AWAY 2.600,00 10000009 106 10008 A 1,650.00 20000003 102 10 10009 Attitutit 7,200.00 20000026 205 11 10010 AHWAY 1,500.00 10000017 102 12 10011 A 5,000.co 20000010 205 13 10012 Athitit 2,970.00 20000028 205 14 10013 AHWAY 2.198.30 10000030 105 15 10014 A 770.CO 10000016 201 16 10015 319.99 20000019 205 17 10016 AALA 2,769.99 10000001 101 12 10017 A 1,650.00 20000014 203 19 10018 Attitutit 5,859.70 20000016 201 20 10019 AHLAWAN 2,530.00 10000003 102 21 10020 A 3,505.20 20000016 201 22 10021 Attitutit 4,400.00 20000023 205 23 10022 ALAU 1,320,00 10000010 101 24 10023 2.637.20 20000042 203 25 10024 639.98 2000000G 205 100 26 anno 10025 AWAY 2.120.00 10000013 101 27 10026 A 3,505.80 20000017 202 22 10027 hitit 1,559.99 20000003 202 29 10028 AWALAN 5,816.80 10000009 106 30 10029 A 1,210.00 30000017 202 10030 A 1,910.00 20000001 213 32 10031 AHAHAHA 300,00 10000050 101 33 10032 A 600.CO 20000010 214 34 10033 titi 560.CO 30000001 213 35 10034 AHLAWAN 17,SOB.CO 10000023 105 36 10035 A 4,150.00 20000015 205 37 10036 hittit 5,550.00 30000001 215 38 39 40 41 42 44 Sales + # EP - + 100% % View 0) 6% Fri 4:01 PM QE a Excel File File Edit Insert Format Tools Data Window Help AutoSave CEF CE SUE Vendor Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Bodyl v 11 w = = = VA A General th Che X + + Share P Comments G Update Insert O Conditional Formatting Format e Table 1 Cell Styles 4 2 Delete Paste BIU Editing Ideas Sensitivity Farmatu 4 !!! Sites Gurnaar CS x fx 214 Fairview Rd. A F G H H K L M N Q R S LI V or doing so. ain or lose credits. 1 Van Num Ven_Name Ven Addre Ven City Ven_Provir AP Balance 2 600001 EroupeanF 2546 Mein Hamilton Ontariu 0.00 600002 Casalife Fut 154 Lakepe Halifax Nova Scoti. 2.557.00 4 GOO003 Toronto Fu 54 Warda Toronto Ortaria 244.00 5 600004 Furniture 214 Feirvis Winnipeg Meritoba 678.00 ECONOS Custom Fur 312 Dunda Mississaug: Ontario 2.153.00 7 GCODOG Great Furni 5297 GULF Vancouver British Coll G.500.00 600007 Best Furnit 234 FIRSTS Vancouver British Coli 3,584.00 6C0008 Logacy Fur: 1171 DUCE Winnipeg Manitoba 2.540.00 10 GOODOS Halifax Fun 1729 UNIO Halifax Nova Scoli 253.00 11 600010 East Furnit 18120 SW St. John New Drury 5,640.00 600011 Unique Fur 12100 PRE Edmonton Aberta 8.650.00 GOO012 Mary's Anti 78 Gateway Kitchener Ontario 2,100.00 14 600013 Metro Hdi 123 Bloor Toronto Criariu 45600 15 600014 Rogers con 5785 South Mississaug: Ontario 0.00 16 GC0015 Receiver 1050 Notre Sudbury Ontario 0.00 17 600016 Reliance 830 Harrin Burlington Crtario 0.00 18 600017 Uniq Furni 125 Lagan St. Cacharir Ontario 200.00 19 0.00 GC0018 Adam Smit 56 Uptown Hamilton Cratarlo 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Vendor d in Phase & II) 100% >> d. Which inventory type generated the most sales revenue? (Hint: you may create a query that includes all the information needed for the report, and then create a report based on that query. You may include graphs that may help you answer above questions your report.) 3. Based on your models and your understanding of the business, a) identify at least FOUR the threats or vulnerabilities of Brock Ltd.; b) describe the potential consequences of x AutoSave OFF OFF ROSUE Bank Account a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibrl (Body) v 11 ~ Al A et Wrap Text Number Insert v Y , v Delete Paste BIU v Av = = = Merge & Center v Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter Format v Find & Select Sensitivity V C5 fx 20000 c E G H I K M N o P A S T U V W X Y Z AA 1 Bank_Act Bank_Nami Bank_Balar Bank_Type Bank_Location 2 1001 TD 5,000.00 Chequine TD-Downtown St. Catharines 3 2002 TD A Savings TD Downtown St. Catharins 4 2003 Scotia 5.000.CO Chequing Scotia Bank Downtown Toronto 5 1004 Scotia 20,000.COISavines Scotia Benk - Downtown Toronto 2005 EMO 20.000.CO Cheguing AMD North York, Taranto 7 200G MO 14,958.CO Savings - USUMO - North York, Toronto 8 1007 Scotia 0.00 Chequine - Setia Bank - Downtown Toronto 2008 CIBC son.co Chequing CIBC Downtown Taranto 10 11 12 13 14 15 16 17 12 19 20 21 22 23 24 25 26 27 22 29 30 31 32 33 34 35 36 37 38 39 40 41 42 44 Bank Account + # EP - + 100% % AutoSave OFF OFF A SUE Cash Disbursements a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibrl (Body) v 11 ~ Al A eh Wrap Text Number Insert v Y , v Delete Paste BIU Av = = = Y Merge & Center Ideas Conditional Format Cell Formatting es Table Styles - Sensitivity Sort & Filter Format v Find & Select V C5 f520 H I K M N o P A S T U V W X Y Z AA G G 1 CD_Num CD_Date CD Amoun Ven_Num Empl_Nur Bank Acct_Num 2 1 AWAY 7,707.55 500002 109 1003 3 2 1,274.67 500001 109 1003 4 3 Attitute 256.20 tee G00014 209 1001 5 4 AHAHALAM 520.00 600015 109 1001 E SAU 375.26 500016 109 1003 7 GA 2,166.20 LUO003 209 1001 400 87 AMALAN 2,330.81 500005 109 1003 8 AA 2,252.CO 500008 109 1001 10 9 9 tttttt 256.80 G00014 210 1003 11 10 AHHAHAY W 560.00 600015 110 1001 12 11 R 11,623.32 600002 111 1001 13 12 hitt 2,266.20 LUO003 209 1001 14 13 AWAY 256.80 600011 110 1003 15 14 A 570.00 500015 110 1003 16 15 A 1,274.67 G00001 209 1001 17 2001 16 AMALA 7,138.10 500004 111 1001 18 17 A 255.80 500014 109 1003 19 18 550.00 G00015 210 1001 20 19 AHLAWAY 2,330.81 500005 109 1003 21 20 ALAM 6,829.28 500002 109 1003 22 21 in 2,737.10 GOOOD2 209 1001 2. 23 22 AM 286.32 500014 110 1003 24 23 525.00 500015 209 1001 25 24 Autite 2,100.20 LUO003 211 1001 25 26 25 ALALAY 3,933.24 500004 110 1001 27 26 A 278.56 600014 109 1001 22 27 586.CO 600015 211 1003 29 A. 28 AHAHALAW 4,339.53 500002 111 1003 30 29 A 1,748.10 500004 109 1003 31 32 33 34 35 36 37 38 39 40 41 42 44 Cash Disbursements + # EP - + 100% % AutoSave OFF OFF ROSUE Cash_Receipts a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments v 11 Calibrl (Body) X [G ~ Al A ab Wrap Text Number Insert v Y , v Delete Paste Av = = = Y Merge & Center Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter # Format Find & Select Sensitivity BIU f 1559.99 V C6 H . K L M N o 5 T U V W X Y 1100011 D F 1 1 CR_Num CR Date CR Amount Bank Act Num CustNum Empl Num 2 100002 2019-01-02 2,200.00 1001 10000001 110 3 100003 2019-01-02 509.95 1003 20000920 111 4 100004 2019-01-05 1,220.00 1001 10000004 110 5100005 2019-01-05 3.990 00 1001 10000307 110 10000e 2019-011211,559.99 1003 1000OODS 110 7 100007 2019-01-16 2.530.00 1001 10000023 111 A 100308 2019-01-22 2.800.00 1001 1000000 110 100009 2019-01-31 1,550.00 1001 10000003 111 10 100010 2019-02-03 1,193.33 1003 10000020 110 100011 2019-02-09 1,500.00 1003 10000017 111 12 100012 2019-02-11 5,000.00 1001 10000310 110 13 100013 2019-02-24 2,970.00 1003 10000028 110 14 100011 2019-02-28 609 95 1001 10000030 110 15 100018 2019 0228 1,182.33 1003 10000026 111 16 100016 2019-03-17 319.99 1003 10000019 111 17 100017 2019-03-25 2,769 99 1001 10000001 110 12 100018 2019 03 31 509.95 1003 10000320 110 19 100019 2019-03-21 1,193.33 1001 10000020 110 20 100320 100020 2019-04-01 1,550 00 1001 10000014 110 21 10002: 2019-04 OS 5.859.70 1003 10000316 111 22 100022 2019-04-11 2,530.00 1001 10000003 110 23 100323 2019-04-15 77000 1003 10000016 110 24 100924 2019-04 19 3,506.80 1001 10000016 111 25 100025 2019-04-23 4,400.00 1001 10000023 110 26 100026 100326 2019-04-30 609 95 1003 10000020 110 27 100927 2019-0430 1,182.33 1001 10000026 111 24 100028 2019-05-01 1,320.00 1003 20000340 110 29 100020 100328 2019-05-13 639 98 1001 10000006 110 30 100030 2019-05 28 2.420.00 1001 10000013 111 31 100031 2019-05-32 609.95 1003 10000020 111 32 100032 2019-05-31 1,183 33 1001 10000326 110 33 100033 2019-05-02 3,506.30 1003 10000017 34 100034 2019-03-10 1,559.99 1001 10000003 110 35 100335 2019-05-12 5,816 80 1003 1000000 110 36 100036 2019-05-15 2,537.80 1003 10000042 111 37 100037 2019-06-20 1,210.00 1001 10000017 110 38 100038 2019-07-10 1,910 00 1001 20000301 109 39 100039 2019-08-13 588.00 1003 20000010 111 40 100040 2019-09-10 SG0.00 1001 30000002 111 41 42 43 44 Cash Receipts + 110 ED - + 100% % AutoSave OFF OFF ROSUE Customer a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments v 11 Calibrl (Body) ~ Al A X [G ab Wrap Text Number Insert v Y , v Delete Paste BIU 7 Av = = = Y Merge & Center Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter Sensitivity Format v Find & Select V C5 f 101 E G H I K M N o A S T U V W X Y Z AA 15614 1 Cust_Num Cust_Name AR_Balance Cust_Addr: Cus._city Cust_Posts Empl_Num Cus: Province 2 10000001 Hanson's F1,800,00 123 Ontari Sl Catherir L2R3KB 101 Ontario 3 100000DZ Great West 253.00 456 Main St. CatharirL2R2G7 101 Ontaria 4 20000003 Urban Cust 0.CO 2 Lake Stras Hamilton L4K 7H8 102 Ontario 5 1000000 NX Furnit101.00 188 Yong Toronto 103 Ontaris E 100cos Smart Cust 55.CO S6York Sir Taranto LSK2K7 104 Ontaria 7 1000CONG The Fumit 1,200.00 289 Lakesh St. CatharirL2R563 105 Ontario 8 10000007 Med Furnit 0.00 22B Glenric Sl Catherir L2S 4N1 102 Ontario 9 10000008 ACTIVE O.CO 5491 C. PH Niagara FalL2RXKD 102 Ontaria 10 1000000S AMELLA ISL 500.00 3391 S. F.E Kingston L2R 368 106 Ontaris 11 10000010 ANN FRANC 125.00 3149 W. H. Kingston L47H9 105 Ontario 12 10000011 AQUA BEAC a.co 14830 CAP Massaug: LSG 1F5 104 Ontaria 13 10000012 BARE NECE: 0.00 20751 FALI Mlaus LSK 29 102 Ontario 14 10000013 BEACH ROL 0.00 2820 NEW Hamilton L2R561 101 Ontario 15 10000014 BEACH MAS 2.CO 5297 GULF Hamilton LZS 4N2 103 Ontaria 16 10000015 BEACHSIDE 0.CO 234 FIRST S Toronto L2R 31 105 Ontario 17 10000016 BIRTHDAYS 600.00 1171 DUCH Whitby L2R 369 101 Ontaria 18 10000017 CANYON BE 2.000.co 2728 UNIO Whitby L4K 7H1 102 Ontaria 19 10000018 CLUB SPOR 59.00 28120 SW Toronto LSG 1F5 103 Ontario 20 10300019 OCCPER FIT 0.00 12100 PRE Mississaug: 15K2K9 105 Ontario 21 10000020 DIANE'S 145.00 2 18 MAIN! Guelph L2RSGS 103 Ontaria 22 10000021 DIANES 80.CO 920 AVUCA Kitchener L2S 4N3 103 Ontario 23 10000022 DIANES 60,00 705 MONT. Waterloo L2R3K1 103 Ontario 24 10000023 EVERYTHIN 200.CO 19501 BISC Taranto L2R 361 105 Ontaria 25 10000024 EVERYTHIN 0.CO 8500 BEVE Hamilton L4K 21 105 Ontario 26 10000025 EVERYTHIN 0.00 300 MONT Mississaug, 156 157 105 Ontario 27 10000026 EVERYTHIN 340.00 104 THE SH Toronto LSK 2K1 105 Ontario 28 10900027 EVERYTHIN 0.CO 6121 WEST Ottawa L2RSGO 105 Ontario 29 10000028 EVERYTHIN 0,00 10000 RES Peterborou L2S 1N4 105 Ontario 30 10000029 EVERYTHIN 654.00 23160 FAS Kitchener L2R3K2 105 Ontaria 31 10000030 EVERYTHIN 0.00 825 DULAN Wirdsor L2R 365 105 Ontario 32 10000031 EVERYTHIN 125.00 10300 LIT Whitby 14K7H3 105 Ontario 33 10000032 EVERYTHIN 540.00 20530 N. R Barrie LSG 178 105 Ontario 34 10000033 GREATSHA 432.CO 8025 JERIC Waterloo LSK 268 106 Ontario 35 10300034 ISLAND OU 20.00 12BW.BE/Kitchener L2R567 106 Ontario 36 10000035 ISLAND 570 a.co 24514 SPIC Hamilton L2S 4N5 106 Ontario 37 1000003G ISLAND STY 0.CO 782 QUIET Barne L2R 31 106 Ontario 38 10000037 JERRIESHO 3,550.00 290A SUNR SL CatherirL2R 362 104 Ontario 39 10000038 JUST KEEPS 9.CO 3413 CAPT Kitchener L43 7H3 104 Ontario 40 10000039 LINGERIELI 6,750.00 820 KENILV Peterborou LSG 1F9 104 Ontario 41 10000010 UZ FASHICI 254,00 3723 PHOE Barrie L5K2K3 104 Ontario 42 10000041 MEGS 452.CO 207 LASKI Niagara FalL2R568 102 Ontaria 43 10000042 NOMWD SU 0.CO 4655 N. OC Waterloo L2S 4N6 103 Ontario 44 10000043 NUBIA SWI 0.00 215 CAPITI Peleshoto 1234 101 Online Customer + # EP - + 100% % AutoSave OFF OFF ROSUE Customer a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibrl (Body) X [G v 11 ~ Al A ab Wrap Text Number Insert v Y , v Delete Paste BIU Av = = = Y Merge & Center v $ %) Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter # Format Find & Select Sensitivity V C5 f 101 I K M N P A S S T U W X Y Z AA B E F BUTULDUZ EVERYTHIN 1354.00 2516U FASKEche L232 31 10300030 EVERYTHIN 0.CO 825 DULAN Wirdsor L2R 365 32 10300031 EVERYTHIN 125.00 10300 LITT Whitby L4K2H3 33 10000032 EVERYTHIN 540.00 20530 N. R Barra LSG 1FR 34 10000033 GREAT SHA 452.CO 8025 JERIC Waterloo LSK 2K9 35 10300034 ISLAND OU 20.00 428 W. Be Kitchener L2R567 36 10000035 ISLAND SPC a.co 14514 SPIC Hamilton L2S 4N5 37 1000003G ISLAND STY 0.CO 782 QUIET Barrie L2R2K1 38 10900037 JERRIESHO 3,550.00 2904 SUNR St. CatharirL2R 362 39 10000038 JUST KEEPS 0.00 3413 CAP Kitchener 14K 7H3 40 10000039 LINGER ELI 6,750.CO 220 KENI LU Peterboro LSC 1F3 41 10000040 LZ FASHICI 254.00 3723 PHOE Barrie LSK 2K3 42 10000041 MEGS 462.00 307 LASKI Niagara FalL2RSGA 43 10000042 NOMAD SU 0.CO 4555 N. OC Waterloo L2S 4N5 44 10300043 NUDIA SWI 0.00 215 CAPITC Peterborou L2R 34 45 10000044 POSH ESSE O.CO 65R CENTR Ottawa L2R 361 46 20000045 RK'S SURFS 320.CO 233 16THE St. Catharir L4K 7H4 47 10000046 SEA GIRL 20.00 2054 NE 2 Kitchener LSG1F5 48 10000047 SOUTH MO 35.00 815 ALICEA Whitby LSK2K3 49 10000048 SPLASH SUI 0.CO 6509 5. TAI Barrie L2RSG9 50 10000049 SPLASH SUI 0.00 120 S. US 4 St. Catherir L2S 4N7 51 10000050 SPORTY LAC 210.00 4427 COM Kitchener L2R 35 52 10900051 STYLE IN 120.00 27 S.FORT Peterborou L2R 361 53 10300052 SUIT YOURS 0.00 1640 N.W. Ottawa LK 75 54 10000053 SWIM CITY 0.00 3170 GULF Hamilton LSG 1F2 55 10900054 SWIM MAR 365.CO 4223 5. TAI Waterloo LSK 2K1 56 10300055 SWIM MAR 210.00 1500 PLAC Kitchener L2R561 57 10000056 THE VENETI 180.CO 2325 W. Sl Whitby L2S 4NR 52 20000001 PETERSONI SOD.CO 5451 Vem Montreal H9, 2BL 59 20000010 EUROFUNI 0.00 235 Kirklar Montreal H9W 1K6 60 30000001 BAYFIELDF 0.00 78 Jones St Frederictor ESL 2F2 H 109 unta 105 Ontaria 105 Ontario 105 Ontaria 106 Ontario 106 Ontario 106 Ontaria 106 Ontario 104 Ontario 104 Ontaria 104 Ontario 104 Ontario 102 Ontaria 103 Ontario 101 Ontario 101 Ontaria 102 Ontario 103 Ontario 104 Ontaria 102 Ontario 101 Ontario 101 Ontaria 102 Ontario 103 Ontario 103 Ontaria 104 Ontario 104 Ontario 104 Ontaria 113 Quebec 114 Quebec 115 New Brunswick 62 63 G4 65 66 G7 68 69 70 71 72 73 Customer + - + 100% View Il ) 7% O Fri 4:00 PM a th che x + Excel File File Edit Insert Format Tools Data Window Help AutoSave CEF CE SUE Employees Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Body 11 VA A = = = General C Paste BIU Share P Comments G Update Insert O Conditional Formatting Format e Table 1 Cell Styles 4 2 Delete Editing Ideas Sensitivity Farmatu !!! Sites Gurnaar CS fcKinney C G H K L M N Q R S LI V pr doing so. ain or lose credits. i Empl Num Empl First Empl Last Empl_DOS Empl SIN Commiszlo Position 2 101 Nex Phillips HWWM 4.11.08 0.1 Salesperson 102 Jason Hill HALA 5.12.08 0.12 Salespersan 4 103 Heather Raiborn Att 1.25E08 0.00 Sal person 5 104 Paul Kirney HW 5.42E+08 0 11 Salesperson 6 105 Rob Harrison HALA 2.15.08 0.1 Salespersen 106 Victor Thomas tutt 2.45E+09 tatt 0.09 Salesperson 107 Natalie Maines HWM 6.12.08 Accounts Payable 9 108 Emily Robinson HALA 5.45E08 a Accounts Payable 10 109 Rod Stewart tutt 3.25E+02 Cashier 11 110 Joe Walsh HW 6.39[08 Costier 111 Gary Allen A B.SSE 08 a Accounts Receivable 112 Taylor Swift Hut 6.48E+02 Accounts Receivable 14 | i10 Hy f| S 5 HAMN 5.46[*08 0.09 Salesperson 114 Jessica Phillips A 2.46108 0.1 Salespersen 115 Matthew Roberts Att 4.52E04 0.1 Salesperson 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Employees d in Phase I & II) 100% d. Which inventory type generated the most sales revenue? (Hint: you may create a query that includes all the information needed for the report, and then create a report based on that query. You may include graphs that may help you answer above questions your report.) 3. Based on your models and your understanding of the business, a) identify at least FOUR the threats or vulnerabilities of Brock Ltd.; b) describe the potential consequences of >> View Data Il Excel File File Edit Insert Format Tools AutoSave CEF CE SUE Home Insert Draw Page Layout Formulas Data Window Help Furniture Inventory 9 ) 7% Fri 4:00 PM a th the > AutoSave OFF OFF ROSUE Inventory_Purchases a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibrl (Body) v 11 ~ Al A et Wrap Text General Insert v Y , v Delete Pastc BIU Av = = = Y Merge & Center Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter Sensitivity Format v Find & Select V C5 fx 2 F G H I K M N o P A S T U V W X Y Z AA B E i Item_Num Pur_Order Actual_Pur Actual_Pur_Price 2 1001 100058 5 5 1.186.19 3 2001 100055 5 1,486,49 4 2001 100076 2 1,486.49 5 1002 100060 2 891.15 2002 100057 2 2 891.15 7 2002 100080 2 991.15 A 1003 100058 2 216.21 2003 100066 2 216.21 10 2003 100077 2 216.21 11 1003 100084 2 216.21 12 2002 100053 214.05 13 2002 100067 2 214.05 14 2002 100080 2 2 211.05 15 3001 100071 2 1,114.86 2 16 3001 100081 2 1.114.86 17 3002 100071 2 2 891.89 12 3002 100081 891.89 19 3002 100085 2 991.99 20 3003 100062 2 1,189.19 21 3003 100074 2 1,189.19 22 2004 100071 2 1.635.14 23 3005 100063 2 1,200.00 24 4001 100065 2 817.57 25 4001 100075 2 917.57 26 1001 100084 2 817.57 27 4002 100065 2 1,180.27 2 28 4002 100075 2 1.120.27 29 4002 100077 2 1,180,27 30 4002 100084 2 1,180.27 31 6001 100059 260.14 32 6001 100070 5 260.14 33 4093 10085 550 10.00 34 2002 1000 214 5.00 35 36 37 38 39 40 41 42 44 Inventory Purchases + # B - + 100% AutoSave OFF OFF ROSUE Inventory_Sale a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibrl (Body) v 11 ~ Al A et Wrap Text Number Insert v Y , v Delete Paste v Y BIU Av = = = Merge & Center Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter Sensitivity Format v Find & Select V C5 fx 2000 E F G H I K M N o P A S T U V W X Y Z AA 20 i Item_Num Salc_lnv_N Actual_Sale Actual Sale_uty 2 1001 10001 2,200.00 1 3 2001 10018 2,200.00 1 4 2001 10021 2,200.CO 2 5 1001 10034 2.000.co 5 2002 10007 1,200.CO 2 7 2002 10011 1,250.00 4 8 13 1002 10013 1,318.30 1 9 2002 10023 1,218.00 2 10 2002 10034 1,319.00 6 11 1003 10015 319.99 1 12 2003 10024 3119.59 2 13 2002 100OZ 216.80 6 14 2002 10009 300.00 6 15 2002 10018 315.80 E 16 2002 10035 300.00 17 1000 2004 10002 1,758.50 1 1 12 2004 1000 1,500.00 1 19 2004 10019 1,759.90 1 2004 10035 1,750.00 1 1 21 3001 10005 1.650.00 1 22 2001 10012 1.650.00 1 3001 10017 1.650.00 1 24 3001 10028 1,650.00 1 1 25 3001 10030 1,000.00 3 26 3002 10003 1,220.00 1 1 27 3002 10012 1,320.00 1 28 3002 10019 1,320.00 1 29 3002 10022 1,320.00 1 30 3003 10004 1,700.00 1 3 2003 10029 1,760.00 1 32 3003 10025 1,760,00 1 33 3004 10004 2,200.00 1 34 2004 1000g 1,690.CO 1 35 3004 10009 2,200.00 1 36 3004 10025 2,420.00 1 37 2004 10029 2,420.00 1 38 3005 10005 1.559.99 1 39 2005 10010 1.500.CO 1 40 3005 10016 1,559.99 1 41 3005 10027 1,559.99 1 2006 10032 120.00 5 43 2006 10036 150.CO 44 3007 10033 70.00 8 Inventory Sale + 23 # EP - + 100% % AutoSave OFF OFF ROSUE Inventory_Sale a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibrl (Body) X [G v A A v 11 Insert v Number et Wrap Text Y , v Delete Paste B I U Av Y = = = Merge & Center v Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter Sensitivity Format v Find & Select V C5 fx 2000 E F G . I M N o P A S S T U W X Y Z AA 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 3002 3002 3002 3003 3003 3003 3004 3004 3004 3004 3004 3005 3005 2005 3005 300G 3006 3007 4001 4001 4001 4002 4002 4002 4002 4003 4004 400S 5001 5001 6001 B 10012 1.320.00 10019 1.320.00 10022 1,320.00 10004 1,700.CO 10029 1,760.00 10025 1,760.00 10004 2,200.00 10008 1.650.00 10009 2,200.00 10025 2,420.00 10028 2.420.00 10005 1,559.99 10010 1,500.CO 10016 1,559.99 10027 1,559.99 10032 120.00 10036 150.00 10033 70.00 10015 1,210.00 10019 1.210.00 10029 1,210.00 10009 1,600.CO 10020 1,746.80 10025 1,745.80 10028 1,745.20 10030 830.00 1000 50.00 10031 300.00 10006 880.00 10013 88.00 10014 385.CO 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 5 5 & 1 1 1 1 1 1 1 2 5 1 1 1 44 45 46 47 49 49 50 52 52 53 54 55 56 57 58 59 GO 61 62 2 64 65 G6 67 68 G9 Inventory Sale + # EP - + 100% AutoSave OFF OFF ROSUE Purchases a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibrl (Body) v 11 ~ Al A ab Wrap Text General X [G Insert v Y , v Delete Paste BIU Av = = = Y Merge & Center $ Ideas Conditional Format Cell Formatting es Table Styles - Sensitivity Sort & Filter Format v Find & Select V C5 . I K M N o P A S T U V W X Z AA G Pur_Order. Pur_Dac Pur_DescriPur_Amour Ven_Num CD_Num Empl_Num 2 10086 AHAWA 6,570.25 600003 107 3 10005S ATAU Phone and 256.80 690014 3 108 4 100057 notte Hydro 520.00 600015 4 107 5 100058 ALWAY AL 7,864.85 600002 1 1 108 100059 ATAU 1,300.68 600001 2 107 7 1000GD 2.210.41 G00003 6 108 8 100051 AUW Utilities 375.86 600015 5 108 100052 AM 2,378.38 500005 7 108 10 100063 2.400.00 600009 8 108 11 100051 AWAY Phoneard 256.00 600014 9 107 12 100055 Hydro 50.00 600015 10 107 13 100OGG 21.860.53 G00002 11 107 14 100067 ARALAY 2.210.11 600003 12 108 15 100058 A Phone and 256.80 600014 107 16 100069 H Hydro 570.00 600015 107 17 100070 AAAA 1,300,68 600001 15 107 12 100071 AU 7,283.78 600004 16 108 19 100072 in Phoneard 256.80 600014 27 108 20 100073 A Hydro 550,00 600015 18 108 21 100074 2,378.38 630005 19 107 22 100075 ne 3,995.68 G00002 20 108 23 100076 ARAU 2,972.97 600002 20 107 24 100077 A 2,792.96 600002 21 107 25 100079 Tit Phoneard 286.32 600014 22 108 26 100079 A Hydro 525.00 23 23 108 27 1000RO A 2,210.41 600003 24 107 22 100091 4.013.51 600004 25 107 29 100002 AALAY Phoneard 278.56 600014 26 108 30 100083 A Hydro 586.00 600015 27 108 31 100034 Att 4,428.09 G00002 28 107 32 100085 AM 1,783.78 630004 108 33 34 35 36 37 38 39 40 41 42 600015 44 Purchases + # EP - + 100% % AutoSave OFF OFF A SUE Sales_Cash_Receipt a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments Calibri (Body) v 11 X [G ~ Al A et Wrap Text Insert v Number Y , v Delete Paste BIU 7 Av Y = = = Merge & Center v Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter Sensitivity Format v Find & Select V C5 fx 609.95 E F G H I K M N o P A S S T U V W X Y Z AA 10000 1 Sale_Inv_N CR_Num Amount Applied 2 10001 100002 2,200.00 3 10002 100003 609.95 4 10002 100019 5 10002 609.95 10002 100025 AORE 100031 609.55 7 10003 100004 1,220.00 8 10004 100005 3.500.00 1000S 100005 1,559.19 10 10006 100007 2,530.00 11 10007 100C0B 2.600.00 12 10008 100009 1,650.00 13 1000S 101010 1,283.33 14 10009 100015 1,183.33 15 10009 100019 1,183.33 16 10009 100027 1,283.33 17 10009 100032 1,183.33 12 10010 100011 1,500.00 19 10011 100012 5,000.CO 20 10012 100013 2,970.00 21 10013 100014 609.55 22 10014 100023 770.00 23 10015 100016 319.99 24 10016 100017 2,769.99 25 10017 100020 1,650.00 26 10018 100021 5,859.70 27 10019 100022 2,530.00 22 10020 100024 3,300.00 29 10021 100 100025 1,100.00 30 10022 100028 1,320.00 10023 100036 2,637.20 32 10024 100029 639.98 33 10025 100030 2,423.co 34 10026 100033 3,500.00 35 10027 100034 1,559.99 36 10028 100035 5.215.20 37 10029 100037 1,210.00 38 10030 10003B 1.810,00 39 10002 100039 588.CO 40 10033100040 560.CO 41 42 44 Sales Cash Receipt + + # B - + 100% % AutoSave OFF OFF ROSUE 2 Sales a Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments X Calibrl (Body) v 11 ~ Al A ab Wrap Text Number Insert v Y , v Delete Paste B IV. v Y Av = = = Merge & Center v Ideas Conditional Format Cell Formatting es Table Styles Sort & Filter Sensitivity Format v Find & Select V C5 fx 3900 F G H I K M N o P A S T U V W X Y Z AA B i Sale_Inv_N Salc_Date Sale Amou Cust_Num Empl_Num 2 10001 AHLAWAN 2,200.00 10000001 102 3 10002 3,659.70 10000020 203 4 10009 Ant 1,220.CO 20000004 203 5 10004 AHLAWAN 3,500.col 10000007 102 10005 A 1,555.19 1000000 104 7 1000G A 2,530.00 30000023 205 8 10007 AWAY 2.600,00 10000009 106 10008 A 1,650.00 20000003 102 10 10009 Attitutit 7,200.00 20000026 205 11 10010 AHWAY 1,500.00 10000017 102 12 10011 A 5,000.co 20000010 205 13 10012 Athitit 2,970.00 20000028 205 14 10013 AHWAY 2.198.30 10000030 105 15 10014 A 770.CO 10000016 201 16 10015 319.99 20000019 205 17 10016 AALA 2,769.99 10000001 101 12 10017 A 1,650.00 20000014 203 19 10018 Attitutit 5,859.70 20000016 201 20 10019 AHLAWAN 2,530.00 10000003 102 21 10020 A 3,505.20 20000016 201 22 10021 Attitutit 4,400.00 20000023 205 23 10022 ALAU 1,320,00 10000010 101 24 10023 2.637.20 20000042 203 25 10024 639.98 2000000G 205 100 26 anno 10025 AWAY 2.120.00 10000013 101 27 10026 A 3,505.80 20000017 202 22 10027 hitit 1,559.99 20000003 202 29 10028 AWALAN 5,816.80 10000009 106 30 10029 A 1,210.00 30000017 202 10030 A 1,910.00 20000001 213 32 10031 AHAHAHA 300,00 10000050 101 33 10032 A 600.CO 20000010 214 34 10033 titi 560.CO 30000001 213 35 10034 AHLAWAN 17,SOB.CO 10000023 105 36 10035 A 4,150.00 20000015 205 37 10036 hittit 5,550.00 30000001 215 38 39 40 41 42 44 Sales + # EP - + 100% % View 0) 6% Fri 4:01 PM QE a Excel File File Edit Insert Format Tools Data Window Help AutoSave CEF CE SUE Vendor Home Insert Draw Page Layout Formulas Data Review View Tell me X Calibri (Bodyl v 11 w = = = VA A General th Che X + + Share P Comments G Update Insert O Conditional Formatting Format e Table 1 Cell Styles 4 2 Delete Paste BIU Editing Ideas Sensitivity Farmatu 4 !!! Sites Gurnaar CS x fx 214 Fairview Rd. A F G H H K L M N Q R S LI V or doing so. ain or lose credits. 1 Van Num Ven_Name Ven Addre Ven City Ven_Provir AP Balance 2 600001 EroupeanF 2546 Mein Hamilton Ontariu 0.00 600002 Casalife Fut 154 Lakepe Halifax Nova Scoti. 2.557.00 4 GOO003 Toronto Fu 54 Warda Toronto Ortaria 244.00 5 600004 Furniture 214 Feirvis Winnipeg Meritoba 678.00 ECONOS Custom Fur 312 Dunda Mississaug: Ontario 2.153.00 7 GCODOG Great Furni 5297 GULF Vancouver British Coll G.500.00 600007 Best Furnit 234 FIRSTS Vancouver British Coli 3,584.00 6C0008 Logacy Fur: 1171 DUCE Winnipeg Manitoba 2.540.00 10 GOODOS Halifax Fun 1729 UNIO Halifax Nova Scoli 253.00 11 600010 East Furnit 18120 SW St. John New Drury 5,640.00 600011 Unique Fur 12100 PRE Edmonton Aberta 8.650.00 GOO012 Mary's Anti 78 Gateway Kitchener Ontario 2,100.00 14 600013 Metro Hdi 123 Bloor Toronto Criariu 45600 15 600014 Rogers con 5785 South Mississaug: Ontario 0.00 16 GC0015 Receiver 1050 Notre Sudbury Ontario 0.00 17 600016 Reliance 830 Harrin Burlington Crtario 0.00 18 600017 Uniq Furni 125 Lagan St. Cacharir Ontario 200.00 19 0.00 GC0018 Adam Smit 56 Uptown Hamilton Cratarlo 20 21 22 23 24 25 26 27 28 29 30 31 32 33 Vendor d in Phase & II) 100% >> d. Which inventory type generated the most sales revenue? (Hint: you may create a query that includes all the information needed for the report, and then create a report based on that query. You may include graphs that may help you answer above questions your report.) 3. Based on your models and your understanding of the business, a) identify at least FOUR the threats or vulnerabilities of Brock Ltd.; b) describe the potential consequences of x