1. #1
    Unregistered

    MIS format for Aqua Guard Marketing professional?

    I am a marketing professional of Aqua Guard. My job is to visit customers home, demo of the product and take the orders. My senior has asked me to prepare a MIS format. I have never did so. Kindly help me to make it.

  2. #2
    randhirk.rk Array
    Join Date
    Aug 2012
    Posts
    181

    Re: MIS format for Aqua Guard Marketing professional?

    If you want to make an MIS format- that is to preapare the daily sales report

    you boss wants what you did whole day

    This format can be made in the excel -

    the headings of the format can be:
    S.no
    Date
    Name of the customer
    Address of the customer
    Tel No if any

    Time of visit
    If Product Demo given to customer
    Time taken to give the demo
    Customer feedback and queries
    Remarks if any

    I think if you fill these column on daily basis that will be ok with your boss

  3. #3
    looser Array
    Join Date
    Jul 2012
    Posts
    619

    Re: MIS format for Aqua Guard Marketing professional?

    Hi friend,

    As you need to prepare MIS report. its very easy to prepare.

    Mainly make use of the excel spread sheet in order to make the report.

    MS excel would be convinient for you to prepare a report.

    You would get all the formulae related to that and mostly make use of the vlookup and pivot
    .

    THE MAIN THINGS THAT ARE TO BE INCLUDED IN THE EXCEL SHEET AS HEADINGS ARE:-

    1. SERIAL NUMBER.

    2. DATE.

    3. NAME OF THE CUSTOMER.

    4. ADDRESS OF THE CUSTOMER.

    5. MOBILE NUMBER.

    6. PRODUCT DETAILS.

    7.TIME OF ARRIVAL.

    8. TIME OF EXIT.

    9. FEEDBACK AND SUGGESTIONS.

    10. REMARKS.

    11. SIGNATURE.


    All these are the things which you need to include in ms excel spread sheet in order to make your work easy and faster.

    Hope i have helped you in getting answer to your query.

    all the best.

    thanking you....

  4. #4
    king87 Array
    Join Date
    Jul 2012
    Posts
    62

    Re: MIS format for Aqua Guard Marketing professional?

    Dear friend ,

    mis means daily sales report of the products.

    This will be made on microsoft excel.

    1. Serial no

    2. Date

    3. Customer name

    4. Customer address

    5 customer contact no.

    6.visiting time

    7.product name which is shown to customer

    8. Customer feedback.


    All the best......

+ Reply to Thread

Similar Threads

  1. Excellent Resume format for MBA student?
    By Unregistered in forum Professional Discussions
    Replies: 12
    Last Post: 04-06-2013, 10:03 AM
  2. How can I get sitting Marketing job after MBA in Marketing?
    By Unregistered in forum Professional Discussions
    Replies: 9
    Last Post: 16-05-2013, 03:33 PM
  3. How to work on payroll format?
    By Unregistered in forum Professional Discussions
    Replies: 5
    Last Post: 06-02-2013, 12:01 PM
  4. Difference in Resume format of Marketing professional and an Engineer?
    By Unregistered in forum Professional Discussions
    Replies: 4
    Last Post: 20-09-2012, 04:24 PM
  5. Replies: 2
    Last Post: 23-08-2012, 06:33 PM