Hi,
I want to produce a spreadsheet in which i have a schedule of services with pricing required by a customer to calculate the profit and annual Turnover etc like below;
However I would like to base the buy prices on 3 or 4 set of prices from various suppliers for each service and be able to quickly flick between the pricing sets. I would then like to base the sell price on various % mark ups from the buy prices to create what-if scenarios. I would also like to mix and match between suppliers on specific lines if this would be possible at all!
Can anyone help ?
The spreadsheet would have around 30 lines on it and a total of around 16 different services.
i don't think the what if analysis can do what i need ?
the business is of a broker/middle-man nature
thanks in advance
I want to produce a spreadsheet in which i have a schedule of services with pricing required by a customer to calculate the profit and annual Turnover etc like below;
|
However I would like to base the buy prices on 3 or 4 set of prices from various suppliers for each service and be able to quickly flick between the pricing sets. I would then like to base the sell price on various % mark ups from the buy prices to create what-if scenarios. I would also like to mix and match between suppliers on specific lines if this would be possible at all!
Can anyone help ?
The spreadsheet would have around 30 lines on it and a total of around 16 different services.
i don't think the what if analysis can do what i need ?
the business is of a broker/middle-man nature
thanks in advance