When you show how you did this, can you please use the format pictured? You can leave any fields blank that aren't necessary to calculate flexible budget (static, etc)

Problem #4 Calculate the flexible budget variance for variable costs. (SHOW ALL YOUR WORK)

The static budget, at the beginning of the month, for Redwyne Company follows:

Static budget:

Sales volume: 2,000 units; Sales price: $50.00 per unit

Variable costs: $14.00 per unit; Fixed costs: $25,000 per month

Operating income: $47,000

Actual results, at the end of the month, follows:

Actual results:

Sales volume: 1,900 units; Sales price: $58.50 per unit

Variable costs: $16.00 per unit; Fixed costs: $33,000 per month

Operating income: $47,750

A C D E F G H I J (D-G) Flexible Budget Variance F/U (G-)) Sales Volume Variance F/U Budgeted Rates Flexible Budget Static Budget Actual Volume/Quantity Selling Price/Unit Variable Costs: Direct Materials Direct Labor Variable Overhead Total Variable Costs Contribution Margin Lease/Rent Insurance Other Fixed Expenses Total Fixed Expenses Net Income/(Net Loss) Static Budget Variance Step 1: Static Budget Step 2: Flexible Budget Step 3: Actual Step 4: Sales Volume Varial Step 5: Flexible Budget Var Step 6: Static Budget Variar