InstructionsUsing your learning from MBA 520 and MBA 640, analyze the projected costs, revenue streams, and net present value for the concept from launch until two years after the breakeven point. Be sure to include a budget, an assessment of assets and liabilities, your anticipated sources of funding, and the associated costs of attaining that capital as part of the analysis. Justify the analysis with relevant primary and secondary data in an appendix, specifying any relevant assumptions and limitations. You should include, among other support, sales forecasts, cash flow statements, income projections, and any other relevant calculations or financial reports. For additional details, please refer to the Milestone Four Guidelines and Rubric document and the Final Project Guidelines and Rubric document.

Assignment 3: Course Project—Developing a Marketing StrategyFor the course project of this course, you will select an organization, analyze the market for the organization’s product/service, analyze the organization’s current marketing strategy, and justify recommendations for the marketing strategy to make the organization more effective.The major project assignments are due in Week 3 and Week 5. It will take more than a week’s effort to adequately complete the major assignments. Plan time to start research and work on those assignments earlier than the week in which they are due.To assist you in planning for the course project, the following table provides a high-level overview of the project deliverables during the course.Course Project—Developing a Marketing StrategyWeek numberTask1Choosing an OrganizationSelect an organization to study.Perform a SWOTT analysis to identify the trends affecting the industry—the industry in which your specific organization is a participant.Create a mission statement for the organization.2Collecting Customer DataStudy key elements of the customer relationship management (CRM) technology.Determine how the organization can make the best use of the CRM technology to improve customer loyalty.3Marketing the Product/ServiceCreate the service delivery process for the organization.Identify the contact point failures and prescribe improvements.Position the brand around the improvements. In what ways might you reposition the organization's brand as a result of the changes in delivery or process?4Developing the New Product/ServiceIdentify potential stakeholders involved in new product/service development.Analyze the role stakeholders should play in launching the new product/service.Justify strategies to involve stakeholders in the new product/service development.5Creating the Communication StrategyCreate an integrated marketing communication (IMC) strategy for the new product/service and any adjustments in the brand.Propose a pricing strategy that the organization should follow.Choosing an OrganizationIn this first week of your course project, select an organization to study in depth over the next five weeks. Each week, your assignment will require you to evaluate this organization. You may use an organization you currently belong to, a past organization, or an organization that you identify through research. Be sure to review the types of information you will need for the project (all five weeks) before choosing your organization. You might need to create some hypothetical details to fill gaps in researched information. However, the project should use as much real information as possible.You must have your organization approved in writing by your instructor before moving forward with the assignment. Contact your instructor early in the week to gain approval.For the Week 1 paper, complete the following tasks:Summarize key details about your organization. What does it do? Who are its customers, clients, prospects, or constituents? For convenience in this class, we will call them customers.Perform a SWOTT analysis, placing particular emphasis on long-term trends affecting your organization and what your competitors are doing.Analyze the organization’s mission statement. Does it address the following core components:Customers—who do we serve?Product/service—what do we provide?Market—who/where are our customers?Core competencies—how do we provide or deliver our product/service? What gives us a competitive advantage?Measurability—how do we know when we are successful?Defend a new/revised mission statement. It should be a succinct statement of what the organization is, what it does, and who its customers are. Be sure to support why your revisions are an improvement to the current mission statement.Submission Details:Present your analysis as a 3- to 4-page report in a Microsoft Word document formatted in APA style.On a separate page, cite at least three peer-reviewed sources using APA format.Name your document SU_MBA6011_W1_A3_LastName_FirstInitial.doc. For example, if your name is John Smith, your document will be named SU_MBA6011_W1_A3_Smith_J.doc.By Tuesday, August 1, 2017, submit your response to the W1 Assignment 3 Dropbox.

please answers these questions and follow the instructions belowVIEW:InstructionsPrevious AttemptsBest PracticesGuided Project 7-3Windows MacAgents for Placer Hills Real Estate (PHRE) have built a worksheet to help clients compare monthly payments. You clear and reset data validation, insert a spin box form control, and save the workbook as a template.[Student Learning Outcomes 7.1, 7.2, 7.3, 7.4]File Needed: PlacerHills-07.xlsx (Available from the Start File link.)Completed Project File Names: [your name]-PlacerHills-07.xlsxSkills Covered in This ProjectSave a workbook as a template.Find and clear data validation settings.Set data validation with an error alert.Insert a spin box form control.Protect a worksheet.Create a workbook from a template. Open the PlacerHills-07 start file. Click the Enable Editing button. The #NUM! error appears in three cells because arguments for the formulas in those cells are missing. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.Find and clear data validation settings. Click the Find & Select button [Home tab, Editing group] and choose Go To Special. Select the option button for Data validation (Figure 7-62).Figure 7-62 Locate cells with data validation using Go To Special Click OK. Cells with data validation settings are highlighted. Click the Data Validation button [Data tab, Data Tools group]. Click Clear All on the Settings tab and leave the dialog box open.Set data validation with an error alert. Verify that the following cells in the worksheet are selected: C9:C12, H9, H11, H13:H14, and H16. (If they are not, close the Data Validation dialog box, select the cells, and click the Data Validation button [Data tab, Data Tools group].) Click the Allow arrow and choose Decimal on the Settings tab. Click the Data arrow and choose greater than or equal to. Click the Minimum box and type 0. Click the Error Alert tab and verify that the Show error alert after invalid data is entered box is selected. Verify that Stop displays as the Style. Click the Title box and type Required. Click the Error message box and type Please enter a positive value. including the period (Figure 7-63).Figure 7-63 Data validation error alert Click OK.Display the Developer tab on the Ribbon if it is not shown. Select the Options command [File tab] and click Customize Ribbon in the left pane. Select the Developer box in the Main Tabs group and click OK.Insert a spin button form control. Show the gridlines on the worksheet [View tab]. Click the Insert Controls button [Developer tab, Controls group]. Click the Spin Button (Form Control) button. Draw a control directly over cells I21:I22 (Figure 7-64).Figure 7-64 Spin button form control Right-click the control and choose Format Control. Click the Minimum value box on the Control tab and type 1. Set a maximum value of 8. These are agent identification numbers (1 through 8). Click the Cell link box and select cell H22. The choice made by the spin button will be placed in this cell (Figure 7-65).Figure 7-65 Options set for spin button control Verify that the 3-D shading box is selected and click OK. The linked cell displays the minimum value 1. Click cell D4 to deselect the control.Protect the worksheet for data entry. Select cells D4:E4. Press Ctrl and select cells C9:C12, H9, H11, H13:H14, H16, H22, and E22. Click the Format button [Home tab, Cells group]. Select Lock Cell to remove the Locked property. Click the Protect Sheet button [Review tab, Protect group]. Allow the options to select locked and unlocked cells. Do not use a password. Click OK. Delete the contents of cells C9:C10, H9 and H16. Select cell C9, type 450000, and press Enter. The cells are formatted and formulas are calculated. Type 275000 in cell C10 and press Enter. Select cell H9, type 485000, and press Enter. Type 75000 in cell H11. Enter data in cells H13, H14, and H16 as shown in Figure 7-66. The term is 30, the rate is 4.25%, and estimated taxes and insurance are $850.Figure 7-66 Completed worksheet for Excel 7-3 Click the spin box control arrows to select 3 as the agent ID. Select cell E22, type 1875, and select cell D4.Remove the Developer tab. Click the Options button [File tab] and click Customize Ribbon in the left pane. Deselect the Developer box in the Main Tabs group and click OK. Save and close the workbook. Upload and save your project file. Submit project for grading.