Excel Model For Aggregate Production Planning Aggprods Online Case Study Help

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

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


Excel Model For Aggregate Production Planning Aggprods Case Study Help (National Association for Stock Vehicle Car Racing) is an organization performing series of Stock Cars and truck racing in United States and serving as a sanctioning body for driving the guidelines for Stock Car Racing. The organization was established in 1947, by "Huge Bill" France. NASCAR arrange Stock Automobile Racing events in United States with the existence of about 130000 audiences usually in 2005. It likewise broadcast its occasions in about 150 countries. Stock Vehicle Racing by NASCAR is the second largest spectator sport, with highest variety of sponsors. It has about 500 sponsors contributing billions of dollars in its earnings. The other sources of income for Excel Model For Aggregate Production Planning Aggprods Case Study Help includes; 10% of the overall income from television 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 method. The structure of Automobile of Tomorrow by NASCAR, with an objective of safety for the motorists, brought numerous tensions amongst the stakeholders of the sport.
Executive Summary
The communication audit, carried out in 2010, exposed that despite the fact that business highly count on the communications between its stakeholders, there was no identifiable service interaction technique. The market's target customers, instructions and objectives were all unknown.

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

Excel Model For Aggregate Production Planning Aggprods Case Study Help viewers was extremely loyal to the sport and the brand names related to the NASCAR, making it appealing for sponsors and business marketers.

Issue Statement.

The business is currently facing the problem of declining rates of attendance at racing tracks and rates of tv viewers. This can put a considerable influence on its incomes from sponsors, media rights, and from other sources of earnings.

Situational Analysis.

Although the business was rather effective till 2005 with its standard marketing strategies, however not long after 2005 the company begins facing different problems consisting of decline of its fan base. A number of external as well as internal elements are accountable for the decrease. Internal elements include; insufficient financial investment in social networks and other digital medias of.

Fan base of NASCAR made up of married males with a typical age of 47, which passes their fandom to their children and create generational loyalty. Other challenges for NASCAR consists of the shift of its fans to other sports as they were enhancing their fan's experience permitting access to their broadcasts out of the houses through jumbo turns, Wi-Fi access, etc.

SWOT Analysis.


NASCAR core competencies includes it has rights of determining guidelines as approving body. Guidelines and regulations relating to expert stock cars and truck racing are dictated by NASCAR like if any team with required abilities and resources can enter into races by following guidelines and guidelines determined by NASCAR. All the occasions of NASCAR are sponsored by corporates due to the fact that of greatest brand name commitment of fans towards brands marketed by Excel Model For Aggregate Production Planning Aggprods Case Study Analysis.


Weaknesses in SWOT Analysis are thought about as external elements. Weaknesses includes the elements that stops company to carry out at needed level of performance. Weak points of NASCAR includes its close culture which is non collective. They have non-interventionist approach. They usually used to form rules and other needed procedures without intervention of others which results in poor partnership. NASCAR develops Car of Tomorrow without collaboration so result is that chauffeurs did not like that principle. As this is racing sport so covering of sports by media is likewise difficult. It was also found that NASCAR had no reliable method for organisation interaction. They don't know how to deal with problem if it occurred off track. Inadequate company interaction leads to that they do not have clear direction for their long term goals. They don't understand that where they want to see this sport in future.
Porter's 5 Forces Analysis

NASCAR usually used to rely on conventional media sources like regional newspaper for publicity of its sports. NASCAR also came to know from these traditional media outlets that sport was hard to cover. When sports fans were asked concerning popular celebs and stars then NASCAR motorist was not found even in leading twenty reactions.


Economic down turn was experienced in late 2000 which can be threat for NASCAR due to the fact that if there is financial down turn then people would be having less return on investment. Economic down turn likewise results in boost fuel costs which likewise impacted NASCAR. Now if NASCAR make considerable financial investments in new sections which are based on new customers then it may deal with negative remarks from its core fan base.

Porter's Five Forces Analysis

Porter's 5 forces is a model that is used to analyse market in which company is working. It helps in determining what are strengths and weakness of any specific industry. It recommend that every market is various from one another. Since NASCAR's bottom line i.e. net profit is greatly depends on this, it is important to comprehend market in which company is working. There are 5 forces that are utilized to recognize success, strength and attractiveness of Excel Model For Aggregate Production Planning Aggprods Case Study Help service.

Competitive Competition

These drivers can go versus NASCAR if they got better opportunity in terms of prizes and tv exposure. If audiences delight in other race cars and motorists more than NASCAR then audiences can shift to those other intriguing vehicles and motorists. NASCAR might be having hazard from its two direct competitors that is Solution 1 and Moto GP.
Swot Analysis
Supplier Power

