Level 1 – Illustrating Travel Data for the Indiana Department of Tourism As a travel industry consultant, you have been working for the state of Indiana Department of Tourism. The department manager has asked you to present a report on where Indiana residents travel to and where Indiana visitors come from. The modes of transportation must also be presented. You will also include some information from a survey that your firm has recently completed. The travel survey is located in the workbook named Indiana.xlsx. Complete the following: 1. Open the workbook named Indiana.xlsx in the Chapter 3 folder, and then save the file as Indiana Travel.xlsx. 2. Create two bar charts to illustrate the differences in Trips per Traveler and Miles per Traveler of the average Indiana resident, the average U.S. resident, and the average Indiana visitor. (Hint: Create the charts for Indiana and Indiana Visitors first, and then add the data for United States using the Select Data Source dialog box. (Hint: Delete the “={1}” value in the Series values box before selecting the United States data.) 3. Create a bar chart to illustrate a state-by-state comparison of the number of residents from the rest of the nation who visit Indiana, and the number of Indiana residents who visit other states. Rank the information in this chart by the states with the most visitors to Indiana. 4. The Indiana Department of Tourism is very interested in learning more about how people travel in Indiana. They want to use this information to better target advertising to specific demographic groups and methods of travel. Use the appropriate chart or series of charts to illustrate how people travel; the purpose of their travel; and their income levels, age, and gender. This information should be presented for people who live within the state and those visiting the state with a comparison between the two groups. 5. Save and close the Indiana Travel.xlsx workbook.Gross, Debra; Akaiwa, Frank; Nordquist, Karleen. Succeeding in Business with Microsoft Excel 2013: A Problem-Solving Approach (New Perspectives) (Page 209). Cengage Textbook. Kindle Edition.

Attached are the first five pages of the case. Will send the rest in a private forum. The format is a typed document (12-point font, double-spaced text).Each submitted analysis should be roughly two-to-three pages in length.Creating a strategic analysis of a company’s situation will help you develop the skills to synthesize diverse information and so reason critically about potential solutions. Such skills are necessary for effective business management. The task is to create a written analysis containing the following three aspects:An identification of the company’s strategy, referencing course concepts (e.g. business-level strategy, five elements of strategy, international strategy)An explication of the strategic issues facing the company, derived from an analysis of the external environment and internal organization (i.e. SWOT analysis)A recommendation plan for dealing with the issues explicated (i.e. detailed options that weigh the benefits and costs of the proposal)

For this week's written assignment you are a manager at, Ad It Up, a mid-size marketing firm. Over the last five years you notice that issues relating to unethical practices seem to be on the rise. From minor issues, such as employees calling in sick when they should have used a personal/vacation day, to more serious issues, such as the inflation of hours billed to clients, the incidences are trending at a higher rate. In an attempt to curb these actions, the company decides to take a stronger stance and terminate those employees flagged as being unethical. Along with a heightened emphasis on training, a revision of the code of ethics, and stricter enforcement of the policies, you have been tasked with hiring three entry-level marketing employees to replace some of the terminated employees. The company wants to attract employees who are not only talented, but are ethical. You need to create a help wanted ad that spells out the various virtues that you are seeking in an employee.InstructionsCreate a 1-page, help-wanted ad for an entry level marketing person. In your ad, provide the following details:Attention grabbing titleA brief summary of the entry-level marketing positionA list of the desired virtues applicants should possess. For this part, you will need to provide and explain five of the virtues covered in this week's materials. Instructions for applying for the job. Submit your completed assignment by following the directions linked below. Please check the Course Calendar for specific due dates. Save your assignment as a Microsoft Word document.