hsm/260 week 9 final poject Analying financial statement

profileJessicam628
fixed_weeeeeeeeeeekkkkkkkkkkkk_44444444444.docx

Fixed, Cost, Variable Cost and Break

Assignment: Fixed Costs, Variable Costs, and Break-Even Point

Exercise 10.1

During the sixth month of the fiscal year, the program director of the Westchester Home-Delivered Meals (WHDM) program decides to again recompute fixed costs, variable costs, and the BEP using the high–low method. Here are the number of meals served and the total costs of the program for each of the first six months:

Month

Meals

Served Total Costs

July

3,500

$20,500.

August

4,000

$22,600.

September

4,200

$23,350.

October

4,600

$24,500.

November

4,700

$25,000.

December

4,900

$26,000.

Recompute fixed costs, variable costs, and the BEP. What are the variable costs? What are the fixed costs? How many meals will the WHDM program need to provide during the fiscal year to reach the BEP? How much profit will the program earn if it completes its 45,000-meal contract with the City of Westchester?

Meals: High-Low=

Cost: High-Low=

The variable cost per meal: The variable cost for the low month:

Fixed cost:

(Monthly BEP)

(Fiscal-year BEP)

WHDM program profit analysis

= meal contract

Break Even Point (BEP) =

1,008 Revenue

1,008 Meals at

Total Cost Per meal

Total Profit =

Exercise 10.2

It has been two years since the New River Community Council (NRCC) started its newsletter dealing with state and community funding opportunities for human service agencies. The current number of subscribers to the newsletter is 525. During the second year, the NRCC hired a new part-time newsletter coordinator (social work student). The NRCC has raised the salary of the part-time newsletter coordinator to $6,000 per year and has also hired another part-time student as an assistant for ten hours a week. The assistant is to be paid $75 per week or $3,900 per year. Together the newsletter coordinator and the part-time assistant believe they can handle up to 650 newsletter subscribers. Beyond this number, the newsletter program will require still more staff resources. In order to help cover the cost of the new part-time assistant, the executive director has also decided to increase the annual subscription price of the newsletter to $20. Additionally, the variable costs of preparing, printing, and mailing six bimonthly issues of the newsletter have risen to $4.50. Recompute the BEP for the newsletter program. What is the new BEP? Is the new BEP a feasible solution? Why or why not? Will any slack capacity exist? If so, how much? If not, why not?

New River Community Council (NRCC)

Break Even Point (BEP)

15.5X=9,900.

Maximum Number= 650

Break Even Point = 639

Surplus Capacity = 11

Newsletter Coordinator salary: $6,000 per year

Newsletter assistant salary: $3,900 per year

Since the two employees have the maximum capacity of 650, there is no slack capacity.

Reference

Martin, L. (2001). Financial management for human service administrators. Boston, MA: Allyn and Bacon.

.

755

,

13

$

(

)

.

745

,

6

$

93

.

3

$

500

,

3

.

500

,

20

$

=

·

-

BX

A

PX

+

=

X

X

93

.

3

745

,

6

77

.

5

+

=

)

93

.

3

93

.

3

(

745

,

6

93

.

3

77

.

5

-

+

=

-

.

745

,

6

84

.

1

=

X

X

X

X

84

.

1

.

745

,

6

84

.

1

84

.

1

¸

=

¸

666

,

3

=

X

992

,

43

12

666

,

3

=

·

000

,

45

.

992

,

43

$

16

.

816

,

5

$

77

.

5

$

=

44

.

961

,

3

$

93

.

3

$

008

,

1

=

at

72

.

854

,

1

$

44

.

3961

$

16

.

816

,

5

$

=

-

400

,

1

500

,

3

900

,

4

=

-

X

X

50

.

4

.

900

,

3

.

000

,

6

20

+

+

=

X

X

50

.

4

.

900

,

9

20

+

=

(

)

X

X

X

X

50

.

4

50

.

4

.

900

,

9

50

.

4

20

-

+

=

-

X

X

X

5

.

15

.

900

,

9

5

.

15

5

.

15

¸

=

¸

639

=

X

.

500

,

5

$

.

500

,

20

$

.

000

,

26

$

=

-

93

.

3

$

400

,

1

.

500

,

5

$

=

¸