+1(978)310-4246 credencewriters@gmail.com
Select Page

After completing the assigned reading in the Chen, Weikert, & Williams text, go to page 25 and complete the following assignment using the provided spreadsheet titled,

Excel: How Government is Organized Template.

This document will be provided in the

Excel: How Government is Organized Assignment

page.

Complete all portions of

questions 1â€“3 on page 25

of the

Budget Tools

textbook using the provided Excel spreadsheet.

On the tab

Exercise 3.1

you can answer the questions under 1 using text.

On the tab

Exercise 3.2b

complete

question #2- a & b.

Enter the text for a at the top of the tab. Use formulas to calculate your answers for question b.

On the tab

On the tab

Exercise 3.b

â€“complete

question

#3- a & b.

Enter the text at the top of the tab.Use formulas to calculate your answers for question b.

On the tab

Exercise 3.c-

complete

question

#3- c.

Submit the Excel file when complete.

NOTE: For Excel assignment #1- Question 2, there is an error in the book- it reads that there are 5 camp counselors at a total cost of \$2000 per week so the cost per counselor should be \$400.00

There are tutorials on how to use Excel in the back of the

Budget Tools

textbook. Navigate to the

Appendix- page 271

. Additionally, for those who are less familiar with Excel- there are tutorials in the back of the

Budget Tools

book. Additionally, there are several basic excel tutorial videos on YouTube and other Internet sites.

EXCEL: HOW GOVERNMENT IS ORGANIZED ASSIGNMENT INSTRUCTIONS
OVERVIEW
Students will complete a series of Excel spreadsheet assignments to aid in the development of
skills necessary to compile a public budget. Through these exercisesâ€™ students will demonstrate
practical budget skills, including conducting a break-even analysis, time value of money,
calculating fixed and variable costs, adjusting for inflation, and developing budget
scenarios. There is both a practical application of knowledge as well as the theory behind the
practices. Through these exercisesâ€™ students will understand the complexities of developing a
public budget.
INSTRUCTIONS
After completing the assigned reading in the Chen, Weikert, & Williams text, go to page 25 and
complete the following assignment using the provided spreadsheet titled, Excel: How
Government is Organized Template. This document will be provided in the Excel: How
Government is Organized Assignment page.
â€¢
â€¢
â€¢
â€¢
â€¢
â€¢
â€¢
Complete all portions of questions 1â€“3 on page 25 of the Budget Tools textbook using the
On the tab Exercise 3.1 you can answer the questions under 1 using text.
On the tab Exercise 3.2b complete question #2- a & b. Enter the text for a at the top of
NOTE: For Excel assignment #1- Question 2, there is an error in the book- it reads that
there are 5 camp counselors at a total cost of \$2000 per week so the cost per counselor
should be \$400.00
On the tab Exercise 3.b â€“complete question #3- a & b. Enter the text at the top of the tab.
On the tab Exercise 3.c- complete question #3- c. Use formulas to calculate your answers
for c.
Submit the Excel file when complete.
There are tutorials on how to use Excel in the back of the Budget Tools textbook. Navigate to the
Appendix- page 271. Additionally, for those who are less familiar with Excel- there are tutorials
in the back of the Budget Tools book. Additionally, there are several basic excel tutorial videos
on YouTube and other Internet sites.
2b
Clifftown Summer Camp
Ten Weeks
Counselors/week
Meals
Weeks
Campers
Counselors
5000
500 per counselor per week
15 per camper
10
50
5
2c
Clifftown Summer Camp
Ten Weeks
Counselors/week
Meals
Weeks
Campers
Counselors
5000
500 per counselor per week
15 per camper
10
75
7
3b
Desert Vista Homeless Campus
Facility
Cooks
Meals
1500 weekly
50 per cook per meal
2 per person
Days
Guests
7
150
3c
Desert Vista Homeless Campus
Facility
Cooks
Meals
1500 weekly
50 per cook per meal
2 per person
Days
Guests
7
200
Printed by: 3407ab5d3311233@placeholder.48134.edu. Printing is for personal, private use only. No part of this
book may be reproduced or transmitted without publisher’s prior permission. Violators will be prosecuted.
Printed by: 3407ab5d3311233@placeholder.48134.edu. Printing is for personal, private use only. No part of this
book may be reproduced or transmitted without publisher’s prior permission. Violators will be prosecuted.