MARKETING PLAN: SITUATION ANALYSIS ASSIGNMENT INSTRUCTIONS

OVERVIEW
You must comprehensively address each topic (for this Section) and submit by the end of the
assigned module: week. For this assignment, you will continue developing your marketing plan,
focusing on the situational aspects of the plan. Current edition APA formatting is required.
INSTRUCTIONS
The following apply to all four marketing plan sections:
1. Weekly and earlier text readings will have covered many of the topics in this section.
Outside research is encouraged, referenced accordingly. Comprehensively discuss each
topic in this Section.
2. Submit this second section of your Marketing Plan (MP) attached as a MS Word file.
This section must address the following topics:
MARKETING PLAN: SITUATION ANALYSIS ASSIGNMENT
4.1. SWOT Analysis
4.2. Industry Analysis
4.3. Competitor Analysis
4.4. Company Analysis
4.5. Customer Analysis
You are encouraged to organize the Marketing Plan into four (4) sections from the beginning so
that the plan follows a logical sequence. The four (4) sections are shown below:

BUSI 330
Page 2 of 3
Marketing Plan Section Sequence
Section 1
MARKETING PLAN: COMPANY ANALYSIS ASSIGNMENT
1.0 Executive Summary
2.0 Company Description
3.0 Strategic Plan and Focus
3.1 Mission
3.2 Goals
3.3 Core Competency
3.4 Sustainable Competitive Advantage
Section 2
MARKETING PLAN: SITUATION ANALYSIS ASSIGNMENT
4.1. SWOT Analysis
4.2. Industry Analysis
4.3. Competitor Analysis
4.4. Company Analysis
4.5. Customer Analysis
Section 3
MARKETING PLAN: MARKETING STRATEGIES ASSIGNMENT
5.1. Marketing and Product Objectives
5.2. Target Markets
5.3. Points of Difference
5.4. Positioning
Section 4
MARKETING PLAN: FINAL PLAN ASSIGNMENT
6.1. Product Strategy
6.2. Price Strategy
6.3. Promotion Strategy
6.4. Place (Distribution) Strategy
7.0 Financial Data and Projections
7.1. Past Sales Revenues

MARKETING PLAN: OVERVIEW ASSIGNMENT INSTRUCTIONS
OVERVIEW
In many organizations, the assignment and completion of projects are increasingly completed in
months or years. The use of technology, such as teleconferences, video-teleconferences, and
computer technology has allowed organizations to reduce the costs of sending employees cross-
country or even overseas. To be successful in this kind of environment, you must adapt and react
to changing business dynamics in the marketplace. This assignment provides the experience to
help you learn to develop a dynamic marketing plan.
INSTRUCTIONS
You will complete a Marketing Plan that introduces a new product by an existing Fortune 500
company. If you have an idea that would be a great fit for any company (perhaps even one that
you are working for), be sure to seek the Instructor’s permission before you begin work on it.
Keep in mind that it is usually difficult to research smaller companies (especially privately held
ones unless you work for one and have good internal sources of information). You can change
the company’s name if you wish to disguise the discussion of their strengths, weaknesses, or
other “possibly sensitive” information.
This plan will be developed in stages (four sections) Each section assignment builds on previous
section toward the completed Marketing Plan (MP) due at the end of the course, which will
include all four sections.

1. Open the PlacerHills-09 start file. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor
2. Enable the content security warning.
3. Review formulas.
   1. Select cell C14 on the Calculator worksheet. The total commission is calculated by multiplying the selling price by the commission rate.
   2. Select cell C15. The IFS function checks the selling price (C12) to determine the split percentage (column D) based on the price group.
   3. Select cell C16. The IFS function checks the selling price (C12) to determine the administrative fee percentage (column E) and multiplies that percentage by the value in cell C15 to calculate the fee in dollars.
   4. Select cell C17. The net commission is calculated by subtracting the fees from the PHRE amount.
4. Build one-variable data tables.
   1. Select cell C20 and create a reference to cell C15.
   2. Select cell D20 and create a reference to cell C17. Both formulas depend on cell C12, the one variable.
   3. Use cell D8 as the column input for the data table (Figure 9-87). (You can use any percentage from column D because its value is replaced by the proposed rates in column B in the data table.)
      

      

   4. Decrease the decimal two times for all values in the data table.
5. Name cell ranges.
   1. Click the Price Solver worksheet tab.
   2. Click cell C12 and name the range Selling_Price. You cannot use spaces in a range name.
   3. Name cell C14 as Total_Commission and cell C17as PHRE_Commission.
6. Install the Solver Add-in and the Analysis ToolPak.
7. Use Solver to find target PHRE net commission amounts.
   1. Build a Solver problem with cell C17 as the objective cell. For the first solution, set the objective to a value of 50000 by changing cell C12. Use the GRG Nonlinearsolving method. Save the results as a scenario named $50,000.
   2. Restore the original values and run another Solverproblem to find a selling price for a PHRE commission of 75000. Save these results as a scenario named $75,000.
   3. Restore the original values and run a third Solver problem to find a selling price for a net commission of $100,000. Save these results as a scenario and restore the original values.
