Costing Spreadsheet - Calculate Profit per product or service - Create eBay Spreadsheet Excel

Поділитися
Вставка
  • Опубліковано 5 вер 2024

КОМЕНТАРІ • 36

  • @catherinecheynedavies
    @catherinecheynedavies 6 місяців тому +2

    Thank you for your step by step guide on how to use the spreadsheet as I am totally number illiterate!
    Starting out in business is a struggle for me with knowing the easy way to price up my products to enable me to make a profit and not a loss,
    Catherine

    • @BookkeepingMaster
      @BookkeepingMaster  6 місяців тому

      Glad it was helpful! Thanks for taking the time to comment.

  • @TheWellnessAbbey
    @TheWellnessAbbey 4 роки тому +6

    Thank you- this video has given me reassurance that I was on the right track with my costing spreadsheet. Thank you for filming this!

  • @bastionwolf
    @bastionwolf 5 років тому +6

    This is exactly what I have been looking for, thank you so much this is perfect and very well explained.

  • @adejokeotulana6616
    @adejokeotulana6616 10 років тому +2

    thank you very much for this video, i feel like i pro after watching it. i have saved it for future use cos knowing me i'll forget how i did it the first time round

  • @IncrediBobie
    @IncrediBobie Рік тому +1

    thank you this is very helpful. ♥from Philippines

  • @junelovejoyofficial
    @junelovejoyofficial 4 роки тому +2

    Super helpful video! Thank you so much!

    • @BookkeepingMaster
      @BookkeepingMaster  4 роки тому

      Your kind words are much appreciated. Thanks for watching

  • @msafe5167
    @msafe5167 3 роки тому +2

    How do you workout a selling price based on a desired profit?

    • @BookkeepingMaster
      @BookkeepingMaster  3 роки тому +1

      Work backward. Start with the profit you wish to make, add all expenses, you will then have the selling price. Thanks for watching.

  • @sandrafay334
    @sandrafay334 8 років тому +1

    Quick question. How can I determine how much I'm spending to make and sell a T-shirt. Like the price of the vinyl, how much vinyl I'm actually using to make the shirt ( how much it costs per inch) and the cost of the actual shirt itself. Don't want to short change myself. Thanks so much. New subbie here.

    • @YS-mg2cu
      @YS-mg2cu 7 років тому

      calculate how much the material in bulk cost then divide that by what your using per item. Then subtract from your selling price.

  • @BadamosiYusra
    @BadamosiYusra Рік тому +1

    Thank you very much

  • @CuocSongGianDon223
    @CuocSongGianDon223 2 роки тому +1

    Thank you. So helpful!

  • @savrtheflavr
    @savrtheflavr 8 років тому

    Great video, thank you. I was wondering why you merged the cells in the beginning of the video.

    • @BookkeepingMaster
      @BookkeepingMaster  8 років тому

      Just habit. You can adjust the size of the cells instead. Thanks for watching.

  • @pelvicangel
    @pelvicangel 8 років тому +1

    excellent, this is just what I was looking for . Thanks

  • @brynmag
    @brynmag Рік тому

    I have a similar spreadsheet that I have been using for years. I am trying to update it to work out a "Floor" price for selling items that includes a 10% profit margin and also the selling fees between various marketplaces, ranging from 10-14%. I can't get my head around that formula. Any suggestions?

    • @BookkeepingMaster
      @BookkeepingMaster  Рік тому

      =thecellwithcostprice*0.10
      Does this help at all?

    • @brynmag
      @brynmag Рік тому

      @@BookkeepingMaster It's more complex than that. Selling fees vary depending on the sell price. So the amount needs to be worked backwards not forwards. I'll keep trying to find the answer. Thanks for responding.

  • @TonyMilanoOfficial
    @TonyMilanoOfficial 7 років тому +1

    Exactly what I needed! Cheers!

  • @johnbrett4092
    @johnbrett4092 9 років тому +1

    Thank you, really helpful and exactly what I wanted!

    • @BookkeepingMaster
      @BookkeepingMaster  9 років тому

      +John Brett No problem. Please check out my website for more free videos.

  • @66rickf
    @66rickf 9 років тому +3

    This spreadsheet is incorrect as ebay and paypal fees come from your selling price including postage, not cost price ex postage. They always take their percentage from retail incl post.

    • @nathanyoung7587
      @nathanyoung7587 8 років тому +1

      Its not incorrect if you're not charging the customer for shipping. But you are correct if you are charging the customer a separate shipping fee.

  • @ferttt7595
    @ferttt7595 10 років тому

    Hi I hv been selected to a admin job. But they asked me to do accounts. I really dont knw anyting abt account. But my friend said if I see sm videos I cn catch it. do u thk is it possible? If so wht I hv to do nw? Plz help me.

  • @dreww7498
    @dreww7498 7 років тому

    can we have the template?

    • @BookkeepingMaster
      @BookkeepingMaster  7 років тому

      I may have one saved on my desktop. Send me an email and I will see what I have got - info@bpfs-online.com

    • @dreww7498
      @dreww7498 7 років тому +1

      I emailed you and haven’t heard anything back. I could send you a donation for the file.