You will create a marketing plan for a hypothetical product-based company. Each assignment focuses on a different section of the overall marketing plan. For Assignment 1, you will compile information on the company’s background information, an environmental analysis, your company’s short and long-term goals, and a SWOT analysis. For information on Website analytics, visit Google Analytics at http://www.google.com/analytics/why/. Note: You may create and / or make all necessary assumptions needed for the completion of this assignment. Write a five to six (5-6) page paper in which you: Write an introduction to your company. Describe your company, its location, and the product it makes or the service it provides.Develop an environmental analysis that includes competitive, economic, political, legal, technological, and sociocultural forces.Determine the primary and secondary target markets for your company. Next, analyze the primary and secondary target markets that you identified for your company. Be sure to cover the 4Ps, 5Cs and STP.Decide the main goals that you would like to achieve within the next year (short term) and the mains goals that you would like to achieve within the next five (5) years (long term). Determine the most appropriate ways to measure both short- and long-term goals. Note: Consider the following metrics: tracking downloads of Website content, Website visitors, increases in market share, customer value, new product adoption rates, retention, rate of growth compared to competition and the market, margin, and customer engagement.Develop both a SWOT analysis and needs analysis for your product. Each analysis should examine four (4) strengths, weaknesses, opportunities, and threats for your company.Use at least four (4) academic resources as quantitative marketing research to determine the feasibility of your product / service. These resources should be industry specific and relate to your chosen product / service. Note: Wikipedia and other Websites do not qualify as academic resources. Your assignment must follow these formatting requirements: Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.Include a cover page containing the title of the assignment, the student's name, the professor's name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

