• 3 PAGES
• Times New Roman, 12 point.
• Describe where the physician practice and the hospital fall on the continuum of patient care.
• Analyze how providers at each location try to return their patients to their highest level of functioning.
• Explain how a physician practice communicates with the hospital to foster high-quality, efficient, and effective patient care.
• Analyze three peer-reviewed articles that each discuss one of the topics above.
  • Description or summary presents the what of the article, but analysis will pursue the question of so what?
  • Why do these ideas matter and/or how are these ideas connected?
  • What are the potential gaps or questions that remain?

Organize your paper with the following headings:

• Title Page.
• Agenda.
• Introduction.
  • Professional introduction (1 paragraph).
    • You have license to be creative as you imagine the background you would bring to a position like this one.
  • Agenda (bullet points).
    • Preview the main goals of the lunch-and-learn.
    • Refer to some of the scholarly sources you will summarize.
• Continuum of Care.
  • Describe where the physician practice and the hospital fall on the continuum of patient care.
  • Analyze a peer-reviewed article that discusses where the physician practice and the hospital fall on the continuum of patient care.
• Care Quality.
  • Describe how a physicians practice maximizes patient care quality to return them to the highest level of function, addressing quality standards such as:
    • Maximizing value-based reimbursement.
    • Positive patient experience.
    • Maintaining operational efficiency.
  • Analyze a peer-reviewed article that discusses how a physicians practice maximizes patient care quality to return them to the highest level of function.
• Operational Approach.
  • Describe how the physicians practice and the hospital system communicate to foster high-quality, efficient, and effective care.
  • Analyze a peer-reviewed article that discusses how a physicians practice and the hospital system communicate to foster high-quality, efficient, and effective care.
• Conclusion.
  • Recap the main themes of your lunch-and-learn session.
  • Draw conclusions based on information contained in at least two of the articles you summarized.
  • Offer specific examples to demonstrate application of these ideas in everyday practice.
• References.

In this project, you will demonstrate your mastery of the following competencies:

• MBA-50716: Use descriptive statistics for business analysis
• MBA-50679: Perform regression analysis to address an authentic problem
• MBA-50880: Apply statistics in the business environment

Overview

You have been hired as a consultant by TC Ice Cream. As part of its expansion plan, TC Ice Cream wants to limit the number of flavors that they sell and only focus on those that are the most profitable. You will do an analysis of two flavors for a specific division and determine which flavor should be kept and which should be removed.

• Option A: Keep Flavor One
• Option B: Keep Flavor Two

The TC Ice Cream management team has tasked you with doing an in-depth analysis to determine which of the two options will be the most profitable, given the monthly advertising expense range of $500–$2,750. Use the division that you selected in Module Two and the two flavors that you selected for Milestone One. Consider the TC Ice Cream data set that contains data about quantity sold, advertising expenses, flavor rating, social media posts, and event promotions. 

Prompt

Part 1: Data Analysis Workbook 

Analyze the data from the provided TC Ice Cream data set and identify current and future trends and patterns in operations.

Complete the following visualizations for each flavor. The visualizations for Flavor One should be completed in the “Flavor One Analysis” sheet and the visualizations for Flavor Two should be completed in the “Flavor Two Analysis” sheet of the TC Ice Cream Excel Workbook. It is recommended that you use pivot table filtering to filter the data to the specific division and flavor you have selected.

Specifically, you must address the following rubric criteria:

1. Present the key descriptive statistics for the five quantitative variables in a table (quantity sold, advertising expenses, flavor rating, social media posts, and event promotions). The key descriptive statistics include the mean, median, standard deviation, and range.
2. Analyze the TC Ice Cream data to identify trends and patterns for the two flavors you have selected. For each flavor, create the following visualizations:
   1. Create a line chart (also known as a trend chart) using the qualitative variable Date and the quantitative variable Quantity Sold to provide a visualization displaying quantity sold by month.
   2. Create a line chart (also known as a trend chart) using the qualitative variable Date and the quantitative variable Flavor Rating (average) to provide a visualization displaying flavor rating (average) by year/quarter/month.
   3. Create a combo chart using the qualitative variable Date (x-axis) and the quantitative variables Quantity Sold (clustered column) and Advertising Expenditures (line – secondary axis).
   4. Create a combo chart using the qualitative variable Date (x-axis) and the quantitative variables Quantity Sold (clustered column) and total – Social Medial Posts and Event Promotions (line – secondary axis). Hint: create a pivot table variable to sum the social media posts and event promotions.
   5. Create a box and whiskers chart using the qualitative variable Quantity Sold. This will help identify any outliers in the Quantity Sold data.
   6. Create a histogram for the qualitative variable Flavor Rating. It is recommended to use the data analysis “add-in” and the analysis tool “Histogram” to create the data for the visualization.