If company shifts from one provider 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 since motorists with needed abilities and resources are limited.

Buyer Power

In the case of NASCAR clients are its viewers. Audiences can switch to other rivals quickly because viewers will having low switching cost.

Hazard of Replacement

Alternatives are referred as options. The alternatives in this case can be other entertainment suggests like audiences can shift to other sports. So there are large range of alternatives are readily available in this scenario which suggests that hazard of alternative is high.

Hazard of New Entry

In the case of NASCAR hazard of brand-new entry is low. They require to build cars and racing tracks and likewise requires to pay hefty quantity to motorists for switching.

PESTEL Analysis


It can not be concluded from case study that there would be change in resource allocations. NASCAR had got gain from lower tax policies which leads to increasing in earnings. They made heavy investments in the research study and development. As NASCAR is operating in numerous markets so it requires to deal with different policies. It is likewise kept in mind that Excel Model For Aggregate Production Planning Aggprods Case Study Help has actually faced increased examination concerning regulative. Every federal government has different priority so NASCAR needs to be prepared for it as priority can be shifted to other sector.


Financial aspects consists of tax rate, currency exchange rate, financial performance of that particular business, conditions of labour market, inflation rate and so on. If there is government intervention in the marketing and sales sector, fortunes of the NASCAR and its competitors can be impacted. NASCAR can leverage capabilities of staff members to develop new opportunities and enhance existing chances.


Every society is various from each other. Each has various social worths and standards. It assists in comprehending relating to society and preference of customers. Social aspects consists of traditions, culture, mindsets towards particular product and services, demographics, norms, interests etc. It can be concluded that marketing through other ways rather than standard (i.e. paper) can be preferred in this society.


Innovation has influence on nearly every company. It consists of development in company method. In this case of Excel Model For Aggregate Production Planning Aggprods Case Study Analysis it can be noted that business are greatly spending for research study and advancement. NASCAR ought to likewise deal with its media rights policy with Turner Broadcasting System.

Vrio Analysis
Legal plays a crucial function in every country since every nation has various legal terms and conditions. Excel Model For Aggregate Production Planning Aggprods Case Study Analysis needs to be make sure that they secure their legal rights in every county so any company does not harm to its legal rights.


Ecological factors are also crucial for every business. NASCAR needs to make sure that its vehicles are not generating pollution more than appropriate level.

7 P's of Marketing


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


Pricing technique of NASCAR for its race events tickets is based upon the venue and significance of the racing occasions. Together with race occasions tickets, NASCAR likewise charge numerous service charge to its stakeholders and makes profits. For example it charged sanctioning costs of $1-2 million per race on average in 2005.


Promotional technique of Excel Model For Aggregate Production Planning Aggprods Case Study Analysis 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 company is not completely relied upon its fan base for its promotion and promote through regional radio stations too. The company has likewise embraced the retailing media of promotion, in which the company offers merchandises with its logo design.


NASCAR have its racing tracks in numerous cities in United States. The most important tracks of NASCAR includes Atlanta Motor Speedway in Georgia, Automobile Club Speedway in California and Darlington Raceway in South Carolina. It attempts to conduct its races in the majority of the cities in United States to comprehend nationwide popularity.


Nestle individuals strategy is consisted of supplying much better experience to its viewers, its fan base and to all of its stakeholders. Individuals are an important element of Excel Model For Aggregate Production Planning Aggprods Case Study Help A marketing technique as its occasions are the source of entertainment for crowd. Its individuals technique consists of efforts to supply much better experience to its Fans, Race Drivers, Team, Event Organizers etc., all of which come under individuals strategy of NASCAR.


Several business procedures are required to carry out racing events in an effective method. These processes include; appropriate schedule of time, arrangement for viewers, selling tickets, arrangement of space for sponsors, managing logistics and so on. These all procedures contribute I building NASCAR image, enhancing spectators experience and increasing fan base.

Physical Proof.

Crucial physical evidences for the NASCAR consists of the presence of its racing tracks, stock cars and racing events. In addition to it, its retailing brands consisting of tee shirts, caps, goodies etc., also serve as a physical evidence for NASCAR.

Product Life Process Evaluation.

The racing occasions by NASCAR was presented on June 19, 1949. At the first phase competitors for NASCAR was low, as the competitors drove the automobiles comparable to the vehicles driven by ordinary people.


After conducting its very first race effectively the company moved towards developing its own tracks. The very first Excel Model For Aggregate Production Planning Aggprods Case Study Analysis based track, namely the Darlington Raceway track, was initiated in 1950 in South Carolina. It was followed by facility of more raceways consisting of Daytona International Speedway, which was opened in 1959. After the development of racing tracks the business moved towards transmitting its races on tv in 1979. The first event broadcasted on television was flag-to-flag protection of Daytona.

