InstructionsThis week you will be doing the case study entitled, "Forecasting Attendance" (see below). All cases and problems must use Excel QM. ALL CALCULATIONS MUST BE SHOWN. Spreadsheets must accompany a formal analysis in APA format (Word) and submitted through Assignment for credit. Assignments not turned in in APA format will not receive credit. Please read the rubric before starting your assignment. Do not recopy the case or any significant portion of the case in your document. Rubric for a case study is below (after the case.)Case - Forecasting Attendance Southwestern University (SWU), a large state college in Stephenville, Texas, 30 miles southwest of the Dallas/Fort Worth metroplex, enrolls close to 20,000 students. In a typical town–gown relationship, the school is a dominant force in the small city, with more students during fall and spring than permanent residents.A longtime football powerhouse, SWU is a member of the Big Eleven conference and is usually in the top 20 in college football rankings. To bolster its chances of reaching the elusive and long-desired number-one ranking, in 2012 SWU hired the legendary Bo Pitterno as its head coach. Although the number-one ranking remained out of reach, attendance at the five Saturday home games each year increased. Prior to Pitterno’s arrival,attendance generally averaged 25,000 to 29,000 per game. Season ticket sales bumped up by 10,000 just with the announcement of the new coach’s arrival. Stephenville and SWU were ready to move to the big time! The immediate issue facing SWU, however, was not NCAA ranking. It was capacity. The existing SWU stadium, built in 1953, has seating for 54,000 fans. The following table indicates attendance at each game for the past six years. One of Pitterno’s demands upon joining SWU had been a stadium expansion, or possibly even a new stadium. With attendance increasing, SWU administrators began to face the issuehead-on. Pitterno had wanted dormitories solely for his athletes in the stadium as an additional feature of any expansion. SWU’s president, Dr. Marty Starr, decided it was time for his vice president of development to forecast when the existing stadium would “max out.” He also sought a revenue projection,assuming an average ticket price of $20 in 2018 and a 6.5% increase each year in future prices.Discussion Questions1. Develop a forecasting model, justify and compare its selection over other techniques, and project attendance through 2019. 2. What revenues are to be expected in 2018 and 2019?3. Discuss the school’s options.Southwestern University Football Game Attendance, 2012-2017201220132014Game AttendeesOpponentAttendeesOpponentAttendeesOpponent134,500Baylor36,500Oklahoma36,100TCU2*39,900Texas40,100Nebraska45,600Texas Tech338,000LSU39,500UCLA43,500Alaska4**26,500Arkansas25,300Nevada27,000Arizona534,500USC36,500Ohio39,500Rice201520162017Game AttendeesOpponentAttendeesOpponentAttendeesOpponent141,500Arkansas43,000Indiana47,000TCU2*46,900Missouri49,300North Texas50,500Texas Tech343,500Missouri44,500Texas A&M46,000Alaska4**30,500Miami34,000Southern36,500Arizona541,000Duke48,000Oklahoma50,000Rice*Homecoming games**During the fourth week of each season, Stephenville hosted a hugely popular southwestern crafts festival. This event brought tens of thousands of tourists to the town, especially on weekends, and had an obvious negative impact on game attendance.Rubric for case study as follows:Rubric: Case Study AnalysisCriteriaExcellent AveragePoor Points60-75 points50-59 points1-49 pointsAnalysis fully addresses all three questions listed in the case. Analysis is consistent and supported by Excel QM spreadsheets as a separate document.· Analysis fully answers all three questions listed in the case. Analysis is consistent and supported by Excel QM spreadsheets as a separate document. All calculations are shown.· Analysis partially answers all three questions listed in the case. Analysis is consistent and supported by Excel QM spreadsheets as a separate document. Most calculations are shown.Analysis partially answers less than all three questions listed in the case. Analysis is not consistent with supporting Excel QM spreadsheets. Most or all calculations not provided.Paper must be in APA format including:Cover Page,Running Head,TitlesReferences· Entire assignment is in Proper APA format and includes all required parts.· Assignment is in partial APA format. Most but not all requirements met.· Few to none of the APA format requirements met.Academic Integrity and Syntax:· Academic Integrity· Spelling and grammar· Proper citations· Work is original.· Adheres to all spelling and grammar rules· Uses proper citations· Work is original· Few grammar and spelling errors· Use of citations – proper and improper· All or portions of the work are not original· Follows few or does not follow grammar and spelling rules· No citationsTimely, successfully submitted through Turn-it-in submission· Entire assignment successfully submitted through Turn-it-in on or before due date.· Entire assignment submitted, but not successfully through Turn-it-in on or before due date.· Part or entire assignment submitted within 3 days after the due date.

Timeliness and transparency in government has become an important issue with so many governmental entities in such poor financial condition. Do you think that governments should have to create the CAFR on a quarterly basis and release it to the public? Why or why not? Do the discussion first then response each posted below Posted1 The Comprehensive Annual Financial Report (CAFR) is an accurate and detailed document that provides a City’s financial condition and performance. It was designed to keep the City Council and citizens informed. I think that preparing CAFR’s on a quarterly schedule is a bit excessive and overwhelming. Brief and necessary updates throughout the year would suffice. There are so many fluctuations and adjustments made within a year, so it's best to just consolidate them all. Plus it gives viewers to observe true results and provide realistic suggestions. Quarterly reports will increase frustration, confusion, and misinformation. Extended time gives the state more time to properly observe the responses to financial decisions and generate a detailed report. This does not dismiss timeliness and transparency as these two factors develop trust. Posted2 Hello Everyone, A Comprehensive Annual Financial Report (CAFR) is one of two reporting requirements for governmental agencies. The CAFR is the equivalent to an annual report for for-profit organizations. It contains 3 sections: Introduction- giving general informationFinancial- providing the auditor's report, MD&A, government-wide-financial statements, fund financial statements, notes to the financial statements, and other supplementary informationStatistical- giving trend data and nonfinancial data (Wiley, 2022). I do feel that the government should produce a CAFR quarterly because timeliness and transparency are two of the most important aspects in financial reporting. The public has the right to know the financial position of the government and that can change dramatically throughout the course of a year. Also, preparing a CAFR quarterly would give users of the report a chance to compare it to a report from 3 months prior rather than one year prior. Posted 3 A CAFR, or Comprehensive Annual Financial Report, is a detailed presentation of the state's financial condition. it's broken down into three sections. The first section is an introduction with a transmittal letter. This is followed closely by the financial statement, which details auditor reports, government-wide financial statements, fund financial statements, required supplementary information, combining financial statements, and schedules. The final section is the statistical section that includes additional financial, economic, and demographic information. Timeliness and transparency in government are extremely important, and for this reason, I do believe that governments should have to create a CAFR on a quarterly basis and release it to the public. There are many things that can and do happen in government that affects where the funds go. Some of these things include scandals, bribery, and corruption. a regular report of exactly how much money is used and where its used ensures transparency and allows the public to better understand what's going on.