Can you show me the work for these numbers with the formulas and everything

D15 V XVfx H #3 The answer should talk about the fact that collections are slow while payments must be made right away. Kohl could tighten credit policies to and or negotiate more lenient terms with suppliers of materials to improve this. #4 Cost Item Actual results Flexible Flexible Budget Sales Volume Static Master Budget Budget for 175,000 units Variance for 180,000 units Variance 4 Sales Revenues $4,342,000 $33,000 U $4,375,000 $125,000 U $4,500,000 5 6 Direct Materials $1,515,625 $115,625 U $1,400,000 $40,000 F $1,440,000 Direct Labor $881,436 $6,436 U $875,000 $25,000 F $900,000 8 Supplies $166,288 $8,712 F $175,000 $5,000 F $180,000 Electric Power $701,354 $1,354 U $700,000 $20,000 F $720,000 10 Indirect Labor $339,272 $10,728 F $350,000 $10,000 F $360,000 Salaries and Supervision $175,549 $4,451 F $180,000 SO $180,000 17 12 Maintenance $37,336 $14,336 U $23,000 SO $23,000 13 Insurance $12,000 $12,000 $0 $12,000 Permits and license fees $68,000 $4,000 U $64,000 SO $64,000 14 6 Factory depreciation $70,000 $0 $70,000 $70,000 Other Overhead $33,173 $2,173 U $31,000 $0 $31,000 16 expenses Total Production $4,000,033 $120,033 U $3,880,000 $100,000 F $3,980,000 17 Expenses Total Selling & $329.453 $9,453 U $320,000 SO $320.000 Administrative Expenses 18 19 Total Expenses $4,329,486 $129,486 U $4,200,000 $100,000 F $4,300,000 20 Operating Income $12,514 $162,486 U $175,000 $25,000 U $200 000 21 22 23 24 25 26 Sheet1 Sheet2 Sheet3 + Ready 1X Accessibility. Investigate