Preview

Northwind Traders

Satisfactory Essays
Open Document
Open Document
747 Words
Grammar
Grammar
Plagiarism
Plagiarism
Writing
Writing
Score
Score
Northwind Traders
Memo
To: Northwind Traders

Date: 9/22/13
Re: Revenue Assessment
Thank you for the opportunity to assess your sales data in order to provide recommendations for increasing your sales. The analysis and recommendations below are based on the data you provided, which covers a period from May 2004 through June 2006. The analysis below is based on this data alone. Therefore, our recommendations should be tempered by your knowledge of business realities and your market. Please let us know if we can answer any questions concerning the analysis or the recommendations provided.
ANALYSIS 1 My Analysis of sales per Country
I have included charts that show total sales per country ranging from the years 2004-06 these charts show the following, Strong business sales, Probationary sales and Low sales. I have concluded in my analysis that there are some countries that are stronger, some that either need new guidance in sales and some that do not generate enough for the company in sales.

Salesperson
Austria
Brazil
Canada
France
Germany
Mexico
Sweden
UK
USA
Venezuela

Buchanan

15

12
11
4
7
7
19
9

Callahan
13
24
4
16
46
4
20
16
45
23

Davolio
17
21
12
23
49
16
13
22
85
19

Dodsworth
8
5
3
7
23

6
10
10
2

Fuller
17
25
14
21
37
11
13
11
23
8

King
19
19
4
12
13
11
5
12
20
9

Leverling
18
24
20
36
50
13
22
17
47
23

Peacock
21
53
9
39
73
13
6
28
68
19

Suyama
12
17
9
18
26

5
12
35
6

Grand Total
125
203
75
184
328
72
97
135
352
118

Salesperson
Belgium
Denmark
Finland
Ireland
Italy
Spain
Switzerland
Buchanan
11

4

3
5
3
Callahan

5
9
4
7
3
3
Davolio
3
13
5
3
8
7
9
Dodsworth
7

3
9
2
1
7
Fuller
7
3
17
8
15
7

King
7
9
3
6
3
8
6
Leverling
2
4
4
14
2
7
9
Peacock
15
11
7
2
12
16
9
Suyama
4
1
2
9
1

6
Grand Total
56
46
54
55
53
54
52

