Question: In an Excel spreadsheet, could someone show me the formulas used to get the minimum funding, the requested, Provided, Difference. If you could please use
In an Excel spreadsheet, could someone show me the formulas used to get the minimum funding, the requested, Provided, Difference. If you could please use excel, and just write in the formulas you used to get these. As in, I can see they are using a sum formula for the requested, but what would the formula be for provided, and then how does difference play into the formula?

Men's Basketball 13 Provided 15 Provided Head Coach Asst Coaches Scholarships Travel Recruiting Equipment Discretionary Total Requested Budget Requested 550,000.00 225,000.00 325,000.00 214,000.00 82,000.00 20,000.00 25,000.00 1,441,000.00 $ $ $ $ $ $ $ $ $ $ $ $ Women's Basketball Difference $ (550,000.00) Head Coach (225,000.00) Asst Coaches $ (325,000.00) Scholarships $ (214,000.00) Travel $ (82,000.00) Recruiting $ (20,000.00) Equipment (25,000.00) Discretionary $ (1,441,000.00) Total Requested Budget Minimum Funding* Requested 195,000.00 145,000.00 375,000.00 185,000.00 55,000.00 20,000.00 13,000.00 988,000.00 $ $ $ $ $ $ $ $ Difference (195,000.00) (145,000.00) (375,000.00) (185,000.00) (55,000.00) (20,000.00) (13,000.00) (988,000.00) $ $ $ Minimum Funding $ 975,000.00 $ 650,000.00 Provided 7 Provided $ $ $ Football 105 Head Coach Asst Coaches Scholarships Travel Recruiting Equipment Discretionary Total Requested Budget $ $ $ $ $ $ $ $ Requested 900,000.00 1,200,000.00 2,125,000.00 600,000.00 212,000.00 241,000.00 95,000.00 5,373,000.00 Women's Bowling Difference $ (900,000.00) Head Coach $ (1,200,000.00) Asst Coaches $ (2,125,000.00) Scholarships $ (600,000.00) Travel $ (212,000.00) Recruiting $ (241,000.00) Equipment $ (95,000.00) Discretionary $ (5,373,000.00) Total Requested Budget $ $ $ $ $ Requested 41,000.00 20,000.00 47,500.00 29,000.00 14,000.00 9,000.00 1,000.00 161,500.00 Difference (41,000.00) (20,000.00) (47,500.00) (29,000.00) (14,000.00) (9,000.00) (1,000.00) (161,500.00) $ $ Minimum Funding $ 3,900,000.00 Minimum Funding* $ 88,000.00 Men's Basketball 13 Provided 15 Provided Head Coach Asst Coaches Scholarships Travel Recruiting Equipment Discretionary Total Requested Budget Requested 550,000.00 225,000.00 325,000.00 214,000.00 82,000.00 20,000.00 25,000.00 1,441,000.00 $ $ $ $ $ $ $ $ $ $ $ $ Women's Basketball Difference $ (550,000.00) Head Coach (225,000.00) Asst Coaches $ (325,000.00) Scholarships $ (214,000.00) Travel $ (82,000.00) Recruiting $ (20,000.00) Equipment (25,000.00) Discretionary $ (1,441,000.00) Total Requested Budget Minimum Funding* Requested 195,000.00 145,000.00 375,000.00 185,000.00 55,000.00 20,000.00 13,000.00 988,000.00 $ $ $ $ $ $ $ $ Difference (195,000.00) (145,000.00) (375,000.00) (185,000.00) (55,000.00) (20,000.00) (13,000.00) (988,000.00) $ $ $ Minimum Funding $ 975,000.00 $ 650,000.00 Provided 7 Provided $ $ $ Football 105 Head Coach Asst Coaches Scholarships Travel Recruiting Equipment Discretionary Total Requested Budget $ $ $ $ $ $ $ $ Requested 900,000.00 1,200,000.00 2,125,000.00 600,000.00 212,000.00 241,000.00 95,000.00 5,373,000.00 Women's Bowling Difference $ (900,000.00) Head Coach $ (1,200,000.00) Asst Coaches $ (2,125,000.00) Scholarships $ (600,000.00) Travel $ (212,000.00) Recruiting $ (241,000.00) Equipment $ (95,000.00) Discretionary $ (5,373,000.00) Total Requested Budget $ $ $ $ $ Requested 41,000.00 20,000.00 47,500.00 29,000.00 14,000.00 9,000.00 1,000.00 161,500.00 Difference (41,000.00) (20,000.00) (47,500.00) (29,000.00) (14,000.00) (9,000.00) (1,000.00) (161,500.00) $ $ Minimum Funding $ 3,900,000.00 Minimum Funding* $ 88,000.00
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
