Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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 -

Store & Region Sales Database
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

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

Company Accounting

Authors: Ken Leo, Jeffrey Knapp, Susan Mcgowan, John Sweeting, Leah Meng

12th Edition

0730382672, 9780730382676

More Books

Students also viewed these Accounting questions

Question

What is a shelf company, and what is its purpose?

Answered: 1 week ago

Question

3. Provide unexpected, spontaneous, and genuine praise.

Answered: 1 week ago