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 Analysis (National Association for Stock Car Auto Racing) is a company performing series of Stock Car racing in United States and serving as an approving body for driving the guidelines for Stock Automobile Racing. The company was founded in 1947, by "Huge Bill" France. NASCAR arrange Stock Vehicle Racing occasions in United States with the existence of about 130000 viewers on average in 2005. It likewise broadcast its occasions in about 150 countries. Stock Cars And Truck Racing by NASCAR is the second largest spectator sport, with greatest variety of sponsors. It has about 500 sponsors contributing billions of dollars in its earnings. The other sources of revenue for Excel Model For Aggregate Production Planning Aggprods Case Study Analysis includes; 10% of the total revenue from tv rights, sanctioning charges i.e. $1-2 million per race, and licencing NASCAR brand to business.

NASCAR has a closed business culture with the non-interventionist method. This non collaborative method brings stress in the sport. The building of Cars and truck of Tomorrow by Excel Model For Aggregate Production Planning Aggprods Case Study Solution, with an intention of security for the drivers, brought various tensions amongst the stakeholders of the sport.
Executive Summary
The communication audit, performed in 2010, exposed that in spite of the fact that the company highly rely on the interactions between its stakeholders, there was no identifiable company interaction technique. (

The audit pointed out various lacking of NASCAR in terms of lack of internal integration, absence of fan management technique and lack of digital and social media of marketing.

Excel Model For Aggregate Production Planning Aggprods Case Study Solution audiences was extremely faithful to the sport and the brands associated with the NASCAR, making it appealing for sponsors and business marketers.

Issue Statement.

The business is presently facing the problem of declining rates of presence at racing tracks and rates of television audiences. This can put a significant effect on its earnings from sponsors, media rights, and from other sources of income.

Situational Analysis.

Although the company was quite effective till 2005 with its traditional marketing methods, but not long after 2005 the business starts dealing with various problems consisting of decrease of its fan base. A number of external as well as internal factors are accountable for the decline. Internal elements consist of; insufficient investment in social networks 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 loyalty. However the family system in America was altering resulting in decrease of impact of married male fan base over their youngsters. Together with it perceptions about vehicle was also changing with perceiving car an automobile to reach at point B from point A, instead of as an enjoyable project. 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 enhancing their fan's experience permitting access to their broadcasts out of the homes through jumbo turns, Wi-Fi gain access to, etc. These all challenges were tending the company to modify its marketing strategies.

SWOT Analysis.


In SWOT analysis, strengths defined as company's qualities which are various from its competitors. These are business's core proficiencies on which business efficiency or business success based upon. Excel Model For Aggregate Production Planning Aggprods Case Study Help core proficiencies includes it has rights of dictating rules as sanctioning body. Guidelines and policies regarding professional stock car racing are dictated by NASCAR like if any group with required skills and resources can enter into races by following rules and policies dictated by NASCAR. So NASCAR has monopoly it this aspect. Its strengths also consists of that it has title of second biggest viewer sport in the United States with having more fortune 500 sponsors based in US. Its races were used to transmit in more than 150 nations all over the world with more than $56 million profits. The primary sources of their revenues come from television rights, approving costs, sponsorship and licensing. It has longest season of 10 months and having ownership of 3 national series i.e. Outdoor camping World Truck Series, the Sprint Cup Series and the Nationwide Series. It has also big resource of fans and business sponsors. All the occasions of NASCAR are sponsored by corporates due to the fact that of most significant brand name commitment of fans toward brands marketed by Excel Model For Aggregate Production Planning Aggprods Case Study Solution. (See Appendix A).

Weak points.

Weak Points in SWOT Analysis are considered as external factors. Weak points includes the aspects that stops company to perform at needed level of efficiency. Weaknesses of NASCAR includes its close culture which is non collective. They have non-interventionist method. They generally utilized to form guidelines and other required processes without intervention of others which leads to poor cooperation. NASCAR develops Cars and truck of Tomorrow without cooperation so result is that chauffeurs did not like that concept. As this is racing sport so covering of sports by media is also tough. It was also discovered that NASCAR had no efficient technique for service interaction. They do not understand how to deal with problem if it took place off track. Ineffective company communication leads to that they do not have clear instructions for their long term objectives. They do not understand that where they wish to see this sport in future.
Porter's 5 Forces Analysis

Opportunities in SWOT analysis are external factors which can be favourable to company or the external elements on which company is having competitive advantage. NASCAR normally used to count on conventional media sources like regional newspaper for publicity of its sports. Typically these traditional media sources attempt to cover their home team and particular sort of occasions. NASCAR also came to know from these traditional media outlets that sport was difficult to cover. Media landscape also altered from conventional to digital landscape. Newspapers went out of business. NASCAR can work on its capabilities to get optimal possible gain from this brand-new digital landscape. NASCAR have underinvestment in digital resources. So it can capitalize in social and digital media to get its benefits. Digital rights of NASCAR were likewise sold to Turner Sports. NASCAR utilized to make money check of around $15 million each year from Turner Sports. There are number of cons behind this offer. NASCAR had to get approval from Turner Sport if it desire to create its Facebook page, twitter account or even mobile application. Turner Sport also had rights of every single video which is shoot throughout race at track. Then they are needed to pay licensing fees to Turner Sport, if media sources like newspapers, publications and cable television channels desire to post videos of races on their particular pages. NASCAR can work on terms and conditions and attempt to negotiate with Turner Sports to get maximum benefits of it. Star power plays very crucial role in generating revenues from every sport. However it was kept in mind that Excel Model For Aggregate Production Planning Aggprods Case Study Analysis is lagging in this location i.e. star power. For instance when sports fans were asked concerning popular celebs and stars then NASCAR driver was not found even in leading twenty responses. So NASCAR can put efforts in this location too for profits generation. They need to guide their motorists that how they can end up being sport stars. Four tactical focuses which are generated by research study group can also be functioned as opportunity for NESCAR. These four strategic focuses compares and analysis Excel Model For Aggregate Production Planning Aggprods Case Study Analysis techniques.


Economic down turn was experienced in late 2000 which can be threat for NASCAR because if there is financial down turn then individuals would be having less return on financial investment. Economic down turn also results in boost fuel prices which also affected NASCAR. Now if NASCAR make significant financial investments in new sectors which are based on new consumers then it might face negative comments from its core fan base.

Porter's 5 Forces Analysis

Porter's 5 forces is a design that is used to evaluate market in which company is working. It assists in determining what are strengths and weakness of any particular industry. It suggest that every industry is various from one another. It is essential to comprehend market in which company is working since NASCAR's bottom line i.e. net revenue is greatly depends on this. There are 5 forces that are used to determine success, intensity and attractiveness of Excel Model For Aggregate Production Planning Aggprods Case Study Analysis service.

Competitive Rivalry

This force suggests ability of competitors. Teams generally represents sponsors in NASCAR and the medium of marketing is chauffeurs. Therefore it can be stated that drivers and race cars and trucks are rivals. If they got much better chance in terms of prizes and television exposure, these chauffeurs can go versus Excel Model For Aggregate Production Planning Aggprods Case Study Analysis. If viewers enjoy other race cars and trucks and motorists more than NASCAR then audiences can shift to those other interesting cars and trucks and chauffeurs. NASCAR could be having hazard from its two direct rivals that is Solution 1 and Moto GP. They need to create competitive advantages for drivers so they don't move to other rivals.
Swot Analysis
Supplier Power

The provider power indicates the number of suppliers are available in industry and what is the cost related to supplier if business shifts from one supplier to another. In this industry there is supply monopoly because drivers with required abilities and resources are restricted.

Purchaser Power

In the case of NASCAR consumers are its audiences. Viewers can change to other rivals easily due to the fact that viewers will having low switching expense.

Threat of Alternative

Alternatives are referred as options. The alternatives in this case can be other home entertainment implies like audiences can move to other sports. There are wide variety of alternatives are readily available in this scenario which suggests that danger of alternative is high.

Hazard of New Entry

In the case of NASCAR risk of brand-new entry is low. They need to build cars and racing tracks and also requires to pay large quantity to chauffeurs for changing.

PESTEL Analysis


As NASCAR is working in different markets so it needs to face different policies. It is likewise kept in mind that NASCAR has faced increased examination relating to regulatory. Every government has different concern so NASCAR has actually to be prepared for it as top priority can be moved to other sector.


Financial aspects consists of taxation rate, exchange rate, financial efficiency 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 utilize abilities of employees to develop new opportunities and improve existing chances.


Every society is various from each other. Each has various social worths and norms. It assists in comprehending regarding society and choice of consumers. Social aspects consists of traditions, culture, mindsets towards particular services and products, demographics, standards, interests and so on. It can be concluded that advertising through other methods instead of traditional (i.e. paper) can be chosen in this society.


Innovation has impact on nearly every organisation. It includes innovation in company method. In this case of Excel Model For Aggregate Production Planning Aggprods Case Study Analysis it can be kept in mind that business are heavily spending for research and advancement. NASCAR must likewise work on its media rights policy with Turner Broadcasting System.

Vrio Analysis
Because every nation has different legal terms and conditions, Legal plays an essential function in every nation. Excel Model For Aggregate Production Planning Aggprods Case Study Help requires to be make certain that they secure their legal rights in every county so any company does not damage to its legal rights.


Environmental factors are likewise important for every business. Due to the fact that usually federal governments don't enable those organisation which can damage to environment. These ecological factors includes laws concerning pollution, environment change, safe waste disposal, policies concerning insurance coverage etc. NASCAR needs to ensure that its cars are not creating pollution more than appropriate level.

7 P's of Marketing


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


Pricing method of NASCAR for its race occasions tickets is based upon the venue and importance of the racing events. Along with race occasions tickets, NASCAR likewise charge various service fees to its stakeholders and makes revenue. For example it charged approving charges of $1-2 million per race usually in 2005.


Marketing technique of NASCAR is extremely based upon its fan base. A strong fan base share its fandom with others and increase the number of viewers for NASCAR races.


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


Nestle people strategy is consisted of supplying much better experience to its audiences, its fan base and to all of its stakeholders. People are an essential aspect of Excel Model For Aggregate Production Planning Aggprods Case Study Solution A marketing technique as its events are the source of home entertainment for crowd. Its individuals strategy consists of efforts to offer better experience to its Fans, Race Drivers, Crew, Event Organizers and so on, all of which come under individuals strategy of NASCAR.


A number of company processes are needed to conduct racing occasions in an efficient method. These procedures consist of; correct schedule of time, plan for spectators, offering tickets, plan of space for sponsors, handling logistics and so on. These all processes contribute I developing NASCAR image, enhancing spectators experience and increasing fan base.

Physical Proof.

Crucial physical evidences for the NASCAR includes the presence of its racing tracks, stock cars and racing occasions. Along with it, its merchandising brand names including tee shirts, caps, goodies and so on, also function as a physical proof for NASCAR.

Product Life Process Evaluation.

The racing events by NASCAR was introduced on June 19, 1949. At the very first phase competitors for NASCAR was low, as the rivals drove the cars comparable to the automobiles driven by common people.


The very first NASCAR based track, particularly the Darlington Raceway track, was started in 1950 in South Carolina. After the growth of racing tracks the business moved towards broadcasting its races on tv in 1979.

In 1972, William France Jr., ended up being the president of NASCAR and n about 3 decades, he changed NASCAR from a local Sport popular organization into one with international fan base. He started a brand-new period of profitable sponsorships and tv contracts for NASCAR.


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


The decline in the business's offerings began after 2005 with typical presence rate per race declined by 22% from 2005 to 2010 and television viewership rate declined by 30% from 2005 to 2010. The major causes of decline consist of the financial crisis of 2008, which increased the cost of coming to tracks for viewers due to increasing fuel rates, and the moving of its fan base towards other sports.

Market Segmentation.

The marketplace segmentation of Excel Model For Aggregate Production Planning Aggprods Case Study Solution can be divided into four sections; Geographic, Demographic, Psychographic and Behavioural. (Dutta, 2018).


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


The demographic division of Excel Model For Aggregate Production Planning Aggprods Case Study Solution is also highlydiverse based upon the gender, earnings and age of the customer. To increase the demographic segment of its market NASCAR must revise its marketing strategies to attract more age groups and lower its rates to go into in the market sector with a low average earnings.


The psychological qualities of the majority of the fans are quite similar. NASCAR has a fan base with a loyalty. NASCAR fans perceive it compulsive to acquire tickets and see the races as soon as in a week. 71% of them prefer to purchase items with a NASCAR brand name. They are quite extrovert and are willing to mingle with other fans while racing. They desire quality racing with low rate at convenient location. NASCAR has actually attempted to increase the quality of its racing by introducing phase racing, they also have tried to lower prices and make the event more hassle-free by presenting live racing.


Behavioural division of NASCAR is based upon the behaviour of fans in terms of viewing the race live on the television or by going in the occasions. Presently, the fans preference is towards watching the race at home on television rather than going, as the customer experience at NASCAR tracks is not favourable as well as pricey.

Target Market.


One of the potential target audience of Excel Model For Aggregate Production Planning Aggprods Case Study Analysis was Hispanics; the young and growing population of United States. The marketplace section has great potential for NASCAR as the population was growing at a higher rate and it was anticipated to become thrice after forty years and the section has increasing wealth rate with about $1 trillion of wealth in 2014. The section shows affinity with automobile culture, however require a more concentrated marketing towards inviting the sector towards racing.


Kids are likewise among the potential target market segment for NASCAR, as they are more linked socially than other groups. Producing fan base among kids can supply a possible boost in the number of fans for racing due to their connectivity. Kids invest most of their times in using mobile phones and playing video games. Automobile racing video games established by Excel Model For Aggregate Production Planning Aggprods Case Study Analysis can be a prospective source of gaining attention of kids towards NASCAR track racing. Nevertheless, NASCAR's digital functions related to kids are not capable of gaining the attention. NASCAR requires more attention towards customizing and enhancing its digital functions to draw in the kids target audience.

Generation Y.
Generation Y target market consists of those who spent five times more resources on discretionary expenses i.e. buying tickets for racing events, than others. This big expenditure makes the section potential for NASCAR marketing method of increasing its fan base. The marketplace sector is also easy to approach as 81% of the Y Generation customer utilizes Facebook the usage and every day is twice of utilizing tv and radio. The market sector views sports as a get-together, instead of adherence to sport. The market section thinks about NASCAR as a company doing not have in creating a multiculturalism atmosphere. Excel Model For Aggregate Production Planning Aggprods Case Study Help ought to take numerous actions to enhance the experience of Generation Y customers in its occasions.

5 C's of Marketing

5 C's of marketing helps in taking choices regarding marketing. These 5 C's requirements to be evaluated correctly for taking any marketing choice. These 5 C's represent Climate, Business, Collaborators, Rivals and customers.


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


Excel Model For Aggregate Production Planning Aggprods Case Study Solution is an automobile racing company with having USP of high quality automobile racing with a global structure. Its sector is sports group and occasions.


Collaborations consists of distributors, providers and alliances of NASCAR. NASCAR utilized to get pay check of around $15 million yearly 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 clients with having age of 15-60 years. Fan base of NASCAR comprised of married males with an average age of 47, which passes their fandom to their youngsters and produce generational loyalty.


Teams normally represents sponsors in NASCAR and the medium of advertising is chauffeurs. These drivers can go versus NASCAR if they got better chance in terms of prizes and television direct exposure.

Marketing Strategies.

1. Maintaining and establishing Facebook Page.
One of the possible target markets segments for NASCAR is Hispanics which is the growing population sector of USA but regrettably NASCAR had been not able to attract the this targeted sector. It needs to develop a Facebook page containing the info regarding the races and the areas of tracks to make the customer helpful about the core operations of NASCAR.
2. Developing and Upgrading Accounts of Key Drivers.
NASCAR drivers has a low star power as compare to gamers of other sports. Its ranks 7th in regards to star power (see Case Exhibit). The significant factor behind it is that, the racers mainly play in groups and are not able to build an essential account and keep a close contact with fans. The poor contacts with fans lead to less destination of viewers 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 could be improved by developing and updating accounts of essential drivers by NASCARA itself. This would remove the requirement of forcing chauffeurs to preserve their accounts and would lead to increasing fans attention towards NASCARA drivers.
3. Developing New Games and enhancing existing games for kids.
Kids spent most of their time on playing games and utilizing smart devices. But regrettably, kids playing NASCARA have a worst experience of playing its games. As a result, they are less attracted towards the sport. In order to draw in these kids, NASCARA must improve its existing racing video games by presenting personalization in the vehicles i.e. altering colours, choice of speed, presenting group racing in the video game, using much better graphics connected to the racing tracks and introducing different levels in the game. All these modifications in the current game would provide better experience to kids.
Together with it, NASCAR needs to also develop new games associated with racing like kids racing with kids characters as motorists, cartoon racing with racing in between different animation characters with a choice of selecting the preferred cartoon character for the kids. These methods would make it possible for the company to attract among its possible target sectors.
4. Presenting multiculturalism at occasions.
NASCAR events are comprised of fans with very few cultural variety, due to expense of arrival in occasions, making it unsightly for the customers perceiving sport events as social occasions i.e. Generation Y clients. As the Generation Y customers are a possible target market for NASCAR, therefore the business ought to take certain steps to attract this prospective target market.
5. Improving Client Experience at Tracks.
NASCAR ought to work on facilities and facilities at tracks because on the race day viewers got dissatisfied. Audiences have numerous expectations from Excel Model For Aggregate Production Planning Aggprods Case Study Solution due to the fact that in very same industry other companies are providing much better services than NASCAR. IF NASCAR don't work on this concern then its fans might moved to its rivals.

Marketing Budget

Marketing budget made on the basis of the above techniques for the period of 5 years from 2011 to 2015, shows the expense related information for the marketing strategies. It can be seen that technique 5 of enhancing client experience at tracks would need greatest preliminary investment and expense and strategy 4 of presenting multiculturalism will need least expensive preliminary financial investment with least expensive further per year cost.
NOTE: The values about expense are assumed on logical basis due the absence of facts and figures connected to cost in the case study. Inflation rate of United States is presumed to be 10%.

On the basis of deep analysis of the external and internal elements of Excel Model For Aggregate Production Planning Aggprods Case Study Solution causing the decrease of television viewership rate and participation rate at tracks, the above marketing methods are recommended to NASCAR to increase its fan base in long run. These strategies would handle internal factors like bad customer experience at tracks, inadequate social media marketing, incapable digital medias like video games, lack of culturalisms at tracks etc., in addition to with external factors like shifting of fans towards other sports, demographical modifications in America and altering domesticity designs.