Sales Tracking And Customer Relations Analyses

2311 words - 10 pages

Semester 1, 2014
Weight: 30%
Due: 5pm, Wednesday, Week 11
Sales Tracking and Customer Relations Analyses
To analyse a set of data (in Microsoft Excel), and write a brief report (in Microsoft Word), identifying and explaining your insights into the operation of “Ballarat Trade Fair Consultancy”.
Learning Objectives
In the process of this assessment task you will:
* plan, schedule and execute project tasks with a view to improving your personal productivity;
* gain awareness of some typical issues related to the operation of a small-to-medium size business;
* use the functionality of Microsoft Excel 2007/2010 to manipulate data, analyse it and visualise it in tabular ...view middle of the document...

She is also eager to hear your thoughts and ideas on how to improve the business and requires you to make several recommendations on how to improve the company’s performance, especially in relation to the following business objectives:
* improving the sales strategy;
* improving internal efficiencies and effectiveness; and
* building strong lasting relationships with its customers.
Ms Holt has provided you with last year’s sales information in the “itech1005-5005 2014-05 assignment data.xlsx” file. The data needs to be analysed and visualised to help observations related to the business operation and its shortcomings.
The data worksheet “Sales” contains collected information of the consultancy’s operations in the current year. These details included:
* Date (of customer order),
* Trade Fair
* Customer (i.e. exhibiting company)
* space sold (sq.m.)
* Sales Representative
* time spent by Sales Representative to complete sale
* returning Exhibitor?
* Exhibitor stand organised?
* Exhibitor travel organised?
* Exhibitor accommodation organised?
* Exhibitor marketing material organised?
* Exhibitor hospitality organised?
* Visitor tickets sold
The additional fees charged by BTFC to customers (i.e. exhibitors) for their value-added services are:
Value Added Service | Fee ($A) |
Exhibitor stand organised | 1000 |
Exhibitor travel arrangements | 100 |
Exhibitor accommodation arrangements | 100 |
Exhibitor marketing material organised | 1000 |
Exhibitor hospitality organised | 100 |

The data worksheet “Fairs” contains collected information of the Trade Fairs over the past decade. These details included:
* Trade Fair
* Year
* space available for BTFC to sell to exhibitors (sq.m.)
* Visitor tickets sold by BTFC
* Total Profit for BTFC
BTFC receives a fee ($5) for each Trade Fair visitor ticket sold through its Sales Representatives. This historical information is summarised in the “Fairs” worksheet as a summation of all Sales Representative ticket sales.
The company receives different rates of ‘commissions’ (i.e. fees) from the various Trade Fairs for selling space to companies exhibiting at the various fairs. The Trade Fair managers charge $120 sq.m. for floor space at all Trade Fairs, which rate BTFC charges the exhibiting companies. BTFC then pays commissions to the Sales Representatives for selling the space to those exhibiting companies. The following tables describe how these commissions are calculated:
Commission Received | Space Sold | Rate (% of sale amount) |
New Exhibitor (large) | >= 20 sq.m. | 10 |
New Exhibitor (small) | < 20 sq.m. | 5 |
Returning Exhibitor (large) | >= 20 sq.m. | 7.5 |
Returning Exhibitor (small) | < 20 sq.m. | 2.5 |

Commission Paid | Space Sold | Rate (% of commission received) |
New Exhibitor (large) | >= 20 sq.m. | 20 |
New Exhibitor (small) | < 20 sq.m. | 10 |
Returning Exhibitor...

Other assignments on Sales Tracking And Customer Relations Analyses

Tqm At Ups Essay

5143 words - 21 pages ) In expansion to its existing tracking system, UPS offers a wireless package-tracking service with Korean, Chinese and Japanese character sets in key Asian markets, and a move the company said should not only boost customer satisfaction but also create dramatic cost savings. Growing usage of international wired Web sites during the past few years proves that customers want to do business in their own languages. Another way UPS helps make all

Customer Support Megatrends And Next Practices

5356 words - 22 pages for 45.5 percent of all mobile phone sales in 2013, compared to just 9 percent in 2008. And people are doing a lot more than just voice on smart phones—some of them seem to live online! Mobile and social channels are also driving each other’s growth with Juniper Research expecting mobile social networking users to grow from 54 million in 2008 to 730 million in 2013. So, mobile customer service is a must for any customer-focused organization

Innovation Increases Plumbers Productivity And Efficiency

884 words - 4 pages INTRODUCTION, BACKGROUND, PROBLEM The purpose of this report was to provide a review of current tracking alternatives. INTRODUCTION Companies in the plumbing industry may use a unique service or product that will help differentiate them from competitors. Technology, nowadays, has become a ubiquitous tool that can be tailored to a company and help thrive in customer intimacy, product leadership, or operational excellence. As a result

