Consider the following 2012 data for Newark General Hospital (in millions of dollars):

krp8

                                          Simple budget                Flexible Budget                  Actual Results

 

Revenues                           $4.7                                 $4.8                                   $4.5

Costs                                    4.1                                   4.1                                     4.2

Profit                                     0.6                                   0.7                                     0.3

 

A. Calculate and interpret the two profit variances.

B. Calculate and interpret the two revenue variances.

C. Calculate and interpret the two cost variances.

D. How are the variances related?

 

Need this done on excel 

    • 12 years ago
    • 5
    Answer(1)

    Purchase the answer to view it

    NOT RATED
    • variance_analysis.xlsx
    Bids(1)