Quote:
Originally Posted by masku
This is awesome!! May I suggest adding columns for Estimated Invoice:
Estimated US Base Invoice: =ROUND( 0.92*C2/5,0)*5
Estimated Options Invoice: =ROUND( 0.91*C6/5,0)*5
These estimates are based on previous year's invoice prices.
So, for example, you should get these Estimated Invoice Prices for the 550i: Base: $54,925
ZCV: $1,545
ZP2: $2,185
ZCW: $955
ZDH: $2,455
ZSP: $2,000 Note again that these are Estimates only.
|
The estimates for the Base Invoice seem to be off by $200, possibly because the Training Service Fee of $200 has been rolled into the Base Invoice.
http://www.bimmerfest.com/forums/sho...44#post5087944
The estimates for the Packages/Options Invoice seem accurate.