4. 5 6 7 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 lune. Great Cabinets is in the process of preparing the flexible budget and understanding the results. 9 Actual Results 17,000 Flexible Budget 10 11 Static Budget 21,000 Sales volume (in units) 12 13 14 15 Sales revenues Variable costs $935,000 391,000 $ $ $1,155,000 480,270 544,000 $ 674,730 Contribution margin 16 275,800 $268,200 268,600 $406.130 Fixed costs Operating profit $ 17 18 19 20 21 22 23 24 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. 25