Question: Using Microsoft Excel create a spreadsheet reflecting the Fiscal Year (FY) 2021 budget for the MBOC division, which has a budget of $900,000.00 and MBOCs

Using Microsoft Excel create a spreadsheet reflecting the Fiscal Year (FY) 2021 budget for the MBOC division, which has a budget of $900,000.00 and MBOCs FY 2020 budget, which was $1.2 million. The budget line items for each fiscal year budget are: (1) Personnel Costs, (2) Training, (3) Equipment, (4) Supplies and (5) Contracts. In FY 2020, MBOCs budget allocation was: Personnel Costs @ $400,000, Training @ $50,000, Equipment @ $250,000, Supplies @ $5,000, and Contracts @ $495,000. In FY 2021, MBOCs budget allocation is: Personnel Costs @ $300,000, Training @ $100,000, Equipment @ $250,000, Supplies @ $50,000, and Contracts @ $200,000. The spreadsheet should reflect the FY2020 budget allocation, and the FY2021 budget allocation. Finally, the spreadsheet should reflect the difference in budget/funding allocation between the two fiscal years.

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 General Management Questions!