Welcome to the Small Business Ideas Forum! We are a community of over 100,000 small business folks with over 163,000 posts for you to browse. We pride ourselves on being the friendliest forum you will find and we'd love to have you as a member of our community. Please take a moment and register for a free account. If you need any help, please contact Chris Logan.

Small Business Ideas Forum

Small Business Ideas Forum

A friendly place to share small business ideas and knowledge, ask questions, find help and encourage others that are involved in the small business industry. Topics include small business marketing, generating revenue and small business computing.

Go Back   Small Business Ideas Forum > Small Business Computing > Computer Software
Register Search Today's Posts Mark Forums Read

Thread Tools
Old 20th January 2018, 03:06 PM   #1

Join Date: Jan 2018
Posts: 2
Default Product Sales Spread Sheet


My parents run a small business; it is just the two of them. They have started to sell some products. The amounts are tiny. I created some spreadsheets to calculate the revenue they are getting buy using their purchase cost and the client's purchase price. It's perfect but for one thing. My spreadsheet assumes that the prices my parents pay for the products are constant. They are not. They may get 10 units for $6, and then find it on sale and order 10 units for $5. Does anyone know of a downloadable spreadsheet for this situation, or can help my write an equation for this to work in excel?

Any help or advice is appreciated!

Afriel444 is offline   Reply With Quote
Register or log in to remove this ad.
Old 21st January 2018, 11:50 AM   #2

Join Date: Jun 2004
Location: Colorado
Posts: 8,047

Hi Afriel444, thank you for joining in with us. Could you have a base price for each unit (i.e. $6.00) then have another variable for discounted/additional costs (-16.66%) for a real cost? The variable for the discount could be adjusted each time or be zero if the base cost is the real cost.

Search Engine Guide - Small Business Guide to Search Marketing
Small Business Brief - Small Business Ideas Forum, Articles & News
Logan is offline   Reply With Quote
Old 21st January 2018, 01:12 PM   #3

Join Date: Jan 2018
Posts: 2
Default Perfect!

So I was just summing columns and multiplying by a constant, so that wouldn't work. Now I got rid of summing the 2 columns and instead created a third column with an equation that would do the sum, and have a variable that could be changed for price. Perfect. I'm sure there's an easier way than that, but this will get the job done for the small amount of product they go through. Thanks for the tip; I'm not sure if I did what you meant exactly but it got my brained jogging and problem solved. Thank you!

Afriel444 is offline   Reply With Quote


Similar Threads
Thread Thread Starter Forum Replies Last Post
Business Idea (Feedback?) Jakea91 What Type of Business Should I Start? 4 26th July 2016 06:47 AM
Copywriting Tips Mark Andrews Copywriting 4 9th January 2014 05:13 AM
The Success Of Your E-commerce Web Design Depends On The Product Page acwebguru Website Development 2 13th May 2013 10:30 AM
How To Properly Light Your Product Photos For Better Sales Online Linda General Online Marketing Information 5 4th April 2008 03:54 PM
Collecting State Taxes On Your E-commerce Site PressureProsInc Ecommerce 1 23rd March 2008 02:53 PM

Thread Tools

Get Updates
RSS Feeds:
RSS Feed for Computer Software RSS for this Category Only: Computer Software

RSS Feed for Small Business Ideas Forum RSS for Entire Forum
Forum Rules

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Small Business Ideas Forum

At Your Business - Small Business Directory
Free Business Forms - Prewritten Documents
Search Engine Guide
Small business guide to search marketing

Small Business Brief
Fetching the Best Small Business Info

Used Values - Free Links
Blue Book

All times are GMT -5. The time now is 03:51 AM.

Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004 - 2018 - Privacy