The management of Rooney Modems, Inc. (RMI) is uncertain as to the volume of sales tht will exist in 2017. The president of the company asked the chief accountant to prepare flexible budget income statements assuming that sales activity amounts to 7,000 and 11,000 units. The static budget is shown in the form below.

Please show work, thank you!

The management of Rooney Modems, Inc. (RMI) is uncertain as to the volume of sales that will exist in 2017. The president of the company asked the chief accountant to prepare flexible budget income statements assuming that sales activity amounts to 7,000 and 11,000 units. The static budget is shown in the form below. Required a. Complete the following worksheet to prepare the appropriate flexible budgets. b. Calculate and show the flexible budget variances for the static budget versus the flexible budget at 11,000 units. c. Indicate whether each variance is favorable (F) or unfavorable (U). (Select "None" if there is no effect (i.e., zero variance).) ROONEY MODEMS, INC Flexible Budget Income Statements Cost per Static Flexible Budgets Volume Variance unit Budget 9,000 Number of units 7,000 11,000 120 s 1,080,000 Sales revenue Variable manufacturing costs: Materials 45 405,000 30 270,000 Labor 6 54,000 Overhead 8 72,000 Variable selling, general & administrative 279,000 Contribution margin Fixed costs: 63,000 Manufacturing rent 73,000 Depreciation on manufacturing equipment 92,100 Selling, general & administrative expenses Depreciation on administrative equipment 25,000 S 25,900 S (36,100) S 87,900 T Net income (loss)