Question
As part of your analysis of the company for management, you have been asked to analyze data on this company's financial performance. Review the selected
As part of your analysis of the company for management, you have been asked to analyze data on this company's financial performance. Review the selected financial and sales data in the Introduction to Dirt Bikes, which can be found at the Laudon Web site (http://wps.prenhall.com/bp_laudon_mis_9/32/8212/2102336.cw/). There you will find Dirt Bikess income statement and summary balance sheet data from 2014 to 2016, annual sales of Dirt Bikes models between 2012 and 2016 (measured in units sold), and total domestic versus international sales between 2012 and 2016 (measured in units sold).
Create graphs of Dirt Bikess sales history from 2012 to 2016 and its domestic versus international sales from 2012 to 2016. Select the type of graph that is most appropriate for presenting the data you are analyzing.
Calculate the gross and net margins in Dirt Bikess income statements from 2014 to 2016.
Prepare an addition to your management report that answers these questions:
What are Dirt Bikess best- and worst-performing products? What is the proportion of domestic to international sales? Have international sales grown relative to domestic sales?
Are sales (revenues) growing steadily, and, if so, at what rate? What is the cost of goods sold compared to revenues? Is it increasing or decreasing? Are the firms gross and net margins increasing or decreasing? Are the firms operating expenses increasing or decreasing? Is the firm heavily in debt? Does it have assets to pay for expenses and to finance the development of new products and information systems?
Pay no mind to the item descriptions -
ID | Store No | Sales Region | Item No | Item Description | Unit Price | Units Sold | Week Ending |
---|---|---|---|---|---|---|---|
1 | 1 | South | 2005 | 17" Monitor | $229.00 | 28 | 10/27/2016 |
2 | 1 | South | 2005 | 17" Monitor | $229.00 | 30 | 11/24/2016 |
3 | 1 | South | 2005 | 17" Monitor | $229.00 | 9 | 12/29/2016 |
4 | 1 | South | 3006 | 101 Keyboard | $19.95 | 30 | 10/27/2016 |
5 | 1 | South | 3006 | 101 Keyboard | $19.95 | 35 | 11/24/2016 |
6 | 1 | South | 3006 | 101 Keyboard | $19.95 | 39 | 12/29/2016 |
7 | 1 | South | 6050 | PC Mouse | $8.95 | 28 | 10/27/2016 |
8 | 1 | South | 6050 | PC Mouse | $8.95 | 3 | 11/24/2016 |
9 | 1 | South | 6050 | PC Mouse | $8.95 | 38 | 12/29/2016 |
10 | 1 | South | 8500 | Desktop CPU | $849.95 | 25 | 10/27/2016 |
11 | 1 | South | 8500 | Desktop CPU | $849.95 | 27 | 11/24/2016 |
12 | 1 | South | 8500 | Desktop CPU | $849.95 | 33 | 12/29/2016 |
13 | 2 | South | 2005 | 17" Monitor | $229.00 | 8 | 10/27/2016 |
14 | 2 | South | 2005 | 17" Monitor | $229.00 | 8 | 11/24/2016 |
15 | 2 | South | 2005 | 17" Monitor | $229.00 | 10 | 12/29/2016 |
16 | 2 | South | 3006 | 101 Keyboard | $19.95 | 8 | 10/27/2016 |
17 | 2 | South | 3006 | 101 Keyboard | $19.95 | 8 | 11/24/2016 |
18 | 2 | South | 3006 | 101 Keyboard | $19.95 | 8 | 12/29/2016 |
19 | 2 | South | 6050 | PC Mouse | $8.95 | 9 | 10/27/2016 |
20 | 2 | South | 6050 | PC Mouse | $8.95 | 9 | 11/24/2016 |
21 | 2 | South | 6050 | PC Mouse | $8.95 | 8 | 12/29/2016 |
22 | 2 | South | 8500 | Desktop CPU | $849.95 | 18 | 10/27/2016 |
23 | 2 | South | 8500 | Desktop CPU | $849.95 | 18 | 11/24/2016 |
24 | 2 | South | 8500 | Desktop CPU | $849.95 | 20 | 12/29/2016 |
25 | 3 | South | 2005 | 17" Monitor | $229.00 | 38 | 10/27/2016 |
26 | 3 | South | 2005 | 17" Monitor | $229.00 | 30 | 11/24/2016 |
27 | 3 | South | 2005 | 17" Monitor | $229.00 | 3 | 12/29/2016 |
28 | 3 | South | 3006 | 101 Keyboard | $19.95 | 30 | 10/27/2016 |
29 | 3 | South | 3006 | 101 Keyboard | $19.95 | 32 | 11/24/2016 |
30 | 3 | South | 3006 | 101 Keyboard | $19.95 | 33 | 12/29/2016 |
31 | 3 | South | 6050 | PC Mouse | $8.95 | 25 | 10/27/2016 |
32 | 3 | South | 6050 | PC Mouse | $8.95 | 5 | 11/24/2016 |
33 | 3 | South | 6050 | PC Mouse | $8.95 | 26 | 12/29/2016 |
34 | 3 | South | 8500 | Desktop CPU | $849.95 | 28 | 10/27/2016 |
35 | 3 | South | 8500 | Desktop CPU | $849.95 | 27 | 11/24/2016 |
36 | 3 | South | 8500 | Desktop CPU | $849.95 | 29 | 12/29/2016 |
37 | 4 | North | 2005 | 17" Monitor | $229.00 | 18 | 10/27/2016 |
38 | 4 | North | 2005 | 17" Monitor | $229.00 | 20 | 11/24/2016 |
39 | 4 | North | 2005 | 17" Monitor | $229.00 | 4 | 12/29/2016 |
40 | 4 | North | 3006 | 101 Keyboard | $19.95 | 12 | 10/27/2016 |
41 | 4 | North | 3006 | 101 Keyboard | $19.95 | 24 | 11/24/2016 |
42 | 4 | North | 3006 | 101 Keyboard | $19.95 | 36 | 12/29/2016 |
43 | 4 | North | 6050 | PC Mouse | $8.95 | 29 | 10/27/2016 |
44 | 4 | North | 6050 | PC Mouse | $8.95 | 11 | 11/24/2016 |
45 | 4 | North | 6050 | PC Mouse | $8.95 | 38 | 12/29/2016 |
46 | 4 | North | 8500 | Desktop CPU | $849.95 | 21 | 10/27/2016 |
47 | 4 | North | 8500 | Desktop CPU | $849.95 | 24 | 11/24/2016 |
48 | 4 | North | 8500 | Desktop CPU | $849.95 | 30 | 12/29/2016 |
49 | 5 | North | 2005 | 17" Monitor | $229.00 | 27 | 10/27/2016 |
50 | 5 | North | 2005 | 17" Monitor | $229.00 | 25 | 11/24/2016 |
51 | 5 | North | 2005 | 17" Monitor | $229.00 | 23 | 12/29/2016 |
52 | 5 | North | 3006 | 101 Keyboard | $19.95 | 80 | 10/27/2016 |
53 | 5 | North | 3006 | 101 Keyboard | $19.95 | 82 | 11/24/2016 |
54 | 5 | North | 3006 | 101 Keyboard | $19.95 | 75 | 12/29/2016 |
55 | 5 | North | 6050 | PC Mouse | $8.95 | 65 | 10/27/2016 |
56 | 5 | North | 6050 | PC Mouse | $8.95 | 24 | 11/24/2016 |
57 | 5 | North | 6050 | PC Mouse | $8.95 | 55 | 12/29/2016 |
58 | 5 | North | 8500 | Desktop CPU | $849.95 | 55 | 10/27/2016 |
59 | 5 | North | 8500 | Desktop CPU | $849.95 | 57 | 11/24/2016 |
60 | 5 | North | 8500 | Desktop CPU | $849.95 | 47 | 12/29/2016 |
61 | 6 | East | 2005 | 17" Monitor | $229.00 | 24 | 10/27/2016 |
62 | 6 | East | 2005 | 17" Monitor | $229.00 | 85 | 11/24/2016 |
63 | 6 | East | 2005 | 17" Monitor | $229.00 | 56 | 12/29/2016 |
64 | 6 | East | 3006 | 101 Keyboard | $19.95 | 52 | 10/27/2016 |
65 | 6 | East | 3006 | 101 Keyboard | $19.95 | 58 | 11/24/2016 |
66 | 6 | East | 3006 | 101 Keyboard | $19.95 | 69 | 12/29/2016 |
67 | 6 | East | 6050 | PC Mouse | $8.95 | 35 | 10/27/2016 |
68 | 6 | East | 6050 | PC Mouse | $8.95 | 39 | 11/24/2016 |
69 | 6 | East | 6050 | PC Mouse | $8.95 | 44 | 12/29/2016 |
70 | 6 | East | 8500 | Desktop CPU | $849.95 | 78 | 10/27/2016 |
71 | 6 | East | 8500 | Desktop CPU | $849.95 | 88 | 11/24/2016 |
72 | 6 | East | 8500 | Desktop CPU | $849.95 | 99 | 12/29/2016 |
73 | 7 | East | 2005 | 17" Monitor | $229.00 | 34 | 10/27/2016 |
74 | 7 | East | 2005 | 17" Monitor | $229.00 | 36 | 11/24/2016 |
75 | 7 | East | 2005 | 17" Monitor | $229.00 | 35 | 12/29/2016 |
76 | 7 | East | 3006 | 101 Keyboard | $19.95 | 49 | 10/27/2016 |
77 | 7 | East | 3006 | 101 Keyboard | $19.95 | 47 | 11/24/2016 |
78 | 7 | East | 3006 | 101 Keyboard | $19.95 | 48 | 12/29/2016 |
79 | 7 | East | 6050 | PC Mouse | $8.95 | 45 | 10/27/2016 |
80 | 7 | East | 6050 | PC Mouse | $8.95 | 42 | 11/24/2016 |
81 | 7 | East | 6050 | PC Mouse | $8.95 | 45 | 12/29/2016 |
82 | 7 | East | 8500 | Desktop CPU | $849.95 | 55 | 10/27/2016 |
83 | 7 | East | 8500 | Desktop CPU | $849.95 | 57 | 11/24/2016 |
84 | 7 | East | 8500 | Desktop CPU | $849.95 | 55 | 12/29/2016 |
85 | 8 | East | 2005 | 17" Monitor | $229.00 | 18 | 10/27/2016 |
86 | 8 | East | 2005 | 17" Monitor | $229.00 | 17 | 11/24/2016 |
87 | 8 | East | 2005 | 17" Monitor | $229.00 | 23 | 12/29/2016 |
88 | 8 | East | 3006 | 101 Keyboard | $19.95 | 22 | 10/27/2016 |
89 | 8 | East | 3006 | 101 Keyboard | $19.95 | 18 | 11/24/2016 |
90 | 8 | East | 3006 | 101 Keyboard | $19.95 | 22 | 12/29/2016 |
91 | 8 | East | 6050 | PC Mouse | $8.95 | 14 | 10/27/2016 |
92 | 8 | East | 6050 | PC Mouse | $8.95 | 16 | 11/24/2016 |
93 | 8 | East | 6050 | PC Mouse | $8.95 | 17 | 12/29/2016 |
94 | 8 | East | 8500 | Desktop CPU | $849.95 | 32 | 10/27/2016 |
95 | 8 | East | 8500 | Desktop CPU | $849.95 | 28 | 11/24/2016 |
96 | 8 | East | 8500 | Desktop CPU | $849.95 | 30 | 12/29/2016 |
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