You 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 isstill 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. you need to peruse the database. It comprises the following tables: • CURRENCY:A list of currencies and conversion rates to the Barbados dollar. • SALES: The POS transactions, both duty-free and duty-paid. • LOCATION: Both stores that sell and head office stock storage locations. You are asked to prepare several queries, as well as some reports. CAN YOU DO THIS FOR ME GIVING THE CORECT ANSWERS/ FIGURES ETC

Oh no! Our experts couldn't answer your question.

Don't worry! We won't leave you hanging. Plus, we're giving you back one question for the inconvenience.

Submit your question and receive a step-by-step explanation from our experts in as fast as 30 minutes.
You have no more questions left.
Message from our expert:
Your question falls outside the scope of our subject coverage. For tailored writing assistance, we recommend bartleby research. A question credit has been added to your account for future use.
Your Question:
 
You
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 isstill 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. you need to peruse the database. It comprises the following tables: • CURRENCY:A list of currencies and conversion rates to the Barbados dollar. • SALES: The POS transactions, both duty-free and duty-paid. • LOCATION: Both stores that sell and head office stock storage locations. You are asked to prepare several queries, as well as some reports. CAN YOU DO THIS FOR ME GIVING THE CORECT ANSWERS/ FIGURES ETC
Knowledge Booster
Industry Specific Activities
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Auditing: A Risk Based-Approach (MindTap Course L…
Auditing: A Risk Based-Approach (MindTap Course L…
Accounting
ISBN:
9781337619455
Author:
Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College