To complete this assignment, you need to use the attached Data File (Excel).ProblemMedical groups are common in the health care industry and range in size. The defining trait of a medical group is that there is more than one doctor on staff for a particular practice, which creates more flexible hours for patients and physicians. In addition, a medical group can provide a variety of medical services in one location. In this assignment, you need to summarize payroll details for employees working in a medical group.Instructions: Perform the following tasks. Data file shows the basic information you will need for this project.Set the Freeze Panes command on the Payroll Details worksheet so that Rows 1 and 2 and Columns A and B are locked in place while scrolling through the worksheet.Enter an IF function in cell G3 on the Payroll Details worksheet to calculate the Social Security tax. Social Security funds are used by the government to provide income for people who are retired, a beneficiary of a retiree, or disabled. An employer must withhold 4.2% of an employee’s weekly pay for Social Security. However, an employee is only taxed up to $100,000. The logical test of the IF function should assess if the value in the Pay Year to Date column is greater than or equal to 100000. If the logical test is true, the output of the function should be zero. Otherwise, the function should multiply the value in the Gross Pay This Week by 4.2%. Copy and paste the function into the range G4:G22.Enter a formula in cell H3 on the Payroll Details worksheet that calculates the Medicare Tax. Medicare funds are used by the government to provide medical financial support to senior citizens. Your formula should multiply the Gross Pay This Week by 1.45%. Copy and paste this formula into the range H4:H22.Enter a formula in cell I3 on the Payroll Details worksheet that calculates the total FICA tax (FICA stands for Federal Insurance Contributions Act). Your formula should add the Social Security Tax to the Medicare Tax. Copy and paste this formula into the range I4:I22.Enter an IF function in cell J3 on the Payroll Details worksheet to calculate the Federal Tax. If the Gross Pay This Week is less than or equal to 1150, then the tax is calculated by multiplying the Gross Pay This Week by 20%. Otherwise, this tax is calculated by multiplying the Gross Pay This Week by 25%. Copy and paste the IF function into the range J4:J22.If an employee has been working with the medical group for 1 or more years, the company will match 50% of the employee’s 401(k) retirement contributions. Calculate the company’s 401(k) retirement contributions by entering an IF function in cell L3 on the Payroll Details worksheet. If the Years of Service is greater than or equal to 1, multiply the 401K Retirement value by 50%. Otherwise, the output of the function should be zero. Copy and paste the IF function into the range L4:L22.The medical group offers its employees an additional retirement benefit based on the employee’s position and years of service. Employees who are with the practice 3 or more years will receive an additional contribution to their retirement account. Calculate this benefit by entering an IF function in cell M3 on the Payroll Details worksheet. If an employee is a physician and has been working in the medical group for 3 or more years, the function should multiply the Gross Pay This Week by 8%. For all other employees who have been working at the medical group for 3 or more years, the function should multiply the Gross Pay This Week by 5%. Copy and paste the function into the range M4:M22.Enter a formula into cell N3 on the Payroll Details worksheet that calculates the Total Retirement Benefits. Your formula should add the 401K Company Match value to the Retirement Benefit value. Copy and paste the formula into the range N4:N22.Enter a formula into cell O3 on the Payroll Details worksheet that calculates the Net Payment for each employee. Your formula should subtract the values in the range I3:K3 from the Gross Pay This Week in cell F3. The range I3:K3 includes the following: Total FICA (cell I3), Federal Tax (cell J3), and 401K Retirement (cell K3). Copy and paste this formula into the range O4:O22.Enter a COUNTIF function into cell B3 on the Payroll Summaryworksheet. The function should count the number of employees in the range A3:A22 on the Payroll Details worksheet for each Practice listed in Column A on the Payroll Summary worksheet. Copy and paste the function into the range B4:B7.Enter an AVERAGEIF function into cell C3 on the Payroll Summaryworksheet. The function should calculate the average Years of Service in the range D3:D22 on the Payroll Details worksheet for each Practice listed in Column A on the Payroll Summary worksheet. Copy and paste the function into the range C4:C7.Enter a SUMIF function into cell D3 on the Payroll Summaryworksheet. The function should sum the Total FICA tax in the range I3:I22 on the Payroll Details worksheet for each Practice listed in Column A on the Payroll Summary worksheet. However, the government requires that employers match the FICA tax that is withheld from employees’ paychecks. Therefore, multiply the result of this SUMIF function by 2. Copy and paste the function into the range D4:D7.Enter a SUMIF function into cell E3 on the Payroll Summaryworksheet. The function should sum the Federal Tax withholdings in the range J3:J22 on the Payroll Details worksheet for each Practice listed in Column A on the Payroll Summary worksheet. Copy and paste the function into the range E4:E7.Enter a SUMIF function into cell F3 on the Payroll Summaryworksheet. The function should sum the Net Payments in the range O3:O22 on the Payroll Details worksheet for each Practice listed in Column A on the Payroll Summary worksheet. Copy and paste the function into the range F4:F7.Enter a SUMIF function into cell G3 on the Payroll Summaryworksheet. The function should sum the Total Retirement Benefits in the range N3:N22 on the Payroll Details worksheet for each Practice listed in Column A on the Payroll Summary worksheet. Copy and paste the function into the range G4:G7.Enter a SUM function in cell B8 on the Payroll Summary worksheet that sums the values in the range B3:B7. Copy and paste this SUM function into the range D8:G8. Then format the range D8:G8 to the Accounting number format.Save the workbook and submit the completed Excel file.

Please use the following Podcast (Links to an external site.) that discusses the use of "audience centric" content. As you have learned from your text, audience centrics are now commonly used to better determine information to allow an understanding of your customers. By definition, "An audience centered approach is where one tailors a presentation to fit the audience. Audience centered approaches are used in public speaking where one considers factors such as the age bracket, socio-economic and educational levels of the audience. A good audience centered approach easily exceeds the expectations of the audience."Have you ever participated in this type of research? If so please explain when/how in detail. If not please provide an example of how a company would use this technique other an those discussed on the Podcast. It is all about understanding our consumer customers allowing professionals to better serve them in the future.