y alpine cupcakes data m x y! data analytics alpine cu x y! modules of the alpine c x Search Results | Course x Alpine Cupcakes, Ze | C X Alpine Cupcakes, 2e X Alpine Cupcakes, Inc. | x T Transtutors:Upload Ass x | Alpine Cupcakes, Inc. R X + X C A cambridgepub.com/ereader/10130/?preview#page/7 1:: Apps 3 6p) HP Connected E Auto Zoom 7 Preface using analytical tools. Acknowledgments 6. Perform substantive audit procedures to evaluate accounts receivable transactions and account ii balances using analytical tools. About the Authors iii Case Assignments Data Analytics Assignments: Before beginning the assignment, take some time to become familiar with typical data analytic tools. There are online tutorials available on this casebook's website. If you plan to use Excel for your analysis, become familiar with using formulas, vLookup and Pivot Tables. These tools are important to your efficient analysis of the data. Also, learn how to use some of the "short cut" keys (for example, copying down an entire page, moving to the top or bottom of a page, finding certain numbers on a page). You should not be looking at one line item at a time when you are performing the data analysis as there are too many transactions to manually check the data. Part 1: Risk Assessment Analytics In this part of your assignment, you will use the Data Analytics Risk Assessment Excel file. Please complete the following tasks using the Excel file: Q1. Analyze the risk associated with the cost of ingredients. Using the data provided in the Excel file, determine the cost of each type of cupcake. Present your work in a professional manner that is easy to understand. An example template is provided in the Excel file or you can create a better way to visually show the solution. Q2. Analyze the risk associated with the cost of ingredients. a. Create a visualization (i.e., chart, graph, table or some other visualization) to show how a 25% and 50% increase in the cost of sugar would affect the price of each cupcake. Case Assignment: pg. 7 of 10 7 Type here to search O EX W e 10:15 PM 5/1/2020