hula hot burger

C 221 Data Analytics Project Instructions - Individual Assignment Due: March 25, 2023 Hula Hut Burger (Financial Accounting) Learning objectives 1. Create a pivot table in Excel 2. Format a pivot table 3. Apply filters to a plvot table 4. Sort a pivot table 5. Create sum columns in a plvot table 6. Create maximum and minimum columns in a pivgs table 7. Create a calculated field 8. Create a pivot chart 9. Create a slicer Data set background stacy Fisher, owner of Hula Hut Burger has contacted your accounting firm to review his fixed asset records. Hula Hut Burger is the home of the "tastiest burger in the world" and specializes on serving allorganic beef and locally sourced food with a Hawailan flair. The company has restaurants throughout the United States and divides its reporting into six regions (South, Mid-Atlantic, Southwest, Northeast, West, and Midwest). Stask has provided you with a spreadsheet containing the company's fuxed asset data and has asked that your firm prepare a fixed asset schedule and answer various questions concerning the company's fixed assets. In addition to the fixed asset data, stasc.ladluded the following information from the company's fixed asset policies and procedures manual. Fixed asset categories are defined as follows: Land Vacant land parcels purchased for building sites, parking lots, or other purposes. tand improvements site improvements (other than bulldings) such as fencing and parking lots. Bulldinss Permanent structures (including permanently attached fixtures). Equipment Self-explanator. furniture self-explanatory. Note: This data anatytics activity uses an anonymized fixed asset record from a small company for the years of 19912014 and contains approximately 1,500s records. Data dictionary - Bscienalarea Indicates the regional location of the fixed asset. - Assetle This field is a sequential number assigned at purchase. This is a unique identified. - Assetcotecory indicates the fixed asset category. Cose Bosed on Hula Hut Burgers Created by Professor Tracle Milier-Nobles - 5/10/18 TLM www. Iteochaccounting.com ACCT 221 Data Analytics Project Instructions - Individual Assignment Due: March 25, 2023 - InsvcDate, This is the date the asset was put into service. - Cost The purchase price of the asset. - SalyareValue; The salvage value assigned by the company. - Beproleth: The depreciation method used for the asset. NeReg indicates that no depreciatioh is being calculated. St indicates the asset is being depreciated using the straight-line convention. - Useful Life: The useful life assigned by the company. - BegAscumDere Beginning accumulated depreciation as of 1/1/2014. - SurrentYearRepri Current year depreciation for 2014. Requirements To start the analytics project, ro to the Fixed Assets tab ta the Excel file. In cell 13, enter the last two (2) digits of your banner 10 . If the last two (2) digits of your Banner 10 are "00", please contact your instructor Immediately. For each of the following requirements, create a new pivot table in a new worksheet. Name each new worksheet as "Beg 1," "Beg 2," etc. Format the dollar amounts in each pivot table or pivot chart using the accounting format with zero decimal places. Format non-currency numbers in each pivot table or pivot chart using the accounting format with zero decimal places, 1. 'Prepare a fixed asset schedule that contains the totals for cost, beginning accumulated depreciation, current year depreciation, ending accumulated depreciation, and ending book value by regional areas. (Hint: Create a calculated field for Ending Accumulated Depreciation and Ending Book Value.) - Change the column names in the pivot table to match the headings listed above.. - Sort the pivot table by book value in descending order. - Which region has the highest book value? Highlight this value in Green. - How much depreciation was taken during the year for the entire company? Highlight this value in fied. 2. Which region(s) does not have land? 3. Which asset category has the highest total cost? in addition to the pivot table, include a plvot chart and slicer to answer this question. 4. What is the maximum and minimum asset cost in each asset category? (Hint: You coug use the maximum and minimum feature in the plvot table.) 5. In Word, prepare a memorandum addressed to stacy Fisher. The memo should summarize the flied asset schedule. It should also discuss any areas that you deem important. Be sure to discuss the overall story that you see emerging from the plvot tables, charts and worksheets. The memo should be in APA format, Times New Roman font size 10, single-spaced (double space between paragraphs) and be at least one page in length. Submission instructions 1. Submit your completed fxcel and Word files via glackboard by 11:59 AM on March 25, 2023. Case Bosed on Hula Hut Burgen Creoted by Professor Trocie Maller-Nobles - 5/10/18 TLM wwwiteochoccounting.com C 221 Data Analytics Project Instructions - Individual Assignment Due: March 25, 2023 Hula Hut Burger (Financial Accounting) Learning objectives 1. Create a pivot table in Excel 2. Format a pivot table 3. Apply filters to a plvot table 4. Sort a pivot table 5. Create sum columns in a plvot table 6. Create maximum and minimum columns in a pivgs table 7. Create a calculated field 8. Create a pivot chart 9. Create a slicer Data set background stacy Fisher, owner of Hula Hut Burger has contacted your accounting firm to review his fixed asset records. Hula Hut Burger is the home of the "tastiest burger in the world" and specializes on serving allorganic beef and locally sourced food with a Hawailan flair. The company has restaurants throughout the United States and divides its reporting into six regions (South, Mid-Atlantic, Southwest, Northeast, West, and Midwest). Stask has provided you with a spreadsheet containing the company's fuxed asset data and has asked that your firm prepare a fixed asset schedule and answer various questions concerning the company's fixed assets. In addition to the fixed asset data, stasc.ladluded the following information from the company's fixed asset policies and procedures manual. Fixed asset categories are defined as follows: Land Vacant land parcels purchased for building sites, parking lots, or other purposes. tand improvements site improvements (other than bulldings) such as fencing and parking lots. Bulldinss Permanent structures (including permanently attached fixtures). Equipment Self-explanator. furniture self-explanatory. Note: This data anatytics activity uses an anonymized fixed asset record from a small company for the years of 19912014 and contains approximately 1,500s records. Data dictionary - Bscienalarea Indicates the regional location of the fixed asset. - Assetle This field is a sequential number assigned at purchase. This is a unique identified. - Assetcotecory indicates the fixed asset category. Cose Bosed on Hula Hut Burgers Created by Professor Tracle Milier-Nobles - 5/10/18 TLM www. Iteochaccounting.com ACCT 221 Data Analytics Project Instructions - Individual Assignment Due: March 25, 2023 - InsvcDate, This is the date the asset was put into service. - Cost The purchase price of the asset. - SalyareValue; The salvage value assigned by the company. - Beproleth: The depreciation method used for the asset. NeReg indicates that no depreciatioh is being calculated. St indicates the asset is being depreciated using the straight-line convention. - Useful Life: The useful life assigned by the company. - BegAscumDere Beginning accumulated depreciation as of 1/1/2014. - SurrentYearRepri Current year depreciation for 2014. Requirements To start the analytics project, ro to the Fixed Assets tab ta the Excel file. In cell 13, enter the last two (2) digits of your banner 10 . If the last two (2) digits of your Banner 10 are "00", please contact your instructor Immediately. For each of the following requirements, create a new pivot table in a new worksheet. Name each new worksheet as "Beg 1," "Beg 2," etc. Format the dollar amounts in each pivot table or pivot chart using the accounting format with zero decimal places. Format non-currency numbers in each pivot table or pivot chart using the accounting format with zero decimal places, 1. 'Prepare a fixed asset schedule that contains the totals for cost, beginning accumulated depreciation, current year depreciation, ending accumulated depreciation, and ending book value by regional areas. (Hint: Create a calculated field for Ending Accumulated Depreciation and Ending Book Value.) - Change the column names in the pivot table to match the headings listed above.. - Sort the pivot table by book value in descending order. - Which region has the highest book value? Highlight this value in Green. - How much depreciation was taken during the year for the entire company? Highlight this value in fied. 2. Which region(s) does not have land? 3. Which asset category has the highest total cost? in addition to the pivot table, include a plvot chart and slicer to answer this question. 4. What is the maximum and minimum asset cost in each asset category? (Hint: You coug use the maximum and minimum feature in the plvot table.) 5. In Word, prepare a memorandum addressed to stacy Fisher. The memo should summarize the flied asset schedule. It should also discuss any areas that you deem important. Be sure to discuss the overall story that you see emerging from the plvot tables, charts and worksheets. The memo should be in APA format, Times New Roman font size 10, single-spaced (double space between paragraphs) and be at least one page in length. Submission instructions 1. Submit your completed fxcel and Word files via glackboard by 11:59 AM on March 25, 2023. Case Bosed on Hula Hut Burgen Creoted by Professor Trocie Maller-Nobles - 5/10/18 TLM wwwiteochoccounting.com