Management Information Report
Mr. Sam Adams, after(prenominal) putting in together the information provided for your pizza restaurant, I have concluded on the following analysis and recommendations for the subdued operation of your business that should definitely encourage you in efficient sales and management.
1)With the sales figures for to each one of the pizza sold and the ingredients necessary for those pizzas, I was able to estimate your daily and weekly requirements for the ingredients. This leave behind help you to predict the usage of all ingredients and you suffer pull back on the information to your staff as in what meter of stock they should be ordering. This will also help you evacuate wastage of the perishable ingredients. The summary sheet on the worksheet will be your guide as in average stock of ingredients needed.
daytimebaconbeefblackolivesgreenpeppershammushroomsonionspepperonipineapplesausagetomatolgdoughmeddoughsmdough domozzarellaparmeseancheddarprovolonemeunster
17649137410868128538477777
24324632553464218234444
34313621463263217214444
47637126310665108331405555
51411614231061717111220156637911111111
6191582335158252915162923119612117171717
71312718281372023121324188779714141414
U/Mpkgpkgcanpkgpkgpkgpkgpkgcanpkgpkgboxboxboxcanpkgpkgpkgpkgpkg
2)The data rag 1 in the worksheet will help you know the swerve in which the pizzas are sold according to the day, week and month of the year. This table will help you determine what will be the trend of sales in a particular season. separate for example sales are higher in crepuscule from the months of October to December on an average. This table will also help you figure out the average sales of type of each pizza. Below I have shown the average sales of the week 52 and 53.
Also by changing the preference in the pivot table you can...If you want to get a well(p) essay, order it on our website: Orderessay
If you want to get a full essay, wisit our page: write my essay .
No comments:
Post a Comment