Excel Assignment

For A milkshake shop

MS Excel: A projected budget for the first two years of operation, which includes:

4 charts and graphs to highlight key data

Sheet 1-Overall budget sheet with sales/expenses and net income for 2 years

Sheet 2-A monthly break of sales by products or services

Sheet 3-A monthly breakdown of expenses by expenses and category

You will use: VLOOKUP, Pivot Tables, Cell Range names, absolute references, and formulas for all calculations.

Only Microsoft Excel files will be accepted or graded. No budget templates may be used.