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

Reply
 
Thread Tools
Old 20th January 2018, 02:06 PM   #1
Afriel444
Member
 

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

Hi,

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, 10:50 AM   #2
Logan
Administrator
 

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

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, 12:12 PM   #3
Afriel444
Member
 

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
Reply   

Bookmarks


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


Free Links - Free Advertising
Free Guide - Online Directory



Advertise your business here
Contact us for more details!


Semantic Juice
Register now to access free Quick SEO service!


Rocket Lawyer
Sign up for free 7 day trial. Boost your biz!


Buy UPC Codes
Get your products listed online!




All times are GMT -5. The time now is 01:31 AM.


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