Create Advanced Salesforce Reports

1) Update salesforce so that we can report on "partner rebate %" against "Product family" against an "Opportunity" We require the ability to create a "rebate percentage" field against product family within a "partner account". If that "partner account" is selected in an opportunity then the the percentage allocated against the product family for both upfront and scheduled revenue / transactions to be reported. ie: if a $1,000 opportunity has a partner account allocated to it, and that product family had a 5% rebate percentage set within the Account, then a report listing all revenue associated with that opportunity must be created to list the associated rebate of $50 for that partner account. 2) Create product schedules so that when a sales rep creates an opportunity they can include the following: - Select a "partner account" (for rebates - Select Products - Discount the Products by % so that the product margin is displayed on the screen, a rep can't continue if this goes below ZERO. by Product line item. - Select a "term" either "One Off", "12 Months", "24 Months", or " 36 Months" - This automatically create a product schedule for this opportunity based on the selection - The following revenue and profit forecasts are included in the Opportunity: Upfront Revenue & Profit, Monthly Revenue & Profit (excludes the upfront portion) 2) We require a revenue schedule report against each opportunity to be created to deduce rebates against that product for the term of the product schedule depending on the products selected in the opportunity. ie: a report by month that shows all closed/won opportunities by "sales rep" with "Revenue" and any a partner rebates % & $ by product family.