CSTARS / farm-budgets-app

Application for calculating farm budgets
1 stars 0 forks source link

Example Data Entry - UCD Cost and Return Study #23

Open qjhart opened 8 years ago

qjhart commented 8 years ago

These are notes on testing the Farm Budget App, using UCD's Cost and Return Study for Wine Grapes in Sacramento Valley.

The study have very detailed information, and is pretty easy to follow. However, the organization is a bit different than our tool, so some modifications need to be done. The first issue is the hypothetical farm. The study shows a 200 acre farm, 135 in established grapes, and 60 to be established. We can replicate the farm exactly, or break it into two. Some of the tables are broken out by category (Tables 1,2) and some are not (Table 8). Tables, 3 and 4 should be automatically generated. Tables 5,56

Table Title Description
1 Overall Costs For establishment. Generated table. Seperate,if we use two budgets
2 Cost per acre for production Established grapes. Generated, Seperate if we use two budgets.
3 Costs/acre production/return Generated
4 Monthly Costs / acre
5 Returns Not included
6 Whole Farm Capital Equipment Included in Complex material for equipment
7 Hourly Equipment Costs Should be generated from complex materials
8 Operations This is what we should input. We will use their exact same operations, however, each row will be a single material, which can be complex.

Most of the reports are in a per acre setup, but I will follow the acreage as described in the report. I think that helps when you describe the types of operations you have. This mostly means I will need to multiply my operation times.

Usually, I have started from the bottom up, but this time I will try from the top down, creating empty operations, and filling them in as I go.

Step 1. Operations

Put in all operations, title only. Used same title as in table, left off the number of times. That took less than 10 minutes.

Next, from Table 8, I'll add in the operations. The table is monthly, and I'll mostly keep it at that. However, at this point, I see that they will change the amounts of some of their operations from month to month. This is not how we have things scheduled. So, I will change the operation names, specifically adding a new operation for each irrigation/fertilization event. So, I don't forget, I'll add in the materials for those.

Despite the number of items here, scheduling went very easy. Spotted what appeared to be errors in the budget (Fertilize N w/irrigation should be in SEP, not OCT). After adding in the operations, we have a very nice operation timeline to investigate.

Materials

Now that the operations are in, I'll start to add in the materials. Again, I will start with complex materials, and work from there.

image

Although it doesn't actually seem like I have any errors actually.

image

Hmm, I am editing a UCD Ext, budget, but the UCD Ext are not included. I can import them one at a time. I guess I like that, it keeps your materials list uncluttered. OK, UCD is using a jrmerz Labor, I want to move that over to UCD. That was quite Easy to do, I just changed authorities, and saved it.

qjhart commented 8 years ago

Now , I seem to be stuck. I cannot add materials to the operation. It seems I can continue to manipulate the materials list, but nothing else.

jrmerz commented 8 years ago

@qjhart pushed bug fixes from yesterday's testing.