In 1972, William France Jr., became the president of NASCAR and n about 3 years, he changed NASCAR from a local Sport popular organization into one with global fan base. He started a new period of lucrative sponsorships and tv contracts for NASCAR.


The maturity period for NASCAR started with the efforts of William France Jr., with the business having large range of revenue sources. The company has about 500 sponsors with transmitting its occasions in about 150 nations. The company has a great deal of tracks in most of the cities of United States.


The decline in the company's offerings started after 2005 with average presence rate per race decreased by 22% from 2005 to 2010 and television viewership rate declined by 30% from 2005 to 2010. The significant reasons for decline include the financial crisis of 2008, which increased the cost of reaching tracks for audiences due to increasing fuel prices, and the shifting of its fan base towards other sports.

Market Segmentation.

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


The geographical division of Excel Model For Aggregate Production Planning Aggprods Case Solution is based upon the geographical presence of its tracks in various states and cities in United States, and the television broadcasting of its events in various countries. The company 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 division offers the business regional in addition to global fan base.


The group division of NASCAR is also highlydiverse based upon the gender, earnings and age of the customer. Its existing fan base is majorly consisted of male married fans with a typical age of 47 years and an income around $30-50 thousands. However presently NASCAR is trying to increase its target audience to the young growing population and kinds as well. To increase the demographic sector of its market NASCAR must modify its marketing strategies to bring in more age groups and lower its costs to enter in the marketplace sector with a low average earnings.( htt1).


The mental characteristics of most of the fans are quite similar. NASCAR has a fan base with a commitment. Once in a week, NASCAR fans view it compulsive to buy tickets and see the races. 71% of them prefer to purchase products with a NASCAR trademark name. They are rather extrovert and want to join other fans while racing. They want quality racing with low cost at convenient place. NASCAR has tried to increase the quality of its racing by presenting stage racing, they likewise have actually tried to lower rates and make the event more convenient by presenting live racing.


Behavioural division of Excel Model For Aggregate Production Planning Aggprods Case Study Help is based upon the behaviour of fans in terms of watching the race reside on the tv or by entering the events. Currently, the fans preference is towards viewing the race in the house on television instead of going, as the consumer experience at NASCAR tracks is not favourable in addition to costly. This preference makes the rates for attendance lower than the rates for television viewers. NASCAR needs to change the behaviour of its fan base by introducing qualitative services at its tracks.

Target audience.


One of the potential target audience of Excel Model For Aggregate Production Planning Aggprods Case Study Solution was Hispanics; the young and growing population of United States. The market segment has fantastic possible for NASCAR as the population was growing at a higher 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. Although, the segment shows affinity with cars and truck culture, but require a more focused marketing towards welcoming the segment towards racing.


Kids are likewise among the prospective target market segment for NASCAR, as they are more connected socially than other groups. Creating fan base amongst kids can provide a potential boost in the variety of fans for racing due to their connection. Kids invest the majority of their times in utilizing smartphones and playing computer game. Car racing video games established by Excel Model For Aggregate Production Planning Aggprods Case Study Help can be a prospective source of gaining attention of kids towards NASCAR track racing. However, NASCAR's digital functions associated with kids are not efficient in getting the attention. NASCAR requires more attention towards customizing and enhancing its digital functions to bring in the kids target audience.

Generation Y.
Generation Y target audience consists of those who invested 5 times more resources on discretionary expenses i.e. buying tickets for racing events, than others. This substantial expenditure makes the sector capacity for NASCAR marketing strategy of increasing its fan base. The marketplace section is also easy to approach as 81% of the Y Generation customer utilizes Facebook every day and the usage is twice of using tv and radio. The market sector views sports as an affair, instead of adherence to sport. The market sector thinks about NASCAR as a company lacking in creating a multiculturalism atmosphere. Excel Model For Aggregate Production Planning Aggprods Case Study Solution ought to take numerous actions to enhance the experience of Generation Y consumers in its occasions.

5 C's of Marketing

5 C's of marketing helps in taking decisions regarding marketing. These 5 C's needs to be analysed appropriately for taking any marketing choice. These 5 C's stands for Environment, Company, Collaborators, Consumers and Competitors.


It requires to make PESTLE analysis in order to understand environment or context in which NASCAR is working. PESTLE means political, financial, social, technical, legal and ecological and is mentioned above.


Excel Model For Aggregate Production Planning Aggprods Case Study Analysis is a car racing company with having USP of high quality vehicle racing with a global structure. Its sector is sports team and events.


