EQUIPMENT+INVENTORY


 * An equipment inventory list should include a description of each piece of equipment a business has in inventory.**

Businesses use spreadsheets to store various types of information in order to stay organized and have the ability to retrieve data quickly. A spreadsheet containing a list of your restaurant equipment is a good example.

Create a spreadsheet to help keep accurate records of the equipment you have in inventory. Not only will this list of equipment be useful to you, but your accountant will also use this information when preparing financial records for your restaurant.


 * Strategies:**
 * Use the Internet to research the different types and costs of restaurant equipment that you will need to run your restaurant. For example, if you open an ice cream shop, you will need items like a freezer, freezer display cases, blender, trays, chairs, tables, dishes, and cups.
 * Format numbers in financial data in the Accounting format so that the "$" symbols are left-aligned and number are decimal-aligned.
 * Be consistent when entering data into a spreadsheet so that if the data is sorted or filtered, the results will be correct. For example, if you list a vendor as "ABC Equipment" it must not be entered in another row as "ABC."
 * Check your results after entering the formulas in the .spreadsheet

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


 * 1) Create a new workbook and save it as "Equipment Inventory."
 * 2) Insert a header with the following text:  Equipment Inventory//
 * 3) Format the header to 18 point bold
 * 4) In the spreadsheet footer, key the title "Equipment Inventory"
 * 5) Set the page orientation to landscape
 * 6) In cells A1 - F1, key the following column headings: //Item, Description, Vendor, Item Cost, Number in Inventory, Total Item Value//

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

7. Bold and center align cells A1 - F1 8. Key your equipment inventory information into the spreadsheet. //(Be as detailed as possible...identify equipment needed for preparation and serving menu items)// 9. Enter a formula in cell F2 to compute the Total Item Value. This is computed by multiplying the Item Cost by the Number in Inventory (D2*E2 10. Enter formulas in the remaining cells in that column for each item listed.  11. Format columns D and F as Accounting showing the "$" symbol and two decimal places.  12. Below the last cell that contains data in column A, key the following text: //Total Equipment Inventory// and format to bold.  13. Below the last cell that contains data in column F, enter a formula to compute the total value of all your restaurant equipment and format to bold.

**Hint**: //Use the SUM formula//

14. Proofread your work for accuracy, format, spelling, and grammar, then resave.

[|Amanda's Equipment Inventory]