Answer the bottom questions  in apa format and decent answer no short answer please. 

Subaru’s Sales Boom Thanks to the Weaker Yen For the Japanese carmaker Subaru, a sharp fall in the value of yen against the U.S. dollar has turned a problem—the lack of U.S. production—into an unexpected sales boom. Subaru, which is a niche player in the global auto industry, has long bucked the trend among its Japanese rivals of establishing significant manufacturing facilities in the North American market. Instead, the company has chosen to concentrate most of its manufacturing in Japan in order to achieve economies of scale at its home plants, exporting its production to the United States. Subaru still makes 80 percent of its vehicles at home, compared with 21 percent for Honda. Back in 2012, this strategy was viewed as something of a liability. In those days, one U.S. dollar bought only 80 Japanese yen. The strong yen meant that Subaru cars were being priced out of the U.S. market. Japanese companies like Honda and Toyota, which had substantial production in the United States, gained business at Subaru’s expense. But from 2012 onward, with Japan mired in recession and consumer prices falling, the country’s central bank repeatedly cut interest rates in an attempt to stimulate the economy. As interest rates fell in Japan, investors moved money out of the country, selling yen and buying the U.S. dollar. They used those dollars to invest in U.S. stocks and bonds where they anticipated a greater return. As a consequence, the price of yen in terms of dollars fell. By December 2015, one dollar bought 120 yen, representing a 50 percent fall in the value of the yen against the U.S. dollar since 2012.    For Subaru, the depreciation in the value of the yen has given it a pricing advantage and driven a sales boom. Demand for Subaru cars in the United States has been so strong that the automaker has been struggling to keep up. The profits of Subaru’s parent company, Fuji Heavy Industries, have surged. In February 2015, Fuji announced that it would earn record operating profits of around ¥410 billion ($3.5 billion) for the financial year ending March 2015. Subaru’s profit margin has increased to 14.4 percent, compared with 5.6 percent for Honda, a company that is heavily dependent on U.S. production. The good times continued in 2015, with Subaru posting record profits in the quarter ending December 31, 2015. Despite its current pricing advantage, Subaru is moving to increase its U.S. production. It plans to expand its sole plant in the United States, in Indiana, by March 2017, with a goal of making 310,000 a year, up from 200,000 currently. When asked why it is doing this, Subaru’s management notes that the yen will not stay weak against the dollar forever, and it is wise to expand local production as a hedge against future increases in the value of the yen. Indeed, when the Bank of Japan decided to set a key interest rate below zero in early February 2016, the yen started to appreciate against the U.S. dollar, presumably on expectations that negative interest rates would finally help stimulate Japan’s sluggish economy. By late March 2016, the yen had appreciated against the dollar and was trading at $1=112 yen. 

Sources: Chang-Ran Kim, “Subaru-Maker, Fuji Heavy Lifts Profit View on Rosy US Sales, Weak Yen,” Reuters, February 3, 2015; Yoko Kubota, “Why Subaru’s Profit Is Surging,” The Wall Street Journal, November 14, 2014; Doron Levin, “Subaru Profit Soaring on Weaker Yen,” Market Watch, November 15, 2014; Y. Kubato, “Weaker Yen Drives Subaru Maker’s Profit Higher,” The Wall Street Journal, February 4, 2016. Page 294 Case

Questions

 Why do you think that historically, Subaru chose to export production from Japan, rather than set up manufacturing facilities in the United States like its Japanese rivals? 

What are the currency risks associated with Subaru’s export strategy?

 What are the potential benefits?  Why did Subaru’s sales and profits surge in 2014 and 2015? Is Subaru wise to expand its U.S. production capacity?

What other strategies could the company use to hedge against adverse changes in exchange rates? What are the pros and cons of the different hedging strategies Subaru might adopt? 

Build out the ERD diagrams for the entire solution based on the following questions (you must have at least 3 tables for full credit, there is no limit based on your simplification of the data. The simplification of the data should follow the in-class examples of data, with no duplication in tables)

Provide 

I. The MYSQL code (within the word document) to build the database and tables

II. The MYSQL code (within the word document) to answer each of the following questions

III. Provide screen shots answering each question along with any supporting text

The answers must be done in SQL, not table presentation and manual interpretation of the data

Questions :

1. What is the total revenue for the year? 

2. What is the gross profit for the year? (based only on what is in the tables)

3. How much revenue did each wine provide for the year?

4. What is the Average revenue per month per location for the year?

5. What is the final inventory of the Premium Red wine?

6. If the retail price of the wine increases by 10%, what is the gross profit margin ?

7. How many bottles of the different wines were ordered in July? 

8. What is the revenue per year per restaurant?

Please find attached the paper and Question number 3. answer question 3 and Prepare slides. 

The Recreation and Wellness Intranet Project team is working hard to ensure that the new system they develop meets expectations. The team has a detailed scope statement, but the project manager, Tony Prince, wants to make sure they’re not forgetting requirements that might affect how people view the quality of the project. He knows that the project’s sponsor and other senior managers are most concerned with getting people to use the system, improve their health, and reduce healthcare costs. Users want the system to be user-friendly, informative, fun to use, and fast.

Tasks

 1. Develop a list of quality standards or requirements related to meeting the stakeholder expectations described in the Running Case. Also provide a brief description of each requirement. For example, a requirement might be that 90 percent of employees have logged into the system within two weeks after the system rolls out.

 2. Based on the list created for Task 1, determine how you will measure progress on meeting the requirements. For example, you might have employees log into the system as part of the training program and track who attends the training. You could also build a feature into the system to track usage by user name, department, and other criteria.

 3. After analyzing survey information, you decide to create a Pareto chart to see which types of recreational programs and company-sponsored classes generated the most interest. First, create a spreadsheet in Excel using the data in the following table. List the most frequently requested programs or classes first. Use the template on the text’s companion Web site.

Appendix A: Brief Guide to Microsoft Project Professional 2016 (companion website)

(https://www.cengage.com/resource_uploads/downloads/1337101354_609952.pdf

Requested Programs/Classes # of Times Requested   

Walking program                                     7,115   

Volleyball program                                     2,054   

Weight reduction class                                8,875   

Stop smoking class                                        1,894   

Soccer program                                       3,297   

Table tennis program                                  120   

Softball program                                          976  

The corporate Board of Directors has asked you to provide a portfolio of your research into the expansion of the company into the country you presented on in Wk 4.

Include an overall corporate code of ethics based on your review of professional associations, such as IEEE, ACM, SANS, ISACA, ASIS, and ISC(2). Include the following in your portfolio:

• Based on the ethical challenges identified in Week 4, choose and depict 2 risks to the corporation related to each challenge in a 1-page table using either Microsoft Word, PowerPoint, or Excel.
• A 1- to 2-page corporate code of ethics using Microsoft Word based on your review of professional associations, such as IEEE, ACM, SANS, ISACA, ASIS, and ISC(2), and the ethical challenges identified
• A 1- to 2-page concise synopsis of classical ethical theories
• A 1- to 2-page process to logically evaluate ethical dilemmas as they arise with the expansion of the company into the country you have chosen. Ensure that the process reflects the code of ethics you provide; for example, your process could start with identifying which part of the code applies to a particular new dilemma and move through assessing the various choices you could make along with any resulting consequences. The end goal is to help your corporation manage complex ethical questions with a variety of stakeholders.