ACCACF2400: Accounting -Creating A Business Dashboard - Accounting Assignment Help

Internal Code: 1AJFEI

Accounting Assignment Help

TASK Prepare an ‘Instructions’ sheet that provides general details about your spreadsheet. In your ‘Instructions’ sheet, you must also include an Internal Memorandum to the CEO Juan Palacios (see details below). Aim for approximately 1,200 words (including internal memorandum) (+/- 10%). ? The ‘Instructions’ sheet must include the following information: Your name and the name of the company. Explain how you inserted the Data Validation rules created and the logic behind the first Data Validation rule (see below) AND the reason why you chose the 3 ratios and how you calculated them. In terms of the first data validation rule, you must also explain the logic behind it. Please note that to get marks for the first data validation rule, it must work and it must be logical. Explain the logic behind the dashboard you created [HINT: You might want to explain why you choose to include that information in your dashboard AND/OR why you decided to present it that way]. Internal Memorandum - You MUST include an internal memorandum that will be sent to the CEO Juan Palacios . - In your internal memo, you MUST include 2 interesting findings that you discovered when analysing the data (and also include the reference; for example, see Panel XX dashboard OR Cells XX:XX Worksheet ‘aaaa’, etc.). - Additionally, you MUST include 2 recommendations to the CEO based on your analysis of the data. Although the internal memorandum must be pasted into the ‘Instructions’ sheet, it will be marked separately (see marking rubric). Please refer to Chapter 16 of ‘Model business letters, emails and other business documents’ by Taylor (2015) when preparing the internal memorandum. In Chapter 16 Taylor (2015) provides guidance about how to write an internal memorandum. ? Your ‘Data Input’ worksheets MUST include the tables provided (one worksheet per table). Additionally, you MUST create three (3) Data Validation (DV) rules that prevent invalid data to be entered. The Data Validation rules must be as follows: Create a DV rule that prevents users entering invalid data and provides an error message guiding the user [HINT 1: Users could retry, but they must enter a value that meets the validation criteria] [HINT 2: Apply this DV rule to a field in any of the tables. Once you choose the field, add 5 rows to that table and then insert the DV rule in those cells]. Insert a CUSTOM DV rule on the 'Product ID' field that prevents entering a duplicated Product ID. In other words, with this DV rule, Product ID should not be duplicated [HINT: Add 5 rows to the 'Product' table and then insert the CUSTOM DV rule in those cells]. Insert a CUSTOM DV rule that prevents entering more than 5 digit numbers [HINT: You need to make sure that each cell only allows 5 characters and those characters must be numbers] [HINT 2: Add another 5 rows to the 'Product' table and then insert the CUSTOM DV rule in those cells]. ? The ratios have to be calculated on the ‘Calculation’ sheets (as per above) using the correct cell referencing. Detailed explanations should be provided in the ‘Instructions’ sheet. ? Although you can use EITHER Excel tables or Pivot Tables (and/or Pivot Charts), you MUST use at least one Pivot Table (and/or Pivot Chart). ?

This ACCACF2400: Accounting Assignment Help has been solved by our Accounting experts at onlineassignmentbank. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.