Can I make a couple of suggestions after a brief look at your model.
- Combine the two fact tables into one with the following fields:
Date, BatchID, Amount, Plant, Type
where Type = 'Plan' or 'Actual'
- Create a master calendar linked to CommonDate. This should contain all the dates from the minimum to the maximum.
Those two steps should simplify the development of this model.
If you are unsure of how to proceed, I suggest that you post the two source Excel files, so I or someone else can modify your model as outlined above.