I made another mistake by using expense digits to estimate food and
accommodation income.
This fixes the digits by using the fee we charge from attendees.
On Tue, Apr 17, 2018 at 12:29:16PM +0800, Yao Wei wrote:
> * Re-decrease the estimations of total attendees to 400 people
> * Use another spreadsheet to estimate the budgets of food and
> accommodation.
> * Fixed an issue that I double counted the food and accommodation
> income.
> * Decrease the portion of self-paid attendees from 75% to 42.5%.
> * Estimate that 90% people will have on-site accommodations.
> * Delete Coffee/Tea and assume that's merged to Bar.
>
> Please refer to another sheet in the spreadsheets for the food/accomm.
> estimations:
> https://storm.debian.net/shared/JChakMNcTAnTRqQov5WcwtUw8SvSeoOZtwJ4Jz0fvLD
>
--------------------
USD -16569.5 Assets:Receivable
USD 172940.0 Budget
USD 5300.0 Accommodations:Sleeping mats
USD 70000.0 Bursaries
USD 60000.0 Bursaries
USD 10000.0 Diversity
USD 1500.0 Child Care
USD 5000.0 Conference Dinner:Food
USD 5500.0 Content
USD 5000.0 Invited Speakers
USD 500.0 Press
USD 500.0 Day Trip:Buses
USD 1000.0 Fundraising:Fulfillment
USD 500.0 Insurance:Insurance
USD 1000.0 Miscallenous:Incidentals
USD 74720.0 Roomboard
USD 6000.0 Bar
USD 13200.0 Breakfast
USD 26300.0 Dinner
USD 19500.0 Lunch
USD 9720.0 Pastries
USD 4920.0 Swags
USD 720.0 Badges
USD 1600.0 Bags
USD 50.0 Posters
USD 150.0 Stickers
USD 2400.0 T-shirts
USD 3000.0 Video
USD 1500.0 Equipment Rental
USD 1500.0 Equipment Shipping
USD -156370.5 Income
USD -15000.0 Attendee:Registration
USD -1000.0 Conference Dinner:Alcohol
USD -108740.5 Fundraising
USD -4000.0 Bronze
USD -19849.0 Gold
USD -17225.5 Governmental Funds
USD -20000.0 Platinum
USD -45000.0 Silver
USD -2666.0 Supporter
USD -31630.0 Roomboard
USD -7380.0 Accommodation
USD -3000.0 Bar
USD -21250.0 Food
--------------------
Yao Wei
Attachment:
signature.asc
Description: PGP signature