Instructionsbusn 278 Budgeting And Forecasting Template Instructionsus ✓ Solved

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.

2.1 & 2.2 Sales Forecast Put your sales forecasting calculations here. General Information Industry recorded pizza sales for 1 yr @ 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 ,000,000,000 Number of restaurants in US 67554 Total possible sales for each restaurant 7,710 Independent % of sales 51% Total possible sales per independent owner 9,332.09 Total sales broken down by /$ yr sales 37,000,000,000.00 Year 1 Year 2 Year 3 Year 4 Year 5 Pizza price % yrly increase in sales 0 3% 4% 5% 6% Units sold 3,700,000,000.00 Total sales forecasted for 5 years 4,616.45 7,054.95 4,137.15 6,344.00 4,324.64 4,324.64 Units sold per pizza company 54,771.00 Units sold by independent companies 27,933.21 Sales by independent @ $ 195,532.46 Gaming sold at per household average $ 219,083.99 Total possible sales $ 414,616..0 Capital Expenditure Budget Equipment Miscellaneous 2 ovens ,327. dish set 5.00 soda fountain bar ,194.00 cutlery/trays/spoons/shakers/forks 9.00 salad/dessert bar ,717.00 cookware 0.00 commercial refrigerator