Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Using these historical data spreadsheets from the Z Chedd'r project, make and post at least one unique visualization that can be used in a digital
Using these historical data spreadsheets from the Z Chedd'r project, make and post at least one unique visualization that can be used in a digital dashboard for Mr. Z.
2017 | 2016 | 2015 | 2014 | 2013 | |
revenue | $2,272,594.96 | $2,158,965.22 | $2,115,785.91 | $2,073,470.19 | $1,969,796.68 |
cogs | $1,111,836.80 | $1,056,244.96 | $1,035,120.06 | $1,004,066.46 | $973,944.47 |
gross profit | $1,160,758.16 | $1,102,720.25 | $1,080,665.85 | $1,069,403.73 | $995,852.22 |
pay expense | $480,977.01 | $452,118.39 | $429,512.47 | $420,922.22 | $395,666.89 |
admin expense | $81,256.56 | $80,443.99 | $78,835.11 | $76,470.06 | $74,175.96 |
cc expense | $65,068.13 | $68,972.22 | $68,972.22 | $65,523.61 | $66,834.08 |
promotion expense | $2,192.81 | $2,127.03 | $2,339.73 | $2,222.74 | $2,089.38 |
store dep | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 | $1,250.00 |
van dep | $5,075.00 | $5,075.00 | $5,075.00 | $5,075.00 | $5,075.00 |
income before tax | $524,938.65 | $492,733.62 | $494,681.32 | $497,940.10 | $450,760.91 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started