These are projects posted by the students of Dr. Gove Allen at Brigham Young University. These students have taken one semester-long course on VBA and generally have had no prior programming experience

Tuesday, April 14, 2015

Grocery Store Sales Report

Executive Summary
During the Chinese New Year holiday, a grocery store’s sales will increase rapidly, like Black Friday in the USA. But when the New Year period passes, sales just drop back to the normal pace, and sometimes sales also will drop some points in the other months. The grocery store’s manager keeps recording sales each month and makes a sales report to his boss.

So the goal of my project is helping this store to make an easier analysis of the sales in each department and each month. Also, the grocery store has promotion each month to promote their sales, but they do not estimate how much promotion they should use. Therefore, this project is designed for creating automatic charts for the manage analysis and  a calculator for a manager to set a sales goal and give an appropriate promotion each month. 

No comments:

Post a Comment

Blog Archive