A worksheet of about 1 page and a procedures explanation of 500–750 words
You are meeting with Georgia tomorrow to give her specific directions on how to develop the budget for the county fair event portion of the project. She has determined that the event will most likely involve a tent of some sort that contains tables and various health-related activities for children and literature for adults. There will be some sort of heart-related giveaway with the program's slogan on it, along with pencils and something else for the children. Expected attendance at the county fair is projected to be between 250,000 and 450,000, with some percentage of that stopping by the tent. Two sellers will be used to produce the giveaways and print the literature and signage. The tent will be staffed by the hospital's employees, who will be paid their regular wages (not part of the project budget). All other work (determining the tent layout, creating the activities, developing the literature, scheduling the staffing, and so forth) will be done by Georgia's team. Prepare the following budgeting documents for Georgia:
1. Create a worksheet (in Excel or other spreadsheet tool) that Georgia can use to create the budget.
2. Prepopulate the worksheet with the components of the estimate.
3. Provide direction to Georgia in the procedures document (in Word) on how to obtain the 3 -point estimates and the resulting budget.
Please make certain to include the following calculations in your spreadsheet along with the three-point estimate.
SV, CV, BV, SPI and CPI.