I work for a plant nursery and I currently use multiple Excel workbooks to calculate costs for our plants. I am in the process of creating my first Access Database and would like some help if possible to either simplify or translate my Excel formula to Access.
Below is an example of the Excel formula that I use to allocate our labor and maintenance costs to our plants.
Workbook 1. Percent of Costs = Actual Labor/Total Labor and Maintenance
Workbook 2. Labor per Plant = Percent of Costs * Average Direct Costs * Pot Size Differential * Plant Type Difficulty
Workbook 3. Calculated Labor = Labor per Plant * Units Produced
Workbook 1. Allocation Adjustment = (Calculated Labor/Actual Labor) * Percent of Cost
Workbook 2. Labor per Plant = Allocation Adjustment * Average Direct Costs * Pot Size Differential * Plant Type Difficulty
I know that this creates multiple circle references, therefore I use a lot of cut and “paste value”. The basic idea is to absorb all labor costs into the plant so that when we multiply our number of plants produced by the labor allocated to each plant we will have consumed all labor costs. Any thoughts (in English please, I am a newbie) on how I can apply this principal in Access? You help is enormously appreciated.
Below is an example of the Excel formula that I use to allocate our labor and maintenance costs to our plants.
Workbook 1. Percent of Costs = Actual Labor/Total Labor and Maintenance
Workbook 2. Labor per Plant = Percent of Costs * Average Direct Costs * Pot Size Differential * Plant Type Difficulty
Workbook 3. Calculated Labor = Labor per Plant * Units Produced
Workbook 1. Allocation Adjustment = (Calculated Labor/Actual Labor) * Percent of Cost
Workbook 2. Labor per Plant = Allocation Adjustment * Average Direct Costs * Pot Size Differential * Plant Type Difficulty
I know that this creates multiple circle references, therefore I use a lot of cut and “paste value”. The basic idea is to absorb all labor costs into the plant so that when we multiply our number of plants produced by the labor allocated to each plant we will have consumed all labor costs. Any thoughts (in English please, I am a newbie) on how I can apply this principal in Access? You help is enormously appreciated.
