Encerrado

Help with Business Finance

This 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 Dropbox. 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 2005 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 2011 and a 6.5% increase each year in future prices.

Discussion Questions

1. Develop a forecasting model, justify its selection over other techniques, and project attendance through 2015.

2. What revenues are to be expected in 2014 and 2015?

3. Discuss the school’s options

2008

2009

2010

Game

Attendees

Opponent

Attendees

Opponent

Attendees

Opponent

1

34,500

Baylor

36,500

Oklahoma

36,100

TCU

2*

39,900

Texas

40,100

Nebraska

45,600

Texas Tech

3

38,000

LSU

39,500

UCLA

43,500

Alaska

4**

26,500

Arkansas

25,300

Nevada

27,000

Arizona

5

34,500

USC

36,500

Ohio

39,500

Rice

2011

2012

2013

Game

Attendees

Opponent

Attendees

Opponent

Attendees

Opponent

1

41,500

Arkansas

43,000

Indiana

47,000

TCU

2*

46,900

Missouri

49,300

North Texas

50,500

Texas Tech

3

43,500

Missouri

44,500

Texas A&M

46,000

Alaska

4**

30,500

Miami

34,000

Southern

36,500

Arizona

5

41,000

Duke

48,000

Oklahoma

50,000

Rice

*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.

Habilidades: Contabilidade, Processamento de Dados, Finanças, Intuit QuickBooks, Folha de Pagamento

Ver mais: usc game development price, university southern indiana, university north texas, university miami, university arizona, top ranking school, time miami, time dallas, tech game, texas tech university, texas data entry, spring texas, small home business, school reach, school ranking, sales help wanted, rice data entry, ranking school, one nevada, miami data, member rankings, member ranking, home business students, help wanted alaska, excel spreadsheets small business

Acerca do Empregador:
( 0 comentários ) United States

ID do Projeto: #10504562

10 freelancers estão ofertando em média $65 para este trabalho

$50 USD em 1 dia
(66 Comentários)
5.9
madhurna

Greetings! I am qualified accountant with nine years of experience in accounting and financial analysis. Please PM me to discuss the project further. Thank you.

$123 USD in 3 dias
(35 Comentários)
5.3
Abbadwajid

We are team of professional's with extraordinary abilities of professional communication, and knowledge. We all have a world class qualification (ACCA, CAT UK member) which equipped us to deal with any type of complex Mais

$55 USD em 1 dia
(40 Comentários)
5.1
kanchana1974

Hi, I am an experienced Finance & Accounting Professional with MBA Finance and CMA qualifications. I would be able to do Forecasting Attendance case study as per your requirements. I have good experience in A Mais

$105 USD in 3 dias
(32 Comentários)
5.2
mra56c16ba740e40

Analytical and performance driven financial professional with diversified experience in financial analysis, projection and investment. Expertise in investment strategies, asset valuation and portfolio management combin Mais

$111 USD in 3 dias
(8 Comentários)
4.6
rakeshwadhwani

Dear Valued Employer, I can add value to your project, by suggesting new ideas. I am fast and reliable. For further understanding why I am the right firm for your project, kindly check my profile, reviews, rating and Mais

$100 USD em 1 dia
(25 Comentários)
4.7
$25 USD em 1 dia
(42 Comentários)
4.8
Valuesolutions

Hello, contact me for high quality work delivered on time. I will work on you paper personally since i do not outsource some of the writers will outsource your paper which might delay the delivery time , this guarantee Mais

$24 USD em 1 dia
(5 Comentários)
4.0
$10 USD em 1 dia
(14 Comentários)
4.3
atalr42743

Hi! If you want it right and done the right way, your price quoted is very low. If you need it done and done the right way, I can do it but the price is $50. Rest assured that you'll get the correct solution alon Mais

$50 USD em 1 dia
(14 Comentários)
3.9