Question: Development of a Dashboard: a visual panel that presents, in a centralized way, a set of information, indicators and their metrics. The information to be

Development of a Dashboard: a visual panel that presents, in a centralized way, a set of information, indicators and their metrics. The information to be identified is: Fixed Costs Variable Costs Total Expenses Total Revenue Main source of Revenue Main sources of Expenses Identification of the balance throughout the month The types of statements and graphics to be used are up to the candidate's choice. Tool to be used: Excel or Google Sheets.

Table below:

Development of a Dashboard: a visual panel that

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 A DATE 02/05/2022 03/05/2022 03/05/2022 06/05/2022 06/05/2022 06/05/2022 09/05/2022 09/05/2022 11/05/2022 11/05/2022 12/05/2022 13/05/2022 13/05/2022 13/05/2022 16/05/2022 17/05/2022 18/05/2022 19/05/2022 20/05/2022 B ENTRANCE R$ 500,00 R$ 0,00 R$ 0,00 R$ 0,00 R$ 0,00 R$ 0,00 R$ 0,00 R$ 0,00 R$ 800,00 R$ 0,00 R$ 5.000,00 R$ 0,00 R$ 0,00 R$ 0,00 R$ 0,00 R$ 0,00 R$ 0,00 R$ 0,00 R$ 0,00 C EXIT R$ 0,00 -R$ 650,00 -R$ 45,00 -R$ 15,00 -R$ 130,00 -R$ 2.000,00 -R$ 160,00 -R$ 750,00 R$ 0,00 -R$ 150,00 R$ 0,00 R$ 55,00 R$ 375,00 R$ 700,00 R$ 312,00 R$ 97,00 R$ 278,00 R$ 130,00 R$ 150,00 D CASH BALANCE R$ 7.500,00 R$ 8.000,00 R$ 7.350,00 R$ 7.305,00 R$ 7.290,00 R$ 7.160,00 R$ 5.160,00 R$ 5.000,00 R$ 4.250,00 R$ 5.050,00 R$ 4.900,00 R$ 9.900,00 R$ 9.955,00 R$ 10.330,00 R$ 11.030,00 R$ 11.342,00 R$ 11.439,00 R$ 11.717,00 R$ 11.847,00 R$ 11.997,00 E IDENTIFICATION Previous balance Receipt of part of the Bibliographic Review project - 1 of 3 Purchase of Tickets to participate in Junior Companies Event Reimbursement for transporting a member of the company to the customer Bibliographic Review Project ISS Payment - 1 of 3 Purchasing Cartridges for Headquarters Purchase and Installation of Air Conditioning for the Headquarters Quarterly Payment of the Federation Purchase of Laboratory Supplies Donation Monthly payment of the company accountant Receipt of the single installment Company Project Purchase of Stationery Supplies for the headquarters Payment of Excel Training for Company members DLS characterization payment company project Payment of costs with legalization of the exchange of management Purchase of items for the General Meeting Coffee-break Payment for Hosting the Company's Website Google Ads payment for business marketing Purchase of Digital Certificate for the company

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

See attached for instructions and powerpoints. Directions: Answer all the questions. Please submit your work in Word or PDF formats only. You can submit an Excel file to support calculations, but...

I have attached all documents, including the homework question. I can answer question 1, but I need help on 2 and 3. ACT 5140 ? Accounting for Decision Makers HW #2 ? Chapter 9 Question #1 List and...

Process Strategy Chapter 3 Copyright 2013 Pearson Education, Inc. publishing as Prentice Hall 03 -01 What is Process Strategy? Process Strategy The pattern of decisions made in managing processes, so...

MKT500 Discussion Board 10 "Marketing Strategy" Please respond to the attached questions. I have attached the question, scenario, and lecture notes. Thank You "Marketing Strategy" 1.) From the...

What are the methodology and findings of used in this article? 1204 Y. JIA, L. VAN LENT, AND Y. ZENG within a sample of men." Pound, Penton-Voak, and Surridge [2009] also report that circulating...

Case Study World Bank: Behind the I.T. Transformation Baseline Magazine To provide technical assistance and developmental knowledge to fight poverty and disease, the World Bank first had to overhaul...

Below is my paper that I pasted. I need help writing my introduction and conclusion. Introduction Vision Striving to emerge as a foremost global entity, we aspire to spearhead innovation, foster...

Evaluation and Control in Strategic Management Evaluation and control information consists of performance data and activity reports (gathered in Step 3 in Figure 11-1). If undesired performance...

Hi. I am going to do research project in Managemeerial accounting. What i need is to come up with good research question from one of these two articles below. The research project is going to be very...

Managerial accounting is changing rapidly as a result of technology and new types of enterprises. Below is an article that states the opposite (Talha et al, 2010). How can we reconcile the two...

Use the following information to calculate the balance in the future income tax account for a building owned by the entity: Cost of the machine when it was purchased............ $1,400,000 Total...

A colleague has been taken ill. Your managing director has asked you to take over from the colleague and to provide urgently needed estimates of the discount rate/cost of capital to be used in...

when computing the Piotroski score, a decrease in asset turnover equals a score of 1 . true or false?

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...