Hi,
We are WEB4PRO company.
We have certified Magento developers.
You can check our portfolio at http://www.web4pro.net.
Regarding your requirements:
We understand this issue that way.
You need report, that has such columns:
1. Period.
2. Total revenue
3. Total cost
4. Total shipping.
All totals shouldn't include canceled/refunded items. Problem is with cost element of this report, because cost is a attribute of an option. I think, the better way will be to add cost field to sales_flat_order_item and store there cost value on item save. We can get this element on reports only from new orders, but reports will be fast enough, that we cannot get, if we try to render cost without storing it in the order item.
So estimate will be
1. Implement storing cost to order item 4 hours
2. Implement report 7 hours.
Total 11 hours.
We anyway will need your full magento code (with customization) and database, because we should know, if there is a conflict between our changes and some your other customization, before we put them to live.
Look forward to your reply.
Thanks,
Marat