BB CH9 Excel Analytics_Student Form XLSX File Edit View Insert Format Data Tools Help 100% EGP % 0.00 123 Default (Ca... 10 4 BISA B L4 fx A C D E F 1 2 3 A 5 B The Munchkin Theater Planning Budget For the Year Ended December 31 Planning Budget 6 Number of productions (q1) 7 Number of performances(q2) 60 8 Per Cost Formulas Per 9 Production Performance Fixed 10 Actors' and directors' wages $ 2,400 11 Stagehands' wages $ 450 13 221 Ticket booth personnel and ushers' wages $ 180 Scenery, costumes, and props $ 8,600 141 Theater hall rent 15 Printed programs SS $ 750 $ 175 16 Publicity 2.600 += IF Statements Conditional Formatting- Planning Budget Variance Analysis