+ Reply to Thread
Results 1 to 4 of 4

Cider Season Planning Workbook [Project]

  1. #1
    Registered User
    Join Date
    03-05-2019
    Location
    North Carolina, USA
    MS-Off Ver
    2007-2016
    Posts
    4

    Cider Season Planning Workbook [Project]

    Hello, and welcome to my post. I'm not absolutely sure that this is the right place for this kind of thing, or even the most appropriate website, so if this thread is misplaced, let me know and also please direct me to the correct environment. Thanks!

    This thread is intended to explore more than just a question, but a whole project. I'm making cider this year, a lot of it, and doing so for sale. In order to plan and track the season, a good 'ol workbook is the go-to. I like to go overboard with my Excel projects, and this time I want to work on it with all of you. This will hopefully allow me to learn how to make the kind of workbook I want more quickly, give me new and better ideas by stealing them from you, and share these ideas with others looking to learn advanced Excel usage after I feel a crippling sense of guilt for it.

    So, without any further ado, let's get into it:

    Cider Workbook goals:
    -Define Season Start/End (when apples start to get picked & when the last of 'em are pressed)
    -Specify Quantifiable Metrics (how much a crate of apples costs, how many bushels are in a crate, gallons of cider per bushel, et cetera)
    -Populate a Calendar with Daily Goals (Specify pressing/bottling days, weekends, holidays, man-hours per type of workday, et perpetuity)
    -Generate Season Projections (#Gal/Season, Revenue projections, Payroll, Cost of Goods Sold (COGS), et whatever else I wanna know)
    -Compile into User-Friendly/User-Can't-Break GUI (self-explanatory)

    So, if you wanna follow along, give advice, ask your own questions about this project, or branch ideas from here to your own projects or general education, I'm thrilled! Thanks for joining!

    UPDATE #2

    Math

    What are the things you're trying to accomplish in a business? Get more money than you spend.

    Step 1: Spend Money

    Buy equipment
    $Infrastructure
    $Operations
    $Maintenance
    =
    $Business/Season

    Buy apples and vessels
    $/Apple
    $COGS

    Step 2: Do Business

    Press/Bottle
    Apples/L
    L/u
    $/u
    SELL IT! (Don't drink it all first...)
    u/Season
    $Market/u

    $/Seaon + $Business/Season < $Revenue

    What we're looking at is some variables to represent the various things we can measure about how much it costs to do business. How much it costs to get set up, purchase goods and product packaging, and the cost to run the equipment and maintain it. Then, efficiency metrics to measure how effective those investments are. What we want to really know is: How much does it cost us to make and sell a liter of cider? Looking at these little math problems, we see that we can make money if the market will buy our liter for more than the total cost of the setup, apples, jugs, and other costs like electricity and putting cash into my own pocket.

    For the fun of it, let's set everything to 1:

    Season Facility Costs: $1
    Price of Apples: $1
    Packaging Costs per Liter: $1
    Liters per Apple: 1
    Market Price per Liter: $1
    Market Demand per Season: 1

    And to finally look at having Excel do something for us:

    Season Revenue: =B6*B5 =$1
    Cost of Goods Sold =B6*(B2/B4+B3) =$2
    Season Expenses: =B8+B1 =$3
    Margin: =B7-B9 =-$2

    With this table simply showing the formulas for you, the arithmatic is hopefully easy to follow.

    But this also shows I'm a horrible business man, because I lost mony when I sold my cider, and doubled the loss in what it cost to make it. Now, get better numbers.


    UPDATE #1

    Step 1: Table.

    Specify Quantifiable Metrics Define Season Start/End Populate a Calendar with Daily Goals Generate Season Projection Compile into User-Friendly/User-Can't-Break GUI
    $/{ August Weekends Revenue
    $/§ January Holidays COGS
    §/╚ mBirthduh Margins
    ╚/{ Weekend
    $/ƒ Setup
    ƒ/± Press
    ±/r Bottle
    §/§ Breakdown



    Note: currently building this project in Excel 2007. #rebelwithoutaclue
    Last edited by Tokahax; 03-07-2019 at 01:06 AM.

  2. #2
    Registered User
    Join Date
    03-05-2019
    Location
    North Carolina, USA
    MS-Off Ver
    2007-2016
    Posts
    4

    Re: Cider Season Planning Workbook [Project]

    alright. update #1 let's go

  3. #3
    Registered User
    Join Date
    03-05-2019
    Location
    North Carolina, USA
    MS-Off Ver
    2007-2016
    Posts
    4

    Re: Cider Season Planning Workbook [Project]

    Bug report: I'm trying to edit the main post: the edit page is empty.

  4. #4
    Registered User
    Join Date
    03-05-2019
    Location
    North Carolina, USA
    MS-Off Ver
    2007-2016
    Posts
    4

    Re: Cider Season Planning Workbook [Project]

    Update #2: Engaged.
    Last edited by Tokahax; 03-24-2019 at 07:57 PM. Reason: Couldn't delete unnecessary post

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Planning tool for project rollout
    By Link in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-17-2017, 01:19 AM
  2. Meal Tracking and Planning Project
    By BrokeCollegeKid in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 10-01-2014, 10:43 PM
  3. Meal Tracking and Planning Project
    By BrokeCollegeKid in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-01-2014, 05:07 PM
  4. [SOLVED] Template for project planning - budget
    By CorruptWolf in forum Excel General
    Replies: 3
    Last Post: 01-15-2014, 02:55 AM
  5. Project planning with Excel - special Hlookup required
    By Jayster in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-03-2010, 05:44 AM
  6. Looking for a project planning template
    By Rick in forum Excel General
    Replies: 1
    Last Post: 12-20-2005, 09:00 PM
  7. Project planning with Excel
    By MPark in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-18-2005, 03:30 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1