You May Also Find These Documents Helpful

  • Powerful Essays

    The intent of this proposal is to provide a recommendation on how the company can increase revenue, achieve ultimate production levels, determine how fixed and variable costs can be adjusted to maximize profits, suggest a mix of pricing and non-pricing strategies, and create barriers to entry into the market if possible. This proposal will also look into ways on how the company can increase product differentiation, and if there is other means to minimize the cost for the product.…

    • 1404 Words
    • 6 Pages
    Powerful Essays
  • Good Essays

    Bsa 374 Week 3 Ind

    • 627 Words
    • 3 Pages

    Marketing & Sales department has its own challenges and is in need of improvements to boost its overall revenue mark. It has a two year plan to reach $50 million in revenue, by…

    • 627 Words
    • 3 Pages
    Good Essays
  • Better Essays

    The survey did not identify any significant change between the two years; however, the areas of concern remain consistent throughout both survey periods. The 2007 Sales Plan introduces some ideas that will be paramount in addressing the highlighted weak areas captured through the surveys. For example, the frequent shopper program will present incentives that will minimize price and increase customer satisfaction. Additionally, the “Increase behind the Scenes Efficiency” and “Cost Containment” initiative will reduce operational costs and minimize the amount of food requiring storage, while also having a zero stock out policy. These initiatives alone will be essential in increasing merchandise selection and providing a good value to the…

    • 1135 Words
    • 5 Pages
    Better Essays
  • Good Essays

    II. This year for McGregor’s Ltd, the revenue from sales is increased by 7.5% which is greater than the retail average of 4.9%. McGregor believes that by attracting young customers and selling special goods like glassware, clothes and accessories it should led to a significantly greater volume of sales, and he believes a greater reliance on special sales would be necessary to speed up turnover.…

    • 1428 Words
    • 6 Pages
    Good Essays
  • Good Essays

    Hallstead Jewelers

    • 987 Words
    • 4 Pages

    1.) Break-even ticket sales increased from 4533 in 2003, to 4998 in 2004 and 7491 in 2006. Break-even point in Sales Dollars has changed from $7,285 in 2003, to $7,617 in 2004 and $11,634 in 2006. (Table 1) The margin of safety has changed from $1,298 in 2003, to $485 in 2004, and a loss of $923 in 2006. (Table 2) There is a decrease from 2003 to 2006. Fixed cost per month attributed to stores relocation and subsequent renovations caused a decrease from 2003 to 2006. Other factors contributing to the 2003-2006 decrease are as follows: • 1% increase in Cost of Goods Sold (COGS) totaling $81,000 • Decrease in sales of $481,000 • Increase in salaries totaling $60,000 • Increase in miscellaneous expenses of $40,000. (Table 3) 2.) If prices were reduced by 10 percent, Hallstead’s total income would decrease to $1,111. This would change the break-even point for ticket sales to 9,637, and significantly change the overall sales figure to $13,473 (Table 4). 3.) Gretchen’s idea would effectively eliminate sales commissions. This would reduce sales volume by 1,143. This would decrease ticket sales to 8,494 and compromise the break-even. Sales dollars would reduce by $1,598 to $11,875 (Table 4). 4.) Michaela’s suggestion to increase advertising by $200,000 is sound: The increase accounts for 2% of sales and 4% of 2006 sales. Both figures are comparatively low for a retail business. This increase would change the break-even point from 7,491 to 7,790 ticket sales (Table 5). 5.) If fixed costs remained static from 2006 to 2007, average sales ticket would have to increase from $1,553 to $1,690 in order to break-even. (Table 6). List of recommendations for Hallstead Jewelers are as follows: Evaluate the number of sales staff needed and consider reducing the number of FTE’s and/or PTE’s. When reducing staff and/or operating, make sure that the best sales associates are receiving the number of hours they desire and then allocating the remaining…

    • 987 Words
    • 4 Pages
    Good Essays
  • Good Essays

    Executive summary: the business is being faced with falling sales due to consumers viewing the business as outdated and no longer relevant to their needs. There is also strong competition in the area which has placed considerable pressure on pricing. Its target market of 50-65 year olds no longer dominates the area.…

    • 1278 Words
    • 6 Pages
    Good Essays
  • Good Essays

    Ll Bean

    • 1053 Words
    • 5 Pages

    Currently, the business is acquiring greater sales due to its customer acquisition program combined with other marketing efforts (i.e. increase in catalogue circulation, more advertisements). As well, the company is utilizing new technologies to improve its inventory system, its data processing programs, and its order system. This allows the company to provide customers with accurate and efficient services. Furthermore, the company provides its employees with many attractive benefits,…

    • 1053 Words
    • 5 Pages
    Good Essays
  • Good Essays

    Read chapters 1, 2, and be sure to go through the SPSS tutorial (or “run the tutorial”).…

    • 1263 Words
    • 31 Pages
    Good Essays
  • Satisfactory Essays

    the sales of its goods and services in both its domestic markets and overseas markets compared to…

    • 1516 Words
    • 5 Pages
    Satisfactory Essays
  • Satisfactory Essays

    term project

    • 639 Words
    • 7 Pages

    Thank you for the opportunity to assess your sales data in order to provide recommendations for increasing your sales. The analysis and recommendations below are based on the data you provided, which covers a period from May 2004 through June 2006. The analysis below is based on this data alone. Therefore, our recommendations should be tempered by your knowledge of business realities and your market. Please let us know if we can answer any questions concerning the analysis or the recommendations provided.…

    • 639 Words
    • 7 Pages
    Satisfactory Essays
  • Better Essays

    Using examples from the industry, discuss how you would spend this money most effectively to maximise both sales and exposure, giving reasons both for your choices, and why you have rejected possible alternative approaches. The report must include an appendix detailing your projected expenditure.…

    • 1603 Words
    • 7 Pages
    Better Essays
  • Satisfactory Essays

    | Create a new query in Design view. Add the Customers, Orders, and Employees tables to the query design window. From the Customers table, add the CompanyName, ContactName, and ContactTitle fields; from the Orders table, add the OrderID,…

    • 537 Words
    • 3 Pages
    Satisfactory Essays
  • Powerful Essays

    sales and marketing functions into one division. The core objectives of this paper will thus be to…

    • 6643 Words
    • 42 Pages
    Powerful Essays
  • Satisfactory Essays

    5 6 6 7 17 19 21 25 33 36 38 39 45 47 47 47…

    • 2502 Words
    • 11 Pages
    Satisfactory Essays
  • Good Essays

    Computer Graphics Menus

    • 760 Words
    • 10 Pages

    CSC 706 Computer Graphics • Drawing Polylines Stored in a File • Parameterizing Figures • Menus 1 Drawing Polylines Drawing polyline from vertices in a file • • • • # polylines # vertices in first polyline Coordinates of vertices, x y, one pair per line Repeat last 2 lines as necessary File for dinosaur available from theWeb site Code to draw polylines/polygons in Fig. 2.24.…

    • 760 Words
    • 10 Pages
    Good Essays

Related Topics