We have completed Allison, a Master Budget. Now you will be placed in groups of four Together you are to create a Master Budget for an event. You will need to use Excel to create the following budgets with supporting schedules as we did with Problem Allison: Sales Budget Direct Materials Purchases Budget, Overhead (all ONE 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 You will need to convince management why your project should be chosen over others Here are some criteria to remember. The project should be profitable and realistic. All event information needs to be clearly documented and submitted. The following is an example of a scenario: Our company MCC Inc is hosting an event for students graduating this spring. You will need to create the budgets above to accommodate this event. I expect that you will provide all guests with a dinner and entertainment. Create the menu and the cost of each item. Be all inclusive from the menu to the dinner napkins. To assist with the costs, you may use the Lowell Cafeteria at no charge for this event. but must decorate the location. Not only will you create a menu for the event, and but must entertain the guests in some manner and should provide costs for this as well. Supporting cost documentation should be submitted You may use the internet to obtain the information. In addition, you are expected to arrive at a sales price for each ticket to the event. Do not just make an event with elegant dining and entertainment with the price of the ticket being one that will not sell due to price or lack of interest You do not have to limit ticket sales to MCC students. This should be very realistic We have completed Allison, a Master Budget. Now you will be placed in groups of four Together you are to create a Master Budget for an event. You will need to use Excel to create the following budgets with supporting schedules as we did with Problem Allison: Sales Budget Direct Materials Purchases Budget, Overhead (all ONE 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 You will need to convince management why your project should be chosen over others Here are some criteria to remember. The project should be profitable and realistic. All event information needs to be clearly documented and submitted. The following is an example of a scenario: Our company MCC Inc is hosting an event for students graduating this spring. You will need to create the budgets above to accommodate this event. I expect that you will provide all guests with a dinner and entertainment. Create the menu and the cost of each item. Be all inclusive from the menu to the dinner napkins. To assist with the costs, you may use the Lowell Cafeteria at no charge for this event. but must decorate the location. Not only will you create a menu for the event, and but must entertain the guests in some manner and should provide costs for this as well. Supporting cost documentation should be submitted You may use the internet to obtain the information. In addition, you are expected to arrive at a sales price for each ticket to the event. Do not just make an event with elegant dining and entertainment with the price of the ticket being one that will not sell due to price or lack of interest You do not have to limit ticket sales to MCC students. This should be very realistic
