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

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

Exercise 2c- answer c.

Use formulas to calculate your answers for question c.

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.

Use formulas to calculate your answers for 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.

PADM 462
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
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.
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 2c- answer c. Use formulas to calculate your answers for question c.
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. 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.

Purchase answer to see full
attachment

  
error: Content is protected !!