Problem A Roswell Mfg. produced 80,000 units, 8,000 more than budgeted. Production data are as follows. Except for physical units, all quantities are in dollars Revenue & Actual Results Spending FlexibleActivity Planning Budget 72,000 720,000 Variances Budget Physical Units Sales Variable Costs Contribution Margin Fixed Costs Operating Income _ 80,000 6,400 492,000 480.000 150,000 138,000 30,000 In Excel, re-create & complete the schedule (determine values for all areas shaded in yellow) Indicate whether variances are favorable (F) or unfavorable (U) where applicable Give a brief summary explanation of why the original target income was not attained 1. 2. 3