Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Spring 2019 Accounting 302 Coffee Shop Special Project due May 6. Accounting 302 Special Project Due December 8, 2019 No late submissions will be accepted. Please submit your document through Turnitin...

1 answer below »
Spring 2019 Accounting 302 Coffee Shop Special Project due May 6.
Accounting 302 Special Project
Due December 8, 2019
No late submissions will be accepted. Please submit your
document through Turnitin on Titanium.
Your Mission
The information in the excel file from The Coffee Shop is based on real data from a real company. The
name of the company has been changed.
You are the CFO of the company and you have been asked to analyze the operations and products of
The Coffee Shop. The attached excel file is what they gave you.
The objectives of the company are to (i) prepare a memo and visualization discussing your perspective
on what’s happening in the company’s products and markets with analysis of information including AT
LEAST (ii) the
eakeven points for top five profitable and bottom 5 profitable locations (assuming the
most recent year’s sales mix stays the same). You and your team have been asked to prepare a
visualization that will allow management to easily see what is happening in each market and/or with
each product.
Using Tableau and the concepts and tools you learned from this class, please analyze the data
contained in the attached pdf and provide me with a memo in pdf format with your conclusions and
support for those conclusions. Your conclusions should be well thought out and organized and
should result in comments as to what you believe the company should focus on and why.
You will be graded on the creativity and application of the tools and concepts learned in this class,
including the use of Tableau. You will present your visualizations that you created in Tableau in class
on December 10, 2019. Your visualizations should support the conclusions in your memo. The written
portion of the memo should NOT exceed 2 pages in length. DO NOT MAKE UP INFORMATION. Only
one member of the group needs to turn in the memo. Each member of the group should be named on
the face of the memo and I will apply the grade on the memo to each member of the group.
You may work in groups, but the number of people in the group is limited to 5 people or less. If you
intend to work as a group, please provide me with your group names no later than October 22, 2019.
Each member of the group will receive the same number of points, regardless of the effort of the team
member so choose your team wisely.
2
Each spelling, grammatical and/or math e
or will result in a deduction of 5 points from the total
possible points. The special assignment is due by midnight, Sunday, December 8, XXXXXXXXXXLate
submissions will receive zero points!
Criteria Excellent Meets
expectations
Approaches
expectations
Needs
improvement
Presentation Students uses
appropriate methods
to present data. The
visualization shows
trends and the
students are able to
draw appropriate
conclusions based on
knowledge.
Students use methods to
present data, but not all
may be appropriate.
The visualizations used
show trends and the
students use some prior
knowledge to draw
conclusions.
Students
attempts to use
appropriate
methods and to
identify trends,
ut e
ors exist
that do not allow
the students to
make the co
ect
conclusions.
Methods and
tools used were
not appropriate.
The analysis leads
to inco
ect
conclusions and
e
ors.
Data
Transforming
and
Manipulation
Important e
ors in the
data were recognized
and co
ected or
mentioned in the
summary memo.
Important e
ors in the
data were not
completely recognized
and co
ected or
mentioned in the
summary memo.
Important e
ors
in the data were
not completely
ecognized and
co
ected or
mentioned in the
summary memo.
Most of the e
ors
in the data were
not recognized
nor co
ected.
Visualization
Methods
The methods are
suitable for the
problem and the
intended audience.
The students
incorporate filtering
and sorting features as
appropriate.
Most methods were
co
ectly applied but
more could have been
done with the data.
Some methods
were applied but
with a large
amount of e
ors
or omissions.
Few methods
were applied
esulting in
significant
amounts of e
ors
and omissions
Analysis and
Conclusions
Conclusions are
focused and supported
y the visualization
esults. Important
points are covered in
the summary memo.
Missed some important
points.
Analyzed only
the most basic
points.
Entirely missed
the point.
Answered Same Day Nov 12, 2021

Solution

Preeta answered on Nov 14 2021
138 Votes
To: All Staff
From: CFO
Dated:
Subject: Position of the company
The company has a total of 13 products. There are mainly four types of products which are coffee, espresso, he
al tea and tea. Further there are three types of coffee, four types of espresso, three types of he
al tea and three types of tea. It is visible that the products are performing well in almost all the markets. The most profitable product is the Columbian coffee, which is sold almost at all the locations. The next most profitable products are decaf espresso and regular espresso. Caffe Mocha is also a very profitable product.
The top two most profitable locations are with the area code 508 and 617, both of these locations are in Massachusetts, one of the major markets of East. The next most profitable location is with the area code 650, which is in California, one of the major markets of West. The...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here