Hula Hut is the home of the "tastiest burger in the world" and specializes in serving all-organic beef and locally sourced food with a Hawaiian flair. The company has restaurants throughout the United States and divides its reporting into six regions (South, Mid-Atlantic, Southwest, Northeast, West, and Midwest). Jim Nelson, owner of Hula Hut, has contacted your accounting firm to review his fixed asset records. He's provided you with a spreadsheet containing the company's fixed asset data and would like for your firm to prepare a fixed asset schedule and answer various questions. Download the Fixed Asset Data Set Data Definitions Learning Objectives Using this data set, you will learn how to complete a fixed asset analysis using Microsoft Excel pivot tables. The specific pivot table functions you will learn include: . Creating a new table Formatting data Applying filters Creating sum columns Creating calculated fields Using the slicer tool Analyzing data for errors . Using the timeline tool Creating a pivot chart Instructions 1. There are seven requirements to research. 2. Each requirement will be presented on its own slide and will be followed by step-by-step instructions. 3. You'll create a new pivot table for each requirement in a new worksheet (i.e. "tab") and name each new worksheet following the sequence "Req 1," "Req 2," etc. 4. Dollar amounts should be formatted using the "Accounting" format with zero decimal places. 5. Non-currency numbers should be formatted using the "Number" format with zero decimal places. 6. Enter your responses for each requirements in the editable boxes at the end of each question, and save your spreadsheet for review when complete. Need some guidance? Check out these YouTube tutorials for Requirements 1 through 3 and Requirements 4 through 6. Requirement 1 Requirement 2 Requirement 3 Requirement 4 Requirement 5 Requirement 6 Requirement 7