Sales Report of XYZ Comapny

Sales Report of XYZ Comapny


For every company or institution which is build or started for profit generation, the sales are very important because that is the main backbone of every organization which keep its momentum well equipped for the future. In every company or organization, the top leadership generally focused on its sales, performance of staff and for this process, heavy amount is generated to keep the sales upright and forward in comparison to other organization because of this, they can survive in the market.
To this preview, we have analyzed the sales of XYZ Company generating the fake data for any knowledgeable person who can easily understand by looking at the graph generated by us. We have deeply focused on the employee’s sales because without them, the sales of a company cannot grow.



For example, if we analyze the overall performance of Puneet, he has sold a total of 2806 units out of which in Delhi, his performance is not up to the mark because he has conceded only 200 units but in Kolkata, Mumbai and Gurgaon he has stronghold because of 390, 385 and 365 units sold by him respectively.



If we more analyze the performance of Puneet area wise, especially Delhi, the month January, February and April was not good because the units sold was not high, but his performance has steadily grew in the month of March, May, June and July.



In the overall performance of Puneet, the month of February, May and June was not high but his performance grew in the month of January, March and April. In July, August and September also, he has sold pretty good units for the company which has taken the organization to major level. For the analysis of any other employee and his performance in the respective city and respective month, the dashboard of sales report is attached herewith which is handy and can be understood by a layman also.

Comments

  1. pralay14 March 2015 at 05:08

    Employee Name drop done is not dependent on City droop down, i.e: by selecting delhi only delhi people should be listed.

    ReplyDelete
    Replies
    1. Unknown14 March 2015 at 10:37

      Dear Pralay,

      Thanks for your feedback, i have made some change 's now City and Employee both are Dependent to each other.

      Please review it and follow my upcoming analysis for practice.

      Delete

Post a Comment

Popular posts from this blog

TDS Calculation System

Image
TDS Calculation System Calculation of how much TDS should deduct from salary will become headache for every employee who will come in the criteria of Tax. In the month of Feb and March employee loosing patient and spent most of the time in internet and communicate with other employee and accountant for better solution to save tax but they do not get appropriate solution. I have designed a nice TDS Calculation System to calculator which will give right and valued information from which the get the scenario of interest and monthly TDS. Download File
Read more

VBA - Additional Controls Dialog Box "MISSING"

VBA - Additional Controls Dialog Box "MISSING" Additional Controls Dialog Box "MISSING" solution, let's do this. 1-click on start menu( in the left on your desk top ) 2-drage a shortcut of Microsoft Excel in your desktop 3-Right click on it and choose Properties then click on compatibility Tab 4-set check on run this program in compatibility mode for 5-Apply then OK Now open Microsoft Excel or (any ms Application like Word, ppt etc), You can see everything is OK and additional Control box is working well This problem usually happen when we change or config our Microsoft to new version( 2003 to 2010 ,.....)
Read more

Loan EMI Calculator Dashboard

Image
Loan EMI Calculator Dashboard Generally the Loan EMI calculation is a headache for every customer when  demanding a sum of money from any bank. The customers search in the internet for better solution but they do not get appropriate solution. We have designed a strong EMI loan calculator which will give right and valued information from which the customers get the scenario of interest and monthly EMI. For example, if any customer is taking 10 Lakh loan at the rate of 10% for the period of 15 years, he/she has to pay Rs 10,746 every month to the bank and if a customer is taking 5 Lakh loan at the rate of 10%, he/she has to pay Rs 5373 every month to the respective institution from where he/she has taken the loan. For Rs 7,50000, the customer has to pay Rs 8059 to the bank at the rate of 10% for the period of 15 years. For the loan of 10 Lakh, the customer has to pay 9,34289 as interest which will build up to 19,34,289 as total in 15 years whereas for the ...
Read more