Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Reporting and Analysis

Authors: Flawrence Revsine, Daniel Collins, Bruce, Mittelstaedt, Leon

6th edition

9780077632182, 78025672, 77632184, 978-0078025679

More Books

Students also viewed these General Management questions

Question

54. Prove Theorem 6.7.10.

Answered: 1 week ago