Qualitative Analysis Tacobell and Walmart

466 Words2 Pages
Quantitative Analysis My choices for the Quantitative analysis is Taco Bell and Wal-Mart Taco Bell used forcasting and Qualitative analysis models to help save over $150 million in the mid 90’s, it started a trend that has caused many if not all fast food establishments to adopt this principle to focus on what time sales are at a peak and when more employess are needed and what training is necessary for the staff due to over/under rings and other factors. The choses process is a data warehouse and reporting structure to address the requirements for a fast food franchise operation. The company Exclusive ore designed and implemented the process initially for 80 Taco Bell and Kentucky Fried Chicken locations. The process was so effective it was implemented in all locations country wide and eventually internationally as well. The program had 2 main sources of data to gather, 1) Daily sales information automatically polled by the TACO system DePol utility. 2) Period based accounting information from the Dynamics accounting database. The data for reporting and analysis is processed into OLAP cubes, the cubes are then accessed through Excel by using BusinessQuery MD, the data is then able to be analyzed by slicing and dicing the data by store, company, zone, area, by accounting year, quarter and period as far back as 1996 and also by brand and concept. The data can then further be analyzed by The SalesOps and SalesMix cubes are updated overnight and contain up-to-the-minute (through yesterday) information captured by the cash registers (POS) in each store. This enables managers to evaluate and compare trends in speed of service, labor usage, over/under rings, employee food purchases, etc., by store, zone, area, concept, subsidiary, etc. Because sales and counts are recorded in 15-minute intervals, called day parts, managers can use this to find strange

More about Qualitative Analysis Tacobell and Walmart

Open Document