EXCEL SHEET DEVELOPMENT

Dear Sirs ...

Kindly , looking for help in developing attached excel sheet further , I will elaborate on what is needed :-

First , I have started this sheet many years ago with two parts in it ( it is as a daily excel calendar ) :-

• Upper part is for my business ( calculating break even point on profit margin provision )
• Lower part is personal ( income distribution based on % of each expense to total expenses )

Second , profit margin provision is entered manually at day one of each month based on last month average 

Third , weekends take half the daily cost ( sales are usually lower on weekends ) where weekdays take full cost + difference from weekends 

Fourth , total sales needed to break even with cost is calculated based upon profit margin which is divided to weekdays and weekends accordingly

Fifth, I need to automate few things in this sheet :-

• Need to have profit margin average automated on daily basses ( when data is entered ) . daily profit is at line 11 starts at cell T
• Need to have all cells with profit margin update to daily average accordingly , for example cells C37 , J20 , K20 , etc.
• Lost sales to break even point starts at line 12 cell T ( based on provision )  , need a formula at cell K20 to add lost sales daily after dividing it to remaining weekdays , same at cell P20 for weekends ( keeping in mind profit margin average ) , Also , if sales exceed the break even point , the formula will subtract from remaining weekdays for cell K20 and weekends for cell P20.  

This it for know , we will fine tune accordingly 

Thanks in advance