Monthly Weekly Daily Target Turnover

[koamei]

Hi,

I have the yearly turnover target for a company and would like to calculate the monthly, weekly and daily targets to meet the yearly. I want to be able to put the actual daily revenue and automatically recalculate the next day target and the next month target. For example if my yearly target is $50,000 the company needs to make $136.98 daily if one day the company makes 0 then the next day target should be recalculated to show $273.97.

Can someone please help me and give me some guidelines on how to make the above?

Thanks in advance!

 

[RasGhul]

I've made a sample sheet for how I would build it, see if it suits.


https://www.dropbox.com/s/hxorrvxvqvszlwa/Monthly weekly Target turnover_koamei.xlsx?dl=0