- Your supervisor has requested that you create a supplies budget request for your department for next year. Your supervisor would like you to create three budget request worksheets Elements of the Budget request should contain the following columns:
- Budget Item
- Price per item
- Subtotal Total cost
- Tax on item (6.5%)
- The grand total of item cost
The Budget should contain a Grand Total of all Budget expenses. It is expected that you have at least ten (10) budgeted items. In addition, your supervisor has asked you to create three budget requests- one normal request, one for lean times (.95% of original budget request), and one for good times (107% of budget).
Please create three budget requests on three worksheets using formulas.