Excel Model For Aggregate Production Planning Aggprods Online Case Study Analysis

Home >> Business >> Excel Model For Aggregate Production Planning Aggprods

Excel Model For Aggregate Production Planning Aggprods Case Study Solution & Analysis


NASCAR (National Association for Stock Car Auto Racing) is a company performing series of Stock Car racing in United States and acting as an approving body for driving the rules for Stock Vehicle Racing. 2) Stock Cars And Truck Racing by NASCAR is the 2nd largest spectator sport, with highest number of sponsors. 1) The other sources of earnings for Excel Model For Aggregate Production Planning Aggprods Case Study Solution consists of; 10% of the overall profits from tv rights, sanctioning costs i.e. $1-2 million per race, and licencing NASCAR brand to companies.

NASCAR has a closed business culture with the non-interventionist technique. The building of Cars and truck of Tomorrow by NASCAR, with an objective of security for the motorists, brought numerous tensions amongst the stakeholders of the sport.
Executive Summary
The interaction audit, carried out in 2010, revealed that regardless of the truth that the business extremely rely on the communications in between its stakeholders, there was no recognizable company communication technique. (

The audit pointed out various doing not have of NASCAR in terms of absence of internal integration, absence of fan management strategy and lack of digital and social media of marketing.

Excel Model For Aggregate Production Planning Aggprods Case Study Analysis viewers was highly devoted to the sport and the brand names related to the NASCAR, making it appealing for sponsors and corporate marketers.

Issue Statement.

The company is presently facing the issue of decreasing rates of presence at racing tracks and rates of tv audiences. This can put a substantial impact on its profits from sponsors, media rights, and from other sources of income.

Situational Analysis.

Although the business was quite successful till 2005 with its traditional marketing strategies, however right after 2005 the company starts facing various problems consisting of decrease of its fan base. Several external as well as internal aspects are responsible for the decline. Internal aspects include; insufficient investment in social media and other digital medias of.

Fan base of NASCAR consisted of married males with a typical age of 47, which passes their fandom to their youngsters and develop generational commitment. The family system in America was altering resulting in reduction of impact of married male fan base over their children. Along with it perceptions about car was also altering with perceiving vehicle a lorry to reach at point B from point A, rather than as an enjoyable task. Other challenges for Excel Model For Aggregate Production Planning Aggprods Case Study Solution consists of the shift of its fans to other sports as they were improving their fan's experience allowing access to their broadcasts out of the homes through jumbo turns, Wi-Fi access, and so on. These all difficulties were tending the company to modify its marketing methods.

SWOT Analysis.


NASCAR core proficiencies includes it has rights of dictating guidelines as sanctioning body. Guidelines and regulations regarding professional stock cars and truck racing are determined by NASCAR like if any team with needed abilities and resources can enter into races by following rules and guidelines determined by NASCAR. All the events of NASCAR are sponsored by corporates since of greatest brand name commitment of fans towards brand names advertised by Excel Model For Aggregate Production Planning Aggprods Case Study Solution.

Weak points.

Weaknesses of NASCAR includes its close culture which is non collective. Excel Model For Aggregate Production Planning Aggprods Case Study Solution develops Automobile of Tomorrow without collaboration so result is that drivers did not like that principle. It was also discovered that NASCAR had no reliable technique for company communication.
Porter's 5 Forces Analysis

NASCAR normally utilized to rely on standard media sources like regional paper for promotion of its sports. NASCAR also came to understand from these standard media outlets that sport was challenging to cover. When sports fans were asked relating to popular celebrities and stars then NASCAR motorist was not found even in leading twenty reactions.


Threats in SWOT analysis are specified as external aspects that can risk to business's success. Because if there is financial down turn then people would be having less return on financial investment, Economic down turn was experienced in late 2000 which can be threat for NASCAR. Earning of individuals would be effected and they would be more conscious in spending their money. Economic down turn likewise results in increase fuel costs which likewise impacted NASCAR. Due to the fact that fans of NASCAR used to attend its occasion from fars away. NESCAR had a guideline of 65/25/10 for earnings circulation. 65 percent incomes from media rights would be dispersed to race course, 25 percent earnings would be dispersed to contending team and staying 10 percent would be retained by NESCAR which is approving body. Contending team wished to increase their portion of profits from 25 percent due to the fact that of increase in operating cost of a race team and likewise there is decrease in the number of full-season sponsorship. NESCAR likewise faces threats from other sponsors because they are making massive investments to enhance experience of fans. For instance which includes updating existing opportunities, developing new avenues, offering Wi-Fi facility and also supplying other interactive mediums to engage sports on smartphones. Fan base of NASCAR consisted of married males with a typical age of 47, which passes their fandom to their children and produce generational loyalty. The difficulty is that the household system in America was changing resulting in reduction of impact of married male fan base over their youngsters. Together with it understandings about car was likewise altering with perceiving vehicle a vehicle to reach at point B from point A, rather than as a fun project. Now if Excel Model For Aggregate Production Planning Aggprods Case Study Help make significant investments in brand-new sectors which are based on brand-new consumers then it might face unfavorable comments from its core fan base.

Porter's 5 Forces Analysis

It is essential to understand market in which business is working because NASCAR's bottom line i.e. net profit is heavily depends on this. There are 5 forces that are used to determine profitability, strength and beauty of NASCAR business.

Competitive Rivalry

These chauffeurs can go against NASCAR if they got better opportunity in terms of rewards and tv exposure. If viewers enjoy other race vehicles and chauffeurs more than NASCAR then audiences can move to those other fascinating cars and trucks and drivers. NASCAR might be having hazard from its two direct rivals that is Formula 1 and Moto GP.
Swot Analysis
Provider Power

If business shifts from one supplier to another, the supplier power indicates the number of providers are readily available in market and what is the expense associated with provider. In this industry there is supply monopoly due to the fact that drivers with needed resources and abilities are restricted.

Buyer Power

This force is concerning to clients that is it easy for clients to move to other items. If there is more changing cost is associated then consumers are less most likely to change. In the case of NASCAR customers are its viewers. Since viewers will having low switching expense, viewers can change to other competitors quickly.

Risk of Substitution

Replacements are referred as options. The substitutes in this case can be other home entertainment suggests like audiences can move to other sports. So there are large range of alternatives are available in this scenario which recommends that hazard of replacement is high.

Danger of New Entry

In the case of NASCAR risk of brand-new entry is low. They need to develop automobiles and racing tracks and likewise needs to pay hefty quantity to motorists for changing.

PESTEL Analysis


As NASCAR is working in different markets so it requires to face various regulations. It is also noted that NASCAR has actually faced increased examination relating to regulatory. Every government has different priority so NASCAR has actually to be prepared for it as priority can be shifted to other sector.


Economic elements consists of tax rate, exchange rate, economic performance of that specific company, conditions of labour market, inflation rate and so on. Fortunes of the NASCAR and its competitors can be affected if there is federal government intervention in the marketing and sales sector. NASCAR can utilize capabilities of staff members to develop new opportunities and improve existing chances.


Every society is various from each other. Each has various social worths and standards. It helps in comprehending relating to society and preference of customers. Social factors consists of customs, culture, attitudes towards particular services and products, demographics, standards, interests and so on. It can be concluded that marketing through other methods instead of conventional (i.e. newspaper) can be chosen in this society.


In this case of NASCAR it can be noted that companies are greatly spending for research study and development. NASCAR ought to also work on its media rights policy with Turner Broadcasting System.

Vrio Analysis
Since every nation has different legal terms and conditions, Legal plays an important function in every country. Excel Model For Aggregate Production Planning Aggprods Case Study Solution requires to be ensure that they protect their legal rights in every county so any business does not hurt to its legal rights.


Ecological aspects are also essential for every business. Because usually governments do not allow those company which can damage to environment. These environmental factors consists of laws regarding contamination, climate change, safe waste disposal, policies concerning insurance coverage and so on. NASCAR needs to ensure that its cars are not producing contamination more than acceptable level.

7 P's of Marketing


The items of Excel Model For Aggregate Production Planning Aggprods Case Study Analysis in its product portfolio are; racing events tickets, racing tracks, sponsor's marketing, media rights, licencing NASCAR brand name, approving rules for races and ad-space to corporate marketers during broadcast of NASCAR races. (Hanlon, 2018).


Prices strategy of NASCAR for its race events tickets is based upon the location and significance of the racing events. Along with race occasions tickets, NASCAR also charge numerous service charge to its stakeholders and makes revenue. It charged sanctioning charges of $1-2 million per race on average in 2005.


Advertising method of Excel Model For Aggregate Production Planning Aggprods Case Study Help is highly based upon its fan base. A strong fan base share its fandom with others and increase the number of audiences for NASCAR races. The business is not completely relied upon its fan base for its promotion and promote through local radio stations too. The business has actually also embraced the retailing media of promo, in which the company sells products with its logo.


NASCAR have its racing tracks in different cities in United States. The most important tracks of NASCAR includes Atlanta Motor Speedway in Georgia, Vehicle Club Speedway in California and Darlington Raceway in South Carolina. It tries to perform its races in the majority of the cities in United States to understand across the country appeal.


Nestle people strategy is comprised of offering much better experience to its viewers, its fan base and to all of its stakeholders. Individuals are an essential element of Excel Model For Aggregate Production Planning Aggprods Case Study Analysis A marketing method as its events are the source of home entertainment for crowd. Its people strategy consists of efforts to provide much better experience to its Fans, Race Drivers, Team, Event Organizers etc., all of which come under people strategy of NASCAR.


Numerous organisation procedures are required to perform racing events in an efficient method. These processes include; correct schedule of time, plan for viewers, selling tickets, arrangement of area for sponsors, managing logistics and so on. These all processes contribute I building NASCAR image, enhancing spectators experience and increasing fan base.

Physical Proof.

Essential physical proofs for the NASCAR consists of the existence of its racing tracks, stock cars and trucks and racing events. In addition to it, its merchandising brand names including tee shirts, caps, goodies and so on, also function as a physical proof for NASCAR.

Product Life Cycle Evaluation.

The racing occasions by Excel Model For Aggregate Production Planning Aggprods Case Study Solution was presented on June 19, 1949. The first race was held at Charlotte Speedway in North Carolina. There were about 13000 fans present in the race. At the first phase competitors for NASCAR was low, as the competitors drove the cars and trucks comparable to the vehicles driven by regular people.


The very first NASCAR based track, specifically the Darlington Raceway track, was initiated in 1950 in South Carolina. After the growth of racing tracks the business moved towards relaying its races on television in 1979.

In 1972, William France Jr., became the president of NASCAR and n about 3 decades, he changed NASCAR from a regional Sport popular organization into one with international fan base. He initiated a new age of financially rewarding sponsorships and television agreements for NASCAR.


The maturity period for NASCAR started with the efforts of William France Jr., with the business having vast array of revenue sources. The company has about 500 sponsors with broadcasting its events in about 150 countries. The business has large number of tracks in most of the cities of United States.


The decrease in the company's offerings started after 2005 with typical presence rate per race declined by 22% from 2005 to 2010 and tv viewership rate declined by 30% from 2005 to 2010. The significant causes of decrease consist of the financial crisis of 2008, which increased the expense of arriving at tracks for audiences due to increasing fuel rates, and the moving of its fan base towards other sports.

Market Division.

The market division of Excel Model For Aggregate Production Planning Aggprods Case Study Solution can be divided into 4 segments; Geographic, Demographic, Psychographic and Behavioural. (Dutta, 2018).


The geographical segmentation of Excel Model For Aggregate Production Planning Aggprods Case Analysis is based upon the geographical existence of its tracks in different states and cities in United States, and the television broadcasting of its events in various nations. The business has 23 tracks in about 20 states of America and has tv broadcast through numerous Medias i.e. TNT, ESPN, ABC and Fox, in about 150 countries.This huge geographical segmentation supplies the business local along with international fan base.


The demographic division of NASCAR is also highlydiverse based upon the gender, income and age of the customer. Its current fan base is majorly consisted of male married fans with a typical age of 47 years and an earnings around $30-50 thousands. Presently NASCAR is trying to increase its target market to the young growing population and kinds. To increase the demographic sector of its market NASCAR should modify its marketing strategies to attract more age and lower its costs to go into in the market sector with a low typical earnings.( htt1).


The mental attributes of the majority of the fans are quite comparable. NASCAR has a fan base with a loyalty. NASCAR fans view it compulsive to buy tickets and see the races once in a week. 71% of them prefer to buy products with a NASCAR trademark name. They are rather extrovert and want to mingle with other fans while racing. They desire quality racing with low price at practical area. Although Excel Model For Aggregate Production Planning Aggprods Case Study Analysis has attempted to increase the quality of its racing by introducing phase racing, they likewise have tried to lower prices and make the event more convenient by presenting live racing.


Behavioural segmentation of Excel Model For Aggregate Production Planning Aggprods Case Study Solution is based upon the behaviour of fans in terms of viewing the race survive on the tv or by entering the events. Presently, the fans preference is towards seeing the race in your home on television instead of going, as the customer experience at NASCAR tracks is not beneficial in addition to pricey. This preference makes the rates for participation lower than the rates for tv viewers. NASCAR has to change the behaviour of its fan base by presenting qualitative services at its tracks.

Target audience.


One of the prospective target market of NASCAR was Hispanics; the young and growing population of United States. The market segment has excellent potential for NASCAR as the population was growing at a greater rate and it was expected to become thrice after forty years and the segment has increasing wealth rate with about $1 trillion of wealth in 2014.


Kids are likewise one of the prospective target market segment for NASCAR, as they are more linked socially than other groups. Producing fan base among kids can offer a possible boost in the number of fans for racing due to their connection. Kids invest most of their times in playing and utilizing mobile phones computer game. Car racing video games established by Excel Model For Aggregate Production Planning Aggprods Case Study Help can be a prospective source of acquiring attention of kids towards NASCAR track racing. NASCAR's digital functions related to kids are not capable of getting the attention. NASCAR requires more attention towards personalizing and improving its digital functions to bring in the kids target market.

This big expenditure makes the segment potential for NASCAR marketing strategy of increasing its fan base. The market sector considers NASCAR as an organization doing not have in developing a multiculturalism atmosphere. NASCAR should take numerous steps to improve the experience of Generation Y customers in its events.

5 C's of Marketing

5 C's of marketing helps in taking choices regarding marketing.


It needs to make PESTLE analysis in order to comprehend climate or context in which NASCAR is working. PESTLE means political, financial, social, technical, environmental and legal and is stated above.


NASCAR is an automobile racing company with having USP of high quality vehicle racing with a global structure. Its sector is sports team and events. Its target audience is males in the age of 15-60 years. Business has closed corporate culture and having non-interventionist technique.


Collaborations consists of suppliers, suppliers and alliances of NASCAR. NASCAR used to get pay check of around $15 million every year from Turner Sports. NASCAR had to get approval from Turner Sport if it want to create its Facebook page, twitter account or even mobile application.


The client of Excel Model For Aggregate Production Planning Aggprods Case Study Solution are its viewers. They target consumers with having age of 15-60 years. Fan base of NASCAR consisted of married males with a typical age of 47, which passes their fandom to their children and develop generational commitment.


Teams generally represents sponsors in NASCAR and the medium of marketing is chauffeurs. These drivers can go versus NASCAR if they got much better opportunity in terms of prizes and tv exposure.

Marketing Methods.

1. Maintaining and developing Facebook Page.
Among the possible target markets sections for NASCAR is Hispanics which is the growing population segment of U.S.A. however sadly NASCAR had been unable to attract the this targeted sector. In order to bring in the young growing generation the NASCAR must market by using social networks like Facebook. It ought to establish a Facebook page consisting of the information regarding the races and the areas of tracks to make the consumer helpful about the core operations of Excel Model For Aggregate Production Planning Aggprods Case Study Solution. It needs to likewise update its Facebook page on day-to-day basis to offer info about its upcoming occasions. This would make the target audience section more helpful about the business and would result in attracting big fans base.
2. Developing and Updating Accounts of Key Drivers.
Excel Model For Aggregate Production Planning Aggprods Case Study Analysis chauffeurs has a low star power as compare to gamers of other sports. The poor contacts with fans result in less attraction of audiences towards the racers and a low star power. Star power is a crucial element for bring in audiences towards tracks and towards tv.
3. Developing New Games and enhancing current video games for kids.
In order to bring in these kids, NASCARA needs to enhance its present racing video games by presenting personalization in the vehicles i.e. altering colours, choice of speed, introducing group racing in the game, using better graphics related to the racing tracks and introducing various levels in the video game. All these adjustments in the existing game would supply better experience to kids.
Along with it, NASCAR needs to also build brand-new games connected to racing like kids racing with kids characters as motorists, animation racing with racing between numerous animation characters with a choice of choosing the preferred cartoon character for the kids. These techniques would make it possible for the business to attract among its potential target sectors.
4. Presenting multiculturalism at events.
Excel Model For Aggregate Production Planning Aggprods Case Study Analysis occasions are comprised of fans with very few multiculturalism, due to cost of arrival in occasions, making it unappealing for the clients perceiving sport events as affairs i.e. Generation Y consumers. As the Generation Y clients are a possible target audience for NASCAR, therefore the company should take certain steps to attract this prospective target audience. It needs to adopt techniques to attract the customers far from the tracks place with different culture. The technique to do so might be offering special discounts on tickets or free tickets to audiences coming from a particular distance or from another state. It would increase multiculturalism of the fans and would make Generation Y customers more pleased.
5. Improving Consumer Experience at Tracks.
NASCAR should work on facilities and amenities at tracks because on the race day viewers got dissatisfied. Audiences have numerous expectations from Excel Model For Aggregate Production Planning Aggprods Case Study Help since in same market other business are supplying better services than NASCAR. IF NASCAR do not work on this concern then its fans may shifted to its rivals.

Marketing Spending plan

Marketing budget plan made on the basis of the above strategies for the period of 5 years from 2011 to 2015, shows the expense associated information for the marketing methods. (See Appendix B). It can be seen that technique 5 of improving customer experience at tracks would require highest preliminary investment and cost and method 4 of introducing multiculturalism will require most affordable initial investment with least expensive further annually cost. The business ought to prioritize the resource allocation on these strategies on the basis of its offered resources and the possible benefits which the technique would provide.
KEEP IN MIND: The worths about expense are assumed on rational basis due the absence of figures and facts connected to cost in the event study. Inflation rate of United States is assumed to be 10%.

On the basis of deep analysis of the internal and external aspects of Excel Model For Aggregate Production Planning Aggprods Case Study Help triggering the decrease of television viewership rate and presence rate at tracks, the above marketing strategies are advised to NASCAR to increase its fan base in long term. These techniques would deal with internal factors like bad client experience at tracks, inadequate social networks marketing, incapable digital medias like video games, absence of culturalisms at tracks and so on, along with with external aspects like moving of fans towards other sports, demographical changes in America and altering domesticity designs.