Quinnipiac University Budget Summary PaperAccount Management

Excel Homework Assignment: Due Sunday, September 20, 2020 (Students MUST submit assignment by 11:59 p.m. EST)

Create the following budget, using excel to build a simple spreadsheet, which displays what each cost is for, uses formatting to distinguish each section, and build formulas to calculate the costs, and sum to the total price:

Account Management
• Account Executive 50 hours charged @ $200 per hr

Project Management
• Senior Project manager 25 hours @ $125 per hr

• Junior Project Manager 35 hours charged @ $75 per hr

• Research Assistant 50 hours charged @ $50 per hr

Field Costs
•Focus Group Facility rental: $1500 per focus group (5 groups in total)

•Food for each group: $500 per group

•Participant Recruitment: $10.50 for each recruit; plan for 10 recruits for each focus group

•Field Management: 20 hours charged @ $60 per hr

Data Analysis
•Transcripts: Transcription clean up: $100 per group

•Data Analyst: 15 hours @ 175 per hr

Travel & Living
•Client Meetings: Two people will travel 2 meetings $1600 (air, hotel, food)

•Attend Groups: Two people will travel: 1 night in hotel @ $150 per, Food, $50/day, Air $500 per person