Maintain the same number in a spreadsheet

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I use a spreadsheet to calculate my contract price for a bid. I would like to maintain the same price amount with a formula that would automatically adjust the percentage of profit up or down when a direct cost in the spreadsheet amount is changed. For example; if I have a bid price of $1000 with a 10% profit ($100)and the price of an item that is part of the direct cost goes from $50 to $60 the percentage woud autamatically adjust my profit from 10% to 9%, decreasing my profit to $90, accounting for the additional $10 of direct cost, but the bid price would remain at $1000.
 
I use a spreadsheet to calculate my contract price for a bid. I would like to maintain the same price amount with a formula that would automatically adjust the percentage of profit up or down when a direct cost in the spreadsheet amount is changed. For example; if I have a bid price of $1000 with a 10% profit ($100)and the price of an item that is part of the direct cost goes from $50 to $60 the percentage woud autamatically adjust my profit from 10% to 9%, decreasing my profit to $90, accounting for the additional $10 of direct cost, but the bid price would remain at $1000.
Click to expand...

Please post this Excel question in an Excel forum. This newsgroup is for a
different program, Microsoft Access.
 
It sounds like you're using Excel, not Access. You should probably post your
question to the Excel forum. If your are using Access, and it probably would
be a better option than Excel by the description you give, then you should
use the term table instead of spreadsheet. Access does not have
spreadsheets. - At any rate...

In access you should have a table that hold your bids, another table that
holds your costs on that bidded item, linked together by bidItem or something
like that. Then you can do a report that totals all costs and then
calculates the percent profit based on the bid amount.
 
Back
Top