McKnight_Project_Excel

McKnight_Project_Excel - BUSN-278 Budgeting and Forecasting...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
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.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Put your sales forecasting calculations here. Year 1 Year 2 Year 3 Year 4 Year 5 Sales $140,000 $154,500 $169,744 $185,764 $202,592
Background image of page 2
Capital Budget Soda fountain bar $150.00 2 pizza ovens $200.00 Salad and pizza/dessert bar $110.00 Approximately 100 square foot commercial refrigerator $300.00 2 cash registers $300.00 6 video game vending machines $250.00 $450.00 $1,800.00 20 four-seater tables with chairs $250.00 $300.00 140 sets of dishes, including cutlery and drinking cups $550.00 Commercial dishwasher $320.00 $170.00 Registration Cost $112.00 Insurance $1,000.00 Rennovation $15,000.00 Building Lease $120,000.00 Wages (Six Months) $6,000.00 Total $147,262.00 computer cupboards and refrigerator area to the dishwashing area trays, lifters, spoons, pots etcetera
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Year 1
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 9

McKnight_Project_Excel - BUSN-278 Budgeting and Forecasting...

This preview shows document pages 1 - 5. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online