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?

In an Excel spreadsheet, could someone show me the formulas used to

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!