Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-11-2016, 12:28 PM
lonniepoet lonniepoet is offline Help with formula and math involved with totaling data for invoicing Windows 7 32bit Help with formula and math involved with totaling data for invoicing Office 2013
Advanced Beginner
Help with formula and math involved with totaling data for invoicing
 
Join Date: Dec 2015
Location: Kansas City
Posts: 41
lonniepoet is on a distinguished road
Default Help with formula and math involved with totaling data for invoicing

I’m working on a spreadsheet to help track the hundreds of small orders and their revisions that we will be getting over the next few months. The purpose of the spreadsheet is to help determine what to invoice by the end of each order. I attached a copy of what I am working on but I need help with a couple of the formulas and some of the math involved to get to the next level.

Long story short, the pricing agreement established by my customer is as follows:
1. $300 startup base cost for all orders up to 3 revisions (see column K). $50 for each revision after 3.
2. 1 free WB (white body) per revsion (see column E). Additional WB’s are $25 each.
3. All digital orders (see column F) are $3.50 per square foot (see column N).

I need help with figuring out how to figure revisions past the 3rd one into what to invoice. I also need some help fine tuning my math and maybe making them formulas. For example, what if they order 0 WB’s? I need a better equation/formula. Any help would be much appreciated.
Attached Files
File Type: xlsx Asia PDQ Tracking_test.xlsx (14.6 KB, 8 views)
Reply With Quote
  #2  
Old 01-11-2016, 02:33 PM
gebobs gebobs is offline Help with formula and math involved with totaling data for invoicing Windows 7 64bit Help with formula and math involved with totaling data for invoicing Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

Quote:
Originally Posted by lonniepoet View Post
I need help with figuring out how to figure revisions past the 3rd one into what to invoice.
Cost = Base + RevCost + WBCost + DigCost
Base = 300

For Line 4:
RevCost = Max(K4-3,0)*50
WBCost = Max(E4-K4,0)*25
DigCost = 3.5*H4*G4*F4/144
Reply With Quote
  #3  
Old 01-11-2016, 03:01 PM
lonniepoet lonniepoet is offline Help with formula and math involved with totaling data for invoicing Windows 7 32bit Help with formula and math involved with totaling data for invoicing Office 2013
Advanced Beginner
Help with formula and math involved with totaling data for invoicing
 
Join Date: Dec 2015
Location: Kansas City
Posts: 41
lonniepoet is on a distinguished road
Default

Thank you, gebobs. This formula/equation should work exactly for what I need.
Reply With Quote
Reply

Tags
formula help, mathematics, total

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Totaling on hours problem 56_kruiser Excel 6 09-04-2014 07:01 PM
Help with formula and math involved with totaling data for invoicing A simple select for a given math formula Jo-NathanBSChE Excel 1 04-16-2013 03:10 AM
Help with formula and math involved with totaling data for invoicing Can't get formula to recognize correct data cklassen Excel 1 05-19-2012 01:25 AM
How do I embed a Math formula? DMD Word 0 11-17-2009 12:37 PM
Outlook CONTACTS used for invoicing Garratt Outlook 0 02-16-2006 06:33 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft