need to spread out different models according to a start date and end date

Hello,
I need to spread out different models according to many constrains
1- daily rate
2-sales requirement ofspecific quantity
3-sales requirement of specific color for each model

Please find attached sheet that shows the required plan. you may change the plan's looks a little bit but keep the same outputsmodels.xlsxmodels.xlsxmodels.xlsx

My inputs are
daily rate
model quantity - the quantity is broken down to different colors.
many models.

I want to create the previously attached sheet. I do it completely manually.
I want excel to have my inputs and then work it out somehow by macro or whatever lol, to give me the closest shape of that sheet.
as you can see the sheet has different models and different colors and daily rate differest from a day with over time (10 hrs = higher daily rate )to a day of only 8 hours.

Could you help?
if there's still a problem to understand me, please please get my skype and let's communicate by voice.
lost.sac is my skype

THANKS MAN
I thought i could give it a try
i have already looked it up before i post and knew it won't work by macro :S