Using the community you are assessing for the community assessment assignment, please discuss your communities strengths. Why is it important to use a strengths-based assessment when completing a community assessment? How do you plan to use your chosen community’s strengths to leverage an improvement in the community’s health?

give detailed description of Bilroth 2 procedure

Purpose of Assignment

The purpose of this assignment is the creation of a research analysis. Every day, consumers make millions of decisions that impact the marketplace and influence firms’ decisions. Firms use economic concepts, models, and other “tools” of economics to help determine pricing, output, and profit maximization. As an MBA student of economics, you can apply the “tools” of economics to microeconomic and macroeconomic data to create recommendations for how firms can maximize revenue, profit and market share.

Assignment Steps

Resources: Tutorial help on Excel^® and Word functions can be found on the Microsoft^® Office website. There are also additional tutorials via the web offering support for Office products.

Scenario: Imagine you are a business consultant to a firm of your choice. You have been asked to analyze, advise, and create recommendations on how the firm can ensure its future success in its current market.

Work with your instructor to choose a firm that matches the following criteria: a publicly-traded company operating in the U.S. market. Note: A publicly-traded company is a private-sector firm owned by its shareholders/stock holders.

Prepare a minimum 1,050-word analysis of economic data and business data to explain how the core economic principles impact the sustainability of the firm and what actions the firm can take to ensure success.

Address the following:

• Identify the market structure your chosen firm operates in, analyze your chosen firm’s current market share, and identify the firm’s local/global competitors. Analyze the barriers to entry in this market to illustrate the potential for new competition and its impact on your firm’s future in the market. Hints: Be sure you review the barriers to entry discussed in the course text. You might consider presenting the data graphically.
• Identify and explain trends in current macroeconomic indicators for last three years including:
  • Current stage of the business cycle.
  • Real gross domestic product (GDP).
  • Inflation as measured by the consumer price index (CPI).
  • Unemployment rate.
  • Federal funds rate.
  • Current rate for borrowing funds such as the so-called “prime rate.” Note: A requirement of the Week 1 Influence of Economics on Household Decision Making report was to gather data on the CPI, GDP, and interest rates, so you should consider reviewing the feedback you received on the Week 1 report.
• Evaluate trends in demand over last three years and explain their impact on the industry and the firm. Include quarterly (last two quarters) and annual sales (last three years) figures for the product your firm sells. Create business strategies by analyzing information and data related to the demand for and supply of your firm’s product(s) to support your recommendation for the firm’s actions. Remember to include a graphical representation of the data and information used in your analysis.
• Examine available, current data and information, such as pricing and the availability of substitutes, and explain how you could determine the price elasticity of demand for your firm’s product. Assess how the price elasticity of demand impacts the firm’s pricing decisions and revenue growth.
• Apply the concepts of variable and fixed costs to your firm for informing its output decisions. For instance, analyze how different kinds of costs (labor, research and development, raw materials) affect the firm’s level of output.
• Based on the data gathered and analysis performed for this report write a conclusion in which you:
  • Create business strategies, including price and non-price strategies, based on your market structure to ensure the market share and potential market expansions and explore global opportunities for your business in a dynamic business environment and provide recommendations.
  • Develop a recommendation for how the firm can manage its future production by synthesizing the macroeconomic and microeconomic data presented.
  • Propose how the firm’s position within the market and among its competitors will allow it to take your recommended action.
  • Recommend strategies for the firm to sustain its success going forward by evaluating the findings from demand trends, price elasticity, current stage of the business cycle, and government policies.

Cite a minimum of three peer-reviewed references and a minimum of two government economic data sources/references.

Format your assignment consistent with APA guidelines.

I need this lab put into a crows foot diagram. Ive posted the last one I did for a example. Screenshots are in the document provided

Using the AdventureWorks database, query “Sales.SalesOrderDetail” table to find out the total number of parts associated with each of the following SalesOrderIDs: 43660, 43670, and 43672. This task should be completed in a single query. Submit the SQL statement used to accomplish this task.

oHow many rows were affected?

9 Rows

oProvide a screenshot of the result set.

2. Query “Sales.Store” table to obtain the list of “Name” and “SalesPersonID” where the store name starts with the letters “g” through “j” and the SalesPersonID is greater than 283. Make sure that the list is sorted by “SalesPersonID” and then by “Name” fields in a descending order. Be sure the query returns all the required rows.

a.Submit the SQL statement used to accomplish this task.

The SQL Statement I used was thus:

SELECT Name, SalesPersonID

FROM Sales.Store

WHERE Store.Name >= ‘G’

AND Store.Name < ‘K’

AND SalesPersonID > 283

ORDER BY SalesPersonID, Name DESC;

b.How many rows were affected?

16 Rows

c.Provide a screenshot of the result set.

The Business scenario has been attached please look it over and use it for this assignment.

Resources: Week Two SWOT Analysis assignment, Week Three Staffing Matrix, and Week Four Business Recommendation assignment

Now it is time to put all of the elements of your business plan together and present it to the governing board of the Community Hospital. This board is comprised of the president of the organization, four business leaders from the community, and three leaders of the medical staff.

Create a 12- to 15-slide Microsoft® PowerPoint® presentation that summarizes your business plan. Include the following in your presentation:

• Evaluate the market and demographic data provided in the scenario.
  • Include and discuss the SWOT analysis.
  • Indicate the location you selected for the urgent center and why.
• Analyze the type of corporation proposed for the center.
  • E.g., department of the hospital or an LLC
• Evaluate the equipment and technology needed at the center to deliver the intended services.
  • Do you recommend leasing or purchasing the equipment?
  • How does your recommendation impact the revenue and expenses?
• Analyze quality management elements applicable to the center and the proposed services.
  • How you will monitor the quality of care at the center?
• Analyze financial information needed to sustain the center
  • What are your projected revenue, expenses, and staffing figures?
• Provide your final recommendation for the center based on your business plan analysis.

Format your assignment according to APA guidelines. Include a title slide, detailed speaker notes, and a references slide.

If you use resources outside of the information provided in the assignment, be sure to cite your references using correct APA formatting.

Click the Assignment Files tab to submit your assignment.

Materials

• Business Plan Scenario