Banners Broker Panel Purchase Strategy

I am an agent for a global business called Banners Broker which allows me to rent out Banners space across 150,000+ websites. The business involves purchasing Advertising "Panels" of varying price points which can be set to repurchase at 50% or 100% once the panels campaign has completed e.g. if I have purchased a Yellow panel for $10 it will take 23 days to "Cap" or complete which will then give me $20 revenue to either repurchase another Yellow panel and have $10 back or reinvest in 2 yellow panels which in another 23 days will generate $20 in revenue. The setting of 50% or 100% repurchase which can be varied from month to month. I need someone to develop a spread sheet or methodology to let me know what would be the best settings to set the panels over a 12mth period taking into account the following: -Yellow Panels $10 complete every 23days (can be set to repurchase at 50% or 100%) -Purple Panels $30 complete every 43days (can be set to repurchase at 50% or 100%) -Blue Panels $90 complete every 54days (can be set to repurchase at 50% or 100%) -Green Panels $270 complete every 70days (can be set to repurchase at 50% or 100%) - Processing on purchasing each panel is 5% of cost this needs to be treated as an expense -I am purchasing a traffic pack which will give me 100,000 Sales credits to "Qualify" each panel which need to be applied as each new panel is purchased (as per spread sheet). This is also an expense of US$50/Mth. Additionally more individual panels can be purchased with the same cycle as above. Ideally I would like to be able to see the implications of purchasing an additional 2 yellow Panels, 1 Purple and one Blue panel per week for 12 mths. As this will take some understanding of how this system works you may need to create a free account from the links below to view the help/Videos of how this works to see if this is something you can help me with: [[login to view URL]][1] [[login to view URL]][2] (Read more in additional info section) ## Deliverables I have purchased a Green package from this system and want to find the best strategy to maximise the income over 12mths by just buying Traffic packs (although there are other ways of qualifying panels). I have attached my own spread sheet which I hope will provide an idea of what I am trying to achieve. As I have other associates in this business I want to provide them with the best strategy to succeed in this business but I do not quite have the maths skills to work out what is the optimal way of setting the re-purchase option or additional purchasing of the panels. As I will to pass the information onto my team (they will not have Mysql) this needs to be created in MS Excel so the model can be explianed and past on to my other team members.