Collaborations consists of distributors, providers and alliances of Excel Model For Aggregate Production Planning Aggprods Case Study Solution. It is teamed up with different racing groups which are participating in racing. It likewise teamed up with Turners Sport for digital rights. NASCAR used to earn money check of around $15 million annually from Turner Sports. There are number of cons behind this offer. NASCAR had to get approval from Turner Sport if it desire to produce its Facebook page, twitter account or even mobile application. Turner Sport also had rights of each and every single video which is shoot throughout race at track.


The client of Excel Model For Aggregate Production Planning Aggprods Case Study Analysis are its audiences. They target customers with having age of 15-60 years. Fan base of NASCAR comprised of married males with a typical age of 47, which passes their fandom to their children and create generational loyalty.


The direct rivals of NASCAR are Formula 1 and Moto GP. Groups usually represents sponsors in NASCAR and the medium of marketing is motorists. For that reason it can be stated that drivers and race cars are rivals. If they got better opportunity in terms of prizes and television direct exposure, these motorists can go versus NASCAR.

Marketing Methods.

1. Keeping and developing Facebook Page.
One of the prospective target markets sectors for NASCAR is Hispanics which is the growing population section of USA but sadly NASCAR had been not able to draw in the this targeted section. It ought to develop a Facebook page consisting of the information concerning the races and the places of tracks to make the consumer helpful about the core operations of NASCAR.
2. Establishing and Updating Accounts of Key Drivers.
NASCAR drivers has a low star power as compare to players of other sports. Its ranks 7th in regards to star power (see Case Exhibit). The major factor behind it is that, the racers primarily play in teams and are unable to construct an essential account and preserve a close contact with fans. The bad contacts with fans lead to less attraction of audiences towards the racers and a low star power. Star power is a crucial aspect for drawing in viewers towards tracks and towards television. The star power for the motorists at NASCARA might be improved by developing and updating accounts of crucial chauffeurs by NASCARA itself. This would remove the requirement of forcing chauffeurs to maintain their accounts and would result in increasing fans attention towards NASCARA motorists.
3. Developing New Games and enhancing current video games for kids.
In order to attract these kids, NASCARA should enhance its present racing games by introducing customization in the automobiles i.e. altering colours, choice of speed, presenting group racing in the video game, utilizing better graphics related to the racing tracks and presenting various levels in the game. All these adjustments in the current video game would supply much better experience to kids.
Along with it, NASCAR ought to also construct brand-new games associated with racing like kids racing with kids characters as chauffeurs, animation racing with racing between various cartoon characters with a choice of selecting the favourite cartoon character for the kids. These strategies would make it possible for the business to attract one of its possible target segments.
4. Presenting multiculturalism at occasions.
Excel Model For Aggregate Production Planning Aggprods Case Study Analysis occasions are consisted of fans with extremely couple of multiculturalism, due to cost of arrival in occasions, making it unsightly for the clients perceiving sport events as get-togethers i.e. Generation Y clients. As the Generation Y customers are a potential target audience for NASCAR, therefore the company must take particular measures to attract this potential target market. It must embrace techniques to bring in the clients far from the tracks area with various culture. The method to do so might be supplying unique discount rates on tickets or free tickets to audiences originating from a specific range or from another state. It would increase multiculturalism of the fans and would make Generation Y consumers more pleased.
5. Improving Customer Experience at Tracks.
NASCAR ought to work on facilities and amenities at tracks due to the fact that on the race day audiences got dissatisfied. Viewers have lots of expectations from Excel Model For Aggregate Production Planning Aggprods Case Study Solution due to the fact that in very same market other business are offering better services than NASCAR. IF NASCAR do not work on this issue then its fans might moved to its rivals.

Marketing Budget

Marketing budget made on the basis of the above methods for the duration of 5 years from 2011 to 2015, reveals the cost related information for the marketing strategies. (See Appendix B). It can be seen that strategy 5 of improving customer experience at tracks would need highest preliminary financial investment and cost and method 4 of introducing multiculturalism will need most affordable initial investment with least expensive further per year expense. The company ought to focus on the resource allotment on these methods on the basis of its offered resources and the possible benefits which the method would supply.
NOTE: The worths about expense are presumed on rational basis due the absence of figures and truths related to cost in the case research 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 decline of tv viewership rate and attendance rate at tracks, the above marketing techniques are suggested to NASCAR to increase its fan base in long term. These strategies would handle internal aspects like poor customer experience at tracks, insufficient social networks marketing, incapable digital medias like video games, absence of culturalisms at tracks and so on, in addition to with external elements like shifting of fans towards other sports, demographical modifications in America and changing domesticity styles.