Brass Contributor

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 

1 Reply

@Yousef70 Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future.