Bus 278

budget_proposal_workbook_week_2.xls

Instructions

BUSN-278 Budgeting and Forecasting Template Instructions

Use this spreadsheet structure to lay out the various sections of your project.

The purpose of this spreadsheet is to make it easy for your professor to locate the

various sections of your project. Please don't alter the Worksheet Tabs or titles.

After you finish your calculations in this spreadsheet, you will have to

create a written report where you take screenshots from this spreadsheet

and put them in the Budget Proposal Template, along with necessary

explanations. Detailed instructions for how to write the report

are found in the Budget Proposal Template, a word document.

Put your sales forecasting calculations here.
General Information
Industry recorded pizza sales for 1 yr @ $10	$37 billion
Independently owned % of yrly pizza sales	51%
Number of restaurants in US	67554
Number of restaurants in Orlando, Florida	221
number of peak hours in a day between 10am-9pm	6
Americans age 18-24 eat pizza at least 3x a wk	21%
65 or older only eat 1 pizza a month	7%
Total sales broken down equally
1 yr sales	$37,000,000,000
Number of restaurants in US	67554
Total possible sales for each restaurant	$547,710
Independent % of sales	51%
Total possible sales per independent owner	$279,332.09
Total sales broken down by $10/$7
1 yr sales	37,000,000,000.00		Year 1	Year 2	Year 3	Year 4	Year 5
Pizza price	$10	% yrly increase in sales	0	3%	4%	5%	6%
Units sold	3,700,000,000.00	Total sales forecasted for 5 years	$414,616.45	$427,054.95	$444,137.15	$466,344.00	$494,324.64
Units sold per pizza company	54,771.00
Units sold by independent companies	27,933.21
Sales by independent @ $7	$ 195,532.46
Gaming sold at $4 per household average	$ 219,083.99
Total possible sales	$ 414,616.45

Put your detailed cash inflows and cash outflows here, also showing net cash flow.

Create an NPV Analysis here.

Show your rate of return calculations in this worksheet.

Show your payback period calculations here.

Put your Pro-Forma Income Statement, Balance sheet and statement of cash flows here, along with any other supporting calculations or schedules.