Dismiss Notice
You are browsing this site as a guest. It takes 2 minutes to CREATE AN ACCOUNT and less than 1 minute to LOGIN

Mtaalam wa Microsoft Excel

Discussion in 'Matangazo madogo' started by MwanaHaki, Sep 18, 2010.

  1. MwanaHaki

    MwanaHaki JF-Expert Member

    #1
    Sep 18, 2010
    Joined: Oct 17, 2006
    Messages: 2,349
    Likes Received: 74
    Trophy Points: 145
    Namtafuta, miongoni mwenu, mtaalam wa Microsoft Excel, atakayeweza kunitengenezea document itakayofanya kazi hii:

    Sales Invoice

    Invoice inatakiwa kuwa na worksheet mbili.

    Worksheet ya kwanza ni ile ambayo itajazwa kuonesha ni bidhaa gani zinauzwa, jina na anuani ya mteja, jina na anuani ya mwuzaji, na gharama zote, zikiwa ni pamoja na usafirishaji wa bidhaa na kodi stahiki.

    Worksheet ya pili itawekewa orodha ya bidhaa zinazouzwa na bei ya mauzo ya kila bidhaa moja (unit price), na kupewa alama (Code) maalum.

    Kinachotokea ni kwamba, kwa mfano, mtu anauza spare za magari, kama ni tie-rod end, basi inakuwa na Code yake. Akiiweka kwenye mahali husika, maelezo ya bidhaa yanatokea mahali husika (mstari mmoja chini yake) na bei inatokea kwenye column mbili zifuatazo upande wa kulia, column ya kwanza anaweka idadi ya bidhaa zinazouzwa, chini kabisa majumlisho yote yanafanyika.

    Je, tunaye mtaalam wa kuweza kufanya kazi hii?

    Faida ya document hii ni kwamba, mwuzaji anachotakiwa ni kubadilisha bei na bidhaa, na kuacha Codes zikiwa pale pale, au anaweza pia kubadilisha codes. Invoice ya namna hii inaweza kurekebishwa kukidhi mahitaji ya sekta yoyote ile, hata kwenye mambo ya stationeries pie, kwani hakuna tofauti kubwa kwenye mfumo wa kibiashara.

    Asanteni.

    -> Mwana wa Haki
     
  2. Kobe

    Kobe JF-Expert Member

    #2
    Sep 18, 2010
    Joined: Jun 17, 2009
    Messages: 1,608
    Likes Received: 234
    Trophy Points: 160
    kwanini usitafute ile program ya POS, [oint of sales, inakuwa imekamilika kila kitu mpk deatils unakonunuambei percentage unayouzia,yaani ni mwisho wa tabu yako ya kibiashara.
     
  3. kisu

    kisu JF-Expert Member

    #3
    Sep 20, 2010
    Joined: Mar 31, 2009
    Messages: 752
    Likes Received: 18
    Trophy Points: 35
  4. K

    Kishazi JF-Expert Member

    #4
    Sep 20, 2010
    Joined: Nov 14, 2007
    Messages: 449
    Likes Received: 50
    Trophy Points: 45
    Mbona ni rahisi, ni PM then nikuelekeze kwa kijana wangu mmoja akutolee hiyo kitu in few minutes.
     
Loading...