please help me prepare a flexible budget performance report. show variances between budgeted and actual amounts. in the format below for my notes thank you!

Nina Company prepared the following fixed budget for July using 7,800 units for budgeted sales. Actual sales were 7,500 units and actual costs are shown below. Fixed Budget Variable Amount per Total Fixed Unit Cost $ 100 Fixed Budget (7,880 units) $ 780,000 Actual Results (7,500 units) $ 766,550 35 15 For Month Ended July 31 Sales Variable costs Direct materials Direct labor Indirect materials Sales commissions Total variable costs Contribution margin Fixed costs Depreciation-tachinery Supervisor salary Insurance Depreciation office equipment Administrative solaries Total fixed costs Income ***** 273,000 117,000 31,200 85,800 507.000 5 273,000 277,600 114,100 29,400 81 550 502,650 $ 263,900 65 $ 35 $ 71,050 42,150 10,450 7.700 33,900 $ 165,250 71,050 42,150 10,450 7,700 33,900 165,250 $ 107,750 71,050 43,400 10,450 7,200 31.000 163,600 $ 100,300 Prepare a flexible budget performance report for July at activity level of 7,500 units. Show variances between budgeted and actual amounts (Indicate the effect of each varionce by selecting favorable, unfovorable, or no variance.) Prepare a flexible budget performance report for July at activity level of 7,500 units. Show variances between budgeted and actual amounts (Indicate the effect of each variance by selecting favorable, unfavorable, or no variance.) NINA COMPANY Flexible Budget Performance Report Flexible Actual Budget Results Variances Favorable/Unfavorable (7,500 units) 17.500 units) $ 750,000 $ 766,550 $ 16,550 Favorable For Month Ended July 31 Sales Variable costs Direct materials Direct labor Indirect materials Sales commissions Total Variable Costs Contribution margin Fixed costs Depreciation Machinery Supervisory salary Insurance Depreciation Office equipment 262,500 112.500 30 000 82.500 487.500 262 600 277600 114,1001 29.400 81.550 502,650 (15.100) Unfavorable 1.600 [Unfavorable 600 Favorable 950 Favorable 15.150 Unfavorable 262,500 112,500 30.000 82,500 487.500 262,600 277,600 114,100 29.400 81,550 502,650 (15,100) Unfavorable 1,600 Unfavorable 600 Favorable 950 Favorable 15,150 Unfavorable Variable costs Direct materials Direct labor Indirect materials Sales commissions Total Variable Costs Contribution margin Fixed costs Depreciation-Machinery Supervisory salary Insurance Depreciation Office equipment Administrative salaries Total Fixed Costs Income