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

profilekrp8

                                          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

    blurred-text
    NOT RATED
    • attachment
      variance_analysis.xlsx
    Bids(1)