Excel Model For Aggregate Production Planning Aggprods Online Case Study Solution

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

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


Excel Model For Aggregate Production Planning Aggprods Case Study Solution (National Association for Stock Cars And Truck Auto Racing) is a company carrying out series of Stock Vehicle racing in United States and acting as a sanctioning body for driving the rules for Stock Car Racing. The company was established in 1947, by "Huge Bill" France. NASCAR arrange Stock Automobile Racing events in United States with the presence of about 130000 viewers on average in 2005. It likewise relayed its events in about 150 nations. Stock Vehicle Racing by NASCAR is the 2nd largest viewer sport, with greatest variety of sponsors. It has about 500 sponsors contributing billions of dollars in its revenue. The other sources of income for Excel Model For Aggregate Production Planning Aggprods Case Study Solution includes; 10% of the total revenue 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. However this non collaborative method brings tensions in the sport. The structure 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 different tensions amongst the stakeholders of the sport.

The interaction audit, conducted in 2010, revealed that regardless of the truth that the business highly rely on the interactions in between its stakeholders, there was no recognizable business communication strategy. (

The audit pointed out different doing not have of NASCAR in terms of absence of internal combination, absence of fan management method and absence of social and digital media of marketing.

Excel Model For Aggregate Production Planning Aggprods Case Study Help audiences was extremely loyal to the sport and the brand names associated with the NASCAR, making it appealing for sponsors and corporate online marketers.

Problem Statement.

The business is currently facing the issue of declining rates of attendance at racing tracks and rates of tv viewers. This can put a substantial impact on its incomes from sponsors, media rights, and from other sources of revenue.

Situational Analysis.

Although the company was quite successful till 2005 with its standard marketing methods, but soon after 2005 the company begins facing various problems including decrease of its fan base. Several external in addition to internal aspects are responsible for the decline. Internal factors include; inadequate 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 loyalty. The household system in America was changing resulting in decrease of impact of married male fan base over their youngsters. In addition to it understandings about car was likewise changing with perceiving car a car to reach at point B from point A, instead of as a fun job. Other difficulties for Excel Model For Aggregate Production Planning Aggprods Case Study Analysis includes the shift of its fans to other sports as they were enhancing their fan's experience enabling access to their broadcasts out of the houses through jumbo turns, Wi-Fi access, etc. These all challenges were tending the business to revise its marketing strategies.

SWOT Analysis.


In SWOT analysis, strengths specified as business's qualities which are different from its rivals. These are business's core proficiencies on which company efficiency or business success based on. Excel Model For Aggregate Production Planning Aggprods Case Study Analysis core proficiencies includes it has rights of dictating rules as sanctioning body. Guidelines and policies regarding expert stock car racing are dictated by NASCAR like if any team with required skills and resources can enter into races by following guidelines and regulations determined by NASCAR. So NASCAR has monopoly it this element. Its strengths likewise consists of that it has title of second biggest spectator sport in the United States with having more fortune 500 sponsors based in United States. Its races were utilized to broadcast in more than 150 countries worldwide with more than $56 million incomes. The primary sources of their revenues come from tv rights, sanctioning fees, sponsorship and licensing. It has longest season of 10 months and having ownership of 3 national series i.e. Camping World Truck Series, the Sprint Cup Series and the Nationwide Series. It has likewise large resource of fans and corporate sponsors. All the occasions of NASCAR are sponsored by corporates because of most significant brand loyalty of fans toward brands advertised by Excel Model For Aggregate Production Planning Aggprods Case Study Solution. (See Appendix A).


Weaknesses of NASCAR includes its close culture which is non collaborative. Excel Model For Aggregate Production Planning Aggprods Case Study Solution establishes Automobile of Tomorrow without cooperation so result is that motorists did not like that principle. It was likewise discovered that NASCAR had no reliable method for business communication.


NASCAR normally used to rely on standard media sources like local paper for publicity of its sports. NASCAR also came to understand from these conventional media outlets that sport was difficult to cover. When sports fans were asked concerning popular celebs and stars then NASCAR motorist was not found even in leading twenty actions.


Risks in SWOT analysis are specified as external factors that can hazard to company's success. Economic down turn was experienced in late 2000 which can be threat for NASCAR because if there is economic down turn then individuals would be having less roi. Earning of people would be effected and they would be more conscious in spending their loan. Economic down turn also leads to boost fuel prices which likewise impacted NASCAR. Since fans of NASCAR utilized to attend its occasion from cross countries. NESCAR had a guideline of 65/25/10 for income circulation. 65 percent revenues from media rights would be dispersed to race course, 25 percent profits would be distributed to completing group and staying 10 percent would be kept by NESCAR which is sanctioning body. Competing team wanted to increase their portion of revenue from 25 percent due to the fact that of increase in running cost of a race team and also there is decrease in the variety of full-season sponsorship. NESCAR likewise faces threats from other sponsors since they are making huge investments to improve experience of fans. Which consists of upgrading existing avenues, constructing new avenues, offering Wi-Fi facility and likewise offering other interactive mediums to interact sports on mobile phones. Fan base of NASCAR consisted of married males with an average age of 47, which passes their fandom to their children and create generational commitment. The obstacle is that the household system in America was changing resulting in decrease of impact of married male fan base over their youngsters. In addition to it understandings about automobile was likewise changing with viewing vehicle an automobile to reach at point B from point A, instead of as a fun job. If NASCAR make substantial financial investments in brand-new segments which are based on new customers then it may face unfavorable remarks from its core fan base, now.

Porter's Five Forces Analysis

Porter's 5 forces is a design that is used to evaluate industry in which business is working. It assists in determining what are strengths and weak point of any particular industry. It suggest that every market is different from one another. Because NASCAR's bottom line i.e. net earnings is heavily depends on this, it is important to understand industry in which company is working. There are 5 forces that are utilized to determine profitability, strength and beauty of Excel Model For Aggregate Production Planning Aggprods Case Study Solution company.

Competitive Competition

These drivers can go against NASCAR if they got much better opportunity in terms of prizes and tv exposure. If viewers enjoy other race cars and drivers more than NASCAR then audiences can shift to those other fascinating automobiles and drivers. NASCAR could be having hazard from its two direct competitors that is Solution 1 and Moto GP.

Provider Power

If company shifts from one provider to another, the provider power suggests the number of providers are available in market and what is the expense associated with supplier. In this industry there is supply monopoly because motorists with needed resources and abilities are limited.

Buyer Power

This force is regarding to customers that is it easy for customers to shift to other products. Then consumers are less likely to change, if there is more changing cost is associated. When it comes to NASCAR clients are its viewers. Audiences can change to other competitors quickly due to the fact that viewers will having low changing expense.

Risk of Alternative

Substitutes are referred as alternatives. The alternatives in this case can be other home entertainment suggests like audiences can move to other sports. So there are vast array of substitutes are readily available in this scenario which suggests that danger of substitute is high.

Risk of New Entry

It is specified as how it is easy for any business to go into in that specific industry. When it comes to Excel Model For Aggregate Production Planning Aggprods Case Study Help danger of brand-new entry is low. If any business needs to go into in this organisation than they have to make heavy financial investments, due to the fact that. They need to construct vehicles and racing tracks and also needs to pay hefty total up to motorists for changing.

PESTEL Analysis


As NASCAR is working in numerous markets so it requires to face different policies. It is also noted that NASCAR has dealt with increased scrutiny regarding regulatory. Every federal government has different priority so NASCAR has to be prepared for it as top priority can be shifted to other sector.


Financial elements includes tax rate, currency exchange rate, financial efficiency of that specific business, conditions of labour market, inflation rate etc. Fortunes of the NASCAR and its competitors can be affected if there is federal government intervention in the marketing and sales sector. NASCAR can take advantage of capabilities of staff members to create brand-new chances and enhance existing chances.


Each has different social values and standards. It assists in comprehending relating to society and choice of clients.


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


Legal plays an essential role in every country because every nation has various legal terms and conditions. Excel Model For Aggregate Production Planning Aggprods Case Study Help needs to be make sure that they secure their legal rights in every county so any business does not damage to its legal rights.


Environmental elements are likewise important for every single service. Because usually governments don't enable those service which can hurt to environment. These environmental elements consists of laws relating to pollution, climate modification, safe garbage disposal, policies relating to insurance coverage and so on. NASCAR requires to make certain that its cars are not creating pollution more than appropriate 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 throughout broadcast of NASCAR races. (Hanlon, 2018).


Prices strategy of NASCAR for its race occasions tickets is based upon the venue and value of the racing occasions. In addition to race events tickets, NASCAR also charge various service charge to its stakeholders and makes revenue. 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 Solution is extremely based upon its fan base. A strong fan base share its fandom with others and increase the variety of audiences for NASCAR races. The business is not totally relied upon its fan base for its promo and promote through regional radio stations too. The business has also embraced the retailing media of promo, in which the company sells merchandises with its logo design.


NASCAR have its racing tracks in numerous cities in United States. The most important tracks of NASCAR consists of Atlanta Motor Speedway in Georgia, Auto Club Speedway in California and Darlington Raceway in South Carolina. It attempts to perform its races in the majority of the cities in United States to grasp across the country popularity.


Nestle individuals method is comprised of supplying much better experience to its audiences, its fan base and to all of its stakeholders. People are an important element 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 method consists of efforts to supply better experience to its Fans, Race Drivers, Team, Event Organizers and so on, all of which come under individuals method of NASCAR.


Numerous company procedures are needed to perform racing events in an effective method. These procedures include; correct schedule of time, plan for spectators, offering tickets, arrangement of area for sponsors, handling logistics and so on. These all processes contribute I building NASCAR image, enhancing spectators experience and increasing fan base.

Physical Evidence.

Most important physical evidences for the NASCAR includes the presence of its racing tracks, stock automobiles and racing occasions. Together with it, its merchandising brand names consisting of tee shirts, caps, goodies etc., likewise act as a physical proof for NASCAR.

Product Life Process Assessment.

The racing events by NASCAR was presented on June 19, 1949. At the very first stage competition for NASCAR was low, as the competitors drove the cars and trucks similar to the cars and trucks driven by common individuals.


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

In 1972, William France Jr., became the president of NASCAR and n about 3 years, he transformed NASCAR from a regional Sport popular organization into one with worldwide fan base. He initiated a new age of lucrative sponsorships and tv agreements for NASCAR.


The maturity duration for NASCAR started with the efforts of William France Jr., with the business having wide range of revenue sources. The company has about 500 sponsors with broadcasting its events in about 150 countries. The company has a great deal of tracks in the majority of the cities of United States.


The decrease in the business's offerings started 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 reasons for 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 shifting of its fan base towards other sports.

Market Division.

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


The geographical segmentation of Excel Model For Aggregate Production Planning Aggprods Case Solution 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 large geographical division supplies the company local in addition to international fan base.


The market division of NASCAR is likewise highlydiverse based upon the gender, income and age of the customer. Its current fan base is majorly comprised 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 also. To increase the group sector of its market NASCAR need to modify its marketing strategies to attract more age groups and lower its prices to go into in the marketplace segment with a low typical income.( htt1).


The mental attributes of the majority of the fans are quite similar. NASCAR has a fan base with a loyalty. Once in a week, NASCAR fans perceive it compulsive to acquire tickets and see the races. 71% of them prefer to acquire products with a NASCAR brand name. They are quite extrovert and are willing to join other fans while racing. They desire quality racing with low cost at convenient area. Although Excel Model For Aggregate Production Planning Aggprods Case Study Help has actually tried to increase the quality of its racing by introducing stage racing, they likewise have actually attempted to lower costs and make the event more convenient by introducing live racing.


Behavioural division of NASCAR is based upon the behaviour of fans in terms of seeing the race live on the television or by going in the occasions. Presently, the fans choice is towards seeing the race at house on television rather than going, as the client experience at NASCAR tracks is not favourable as well as expensive.

Target Market.


One of the prospective target market of NASCAR was Hispanics; the young and growing population of United States. The market section has terrific possible for NASCAR as the population was growing at a greater rate and it was anticipated to end up being thrice after forty years and the segment has increasing wealth rate with about $1 trillion of wealth in 2014.


Kids are also one of the potential target market section for NASCAR, as they are more connected socially than other groups. Vehicle racing games established by Excel Model For Aggregate Production Planning Aggprods Case Study Analysis can be a potential source of gaining attention of kids towards NASCAR track racing. NASCAR needs more attention towards customizing and enhancing its digital functions to bring in the kids target market.

This big expense makes the sector potential for NASCAR marketing technique of increasing its fan base. The market section considers NASCAR as an organization lacking in developing a multiculturalism environment. NASCAR needs to take numerous steps to improve the experience of Generation Y customers in its occasions.

5 C's of Marketing

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


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


NASCAR is an automobile racing company with having USP of high quality auto racing with an international structure. Its sector is sports team and occasions. Its target market is males in the age group of 15-60 years. Company has actually closed corporate culture and having non-interventionist approach.


Collaborations consists of distributors, suppliers 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 desire to develop its Facebook page, twitter account or even mobile application.


The customer of Excel Model For Aggregate Production Planning Aggprods Case Study Analysis are its audiences. They target clients 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 youngsters and produce generational commitment.


Groups generally represents sponsors in NASCAR and the medium of marketing is motorists. These motorists can go against NASCAR if they got better chance in terms of rewards and tv exposure.

Marketing Techniques.

1. Preserving and establishing Facebook Page.
One of the possible target markets sections for NASCAR is Hispanics which is the growing population section of U.S.A. however unfortunately NASCAR had actually been not able to draw in the this targeted segment. It ought to develop a Facebook page including the details relating to the races and the places of tracks to make the customer informative about the core operations of NASCAR.
2. Developing and Upgrading Accounts of Secret Drivers.
NASCAR motorists has a low star power as compare to players of other sports. Its ranks 7th in terms of star power (see Case Exhibit). The major reason behind it is that, the racers mainly play in teams and are not able to construct a crucial account and maintain a close contact with fans. The bad contacts with fans lead to less destination of viewers towards the racers and a low star power. Star power is a crucial aspect for bring in audiences towards tracks and towards television. The star power for the chauffeurs at NASCARA could be improved by developing and updating accounts of key chauffeurs by NASCARA itself. This would eliminate the requirement of forcing motorists to keep their accounts and would lead to increasing fans attention towards NASCARA drivers.
3. Establishing New Games and improving current games for kids.
In order to bring in these kids, NASCARA must improve its present racing video games by presenting modification in the automobiles i.e. changing colours, choice of speed, presenting group racing in the game, utilizing much better graphics related to the racing tracks and presenting numerous levels in the video game. All these modifications in the current video game would offer better experience to kids.
Together with it, NASCAR must also build brand-new games related to racing like kids racing with kids characters as drivers, animation racing with racing in between numerous cartoon characters with a choice of choosing the preferred animation character for the kids. These methods would make it possible for the business to draw in one of its possible target sectors.
4. Presenting multiculturalism at events.
Excel Model For Aggregate Production Planning Aggprods Case Study Solution occasions are comprised of fans with extremely few cultural diversity, due to cost of arrival in events, making it unappealing for the consumers viewing sport events as affairs i.e. Generation Y customers. As the Generation Y clients are a potential target audience for NASCAR, for that reason the company must take certain measures to attract this potential target market. It must embrace strategies to attract the consumers far from the tracks location with various culture. The strategy to do so could be supplying unique discount rates on tickets or free tickets to viewers originating from a particular range or from another state. It would increase multiculturalism of the fans and would make Generation Y customers more pleased.
5. Improving Customer Experience at Tracks.
NASCAR must work on infrastructure and facilities at tracks because on the race day audiences got disappointed. Viewers have numerous expectations from Excel Model For Aggregate Production Planning Aggprods Case Study Solution due to the fact that in very same market other business are supplying better services than NASCAR. IF NASCAR don't work on this concern then its fans may shifted to its rivals.
Marketing Budget plan.
Marketing budget plan made on the basis of the above methods 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 strategy 5 of enhancing customer experience at tracks would need greatest initial financial investment and cost and method 4 of introducing multiculturalism will need lowest initial financial investment with lowest even more annually expense. The company should prioritize the resource allocation on these techniques on the basis of its offered resources and the prospective advantages which the strategy would offer.
NOTE: The worths about cost are presumed on logical basis due the lack of figures and truths associated with cost in the event research study. Inflation rate of United States is assumed to be 10%.


On the basis of deep analysis of the internal and external factors of Excel Model For Aggregate Production Planning Aggprods Case Study Solution triggering the decline of tv viewership rate and attendance rate at tracks, the above marketing strategies are recommended to NASCAR to increase its fan base in long run. These techniques would deal with internal aspects like bad client experience at tracks, inadequate social networks marketing, incapable digital medias like games, absence of culturalisms at tracks and so on, in addition to with external factors like shifting of fans towards other sports, demographical changes in America and altering family life styles.

Liz Claiborne China Verge Software B Xmarksthespot Note On Pre Money And Post Money Valuation Ab Risk Management At Apache
Selecting A Hosting Provider Zaplet Inc A Webmd B Avantgo
Strategic Planning At Sun Life Merloni Elettrodomestici Building For A New Century Brazil Embracing Globalization Efrenzy Inc B
Unext Business Education And E Learning Efrenzy Inc C Gucci Group Nv B Monsanto And Intellectual Property
Competition Policy In The European Union And The Power Of Microsoft Verge Software A Robert Shapiro And Monsanto Web And It Hosting Facilities Technology Note
The Global Water And Food Supply Problem Exchange Rate Terminology And Analytics Exchange Rate Exercise Technology Legend In China
Supply Chain Management At World Co Ltd Quest Foods Asia Pacific And The Crm Initiative Corruption In International Business B Hidden Costs Of It Outsourcing
Limits Of Mass Customization Power Of Strategic Integration Execution The Missing Link In Retail Operations Decision Making Its Not What You Think
Learning From Toys Lessons In Managing Supply Chain Risk From The Toy Industry The Good Commissioner Linking Actions To Profits In Strategic Decision Making Enabling Customization Using Standardized Operations
Organizational Support For Employees Encouraging Creative Ideas For Environmental Sustainability Framework For Analyzing Environmental Voluntary Agreements Corporations Communities And Conservation The Mountain Institute And Antamina Mining Co Francisco De Narvaez At Tia Selling The Family Business Video
Katharine Graham Color Kinetics Inc A Color Kinetics Inc B Amazoncom Update January 2001 July 2002
Amazoncom Evolution Of The E Tailer Charlene Barshefsky A Real Options Valuation When Multiple Sources Of Uncertainty Exist Charlene Barshefsky B
Extracting Information From The Futures And Forwards Markets The Relation Between Spot Prices Forward Prices And Expected Future Spot Prices Napster Montefiore Medical Center Valuing The Option Component Of Debt And Its Relevance To Dcf Based Valuation Methods
Arvin Exhaust Thailand Building An Asian Supply Base Sustainable Development And Socially Responsible Investing Abb In 2000 Corruption In International Business A E Commerce In Latin America
Progressive Insurance Firestoneford Tire Controversy B Syncra Systems Psinet Building An Internet Super Carrier A
First For Inspiration And Recognition Of Science And Technology Notel A Speak To Me Power And Influence Achieving Your Objectives In Organizations Kelon A Chinas Corporate Dragon
Technical Note On Managing Inventories Periodic Review System The Israel Cancer Association B Merrill Lynch Holdrs Dpsc Software Post Acquisition Evaluation
Circon B Circon C Veltvest Corp Breakup Of Att Project Grand Slam
Samhoud Service Management Yvette Hyater Adams And Terry Larsen At Corestates Financial Corp Time Warner Vs The Walt Disney Co A Pulling The Plug Chiquita Brands International B
Time Warner Vs The Walt Disney Co B Reaching Agreement Identifying And Realizing Investments In Eastern Europe B Identifying And Realizing Investments In Eastern Europe A Pricing Strategy And The Net
Security Factors Fdi In China Iturf Note On Valuation Of Venture Capital Deals
Venture Capital Vignettes The Israel Cancer Association A Range B Merck Latin America D Mexico
Merck Latin America B Argentina Sime Darby Berhad B The Asian Crisis Begins Two Big Banks Broken Back Office Merck Latin America A
Tampa General Hospital The Politics Of Privatization Sequel An Introduction To Business To Business Exchanges Hdfc B Merck Latin America C Brazil
Tampa General Hospital The Politics Of Privatization Sime Darby Berhad C Responding To The Asian Crisis Word Of Mouth Referral Module Note Service Recovery Module Note
Wingspanbankcom B Should This Bird Still Fly Note On Service Excellence Citigroup Asset Management Aes Corporation B Global Sourcing Initiative
Mack Henley D Macromedia Inc Weaving Dreams Of Global Markets And New Technologies Excel Model For Aggregate Production Planning Aggprods Sweet Concepts Inc Trade Show Marketing
Big Deal Or No Big Deal International Speedway Corporation Six Sigma Fx Cascade Bellaire Clinical Labs Inc B
King Roberts B Note On Acquiring A Specialty Retailer Competitive Cost Analysis Scale And Utilization Calculations Ginnys Restaurant
Mack Henley C Aggregate Production Management 2002 Competitive Cost Analysis Cost Modeling Techniques General Electric 2000 Quality Of Earnings Assessment
Mack Henley B Mack Henley A Note On The Development Of Management Communication In Graduate Business Schools Technology Strategy For A Diversified Corporation