Marketing Week 4 Course Project

585 words - 3 pages ) Segmentation and Targeting c) Positioning d) Product/Service e) Customer Profile f) Marketing Channels D. Communications Strategy Plans Listed here are the typical options available that form the communications strategy mix – marketers must think about how they need to match competitors or provide novelty, each strategy requires a specific objective, a media strategy, a media plan, and a budget. Each communications strategy (e.g. a

Ups Competes Globally With Information System

743 words - 3 pages captures customer’s signatures along with pickup and delivery information. • Package tracking is then transmitted to UPS’s computer network for storage and processing. From there, the information can be accessed worldwide to provide proof of delivery to customers or to respond to customer queries. • Through its automated package tracking system,UPS can monitor and even re-route packages throughout the delivery process. • Customer service

Information Systems And Software Applications

328 words - 2 pages provides help with purchase orders, credit memos, invoices, physical inventor forms, fixed asset forms, capital expenditure requests, and check requests (Formtran, 2010). The software provides a system that helps with certification testing, applicant tracking, charitable fund drives, employee satisfaction, pre-employment testing, time sheets, training, and pay roll forms (Formtran, 2010). The marketing and sales part of the application gives a company

Resume Work

1136 words - 5 pages sales goals, processes, and standards. ¿ Communicates customer concerns, trends, recurring issues, sales and service opportunities, and related issues to higher leadership and within the Customer Care team. ¿ Recommends and coordinates implementation of solutions with various Cox organizations. ¿ Reviews Monthly Achievement Plan and Supervisor scorecard regularly with Manager to identify opportunities to improve results ¿ Collaborates with

Ngs Case Study

538 words - 3 pages .] Business situation [Identify the problems that your customer is facing and their goals and objectives. List the strategic business or competitive reasons that caused the customer to reevaluate its current situation. Be as specific as possible, citing examples when appropriate and including supporting customer quotes. Example: As a result of the recovery of the market, Wingtip Toys wants to procure software for improved tracking of inventory and

Leadership Diversity

984 words - 4 pages tracking response rates of m-coupons seeing that it generates analysis information about the customer and the business. Analysis information that could be gathered would consist of cluster analysis, association detection, and statistical analysis (Baltzan & Phillips, 2009). The first analysis that is considered helpful is cluster analysis. A cluster analysis is a technique used to divide information set into mutually exclusive groups such

Final Paper

3379 words - 14 pages , the equipment and deliver the data. The RTLS has many useful business uses. It will help a business quickly find items in the database or store. Inventory will be properly kept and itemized. Cost will potentially be minimized due to less work force or equipment uses for itemizing and tracking of data. Loss prevention will be strictly managed because inventory will be closely managed. Business relations will improve through careful observation


1167 words - 5 pages Job analysis is the important process of identifying the content of a job in terms of activities involved and attributes needed to perform the work and identifies major job requirements. Job analysis was conceptualized by two of the founders of industrial/organizational psychology, Frederick Taylor and Lillian Moller Gilbreth in the early 20th century.[1] Job analyses provide information to organizations which helps to determine which employees

Similar Documents

Manage And Evaluate Customer Relations Essay

1624 words - 7 pages Reflective Account Unit 3 Manage & Evaluate Customer Relations The customers that our company supplies goods and services to are the petrochemical, bio-pharm, nuclear, pharmaceutical and oil and gas industries. It is important that we provide these customers with excellent quality, value, continuous improvement and respect and to challenge innovation to create new value for the customer. Teesside Fluid Systems was founded and built with

Hris Review

2819 words - 12 pages implementations as needed. LT A has completed its review and analyses of the existing systems listed above and present its findings and recommendations in this paper. Sales and Marketing Systems Review Riordan Manufacturing does not currently employ a consolidated sales and marketing system. Historical data, marketing research, marketing plans, sales and production records and financial information is located in multiple, disparate databases, as well as

Student Essay

6142 words - 25 pages the firm’s preference is to have the events in-store, guests can have Kudler cooking classes at their home for a price premium. | |Programs such as this encourage consumer loyalty and word-of mouth marketing. | |Frequent Shopper Program (Revenue Increase) – Kudler’s new initiative is tracking purchase behavior at the individual customer level and providing | |high

Sales Organization Essay

604 words - 3 pages Sales Organization Forms from export department to global key account management, application in B2C- vs. B2B-markets Table of Content 1.  Sale management in the 21st century 2.  Selling in B2C vs. B2B markets 3.  Sales Organization •  Vertical Structure •  Line Organization •  Line and Staff Organization •  Horizontal Structure •  Geographic Organization •  Product Organization •  Organization by Customer type or market