Case Problem: Capital State University Game-Day Magazines Page 783 (use

Case Problem:  Capital State University Game-Day Magazines
Page 783 (use data file magazinesCSU.xlsx attached below)

Managerial Report 

Use the concepts you have learned from Chapters 2, 3, 7, and 11 to write a study document  that will help Kris analyze football magazine sales in Years 1 through 9 to determine an order amount for Year 10.

Address items 1-3 and explain in detail how you developed your solution and why you think your analysis is accurate using the concepts and tools you learned throughout this course:

  1. There is a considerable amount of data available in the file Magazines CSU, but not all of it may be useful for your purposes here. Are there variables contained in the file Magazines CSU that you would exclude from a forecast model to determine football magazine sales in Year 10? If so, why? Are there particular observations of football magazine sales from previous years that you would exclude from your forecasting model? If so, why?
  2. Based on the data in the file Magazines CSU, develop a regression model to forecast the average sales of football magazines for each of the seven home games in the upcoming season (Year 10). That is, you should construct a single regression model and use it to estimate the average demand for the seven home games in Year 10. In addition to the variables provided, you may create new variables based on these variables or based on observations of your analysis. Be sure to provide a thorough analysis of your final model (residual diagnostics) and provide assessments of its accuracy. What insights are available based on your regression model?
  3. Use the forecasting model developed in Part 2 to create a simulation model that Kris can use to estimate the total football magazine sales amounts in Year 10. Your simulation model should have seven uncertain inputs: one input for football magazine sales at each CSU game in Year 10. Then you should sum these sales amounts for each individual game to create a total football magazine sales amount for Year 10.

Submit a .doc/.pdf for the final report and attach the .xlsx file you used for developing the model/simulation.

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Instructions Include an explanation as to how Walden’s vision, mission,

 Instructions  Include an explanation as to how Walden’s vision, mission, goals, and social change initiatives relate to your professional and academic goals and to your becoming a scholar-practitioner. Also include an explanation for how the Walden MSN Program Outcomes and perspectives relate to your professional and academic goals and to

Case Study Directions Read in your textbook Case #1, “Fixer

Case Study Directions Read in your textbook Case #1, “Fixer Upper: Expanding the Magnolia Brand” and watch the 3-minute video, Chip and Joanna Gaines Reveal the Story Behind the Start of Their Own Business Links to an external site. Additional information can be found at Magnolia Inc.’s website: https://magnolia.com, or

review the article “Development of a Theory-Based (PEN-3 and Health

  review the article “Development of a Theory-Based (PEN-3 and Health Belief Model), Culturally Relevant Intervention on Cervical Cancer Prevention Among Latina Immigrants Using Intervention Mapping.” Consider this article and everything you have learned throughout the SLP  that addresses the following: Explain how you would approach a health education program

Unit I Scholarly Activity Define each component of democracy in

   Unit I Scholarly Activity Define each component of democracy in the space provided below. Your definition should be no more than three sentences in length (30 words each). Rank the components of American democracy on a scale of 1 to 9, with 1 being the most important to a

Deborah Fenton, head of business analytics in the business banking

   Deborah Fenton, head of business analytics in the business banking unit, developed an AI tool as part of the digital transformation of Nedbank Group in South Africa.  She engaged her clients through a design thinking approach to developing and testing the tool.  She needed to convince the executive committee

Do you think that animism is common in world religions?

Premium Paper Help is a professional writing service that provides original papers. Our products include academic papers of varying complexity and other personalized services, along with research materials for assistance purposes only. All the materials from our website should be used with proper references.

Influences on the Declaration of Independence

 In this module’s discussions, we examined the various influences on the Declaration of Independence. For this project, we will continue investigating these themes by analyzing the differences between Jefferson’s original draft of the document and the version that was eventually adopted by the Second Continental Congress, after two days of

Citation- PLEASE USE APA Topic- how does stress affect Polycystic

Citation-  PLEASE USE APA Topic- how does stress affect Polycystic ovary syndrome Aim: The aim is to review a substantial body of literature on a biobehavioral health topic and present a synthesis of current knowledge on the subject.   Special Considerations: The Narrative Review should not be formatted following the

We have discussed many of the tools and processes that

We have discussed many of the tools and processes that are a part of TQM; however, there are additional challenges in implementing TQM in a health care setting.  Describe two of the more significant challenges that the director of a major hospital must address in trying to launch a TQM

To complete this assignment u have to completely read attached

To complete this assignment u have to completely read attached case studi before answering the questions below. After completing your Aquifer Case Studi, answer the following questions using the latest evidenced based guidelines: • Discuss the questions that would be important to include when interviewing a patient with this issue.

Either use your workplace as an example or research an

Either use your workplace as an example or research an organization that has been involved in organizing a relief effort during a crisis. Show how they problem-solved to alleviate bottlenecks in the supply chain. Provide graphs and charts as necessary The 6-10 page formal report should be in APA style.

Option 2: A new social media app is offering itself

  Option 2:  A new social media app is offering itself to you for free. If you upload a picture to it, the app will show how you will look at 10 years. John Doe, a friend of yours, says not to use the app as it will then possess

Creating a Compelling Vision

Leaders today must be able to create a compelling vision for the organization. They also must be able to create an aligned strategy and then execute it. Visions have two parts, the envisioned future and the core values that support that vision of the future. The ability to create a

Section-2Information Technology and Organizational Learning Assignment: Complete the following question

 Section-2Information Technology and Organizational Learning  Assignment: Complete the following question in 1 page and adhere to APA formatting standard Review the section on knowledge creation, culture, and strategy.  Explain how balance scorecards impact knowledge creation, culture, and strategy.  Why are these important concepts to understand within an organization? Article/Section for

You have to writing a full thesis for a business

You have to writing a full thesis for a business plan, the business plan is for a start-up company named look up, look up is a social media platform that brings both formal network and entertainment  community together, it is like instagram and linkdin combined. you have to write a

After completing the readings, videos, and the Guide on Developing

  After completing the readings, videos, and the Guide on Developing HRM Plan, you should have an understanding of the multifaceted processes behind the development and maintenance of quality healthcare environments. In this assignment, you will formulate a strategic approach to human resource management in response to an organization in trouble.

TOPIC is Telehealth technology, impact on patient outcomes PPT Presentation

TOPIC is Telehealth technology, impact on patient outcomes   PPT Presentation will have 8-10 slides, NOT including the title and reference slides. You will also need to include graphics to make your slides interesting. You are to create bullet points for each slide, not including the title and reference slides.

Your team will have to find a problem to solve

Your team will have to find a problem to solve that deals with an organizational issue that will be solved through the use of data mining.  There must be data mining calculations and graphics in the final deliverable. The team should meet prior to the residency weekend and agree to