8. Manage scenarios.
   1. Show the $50,000 scenario in the worksheet.
   2. Create a Scenario summary report for cells C12, C14, and C17.
9. Create a histogram for recent sales.
   1. Click the Sales Forecast sheet tab and select cell G13.
   2. Create a bin range of 10 values starting at 350,000 with intervals of 50,000, ending at 800,000 in cell G22.
   3. Use the Analysis ToolPak to create a histogram for cells E5:E26. Do not check the Labels box and select the bin range in your worksheet.
   4. Select cell H3 for the Output Range and include a chart.
   5. Position and size the chart from cell K3 to cell V19.
   6. Edit the horizontal axis title to display Selling Price and edit the vertical axis title to Number of Sales.
   7. Edit the chart title to display Sales by Price Group.
   8. Select and delete the legend.
   9. Delete cells G13:G22 (Figure 9-88).
      

      

10. Save and close the workbook (Figure 9-89).
    

    

11. Upload and save your project file.
12. Submit project for grading.

The Decisions for Quarter Two Assignment

Must be completed through the Growing Your Business simulation.

Consider the following questions as you prepare your annual budget/plan (if the answer is “No” to any of the questions you may be at a Competitive Disadvantage and lack critical information to draw inference from):

• Did you

Request/purchase the Marketing Report and Business Intelligence Dashboard (BID)?

• Utilize the 4 available role plays for Qtr.2?

Consider in the R&D Projects?

• Must use the Role Play

It is critical you read the details of the role play very carefully and any questions should immediately be referred to the Help Desk.

• You can gain a differentiated competitive advantage through the effective use of role-playing.
• Some role players only provide qualitative information, while others provide the ability to negotiate quantitatively.
• Role-play is a scarce resource because of the limited number of calls per quarter.

Must submit your Quarter Two Budget Plan.

• Must not have a short-range outlook over the credit limit.

Periodically, as you modify inputs, use the “Model My Plan” at the lower right to see the impact of your decisions on the Financial Metrics.

• Input your financial decision and then click on the blue Submit My SRO button on the bottom right of the Quarterly Decisions screen.
• You must submit your Quarter Two Decisions prior to moving on this week’s Quarterly Business Review assignment.
• Part II: Second Quarter Quarterly Business Review (QBR). You must submit your Quarter Two Decisions prior to moving on to this week’s Quarterly Business Review assignment. Prior to beginning work on your Second Quarter Quarterly Business Review, review the content from the Suggestions for Quarter Two Decisions pop-up and your Business Intelligence Dashboard. The graphics in the dashboard should provide you with the trends (that is the time series data is growing) in data to critically analyze your competitors for the few two quarters their positions for the longer term.
• With the completion of Quarter Two, you are responsible for completing your second Quarterly Business Review (QBR). This is a qualitative and quantitative summary of your competitive performance for Q2. Business reviews (or Operational Reviews) are a routine part of annual corporate activities and are very cross-functional in nature. A major component of a QBR is around meeting commitments that are embedded in your budgetary planning process. Meeting commitments are seen explicitly in your Variances. These learnings are designed to enhance your performance in future Quarters.
• In your Growing Your Business simulation,

Evaluate quantitative and qualitative techniques for business analysis and decision-making.

• Utilize tools from finance, marketing, information technology and human resources management to manage the profitability of overall business operations in the second quarter.
• The Second Quarter Quarterly Business Review Assignment
• Must be completed through the Growing Your Business simulation.

After logging in, go to the Quarterly Decisions tab on the top right of the simulation site and then click on the Executive Summary tab to access the Quarterly Business Review section.

• Must be completed and submitted using all of the data provided including

Quarterly Pre-Tax Net Income relative to Plan for the Quarter

Review the Pre-Tax Net Income Chart Explanation

Download Pre-Tax Net Income Chart Explanationdocument

Cash Flow walk

Review the How to Read the Cash Flow Walk Chart

Download How to Read the Cash Flow Walk Chartdocument

• Pre-tax Net Income in Plan
• Must show that Hisco is on track to Meet/Exceed its Annual Net Income Commitment through an evaluation of both quantitative and qualitative techniques for business analysis and decision making.

Must create specific business tactics to achieve organizational survival and growth.

Project relevant subjects:

• Algorithms & Data Structures
• Artificial Intelligence
• Assembly Language
• Computer Science
• Cyber Security
• Databases
• Machine Learning
• Networking
• Operating Systems
• Website Development

Word counts: 2000 – 4000 (at least 1500 already in the Project Plan template that will provided to you to work on)

Brief

The project will be in four phases.

Phase one

Australian Agricultural Transitions

The main farming products for this assignment are potatoes because it is a common and cool seasonal vegetable in Australia. Most areas in Australia support the growth of potatoes because of the soils and seasons, which are more favorable. The most important agricultural digital transition I think would work well for potato farming in Australia is the use of Water Level Monitor.

