MGMT Boutique Inc. is a high-end retailer that operates a chain of boutique stores in major hotel properties along the west coast of Barbados, including the famous five-diamonds Sandy Lane Hotel. Operating in eleven (11) locations, the company offers chic brands like Roberto Cavalli, Pain-de-Sucre, Versace, and Etro Milano, to name a few, and is well known for an eclectic collection of designer swimwear, fine linens, cotton and silk apparel for warm days and sultry evenings. A fine complement of shoes, hats and handbags with hand-picked custom jewellery are included to embrace the very essence of luxurious fashion.The locations connect over a MetroE-wide area network (WAN) that FLOW provides. Each store has a local Point-of-Sale (POS), replicated to a central hub in the main office. Replication occurs once every 15 minutes, so the head office is virtually up-to-date, in real-time, and can see, at a glance, transactions in each store.Customers primarily shop duty-free, paying in either Barbados (BDS) or USA dollars. Duty-free sales do not attract a 15.0% VAT tax. The list price, seen on the shelf, is the price paid. For customer convenience, the company offers a limited range of duty-paid items.Again, customers can pay in either currency or the price listed on the self is still the price paid. However, this price now includes 15.0% VAT. Customers pay by cash or card, charge the expense to their room, and settle the bill later.As a reporting requirement for a duty-free establishment, POS details for customers are routinely captured. This information has proven helpful for analysing behaviour, and the company also tries to capture the exact details of duty-paid transactions. As a rule, duty-free transactions will be done in US dollars, while duty-paid transactions will appear in BDS dollars. As a new boutique employee, your manager wants you to produce some reports to review performance in preparation for an upcoming trip to purchase new merchandise. All queries and reports should appear in Barbados dollars, and so do the conversions. Format all money as currency to improve the display. Please don't have weird values with seven (7) decimal places. Use the currency table provided to convert US dollars to Barbados dollars and pay attention to the currencies in the sales table.