We need a manufacturing schedule for a brewery. Preferably in Microsoft Project or similar. Would even consider online but need the ability to make changes daily if not more often. It needs the ability to track the production of beer every step of the way. Including tank scheduling for future productions, material resources, labor resources, and the ability to track costs. Basically they want to plan in the future for beer as this company is going from making beer once a week to 8-9 times a week but also want to track the costs of each beer to realize their actual profit margin. Below is a list of things that need to be included:
Amount of beer to be made in ounces
Time resources for Fermenting
Time resources for conditioning
Grain Material count and cost
Hop Material count and cost
Yeast count (basically because yeast is recycled we just need to count how many times that yeast is used)
Labor Hours for Brewing, Care for Beer, Filtering, cleaning, packaging, etc
There is 9 Fermentation Tanks and 2 Conditioning Tanks (7Days Fermenting, 2 days Conditioning as an average for each beer)
Packaging resources (12 oz Bottles, 22 oz Bottles, Kegs)
Preventative Maintenence Schedule (Not required but would be sweet)
No one beer is made the same so each beer that is made has different resources so it needs to have the ability to change it but also would be nice to look ahead and order materials as well.
Depending how complex you want to be, this could also serve as a log. Most breweries log everything especially with yeast and bacteria levels for their own protection but also as a QA check. Could be a possible second project if its not possible to add it to scheduling software.