3. Outliers: Identify any outliers that you see and explain how they have an impact on the overall admission and expense trends. Outliers are the data points that can have an impact on your averages and basic descriptive analysis.
4. Perform two bivariate regressions to provide recommendations.
   1. For the first bivariate regression for Flavor One, the dependent variable should be Quantity Sold. Choose an independent variable from one of the remaining attributes (Advertising Expenses, Flavor Rating, Social Media Posts, Event Promotions).
   2. Use the Flavor One Bivariate Analysis sheet.
   3. For the second bivariate regression for Flavor Two, the variable should be Quantity Sold. Choose an independent variable from one of the remaining variables (Advertising Expenses, Flavor Rating, Social Media Posts, Event Promotions).
   4. Which independent variable seems most appropriate to lead you to a monthly quantity sold of 3,000–12,000 gallons?
5. Perform two multivariate regressions to provide recommendations.
   1. For the first multivariate regression, the dependent variable should be Quantity Sold (the column in the data set). Choose two independent variables from one of the remaining attributes (Advertising Expenses, Flavor Rating, Social Media Posts, Event Promotions). Use the Flavor One Multi. Analysis sheet.
   2. Which combination of the attributes seems most appropriate to lead you to the expense range of $500–$2,750?
   3. For the second multivariate regression, the dependent variable should be Quantity Sold (the column name in the data set). You should choose two independent variables from one of the remaining attributes (Advertising Expenses, Flavor Rating, Social Media Posts, Event Promotions). Use the Flavor Two Multi. Analysis sheet.
   4. Which combination of the attributes would seem appropriate to lead you to a monthly quantity sold of 3,000–12,000 gallons?

Part 2: Final Recommendation Analysis PowerPoint PresentationCreate a PowerPoint presentation designed for the TC Ice Cream management team to share the results of your analysis and provide your final recommendation. 

1. Current State Analysis (slides 1–3): State the option (A or B) that you chose and three reasons for your choice.
2. Predictions and Trends Analysis (slides 4–6): Present the predictions based on the regressions that you have analyzed.
3. Executive Audience Summary (slide 7): Summarize your findings for an executive audience.

What to Submit

To complete this project, you must submit the following:

• TC Ice Cream Excel Workbook: Submit your completed TC Ice Cream Excel Workbook as an Excel file.
• Final Recommendations Analysis Presentation: Submit a PowerPoint presentation with 7 to 10 slides. There is no template for this assignment, so you may use an earlier presentation template or create your own design. Any sources should be cited according to APA style. Consult the Shapiro Library APA Style Guide for more information on citations.

https://www.mediafire.com/file/oxlwtbduazr6vxx/TC+Ice+Cream+Stacey+D.+(2).xlsx/file

ESOL COURSE

***** PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC*****

****** THIS ASSIGNMENT HAS 2 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED******

PART 1- MODULE 4- APPROACHES TO TEACHING ELL’s (ENGLIGH LANGUAGE LEARNERS)

After learning about the different approaches to teaching ELLs, which do you prefer and why? In your post, address your opinion on aspects such as: effectiveness of the program; best instructional fit in your classroom; etc.

Support your opinions with information from the CALLA article and SIOP website sources. 

SUBMISSION INSTRUCTIONS: Your initial post should be at least 200 words, formatted and cited in current APA style with support from at least 2 academic sources. 

PART 2- MODULE 5- WRITING and ELL’s (ENGLIGH LANGUAGE LEARNERS)You have read about teaching writing and using process writing in class.  Respond to the following:

