Weekly CSA Harvest Target – This sheet simply multiplies the Weekly CSA Share Content table by the number of shares offered.Ĭ. This information is used to calculate the average Weekly CSA Share price in cell B1 of the Annual plan sheet.įarm Operations Planning: Once you have customized your weekly CSA shares, you can click the Create Farm Plan button on the Intro sheet to generate a consolidated operations calendar along with seed orders, greenhouse and crop schedules, and weekly harvest targets.Ī.Ĝalendar – This sheet offers a consolidated weekly schedule of Field Prep, Greenhouse, and Field Planting work.ī. Fractional values are accepted.ī.Ěs you add and subtract items from your weekly CSA shares, you’ll notice the two summary rows at the bottom of the sheet are keeping track of how much each share is worth. If the ‘one-of-each’ allocation isn’t practical, you may change then ordered quantity by changing the numbers on the Weekly CSA Share Content sheet. That is, if you’re tracking tomato yield by the pound and your tomatoes are available for 10 weeks in the season, then each CSA share will be allocated 10 pounds of tomatoes. If you want to plan out multiple seasons at a time, you may extend this to 2 or more years.ĬSA Share Modelling: After validating the reference data and clicking the Recalculate Availability button on the Intro sheet, the workbook will calculate when your crops will be available (represented by green cells on the Weekly CSA Share Content sheet).Ī.ěy default, the workbook will order one unit of each available crop. The Planning Period Start and Planning Period End values are by default set to 1 year. I would recommend reviewing and updating this data if any of the later calculations don’t pass the sniff test.īusiness planning: On the Annual Input sheet, users can adjust the input parameters (highlighted cells) to model the finances of their farm.Ī. This reference data is going to vary with the local climate conditions. Organize reference data on the Planting Constraints, DS (Direct Seeding) Crop Ref, and TP (Transplant) Crop Ref sheets.Ī. To answer the above questions, this tool performs the following functions: What is the financial outlook of my farm?.This tool attempts to answer the following questions: The basic business model is that customers buy farm products on a subscription basis, with deliveries being made on a weekly or bi-weekly basis. This is a business and operations planning tool designed for consumer-supported agriculture (CSA) farms.