About Water Level Monitor

Since many farmers sometimes face a lot of food losses due to uncontrolled water levels, Water Level Monitor would be an efficient technology to help Australian farmers keep track of the waters levels in tanks, dams and boreholes. Water Level Monitor helps farmers detect any issues early enough such as leaks in their water storages. It also saves on time and cost of labor fuel, making the farmers work easier.

Skills/ Training Programs farmers need to Use Water Level Monitor.

Farmers need to understand more about the Water Level Monitor, how to interpret the results they bring and how to use it. Farmers also need to learn about how to identify problems by using technology that will help manage their farming activities. They also need to understand critical decision-making, especially since they will need to solve all problems relating to the farm as soon as Water Level Monitor picks up a problem.

Data map for future training and education programs

After training the farmers on the above skills they must learn, they will need to have more training and education programs on how to boost crop yield in potato farming and how they can maintain their production at a high level. They also need to learn about prevention measures for decreased potato yields.

Strategy for Education Interventions

First, it will be important to identify the educational needs and specific areas the farmers need education on. Conduct a planning process for the farmers and train them progressively, ensuring all farmers are on track with all training. Check for feedback from the farmers about the education programs to see whether they are on track. It is also important to monitor their progress.

Strategy for capability Development Frameworks

When developing a capability development framework, it is important first to outline the principles of the competency framework. Identifying the purpose and structure of the competency model will also help in the framework. Assemble the project draft competency framework and get ready to start it.

Phase 2

Research and experiments that will lead to phase 3 and phase 4

Phase 3

product to engage and educate farmers to use innovations. It will be based on AI, machine learning, and the urge and want to use cloud storage and cybersecurity.

Phase 4

Delivery of the crop products, including resources needed and staff

Required:

Business case (document attached). The aim of the business case is to ask for seed money for phase one ONLY:

• developing a drone service like this one: https://taranis.ag/
• get the data into an interface (app, etc.)
• get farmers to be interested and engaged to use digital technologies
• provide farers with educational and training programs to get them engaged to use digital technologies such as the one above

Regional economic integration improves the political cooperation between the neighboring states and reduces the potential for violent conflict.

Do you agree or disagree? Provide your views with examples.

You are required to reply to at least two peer answers. These post replies must need to be substantial and constructive.

1-

Regional economic integration improves the political cooperation between neighboring states. Also, it helps to reduce conflicts in the states since it offers members in the states preferential trade access through custom unions, economic unions, common market, and free trade. In free and open trading activities, political cooperation between the states involved is enhanced. Peaceful political cooperation between states has numerous benefits for peaceful coexistence between the involved parties and members; hence, violent conflict abstains at all costs.

Regional economic benefits have advantages for the involved members of states. First, it creates job opportunities for the residents of these states – it helps remove restrictions on economic integration and labor movement; by so doing, state members coexist peacefully hence promoting political stability. Regional economic integration also creates trade by removing investment and trade barriers in the involved states. This factor promotes the growth rate of the involved states and lower prices for consumers; hence, peaceful coexistence is promoted. In addition, Regional economic integration also promotes consensus, cooperation, and increased trust in the involved states (Strachan, 2018). This factor has a high impact on political stability and peaceful coexistence in the involved states since it facilitates regional similarities, agreements, and understanding in the involved states.

An example of regional economic integration in North America is The North American Free Trade Agreement (NAFTA), whose primary goal is to encourage free trade within Mexico, the USA, and Canada. NAFTA has had numerous advantages in promoting peaceful existence and political stability. CAFTA-DR regional trade has also impacted peaceful and political stability within North America and Central American states.

2-

Regional economic integration is a course of action among countries that regularly incorporates the decrease or end of exchange boundaries and the coordination of money related and monetary approaches. Financial mix expects to lessen costs for the two buyers and makers and to increment exchange between the nations engaged with the arrangement.

I agree that regional economic integration very useful and will provide many benefits, including :

• It ordinarily prompts a decrease in the expense of exchange, further developed accessibility of labor and products and a more extensive choice of them, and gains in effectiveness that lead to more prominent buying power.
• It will quite often improve on the grounds that exchange progression prompts market extension, innovation sharing, and cross-line venture.
• Political collaboration among nations additionally can improve due to more grounded monetary ties, which give a motivation to determine clashes calmly and lead to more noteworthy security.

Example:

The most famous example on this subject that adequately illustrates the term is the European Union (EU). The European Union (EU) was made in 1993 and included 27 part states in 2022. Beginning around 1999, 19 of those countries have embraced the euro as a common money. As per information from The World Bank, the EU represented generally 18% of the world’s total national output.

The United Kingdom casted a ballot in 2016 to leave the EU. In January 2020 British legislators and the European Parliament casted a ballot to acknowledge the United Kingdom’s withdrawal. The UK authoritatively split from the EU on January 1, 2021.