Update Budget by Daily Revenue

Good morning! Looking for help updating our Revenue to Budget spreadsheet (sample attached). We have an existing spreadsheet that each department manager updates daily by inputting the daily revenue budget (just taking the total budget and dividing by number of working days - same number each day) in the budget column and then entering the actual revenue hit in the actual column. We enter the daily budget amount on a daily basis so that we have a trending total at the bottom to help us project for the rest of the month. I am trying to add a column that automatically populates an updated adjusted budget (column C on my sample) based on the revenue earned ("actual" column - column d) from the previous day. So if we come in 20k under budget on the first day of the month, I want the Adjusted Budget for the remaining days to increase so that we can still hit budget. I also never want the Adjusted Budget column to decrease lower than the average daily goal. I have a workdays spreadsheet on my sample as well, since certain holidays are not counted. Besides that, only weekdays are counted toward the workdays. If someone can help me out with the formula input for the first section (columns A through F), I can copy over and make adjustments for the other departments. Please help!!