The actual information pertains to the month of June. As a part of the budgeting process, Great Cabinets Company developed the following static budget for June. Great Cabinets is in the process of preparing the flexible budget and understanding the results. Actual Results 17.000 Flexible Budget Static Budget 21.000 Sales volume (in units) Sales revenues Variable costs $935,000 391,000 $ $ $1,155,000 480,270 Contribution margin 544,000 $ $ 674,730 Fixed costs Operating profit 275,800 $268.200 268,600 $406 139 Required: Use the information above to prepare the flexible budget. Do not forget to indicate fvorable or unfvorable amounts. Set up your response in the spreadsheet outside of this text box