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