Homework ASSIGNment #` Dearborn Center for the Performing ATTE 1 . The director of the Dearborn Center for the Performing Arts has asked You to FIEPETE E TENENCE FEDOT COLIFELINE the center's budgetEd End actual REVENUES, EXPENSES, 375 FOLKS for FE ZONE _ =] In the variance column of the Excel template , calculate Each reliance in dollars. Remember that favorable Variances Should be positive numbers and unfavorable "ENECTES Should BE DEEZGIVE QUIDETS . by In the LIF column , label unfavorable variance : U and favorable TENences E LEITE En IF formula . For the revenue "ticket Sales. " the formula would be` = [FIET` = ], HE` _^ LEE conditional formatting to make the L'ETES. Select cells FT. EZE, then choose " conditional formatting " then " highlight call miles __ text that contains*" ther Enter " [* From the" Format With" drop down menu , Select " red text" and PIECE 2 . The Dearborn Center's director wants to know why the center Spent LOVE QI PIOEZZI printing than anticipated in FT 2015. I'VE the following information to help her answer this question. The bucEE: WEE based on the assumption that the center would put On 275 Performances throughout the FEET, but it actually put on ZIT performances _ The Expected Cost of Printing WEE SO CELt FET FIVETENT , but the actual Cost WEE ED CENTE FET FIDECEIT The center FIVE: One program to each patron. ( Hint : USE the information in this question End in the variance report to find the budgetEd and actual numbers Of FIETEITS*! Calculate the Volume, quantity. Price , and total Variance ;, and then label Each variance _ Of F. LEE the information in the VENance analysis to respond to the following FIJIInte ! = ) Write a sentence Explaining the quantity rariance without using financial jargon . by Which variance most contributed to the unfavorable total variance ? How do You = ] Were any of the Variances favorable ? If YES. Explain why the variance [ S] is'VE : favorable . 3 . The Dearborn Center put on the types of performances _ theatrical and musical . The director is trying to Estimate the annual cost of the theatrical performances. Several costs are attributable directly to one TYPE of FactoraICE or the Other For the theatrical FELLOUTIENCEE, EZLIFTTENT rental Costs $2 2,500, EdVENTISIDE COSTS JIG, OOD, and DIOFTEN! Printing Costs $ 17, EAD. THE ZZLE Personnel - including performers, Staff, and CIETY - work on both the theatrical and musical FENTONIanCEE . The total cost Of Salaries and WEEES FOT PERSONNEL WEE FIZZ LES. In total, Personnel = = = = OOD person hour on the
