Nuts and Bolts Inc. (NBI) is a Canadian-based public company located in Milton. 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-ASN01-Q6.G" prepare the following:
i. Create a card visualization of how many countries NBI does business with. (0.5 marks)
ii. Create a map visualization of the supplier locations. (0.5 marks)
iii. Create 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)