REVENUE+PROJECTION


 * Projected revenue is the amount of money a business projects it will earn based on how much it expects to sell.**

Yes, a restaurant is an exciting business, but you have to be profitable to stay in business. A good way to plan for the success of your restaurant is to estimate how much revenue your Menu Items could potentially bring in.

//You will create a spreadsheet to help you track the projected revenue for your restaurant's top-selling categories. Determining how much your restaurant is projected to bring in will help you budget for expenses.//


 * Strategies:**
 * Revenue is calculated by multiplying the price at which goods or services are sold by the number of units or amounts old.
 * Carefully check your results after entering the formulas in the spreadsheet.
 * The spreadsheet will also display the percentage of total revenue that each menu category will generate.

// Refer to Amanda's example for guidance. Do not copy the content or design of the example //
 * Instructions: **


 * 1) Create a new spreadsheet and save it as "Revenue Projection"
 * 2) Set the page orientation to landscape.
 * 3) In cell A1, key the following title: .
 * 4) In cell A2, key the following text: 
 * 5) Format the text in cells A1 and A2 to 16 point bold.
 * 6) Merge and center align the title in cell A1 across six columns of the spreadsheet.
 * 7) Merge and center align the text in cell A2 across six columns of the spreadsheet.
 * 8) In cells A3 through F3, key the following column headings: //Category/Menu, Item Price, Projected, Items Sold, Revenue per Item, Revenue per Menu Category,// and //Percent of Total Revenue.//


 * Note:** //Adjust row heights and column widths when needed so that all daat displays properly.//

9. Format cells A3 through F3 to bold, center aligned, and wrap text. 10. Key the appropriate data into the correct columns. 11. Enter a formula in cell D5 to compute the Revenue per Item for each Menu Item. This is computed by multiplying Item Price by the Projected Items Sold **(Hint**: =B5*C5) 12. Enter formulas into the remaining cells for each menu item listed. 13. Enter a formula in cell E10 to compute the Revenue per Menu Category for the first category. **Hint**: =SUM(D5:D9) 14. Enter a formula in cell E17 to compute the Revenue per Menu Category for the second category **Hint:** =SUM(D12:D16) 15. Enter a formula in cell E24 to compute the Revenue per Menu Category for the third category **Hint:** =SUM(D19:D23) 16. Enter a formula in cell E26 to find the Total Projected Revenue **Hint**: =E10+E17+E24 17. Enter a formula in cell F10 to compute the Percent of Total Revenue for the first category. This is computed by dividing the Revenue per Menu category by the Total Projected Revenue **Hint:** =E10/E26 18. Enter a formula in cell F17 to compute the Percent of Total Revenue for the second category **Hint**: =E17/E26 19. Enter a formula in cell F24 to compute the Percent of Total Revenue for the third category **Hint:** =E24/E26 20.Enter a formula in cell F26 to find the Total Projected Revenue percent **Hint:** =F10+F17+F24 21. Format cells A4, A10, A11, A17, A18, A24, and A26 to bold. 22. Format column B, D, and E as Currency showing the "$" symbol and two decimal places. 23. Format column F to Percentage and display two decimal places. **Hint**: //The total should equal 100%// 24//.// Format the spreadsheet with single lines and double lines, as needed, to reflect proper accounting style. 25. Carefully proofread your work for accuracy, format, spelling, and grammar, then resave.

Projected Revenue for Wicked Kickn' BBQ example //Do not duplicate Amanda's wor//k

Project Revenue template