Content Purpose? This assignment illustrates how data analytics can be used to create strategies for sustainable organizational success while integrating the organization’s mission with societal values. You’ll apply statistical time series modeling techniques to identify patterns and develop time-dependent demand models.?You’ll practice organizing and delivering a presentation to senior decision-makers. The PowerPoint presentation includes an audio component in addition to speaker notes.  Resources:?Microsoft Excel®, DAT565_v3_Wk6_Data_FileScenario: A city’s administration isn’t driven by the goal of maximizing revenues or profits but instead looks at improving the quality of life of its residents. Many American cities are confronted with high traffic and congestion. Finding parking spaces, whether in the street or a parking lot, can be time consuming and contribute to congestion. Some cities have rolled out data-driven parking space management to reduce congestion and make traffic more fluid. You’re a data analyst working for a mid-size city that has anticipated significant increments in population and car traffic. The city is evaluating whether it makes sense to invest in infrastructure to count and report the number of parking spaces available at the different parking lots downtown. This data would be collected and processed in real-time, feeding an app that motorists can access to find parking space availability in different parking lots throughout the city. Instructions: Work with the provided Excel database. This database has the following columns: LotCode: A unique code that identifies the parking lot LotCapacity: A number with the respective parking lot capacity LotOccupancy: A number with the current number of cars in the parking lot TimeStamp: A day/time combination indicating the moment when occupancy was measured Day: The day of the week corresponding to the TimeStamp Insert a new column, OccupancyRate, recording occupancy rate as a percentage with one decimal. For instance, if the current LotOccupancy is 61 and LotCapacity is 577, then the OccupancyRate would be reported as 10.6 (or 10.6%). Using the OccupancyRate and Day columns, construct box plots for each day of the week. You can use Insert > Insert Statistic Chart >Box and Whisker for this purpose. Is the median occupancy rate approximately the same throughout the week? If not, which days have lower median occupancy rates? Which days have higher median occupancy rates? Is this what you expected? Using the OccupancyRate and LotCode columns,construct box plots for each parking lot. You can use Insert > Insert Statistic Chart >Box and Whisker for this purpose. Do all parking lots experience approximately equal occupancy rates?Are some parking lots more frequented than others? Is this what you expected? Select any 2 parking lots. For each one, prepare as scatter plot showing occupancy rate against TimeStamp for the week 11/20/2016 –11/26/2016. Are occupancy rates time dependent? If so, which times seem to experience highest occupancy rates? Is this what you expected? Presentation: Create a 10- to 12-slide presentation with speaker notes and audio. Your audience is the City Council members who are responsible for deciding whether the city invests in resources to set in motion the smart parking space app. Complete the following in your presentation:  Outline the rationale and goals of the project.  Utilize boxplots showing the occupancy rates for each day of the week (which may be presented in one table). Include your interpretation of results. Utilize box plots showing the occupancy rates for each parking lot (which may be presented in one table). Include your interpretation of results. Provide scatter plots showing occupancy rate against time of day of your selected four parking lots. Include your interpretation of results.  Make a recommendation about continuing with the implementation of this project. 

Havel Robotics Company (a U.S.-based firm) exports 25,000 industrial robots per year to China under an agreement that covers a 5-year period. In China, the robots are sold for the RMB (Chinese currency) equivalent of $50 per unit. The total costs in the United States are direct manufacturing costs and shipping costs, which amount to $35 per unit. The market for industrial robots in China is stable, and Havel holds the major portion of the market.In 2020, the Chinese government, adopting a policy of replacing imported robots with local products, invited Havel to open an assembly plant in China. If Havel makes the investment, it will operate the plant for 5 years and then sell the building and equipment to Chinese investors at net book value (cost less accumulated depreciation) at the time of sale plus the current amount of any working capital. Havel will be allowed to repatriate 100% of cash flow from operations (net income plus depreciation) to the United States each year.Havel’s anticipated outlay in 2020 would be $1,500,000 (buildings and equipment, $750,000, and working capital, $750,000). Buildings and equipment will be depreciated over 5 years on a straight-line basis (no salvage value). At the end of the fifth year, the $750,000 of working capital may be repatriated to the United States.Locally assembled robots will be sold for the RMB equivalent of $50 each. Operating expenses per robot are as follows:Materials purchased in China (dollar equivalent of RMB cost)$15Components imported from U.S. parent$8Variable costs per unit$23The $8 transfer price per unit for components sold by Havel to its Chinese subsidiary consists of $4 of direct costs incurred in the United States and $4 of pretax profit to Havel. There are no other operating costs in either China or the United States. The corporate income tax rates in China and the United States are 25% and 21%, respectively.Havel uses a 15% discount rate to evaluate all its investment projects. The present value factor for a single payment in five periods at 15% is 0.497. The present value factor for an annuity of payments for five periods at 15% is 3.352.Assume the investment is made at the end of 2020, and all operating cash flows occur at the end of 2021 through 2025. The RMB/U.S. dollar exchange rate is expected to remain constant over the 5-year period.Required:Assuming that Havel uses a parent company perspective in making foreign capital investment decisions, calculate NPV. Based on your result, do you recommend that the company make the investment?Havel learns that if it decides not to invest in China, a German company will probably make an investment similar to that being considered by Havel. The German investment would be protected by the Chinese government against imports by other foreign robot manufacturers. How does this information affect your analysis and recommendation?Stratford Industries, Inc., has a foreign operation with the following current year contribution margin income statement (amounts in foreign currency, FC):Corporate management has decided to evaluate the performance of the foreign operation’s manager on the basis of controllable profit. The following information has been gathered to assist in calculating controllable profit for the current year:A national labor strike in the foreign subsidiary’s home country caused it to shut down operations for one week, resulting in lost production of 1,000 units. Weekly fixed operating costs are FC 35,000.Stratford required the foreign subsidiary to sell 25% of its output to an affiliated company in Japan at a price of FC 100 per unit, even though all of the foreign subsidiary’s output could have been sold locally at a price of FC 120 per unit.The host government requires companies to purchase 20% of component parts from local manufacturers. As a result, the foreign subsidiary paid FC 60,000 more for parts in the current year than if it had been allowed to import 100% of parts needed.Stratford requires the foreign subsidiary to borrow FC from its sister company in Switzerland at an annual interest rate of 10%, even though local banks charge 6% interest on similar loans.Required:Develop an estimate of the amount of controllable profit to be used in evaluating the performance of the manager of Stratford’s foreign subsidiary for the current year.Why is it important to separate performance evaluations of foreign subsidiaries from those of their managers? When actual results are compared to an operating budget, under what conditions might it be appropriate to hold the manager of a foreign subsidiary responsible for an exchange rate variance as part of the total budget variance? Explain your answer.How do cultural differences impact operational budget and strategy implementation in multinational companies? Consider the concepts of individual/group responsibility, environmental factors, and leadership styles in your response.