We have completed a Master Budget in Chapter 9. You are to create a Master Budget for an event. You will need to use Excel to create the following budgets with supporting schedules:

YOU CAN MAKE UP YOUR OWN REALISTIC NUMBERS!! NO GIVEN NUMBERS TO INCLUDE IN MASTER BUDGET

Sales Budget

Direct Materials Purchases Budget, Overhead (all ONE Budget)

Cost of Goods Sold Budget

Ending Inventory

Cash Budget

Pro Forma Income Statement

The budget should be created on one Excel Workbook with individual sheets for each budget. You will need to provide supporting data for all schedules.

After completion of the budget, you will present your budget and supporting documentation will be submitted to me (you may give me a web link or hard copy paper).You will need to convince management why your project should be chosen over others. Here are some criteria to follow:

The project should be profitable and realistic.

All event information needs to be clearly documented and submitted. I will verifying all your numbers. For example if you are purchases paper products at BJs Wholesale, provide the link with the price or a scan of a picture or paper of the price.