1. What do you see as the challenges your own ELL students face (or may face in the future) in writing for your class? How can you address them?

2. How does process writing support literacy development in ELLs?

3. How do your own instructional approaches support ELL literacy learning? Are there any changes you would make based on the reading you have done in this module? Be specific.

SUBMISSION INSTRUCTIONS: Your initial post should be at least 200 words, formatted and cited in current APA style with support from at least 2 academic sources. 

Choose a country other than the United States, Canada, China, or Brazil. 

Research the culture of the country and its impact on doing business in that country.  Then prepare a short paper on the 5-8 tips on doing business in the country studied..  Here are two short videos with examples of such points for China and

Brazil.  China Links to an external site.

Brazil.Links to an external site.

This individual paper should be a maximum of five pages in length with all appropriate citations and bibliography.  (Five sources minimum).  Submit it through the portal for grading. 

APA7

Do a summary of the key points from this paper will be used

MGT SLP 4 Module – SLP STRATEGY IMPLEMENTATION AND MONITORING

MGT 499 STRATEGIC MANAGEMENT

The Module 4 SLP requires that you run a simulation titled: “The Platform Wars: Simulating the Battle for Video Game Supremacy.” Visit the Forio site and access the simulation. 

As the Chief Executive Officer (CEO), it is your task to make decisions one year at a time. As you do so, note how key data are changing, and take note of how your pricing, changes made to royalties, and new game subsidies change your profits and your market share. You may need to go through at least one practice run of the simulation in order to become familiar with it. 

At the start of the simulation, your market share is 50%. The price of your video game console is $250. Note that your competitor’s market share is 50%, but your competitor’s console price is $261.00 (hint: you are vastly underpriced to begin the simulation). 

One way of becoming familiar with the simulation is to change only the value, leaving the others constant. This will isolate the impact of one variable and will give you a sense of how the change in a single variable impacts revenue, market share, etc. (use the Dashboard and the financial statements to determine this).  

For example, if you leave all variables unchanged in Year 1 (price = $240; Game titles to subsidize = 3, and Royalties = 15%), your market share becomes 69% at the end of Year 1 (and my net profit is $48.0M).  

In contrast, if you reduce the console price to $230, your market share will become 71% at the end of Year 1 (net profit will be $33.6M). Importantly, if you increase the console price to $330, your market share at the end of Year 1 is 58%; however, your net profit is $140.8M.

As the CEO, your task is to find the best combination of changes in the three variables that both increase your market share and earn a maximum net profit. Remember that the changes are relative; there are no right or wrong answers.  

Be sure to take note of how the statements may be used to “control” your strategy. Remember that you need to cover your costs while simultaneously turning a profit and increasing your market share. For this SLP assignment, follow the assignment steps below for your three full-page paper with two scholarly sources.

1. Go to Platform Wars: Simulating the Battle for Video Game Supremacy https://forio.com/simulate/mit/video-game/simulation/
2. Click on “Play as an individual.”
3. Enter Rasheen as the “Screen ID,” then click “Login.”

In this web-based simulation, run the simulation a minimum of three times, noting the changes made each year, as well as your final results. Each year, you have three decisions to make: 

1. Determine the selling price of the video game console.
2. Determine the number of video games that your company will subsidize to enhance the development of new video games (and that can be played on your company’s video game console); be sure to note that the subsidy of each new game costs you $16.2M each year; and
3. Determine the royalty percentage you will require game makers to pay you (the higher the royalties, the more revenue you earn on new games, but the less inclined game makers are to develop new games).
4. Develop and discuss in your paper a table that shows the results from each simulation.

**Please see attached files for complete assignment details**

https://www.dropbox.com/scl/fi/es275uvj52rrgprazn8wu/MGT-499-SLP-4-Strategic-Management-INFO.docx?rlkey=4vf66t961cf28sq6x5pzwqcmf&dl=0

https://forio.com/simulate/mit/video-game/simulation/

https://www.dropbox.com/scl/fi/jtcg7s7w4zen1cv6dqqwi/apa-7th-assignment-template-v.1-3-71906-3.docx?rlkey=s95y7c9vfw6wkasx079jpwlro&dl=0