[FRIAM] FRIAM Homework Assignment: Gala Planning Sliding Scale Chart

[Stephen Guerin]

You have two degrees of freedom (number of attendees and ticket price) with
one constraint, fundraising goal of 100k. So there are multiple solutions
for ticket price.

 If you want to keep the ticket price as low as possible and fill to
capacity, then you can solve for ticket price. attached is your spreadsheet
with the formula and an added column of total cost for convenience:

[image: image.png]

_______________________________________________________________________
Stephen.Guerin at Simtable.com <stephen.guerin at simtable.com>
CEO, https://www.simtable.com <http://www.simtable.com/>
1600 Lena St #D1, Santa Fe, NM 87505
office: (505)995-0206 mobile: (505)577-5828


On Sat, Sep 10, 2022 at 5:20 PM Tom Johnson <jtjohnson555 at gmail.com> wrote:

> Gents:
>
> Attached is an Excel spreadsheet I am trying to create to assist in
> planning a fundraiser for Global Santa Fe <https://globalsantafe.org/>.
> I'm on the board.
>
> My hunch is that it involves a series of nested components, but I have not
> been able to come up with just the right harmony to solve the problem of
> setting an appropriate ticket price given the variables reflecting
> different potential site costs.
>
> All assistance would be much appreciated.  Anyone up to the challenge?
> Tom Johnson
>
>
> --
> ============================================
> Tom Johnson - tom at jtjohnson.com
> Institute for Analytic Journalism   --     Santa Fe, NM USA
> 505.577.6482(c)                                    505.473.9646(h)
> ============================================
> -. --- - / ...- .- .-.. .. -.. / -- --- .-. ... . / -.-. --- -.. .
> FRIAM Applied Complexity Group listserv
> Fridays 9a-12p Friday St. Johns Cafe   /   Thursdays 9a-12p Zoom
> https://bit.ly/virtualfriam
> to (un)subscribe http://redfish.com/mailman/listinfo/friam_redfish.com
> FRIAM-COMIC http://friam-comic.blogspot.com/
> archives:  5/2017 thru present
> https://redfish.com/pipermail/friam_redfish.com/
>   1/2003 thru 6/2021  http://friam.383.s1.nabble.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://redfish.com/pipermail/friam_redfish.com/attachments/20220910/438c6046/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image.png
Type: image/png
Size: 79331 bytes
Desc: not available
URL: <http://redfish.com/pipermail/friam_redfish.com/attachments/20220910/438c6046/attachment-0001.png>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: TJ - Gala Ticket Price Sliding Scale Chart_smg.xlsx
Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Size: 16053 bytes
Desc: not available
URL: <http://redfish.com/pipermail/friam_redfish.com/attachments/20220910/438c6046/attachment-0001.xlsx>