Question
Nuts and Bolts Inc. (NBI) is a Canadian-based public company located in Milton, Ontario. It prepares its financial statements in accordance with IFRS with a
Nuts and Bolts Inc. (NBI) is a Canadian-based public company located in Milton, Ontario. It prepares its financial statements in accordance with IFRS with a December 31 year end. With the increasing population in Milton, NBI has found success supplying hardware stores with inventory sourced from other countries.
NBI was founded five years ago by Peter and Joshua, business partners who used to do project management in a construction company together. Joshua had an idea that if quality hardware purchases could be sourced from elsewhere and provided to local hardware stores in Milton, this would help to keep construction costs low for the increasing population coming to the city.
NBI has never formally tracked its foreign purchases before. However, over the last three years NBI has sourced many more goods from foreign countries and would like to understand where the purchases are coming from so that a hedging strategy can be adopted.
To reduce shipping costs and earn discounts for bulk buys, NBI only purchases foreign goods once a year in each country it deals with. In the most recent year, NBI placed all inventory orders on December 15, 20X8, and took delivery on January 15, 20X9.
Use Power BI to provide an analysis so that Peter and Joshua can understand their foreign-currency transactions.
Required: a) Using the Excel file "Prep-AFR-ASN06-Q6.G" prepare the following:
i. Craft a card visualization of how many countries NBI does business with. (0.5 marks)
ii. Craft a map visualization of the supplier locations. (0.5 marks)
iii. Craft three tables showing the foreign exchange rates for Jamaica and Malaysia in effect on (1 mark):
a. The day the order was placed (December 15, 20X8)
b. The year-end date (December 31, 20X8)
c. The day the order was paid for (January 15, 20X9) Hint: Your visualization must be selected before you can work on it. To select your visualization, simply click on it in Power BI. Similar instructions to help you prepare these visualizations can be found in Week 5 Practice Problem 9.
b) Assume the following (1 mark):
• All inventory purchases are FOB shipping point with payment due on delivery to NBI.
All purchases are shipped by the foreign supplier on the day NBI orders the goods.
• NBI does not hedge its foreign-currency exposure on foreign purchases.
Using your data visualization from part (iii), calculate the following for transactions with Jamaica and Malaysia (round the final number to two decimal places):
i. Foreign exchange gain or loss reported for the year ended December 31, 20X8
ii. Foreign exchange gain or loss reported for the period ending January 15, 20X9
iii. Cumulative foreign exchange gain or loss realized on the recognized monetary items (the accounts payable) arising from these foreign purchases
For parts (c) and (d), assume the following:
• All inventory purchases are FOB destination with payment due on delivery to NBI.
• NBI purchases a forward contract to hedge its foreign-currency exposure on all foreign purchases. NBI enters into the forward contract on the day it orders the goods and settles the contract on the day the inventory is delivered to NBI.
c) NBI does not adopt hedge accounting. Using your data visualization from part (iii),
calculate the following (round the final number to two decimal places) (1 mark):
i. Foreign exchange gain or loss on the hedging instrument reported for the year ended December 31, 20X8
ii. Foreign exchange gain or loss on the hedging instrument reported for the period ended January 31, 20X9
iii. Cumulative foreign exchange gain or loss recognized on the hedging instruments
d) Assume the following (round the final number to two decimal places):
NBI adopts hedge accounting and designates the hedges as fair value hedges.
Using your data visualization from part (iii), indicate how, and at what amount, the Advanced Financial Reporting Project 2 14 / 14 cumulative net foreign exchange gain or loss on the hedged and hedging items would be reported for:
i. The year ended December 31, 20X8 (0.5 marks)
ii. Interim statements for January 31, 20X9 (0.5 marks)
NOTES: NBI tracks the following information about its vendors and purchases:
• Region: global geographic region (defaults to North America)
• Country: country of product origin
• Currency: currency used when transacting in this country
• Order date: date the order was purchased
• Order ID: unique identifier for each order
• Settlement date: date the order was paid for
• Units purchased: number of units purchased per order ID
• Unit cost: the unit cost of each item reported in the applicable foreign currency
• Total cost: total cost of the order in the applicable foreign currency (units purchased × unit cost)
1 2 3 4 5 6 7 8 9 2 10 11 12 13 14 15 16 2 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 32 55 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 51 62 63 64 65 66 67 68 69 70 71 72 A Regina Central America and the Caribbean Central America and the Caribbean Central America and the Caribbean Central America and the Caribbean Europe Europ Europe Europe Europo Europe Europo Europa Aria Aria Asia Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Eurapo Europo Europo Europo Europe Europe Eurapo Eurapa Europo www. Europo Europo Eurapo Europ Europe Europe Europe Europe Europo Europo Europo Eurapo Europe Europe Europe Europe Europo Europe Europe Eurapa Europe Europe Europ Europo B C D Country Currency Sent Rate Brazil Brazil Brazil BRL Brazil Suitzerland CHF Suitzerland CHF Suitzerland CHF Suitzerland CHF Suitzerland CHF Suitzerland CHF Suitzerland CHF Suitzerland CHF China CNY China China China China China China China China China China China China China China China China China China China China China Chinal China China Austria Aurtrial Aurtria Aurtria Ertania Ertania Ertania Ertania Ertania Ertania Estonia Finland Finland BRL BRL BRL Finland Finland Finland Finland France France Franco CNY CNY CNY CNY CNY CNY Purchases CNY CNY CNY CNY CNY CNY CNY CNY Austria Aurtria Belgium EUR Belgium EUR Belgium EUR Belgium EUR CNY CNY EUR Belgium Belgium EUR Belgium EUR EUR Ertania EUR EUR EUR EUR EUR EUR EUR EUR EUR EUR EUR EUR EUR EUR EUR CNY CNY CNY CNY CNY CNY CNY CNY EUR EUR EUR EUR EUR EUR EUR Germany EUR Germany Germany EUR EUR 15-Dec-18 31-Dec-18 15-Jan-19 0.3152 0.3184 0.3426 0.3426 0.3152 0.3104 0.3426 0.3152 0.3184 0.3426 0.3152 1.3414 1.2341 1.3414 1.2341 1.3414 1.2341 1.3414 1.2341 1.3414 1.3414 1.2341 1.2341 1.3414 1.2341 + 1.3414 0.1937 0.1937 0.1937 0.1937 0.1937 0.1937 0.1937 0.1937 0.1937 0.1937 0.1937 9:1951 0.1937 0.1937 0.1937 0.1937 0.1937 0.1937 0.1937 0.1937 0.1937 0.1937 0.1937 0.1937 0.1937 0.1937 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 E F Spat Rate Spat Rats 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.2341 0.1821 0.1821 0.1821 0.1821 0.1821 0.1821 0.1021 0.1821 0.1821 0.1821 0.1821 0.1821 0.1821 0.1821 0.1821 0.1821 0.1821 0.1821 0.1821 0.1821 0.1821 0.1821 0.1821 0.1821 0.1821 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 0.3184 1.2094 1.2094 1.2094 1.400 1.2094 1.2094 1.2094 1.2094 1.2094 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 1.3783 1.3783 1.5165 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 G Farward Rate December 15 2018 Far rettlement on Jan 15 0.3392 0.3392 0.3392 0.3392 1.3816 1.3816 1.3816 1.3816 1.3816 1.3816 1.3816 1.3816 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 0.1995 1.5048 1.5048 1:5040 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1:5040 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.504 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 H Farward Rete December 31 2018 Far zettlement in Jan15 2019 0.3184 Household 0.3184 Carmotier 0.3184 Snackr 0.3184 Meat 1.2588 Clather 1.2588 Boverage 1.25$$ Clather www 1.2588 Carmotier 1.2588 Coroal 1.2588 Most 1.2588 Snacks 1.2588 Beverager 0.1857 Carmotier 0.1857 Beverager 0.1857 Personal Care 0.1857 Vegetabler 0.1857 Office Supplier 0.1857 Carmotier 0.1857 Beverager Snackr Beverager 0.1857 0.1857 0.1857 Snacks 0.1857 Snacks 0.1857 Hourshold 0.1857 Carmetien Cereal Coreal Snackr Baby Food Coroal 1 J L M N 0 Item Type Deder Data Order ID Settlement Dat Unit Purchare ait Cart in Fifatal Cart in FI 0.1857 0.1857 0.1857 0.1857 0.1857 0.1857 Office Supplies 0.1857 Hourshold 0.1857 Snack Coreal 0.1857 Beverager 0.1857 Personal Care 0.1857 Corval 0.1857 1.4213 Office Supplies 1.4213 Office Supplies 1.4213 Office Supplies 1.4213 Vegetabler 1.4213 Hourshold 1.4213 Coreal Fruitr 1.4213 1.4213 Baby Food 1.4213 Beverager Most 1.4213 15-Dec-18 560600841 15-Jan-19 15-Dec-18 597918736 15-Jan-19 15-Dec-18 213965450 15-Jan-19 15-Dec-18 479216182 15-Dec-18 745783555 15-Dec-18 669970749 15-Dec-18 763920438 15-Dec-18 724799668 15-Dec-18 423159730 15-Dec-18 703815782 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-De-18 359911954 15-Jan-19 15-Dec-18 682831895 15-Jan-19 15-Dec-18 773315994 15-Jan-19 15-Dec-18 332877862 15-Jan-19 15-Dec-18 637448060 15-Jan-19 15-Dec-18 737816321 15-Jan-19 15-Dec-18 $93779695 15-Jan-19 15-Dec-18 586165082 15-Jan-19 15-Dec-18 681941401 15-Jan-19 15-Dec-18 637521445 15-Jan-19 15-Dec-18 989119565 15-Jan-19 15-Dec-18 584534299 15-Jan-19 15-Dec-18 732211140 15-Jan-19 15-Dec-18 718781220 15-Jan-19 15-Dec-18 650727784 15-Jan-19 15-Dec-18 141940200 15-Jan-19 15-Dec-18 941909682 15-Jan-19 15-Dec-18 97400329 15-Jan-19 15-Dec-18 $17824685 15-Jan-19 15-Dec-18 317323625 15-Jan-19 731972110 15-Dec-18 15-Jan-19 15-Dec-18 494525372 15-Jan-19 15-Jan-19 15-Dec-18 761439931 15-Jan-19 15-Dec-18 296438443 15-Jan-19 15-Dec-18 603123080 15-Jan-19 15-Dec-18 594540441 15-Jan-19 15-Dec-18 285341823 15-Jan-19 15-Dec-18 979165780 15-Dec-18 15-Dec-18 141977107 15-Dec-18 612911641 15-Dec-18 $52176702 15-Dec-18 753585135 15-Dec-18 674808442 15-Dec-18 901573550 15-Dec-18 978349959 15-Dec-18 760364902 15-Dec-18 146263062 15-Dec-18 277070748 15-Dec-18 403961122 15-Dec-18 405997025 15-Dec-18 462085664 15-Dec-18 902424991 15-Dec-18807678210 1.4213 Office Supplies 15-Dec-18 1.4213 Snackr 1.4213 Carmetien 1.4213 Office Supplier 1.4213 Baby Food 1.4213 Clother 1.4213 Office Supplier 1.4213 Most 15-Dec-18 280571782 15-De-18 175257527 1.4213 Beverager 15-Dec-18 373048341 1.4213 Beverager 15-Dec-18 985092010 1.4213 Vegetables 15-Dec-18 26916301 1.4213 Vegetabler 15-Dec-18 306220996 1.4213 Personal Care 15-Dec-18 409774005 15-Dec-18 $41291654 15-Dec-18 506365287 15-Dec-18 166435849 15-Dec-18 289606320 15-Dec-18 720786225 15-Dec-18 459212481 15-Dec-18 959853875 15-Dec-18 618474757 15-Dec-18 285662829 1.4213 Office Supplies 15-Dec-18 703693473 1.4213 Personal Care 1.4213 Carmotier 1.4213 Porranal Care 1.4213 Hourshold 1.4213 Snacks 1.4213 Office Supplier 1.4213 Vegetabler 1.4213 Baby Food 1.4213 Personal Care 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 3,101 6,296 6,397 9,572 2,782 455 888 6 3,183 1,222 3,585 4,800 3,987 213 4,811 3,901 5,100 8,128 8,128 470 5,618 1,315 5,544 6,405 2,191 3,667 2.114 $61 332 1,353 1,967 5,668 9,902 8,786 5.851 1,57% 6,377 6,583 7,841 5,768 3,036 3,030 6,878 1,443 4,503 4,349 7,726 1,345 246 9,920 2,397 271 6,463 6,280 1,452 2,149 9,711 1,764 6,452 $9 5,751 3,596 921 9,801 5,516 33 947 9,279 2,834 7,391 66.83 43.72 15.26 42.19 10.93 4.75 10.93 43.72 20.57 42.19 15.26 4.75 43.72 4.75 9.11 8.17 15.41 65.12 43.72 4.75 15.26 4.75 15.26 15.26 66.83 43.72 20.57 20.57 15.26 25.53 20.57 65.12 66.83 15.26 20.57 4.75 8.17 20.57 65.12 65.12 65.12 15.41 66.83 20.57 0.93 25.53 4.75 42.19 65.12 15.26 43.72 65.12 25.53 10.93 65.12 42.19 4.75 4.75 15.41 15.41 8.17 $.17 43.72 8.17 66.83 15.26 65.12 15.41 25.53 8.17 65.12 207,239.83 275,261.12 97,618.22 403,842.68 30,407.26 2,161.25 108,075.84 139,160,76 25,136.54 151.251.15 73,248.00 18,930.25 9,312.36 22,852.25 31,871.17 78,591.00 529,295.36 355,356.16 2,232.50 $5,730.68 6,246.25 $4,601.44 97,740.30 146,424.53 160,321.24 43,484.98 17,710.77 5,066.32 34,542.09 40,461.19 369,100.16 661,750.66 134,074.36 120,355.07 7,495.50 52,100,09 135,412.31 510,605.92 375,612.16 197,704.32 46,692.30 459,656.74 29,682.51 8,992.17 114,961.59 20,657.75 325,959.94 $7,506,40 3,753.96 434,052.16 156,092.64 6,918.63 70,640.59 408,953.60 61,259.88 10,207.75 46,127.25 27,183.24 99,425.32 727.13 46,985.67 157,217.12 7,524.57 655,000.83 $4,174.16 2,148.96 14,593.27 236,892.07 23,153.78 481,301.92 P 69 19 70 71 72 73 74 75 76 77 78 79 80 $1 $2 83 $4 $5 26 86 $7 ** 89 90 91 92 22 93 94 95 96 97 48 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 A Europo Europe Europo Europo Europo Europ Europe Europe Europo Europe Europe Europo Europo Europe Europe Europe Europe Europe Europo Europo Europe Europe Europo Europe Europe Europo Europ Europe Europe Europo Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria North America North America Aria Aria Aria Aria Aria Aria Aria Aria Aria Aria Europe Europo Europ Europe Europe Europe Europo Europe Europo Europo Europo Europe Europe Europe Aria www Aria Aria Aria 140 141 Central America and the Caribbean B France Germany Germany Germany Germany Germany Germany Groote Greece Japan Forn Japan Japan Japan Japan Japan Malaysia Malaysia Malaysia Malaysia Malaysia Malayzia Malayzia Malaysia Malaysia Greece Greece Greece Greece Italy Italy Italy Italy Italy Italy EUR Netherlands EUR Netherlandr EUR Netherlandr EUR Netherlandr EUR Netherlandr EUR Portugal EUR Portugal EUR Portugal EUR Portugal EUR Portugal EUR Portugal EUR Japan JPY Japan JPY JPY JPY Malayzia Malaysia Naruay Norway Naruay Norway JPY JPY JPY JPY South Korea KWR South Korea KWR South Korea KWR South Korea KWR Moxico MXN Moxico MXN MYR MYR MYR MYR MYR MYR MYR MYR MYR MYR NOK NOK NOK NOK NOK C EUR Maruay Suodon Sueden Sweden EUR con EUR EUR Sueden Sueden Sueden Sueden EUR EUR Thailand Thailand Thailand Thailand Jamaica EUR EUR EUR EUR EUR EUR EUR EUR EUR EUR EUR EUR Norway Norway NOK NOK SEK SEK SEK SEK SEK SEK SEK SEK THB THE THB THB USD D 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 1.5113 0.0118 0.0118 0.0118 0.0118 0.0118 0.0118 0.0118 0.0118 0.0012 0.0012 0.0012 0.0012 0.0658 0.065* 0.3197 0.3197 0.3197 0.3197 0.3197 0.3197 0.3197 0.3197 0.3197 0.3197 0.1551 0.1551 0.1551 0.1551 0.1551 0.1551 0.1551 0.1474 0.1474 0.1474 0.1474 0.1474 0.1474 0.1474 0.0408 0.0408 0.0408 0.0408 1.3380 E 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 1.4357 0.0113 0.0113 0.0113 0.0113 0.0113 0.0113 0.0113 0.0113 0.0012 0.0012 0.0012 0.0012 0.0645 0.0645 0.3165 0.3165 0.3165 0.3165 0.3165 0.3165 0.3165 0.3165 0.3165 0.3165 0.1567 0.1567 0.1567 0.1567 0.1567 0.1567 0.1567 0.1503 0.1509 0.1503 0.1503 0.1503 0.1503 0.1503 0.1503 0.0420 0.0420 0.0420 0.0420 1.3915 F 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 1.3783 0.0119 0.0119 0.0119 0.0119 0.0119 0.0119 0.0119 0.0119 0.0011 0.0011 0.0011 0.0011 0.0664 0.0664 0.2943 0.2943 0.2943 0.2943 0.2943 0.2943 0.2943 0.2943 0.2943 0.2943 0.1520 0.1520 0.1520 0.1520 0.1520 0.1520 0.1520 9:1459 0.1458 0.145* 0.1458 0.1458 0.1458 0.1458 0.1458 0.0416 0.0416 0.0416 0.0416 1.2802 1.5048 1.5048 wwwwwww 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.5048 1.504 1.5048 1.5048 1.5048 0.0116 0.0116 0.0116 0.0116 0.0116 0.0116 0.0116 0.0116 0.0012 0.0012 0.0012 0.0012 0.0684 0.0684 0.3325 0.3325 0.3325 0.3325 0.3325 0.3325 0.3325 0.3325 0.3325 0.3325 0.1613 0.1613 0.1613 0.1612 0.1613 0.1613 0.1613 0.1533 0.1533 0.1533 0.1533 0.1533 0.1533 0.1533 0.0424 0.0424 0.0424 0.0424 1.3224 H J K 15-Dec-18 959853875 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 1.4213 Office Supplier 1.4213 Clather 1.4213 Carmotier 1.4213 Fruitr 1.4213 Snacks I 1.4213 Vegetabler 1.4213 Baby Food 1.4215 15-Dec-18 618474757 1.4213 Personal Care 15-Dec-18 285662829 1.4213 Office Supplies 15-Dec-18 703693473 1.4213 Household 15-Dec-18 611809146 1.4213 Cereal 15-Dec-18 957276809 1.4213 Personal Care 15-Dec-18 778708636 15-Jan-19 1.4213 Hourehold 15-Dec-18 702186715 15-Jan-19 1.4213 Baby Food 15-Dec-18 294499957 15-Jan-19 1.4213 Hourshold 15-Dec-18 $76286971 15-Jan-19 1.4213 Vegetables 15-Dec-18 140635573 15-Jan-19 1.4213 Personal Care 15-Dec-18 644913613 1.4213 Perronal Care 15-Dec-18 947779643 1.4213 Office Supplies 15-Dec-18 12295901 1.4213 Coroal 15-Dec-18 622791612 1.4213 Personal Care 15-Dec-18 127589738 1.4213 Vegetabler 15-Dec-18 952714908 1.4213 Boverager 15-Dec-18 419124829 1.4213 Snackr 15-Dec-18 580823838 15-Dec-18 944635236 15-Dec-18 339256370 15-Dec-18 $25143039 15-Dec-18 792983996 15-Dec-18 927766072 1.4213 Office Supplier 15-Dec-18 535654580 1.4213 Office Supplier 15-Dec-18 956433522 1.4213 Office Supplier 15-Dec-18 770508801 1.4213 Vegetabler 15-Dec-18 13209140 1.4213 Carmetier 15-Dec-1 736967005 1.4213 Coreal 15-Dec-18 11546599 0.0112 Cereal 15-Dec-18 161442649 0.0112 Beverager 15-Dec-18 981086671 0.0112 Baby Food 15-Dec-18 $23699796 0.0112 Carmetier 15-Dec-18 629925000 0.0112 Carmtier 15-Dec-18 107172334 0.0112 Personal Care 15-Dec-18 885129249 0.0112 Most 15-Dec-18 551725009 0.0112 Carmetics 15-Dec-18 453569972 Fruitr 15-Dec-18 769205892 0.0012 Baby Food 15-Dec-18 780282342 0.0012 Office Supplier 15-Dec-18 312927377 0.0012 Snackr 15-Dec-18 15-Dec-18 763568961 0.0671 Clother 15-Dec-18 654693591 0.0671 Baby Food 15-Dec-18 434355056 0.3102 Snackr 15-Dec-18 175033080 0.3102 Snacks 15-Dec-18 600124156 0.3102 Hourshold 15-Dec-18 444358193 0.3102 Beverager 15-Dec-18 860232770 0.3102 Carmetier 15-Dec-18 73522365 0.3102 Baby Food 15-Dec-18 783596694 0.3102 Carmotier 15-Dec-18 908627116 0.3102 Office Supplies 15-Dec-18 560608565 0.3102 Household 15-Dec-18 750253188 0.3102 Baby Food 15-Dec-18 677394092 0.1536 Personal Care 15-Dec-18 347163522 0.1536 Clother 15-Dec-18 126767909 0.1536 Hourshold 15-Dec-18 326714789 0.1536 Personal Care 15-Dec-18 496897733 0.1536 Carmetier 15-Dec-18 $37055851 0.1536 Baby Food 15-Dec-18 $$7180173 0.1536 Baby Food 15-Dec-18 328236997 0.1473 Baby Food 15-Dec-18 689975583 0.1473 Vegetabler 15-Dec-18 947434604 0.1473 Snacks 15-Dec-18 742443025 0.1473 Baby Food 15-Dec-18 935371100 0.1473 Porranal Care 15-Dec-18 109652699 0.1473 Cereal 15-Dec-18 247776305 15-Dec-18 418593108 15-Dec-18 352327525 15-Dec-18 670878255 15-Dec-18 155128943 0.0012 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 15-Jan-19 0.1473 Carmotier 0.0437 Hourshold Snackr Baby Food 0.0437 ***** 0.0437 0.0437 Vegetables 15-Dec-18 976871955 1.4472 Vegetabler 15-De-18 266467225 15-Jan-19 M 947 9.279 20 2,834 7,391 6.777 8.335 6,045 1,500 7,937 1,643 6,046 3,124 7,913 5,263 6,733 5,494 8,367 7,206 7,536 7.413 2,354 7,017 441 5,453 949 8,788 9,532 5,511 4,029 3,528 3,322 4,203 9,929 7,661 3,530 8.269 6.569 289 3,972 1,739 1,020 www 5,879 7,237 4.168 5,033 8,929 4,319 $48 3,534 2,530 1,810 5,387 5,446 4,820 2,256 2,296 1,021 1.936 9,020 5,183 1,476 7,963 5,808 4,245 5,949 7,821 1,370 9,858 399 **** 6,639 4,957 6,975 2,428 N 15.41 25.53 wwwww 8.17 65.12 20.57 8.17 66.83 25.53 66.03 15.41 8.17 8.17 65.12 20.57 8.17 15.41 4.75 15.26 65.12 10.93 43.72 0.93 15.26 65.12 65.12 65.12 15.41 43.72 20.57 20.57 4.75 25.53 43.72 43.72 8.17 42.19 43.72 0.93 25.53 65.12 15.26 10.93 25.53 15.26 15.26 66.83 4.75 43.72 25.53 43.72 65.12 25.53 8.17 10.93 66.83 8.17 43.72 25.53 25.53 25.53 15.41 15.26 25.53 8.17 20.57 43.72 15.26 25.53 15.41 15.41 0 14,593.27 236,892.87 23,153.78 481,301.92 452,906.91 171,450.95 49,387.65 100,779.64 202,631.61 109,801.69 93,168.86 25,523.08 64,649.21 342,726.56 138,497.81 44,885.98 128,935.47 34,220.50 114,999.36 482,734.56 25,729.22 306,783.24 410.13 $3,212.78 61,798.88 572,274.56 620,723.84 $4,924.51 176,147.88 72,570.96 68,333.54 19,964.25 253,487.37 334,930.92 154,331.60 67,557.73 277,146.11 12,635.08 3,693.96 44,396.67 66,422.40 89,713.54 79.100.41 106,409.04 76,803.50 136,256.54 288,638.77 4,028.00 154,506.48 64,590.90 79,133.20 350,801.44 363,956.18 123,054.60 18,431.52 25,095.28 68,233.43 15.817.12 394.354.40 132,321.99 37,682.20 203,295.39 $9,501.2 64,778.70 151,877.97 63,897.57 28,180.90 430,991.76 26,665.17 101,311.14 126,552.21 107,484.75 37,415.48 P of Sv
Step by Step Solution
3.45 Rating (152 Votes )
There are 3 Steps involved in it
Step: 1
a i To craft a card visualization of how many countries NBI does business with open the Power BI Desktop and select the Card Visualization from the Visualizations pane Then click on the Modeling tab a...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started