Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 05-19-2016, 08:30 AM
Purge07 Purge07 is offline Excel calculation help Windows 8 Excel calculation help Office 2013
Novice
Excel calculation help
 
Join Date: May 2016
Posts: 3
Purge07 is on a distinguished road
Default Excel calculation help

I need help in finding out a formula that will help me in calculating the final prices of things and to give me a constant profit of 30.00.

Final price =X (unknown)
Transaction fees of final price .35 +13%
Shipping/handling + processing costs =31.06 I am charged this by company that send me the items.


Profits to be = to 30.00
Item costs for me = variable such as 34.00 or 83.00 which is a number than can be changed as costs change.
Reply With Quote
  #2  
Old 05-19-2016, 08:34 AM
Purge07 Purge07 is offline Excel calculation help Windows 8 Excel calculation help Office 2013
Novice
Excel calculation help
 
Join Date: May 2016
Posts: 3
Purge07 is on a distinguished road
Default

So
final price x 13% - .35 - my costs - ship/handling costs =30.00 profit
Reply With Quote
  #3  
Old 05-20-2016, 06:23 AM
xor xor is offline Excel calculation help Windows 10 Excel calculation help Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

If I understand you correct:
x = final price
t = transaction fees
c = transaction/handling and processing costs
P = profit
then
x = t+c+p
x = 0.35 + 0.13x + 31.06 + 30.00
0.87x = 61.41
x = 70.59
Reply With Quote
  #4  
Old 05-20-2016, 10:01 AM
Purge07 Purge07 is offline Excel calculation help Windows 8 Excel calculation help Office 2013
Novice
Excel calculation help
 
Join Date: May 2016
Posts: 3
Purge07 is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
If I understand you correct:
x = final price
t = transaction fees
c = transaction/handling and processing costs
P = profit
then
x = t+c+p
x = 0.35 + 0.13x + 31.06 + 30.00
0.87x = 61.41
x = 70.59

Only thing is you forgot the cost of the items. Such as 84.00 cost to me to buy the item to have in stock.
Reply With Quote
  #5  
Old 05-20-2016, 07:46 PM
xor xor is offline Excel calculation help Windows 10 Excel calculation help Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

So problem solved, or?
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Help with a sum calculation please. ballst Excel 4 06-04-2015 11:40 AM
Please help with age calculation!!! Microsoft Idiot Word 4 10-29-2012 05:54 AM
Excel calculation help Excel Calculation Problem UnholySmoke Excel 2 09-14-2011 08:15 AM
Excel calculation help Excel 2010 formula rounds - arithmetic average calculation YooNaa Kim Excel 1 06-07-2011 08:50 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:48 PM.


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