Operation of a small-to-medium size business

Assignment Help Business Management
Reference no: EM13739891

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 Trade Fair organized by "Latrobe Valley Product Gallery". 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 and chart form; and
• use the functionality of Microsoft Word to write a brief report of your business observations and recommendations.

Calculations (All Students):

a. total sales, sub-totalled by each (a) Trade Fair, (b) Sales Representative, and (c) income type.

b. total profit, sub-totalled by each (a) Trade Fair, and (b) Sales Representative.

c. total expenses, sub-totalled by each (a) Trade Fair, (b) Sales Representative, and (c) cost type.

d. total hours worked, sub-totalled by each (a) Trade Fair, and (b) Sales Representative.

e. changes to profitability over past decade, including 2014 figures, sub-totalled by each Trade Fair.

f. Who are LVPG's five best and five worst customers by total sales?

g. What are LVPG's best and worst value-added services by total profit?

h. What are LVPG's best and worst Trade Fairs by total profit?

i. What would happen to profits if the rate of pay to Sales Representatives for hours worked on sales was increased by 40%?

j. What are the best Sales Representative's best- and worst-selling services (by total profit)?

k. What would happen to profits if the amount of space required to be sold to change the rate of commission paid was changed from 20 sq.m. to (a) 25 sq.m. and (b) 30 sq.m.

l. Should LVPG focus on any particular (a) customer(s), (b) Trade Fairs, and (c) particular sales activities in future, and why?

m. What are your recommendations for resolving any data quality issues observed in the workbook?

n. What are your recommendation regarding what other data should be collected to improve decision making for LVPG?

o. What are your recommendation regarding record-keeping to improve the quality of data collection and management?

p. What changes should LVPG make regarding any currently employed Sales Representative(s), or to the fees paid to the Sales Representatives, and why?


Attachment:- Assignment_data.rar

Reference no: EM13739891

Questions Cloud

Privacy and electronic privacy : Distinguish between information privacy and electronic privacy.
Occupational licensing can accomplish : Occupational licensing can accomplish which of the following?
Indifference mapping the change in consumer optimization : Over the past five years American consumers have decreased their frequency of taking vacations. It is believed that a few factors may have led to this decrease. The recession of 2009 effectively stalled income growth in the country while at the same ..
Prejudice and prejudicial treatment against people : Ageism refers to prejudice and prejudicial treatment against people older than a certain age (often people older than their mid-50s). What do you think is the most common expression of ageism?
Operation of a small-to-medium size business : Identifying and explaining your insights into the operation of Trade Fair organized by "Latrobe Valley Product Gallery". Learning Objectives
Obtaining a measure of overall performance : Max's Performance Auto modifies 375 autos per year. The owner, Max Magee, is interested in obtaining a measure of overall performance
Major life events and minor life events : Question: Discuss major life events and minor life events as sources of personal stress.
Use an exactly even amount of amaretto and sour mix. : Assume you have decided to enrol in a bartending academy and while taking classes you have learned that even though customers order a rum and coke they can never tell the difference if you instead use Pepsi. You have also learned that when people ord..
Relationship to globalization : How are information systems transforming business and what is their relationship to globalization? Give examples to illustrate your answer.

Reviews

Write a Review

 

Business Management Questions & Answers

  Public policy evaluate whether a policy has achieved

public policy evaluate whether a policy has achieved measurable objectivessimply designing and implementing a policy is

  Explain how would you do a complete background investigation

Explain How would you do a complete background investigation on applicants to minimize concerns about negligent hiring

  A senior member of the it management team for sai toys

A senior member of the IT Management Team for SAI Toys, one of the leading manufacturers of products for Gifted Electrical Engineering Kids (GEEKs). The toys that the company sells are manufactured in-house and shipped to brick-and-mortar re..

  Explain why there are some companies believe

In the economic downturn, Explain why there are some companies believe which they should not go for the CSR? Give me some reason also example?

  What happens to consumer as well as producer surplus

What happens to consumer as well as producer surplus when the sale of the good is taxed? How does the change in consumer

  The ethics of consumer production and marketing according

according to adam smith what is natural price? ltbrgtaffirmative action call for what steps to eliminate the fact of

  Illustrate what are some of the other responsibilities

illustrate what are some of the other responsibilities that HR might have picked up that it didn't have before as a result of this shift to the use of technology? Answer in 120 words or less.

  Explain the overall campaign

Write a summary that explain the overall campaign.

  Discussion on company motivational profile

Consider what makes working for this company a positive experience for its employees. What is the essence of its approach to motivation? How does it combine the use of various motivational techniques to be successful?

  Coaching versus managing

Explain why Coaching people is associated more with effective leaders than Managing people

  One source of new product thoughts is competitors

One source of new product thoughts is competitors. Steven Fischer freshly joined Frankie as well as Alex Specialty Products as a brand manager

  Cultural values influence planning

Cultural values influence planning, operations and decision making for international organizations.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd