Question

1 Approved Answer

Posted on Sep 15, 2024

PARTI: You will open up and utilize the accompanying Excel-based budget file to balance the budget minus the loss of income from the state legislature.

PARTI: You will open up and utilize the accompanying Excel-based budget file to balance the budget minus the loss of income from the state legislature. Be sure to eliminate the deficit and, preferably, budget for a moderate surplus in case next year's revenues fall short of expectations or costs exceed projections. Also, make sure the prender disparity of male and females participation opportunities are no worse than the status quo and ideally within the five percentage (See video instructions for working with the Excel budget.) LITTLE STATE UNIVERSITY ATHLETIC BUDGET BUDGET SUMMARY PROGRAM SUMMARY PARTICIPATION SCHOLARSHIPS MALE FEMALE MALE FEMALE SPORT REVENUE EXPENSES PROFIT 0.00 S $ $ 980,000 $ 1,014,000 5 91,000 $ 79,200 $ 2,270,000 S 1,074,100 $ 820,800 $ 403,900 $ 283,300 $ 349,650 $ 156,900 $ 221,800 $ 105,900 $ 142,700 $ 130,050 $ 141.950 S 193,500 $ 357,400 $ 80,300 $ 172.600 $ Football B Men's Basketball Women's Basketball 10 Volleyball 11 Baseball 12 Softball 13 Men's Swimming 14 Women's Swimming 15 Men's Tennis 16 Women's Tennis 17 Men's Golf 18 Women's Golf 19 Men's Track 20 Women's Track 21 Men's Gymnastics 22 Women's Gymnastics 23 (1,290,000) (60,100) (729,800) (324,700) (283,300) (349,650) (156,900) 221,800) (105,900) (142,700) (130,050) (141,950) (193,500) (357.400) (73,900) (158,600) 85.00 15.00 0.00 0.00 28.00 0.00 20.00 0.00 11.00 0.00 13.00 0.00 31.00 0.00 12.00 0.00 0.00 0.00 15.00 22.00 0.00 33.00 0.00 25.00 0.00 13.00 0.00 11.00 0.00 34.00 0.00 14.00 63.00 13.00 0.00 0.00 6.00 0.00 3.00 0.00 0.00 15.00 12.00 0.00 12.00 0.00 7.00 2.00 0.00 0.00 0.00 400 0.00 2.00 0.00 4.00 0.00 4.00 0.00 1300 000 6,400 14,000 $ 5 700 Total 215.00 % 56.28 MOK WBK V 25 OTHER 167.00 43.72 S 96.00 56.47 74.00 43.53 WSWIMMEN Overall Operations & Admin Capital FB 8 MSWIM =BB!D7 0.00 000 25.00 0.00 3.00 0.00 2.00 7.00 0.00 13.00 0.00 Men's Swimming Women's Swimming Men's Tennis Nomen's Tennis Men's Golf Women's Golf Men's Track Women's Track Men's Gymnastics Women's Gymnastics 156,900 $ 221,800 $ 105,900 $ 142,700 $ 130,050 $ 141,950 $ 193,500 $ 357,400 $ 80,300 $ 172,600 $ (156,900) (221,800) (105,900) (142,700) (130,050) (141,950) (193,500) (357,400) (73,900) (158,600) 20.00 0.00 11.00 0.00 13.00 0.00 31.00 0.00 12.00 0.00 1100 0.00 34.00 0.00 14.00 3.00 0.00 4.00 0.00 2.00 0.00 0.00 4.00 0.00 13.00 0.00 7.00 6,400 $ 14,000 $ OTHER Capital Expenses Administrative Total 215.00 167.00 96.00 74.00 56.28 43.72 56.47 43.53 (318,000) Note: LSU undergraduate students 50/50 M/F 4,286,400 $ 6,018,000S 318,000 S 1,731,600 $ Totals 8,202,600 $ 8,954,450 S (751,850) PARTI: You will open up and utilize the accompanying Excel-based budget file to balance the budget minus the loss of income from the state legislature. Be sure to eliminate the deficit and, preferably, budget for a moderate surplus in case next year's revenues fall short of expectations or costs exceed projections. Also, make sure the prender disparity of male and females participation opportunities are no worse than the status quo and ideally within the five percentage (See video instructions for working with the Excel budget.) LITTLE STATE UNIVERSITY ATHLETIC BUDGET BUDGET SUMMARY PROGRAM SUMMARY PARTICIPATION SCHOLARSHIPS MALE FEMALE MALE FEMALE SPORT REVENUE EXPENSES PROFIT 0.00 S $ $ 980,000 $ 1,014,000 5 91,000 $ 79,200 $ 2,270,000 S 1,074,100 $ 820,800 $ 403,900 $ 283,300 $ 349,650 $ 156,900 $ 221,800 $ 105,900 $ 142,700 $ 130,050 $ 141.950 S 193,500 $ 357,400 $ 80,300 $ 172.600 $ Football B Men's Basketball Women's Basketball 10 Volleyball 11 Baseball 12 Softball 13 Men's Swimming 14 Women's Swimming 15 Men's Tennis 16 Women's Tennis 17 Men's Golf 18 Women's Golf 19 Men's Track 20 Women's Track 21 Men's Gymnastics 22 Women's Gymnastics 23 (1,290,000) (60,100) (729,800) (324,700) (283,300) (349,650) (156,900) 221,800) (105,900) (142,700) (130,050) (141,950) (193,500) (357.400) (73,900) (158,600) 85.00 15.00 0.00 0.00 28.00 0.00 20.00 0.00 11.00 0.00 13.00 0.00 31.00 0.00 12.00 0.00 0.00 0.00 15.00 22.00 0.00 33.00 0.00 25.00 0.00 13.00 0.00 11.00 0.00 34.00 0.00 14.00 63.00 13.00 0.00 0.00 6.00 0.00 3.00 0.00 0.00 15.00 12.00 0.00 12.00 0.00 7.00 2.00 0.00 0.00 0.00 400 0.00 2.00 0.00 4.00 0.00 4.00 0.00 1300 000 6,400 14,000 $ 5 700 Total 215.00 % 56.28 MOK WBK V 25 OTHER 167.00 43.72 S 96.00 56.47 74.00 43.53 WSWIMMEN Overall Operations & Admin Capital FB 8 MSWIM =BB!D7 0.00 000 25.00 0.00 3.00 0.00 2.00 7.00 0.00 13.00 0.00 Men's Swimming Women's Swimming Men's Tennis Nomen's Tennis Men's Golf Women's Golf Men's Track Women's Track Men's Gymnastics Women's Gymnastics 156,900 $ 221,800 $ 105,900 $ 142,700 $ 130,050 $ 141,950 $ 193,500 $ 357,400 $ 80,300 $ 172,600 $ (156,900) (221,800) (105,900) (142,700) (130,050) (141,950) (193,500) (357,400) (73,900) (158,600) 20.00 0.00 11.00 0.00 13.00 0.00 31.00 0.00 12.00 0.00 1100 0.00 34.00 0.00 14.00 3.00 0.00 4.00 0.00 2.00 0.00 0.00 4.00 0.00 13.00 0.00 7.00 6,400 $ 14,000 $ OTHER Capital Expenses Administrative Total 215.00 167.00 96.00 74.00 56.28 43.72 56.47 43.53 (318,000) Note: LSU undergraduate students 50/50 M/F 4,286,400 $ 6,018,000S 318,000 S 1,731,600 $ Totals 8,202,600 $ 8,954,450 S (751,850)