Markdowns are omnipresent in retailing and play a significant role for any retailer’s strategic decision making.The need for markdowns arises because of variations between predicted sales and actual demand in the selling season.
Despite the benefits it offers, many retailers find it difficult to implement the tool because of the complexities involved and adverse consequences that result because of sub-optimal markdowns. The challenges most retailers face today are threefold i.e. determining optimum markdown levels, determining timing of markdowns and identifying goods for markdown.
In this paper, Perceptive presents a methodology that enables a retailer to track performance of its merchandise and identify items that are under or over-performing and also discusses various best practices using which you can maximize value from markdown optimization.
Marketers in CPG industry are constantly faced with the challenge of allocating their fixed marketing budget among various marketing channels like traditional communication mediums and digital channels.
To achieve effective budget allocation for marketing, companies have to rely on many of the marketing tools available today and create models that will show the impact each of this channel has on sales.
This case study will summarize the various marketing mix models available for marketers by analyzing the strengths and weaknesses of each of them. In particular, we focus on regression models, influence maximization models; agent based models and empirical methods being used by the marketers.
The client has started a closed-ended hedge fund of $15 MM. With three types of investments available, each with a different rate of return and associated risk, the client wanted to analyze the returns under various scenarios.
Faced with this challenge, the client approached Perceptive Analytics to build a model that tracks the performance of the fund and recommends action to obtain maximum return for the selected scenario.
Our model helped the client as a decision support tool for investments in various instruments. The client was also able to optimize the risk by balancing the funds amongst various investments.
Delhi’s ODD-EVEN Rule: You Think It’s Fair? Not True!
Analytics company Perceptive Analytics reveals that odd numbered cars are inherently at an advantage and get 4% higher access to Delhi roads
January 12, 2016
You would think that both odd and even numbered cars have equal access to the Delhi Roads? However, if you are a car owner with an even registration number, you may get lesser chances to use the road. A detailed analysis for 2016 to 2020 by Perceptive Analytics, a Hyderabad based analytics company, reveals that the odd numbered cars have an unfair advantage.
“The calendar gives an inherent advantage to odd numbers because it has seven months with thirty-one days which means seven more odd numbered days. 2016 is a leap year and you get a bonus with February 29th,” said Chaitanya Sagar, CEO, Perceptive Analytics, “Our analysis found that this adds up to 7 extra days for odd numbered cars over even.”
Bonus: Odd numbered cars can drive for 4 continuous days, TWICE!
The analysis further reveals that odd numbered cars also get four continuous days of access in 2016 while even numbered cars can drive just for one day during that period. This happens twice – once in February [Feb 27th – Mar 1] and again in October [Oct 29th – Nov 1].
In addition, ODD numbered cars get 10% higher two day consecutive drives. This happens consistently in all years.
How to offset the advantage: Make 3 odd dates drivable for Even numbered cars instead of odd cars
Delhi government can offset this advantage by giving three of the odd days to even numbered cars instead of odd cars. Those can include the days from Feb 27th to Mar 1 and Oct 29 to Nov 1 – ideally, Feb 29th and Oct 31.
About the Analysis
Perceptive Analytics has simulated the odd-even driving rule for all days in 2016, 2017, 2018, 2019 and 2020. We then tabulated the number of days that the odd and the even numbered cars can drive. We analyzed the information to arrive at the conclusions we presented in this article. If you would like to view complete analysis, please visit our website: Delhi’s ODD EVEN Rule Analysis.
About Perceptive Analytics
Perceptive Analytics is an emerging leader in marketing data analytics. With sound technical and domain knowledge, Perceptive Analytics is a trusted partner for its clients and provides data analytics solutions in Pharma, Retail and e-commerce industries. With its Offices in New York, San Francisco and Miami, Perceptive Analytics has a proven track record in providing result driven solutions to large and medium sized companies globally across USA and India.
Goutami Chitrapu, Saurabh Sood, Krishna Kishore Neelamraju and Vivek Singh contributed to this analysis.
Survey 91, SVK premises
Hyderabad, AP 500032
Our client is the CFO of a mid – sized company based in Chicago, IL. He was looking for research support to assess the investment opportunity in a mining company listed in NASDAQ.
Perceptive helped the CFO by developing an Excel-based model that captured historical financial data and prepared revenue and cash flow projections. The key investment metrics calculated and scenario analysis built in the dashboard provided client with the support needed to analyze and predict stock performance.
This model provided client with a holistic view of current business situation as well as performed macro-economic analysis to help client understand possible economic developments and their implications on performance.
The client decided to spin off its gas division and focus independently on it. The newly formed entity provides two types of services viz., gas distribution and gas filtration.A major challenge in gas distribution business is fixing the tariff rate.
Faced with this challenge, the client approached Perceptive Analytics to build a model that could fix the tariff rate to be given to its end users.
We helped client assess the financial viability of the spin-off decision. The model presented a comprehensive control of key variables affecting the tariff rate. It calculated key metrics like ROI and IRR for a given tariff rate and also vice-versa enabling the client to set a competitive per gallon price.
The client, a non-profit art organization as part of its outreach programme saw strong growth in student enrolment and the number of artists participating in monthly exhibitions. To meet growing demand, the organization decided to renovate its premises and add additional space.
The renovation of the building is a costly affair and the management wanted to make sure it had sufficient cash flows to mitigate the risk of stalling work. Perceptive Analytics built a revenue model that simulated cash flows under various scenarios. The model highlighted cash crunch situations under each scenario allowing adequate time to take corrective measures.
Coupons are recognized to be a highly effective sales tool for all businesses. In 2012, marketers distributed around 310 billion valued coupons at $484 billion. Today coupons affect commerce in much more powerful way than ever before and coupon deals have become a cutting edge promotion tool. Marketers view coupons as an efficient way to influence the smart newer generation of busy consumers. But, if the managers are not careful with the design and timing of the coupon campaign, coupons can have negative impact on business performance. We identify face value, expiration date, purchase requirement, timing and distribution of coupon as the most critical factors in optimizing a coupon campaign.
The client is a financial services company based in New Jersey, USA. It focuses on financial planning, retirement solutions, and insurance. It has a dedicated loyal customer base and is essentially an offline company depending largely on sales people for lead generation. The customer base of the client is geographically bound to the surroundings of New Jersey and Maryland.
The client started its online presence in the form of a website 10 years ago but hardly ever realized any business from it. It has also invested considerably on the web, in the form of advertisements and content, in an attempt to attract new customers. However, the investment has not produced any decent results. The problems identified include: Low relevant traffic, inappropriate landing pages, high bounce rate, low engagement and poor conversion ratio.
PayAvenue is a payment gateway provider that allows users to pay for their online purchases. Its services are accepted by a wide range of both retail and non-retail merchants across United States. For every online transaction, PayAvenue charges a small amount as commission. Utilizing transaction data, PayAvenue can enter into strategic partnerships with its clients.
The CEO of PayAvenue, realized that the current business had low margins and he wanted to move to a higher margin alternative with the existing operational setup. With this objective, we analyzed the data to find significant cross-selling options.
NiteFoodie is a medium sized American fast food chain based on the west coast. The client offers a variety of foods and serves around 20 million consumers each year through its 60 restaurants.
The company had entered food truck business two years ago and expanded aggressively to gain market share. Due to the fast paced growth processes in the company did not evolve for large scale services. The company faced low margins in its packaged food distribution and found that there was scope for significant improvement.
The company needed a solution to optimize food pack distribution to reduce costs. Perceptive Analytics analyzed processes and developed a tool that optimally distributed the food packages required among the carriers. The whole exercise resulted in annual savings of nearly 17%.
* These fields are required.