drbh / food-coop-expansion Goto Github PK

This is a python script that acts as a basic calculator.

It takes in information about the hours our operation. How many people need to be present each of those hours.

It also takes in info about the possible member population, such as the number of people expected, the percent of missed workslots, the number of average spend of these projected customers per week

Lastly it takes in some simple info about the building total cost and the number of years to pay it back. so like a 10,000 dollar buidling in 20 years.

The infoit returns, tells us if the number of projected memebers can handle the expected workslots needed, it also tells us the amount of extra members, and the weekly revenue. We see if we can pay the building cost and the remainder is left over. This money should be able to cover operational costs. But may not in the first few years as the pay back priority goes towards the building repayment.

MY COOP FEASIBILITY CALCULATOR! 


MY INPUTS 

Days open:				 			M Tu W Th F Sa Su
Hours open:							6 7 8 9 10 11 12 13 14 15 16 17 17 19 20 21 22
Workslot hours:				 		2.66
Number needed for hour:				60
Percent of missed workslots:		0.2
Est num members:			 		4050
Cost of building:			 		10000000.0
Loan payback years:			 		20.0
Average weekly spend per member:	40.0


COOP OPERATIONAL NEEDS 

Numbers hours open:		 	119.0
Hours of work needed:		7140.0
Number workslots needed:	2684.210526315789
Number members needed:		2685


COOP OPERATIONAL FEASIBILITY 

Contributing members:		3240.0
Members can support work:	True
Surplus members:		 	555.0


COOP CASHFLOW FEASIBILITY 

Est weekly revenue:		 	129600.0
Est monthly revenue:		518400.0
Monthly Building Cost:		41666.666666666664
Revenue after building:		87933.33333333334