Reference no: EM13500504
Ms Holt needs to have a summary report of operations that will include the following information:
a. total sales, sub-totalled by each (a) Trade Fair, (b) Sales Representative, and (c) income type. Use Pivot Table(s) and appropriate graph(s)/chart(s) to summarise these calculations.
b. total profit, sub-totalled by each (a) Trade Fair, and (b) Sales Representative. Use Pivot Table(s) and appropriate graph(s)/chart(s) to summarise these calculations.
c. total expenses, sub-totalled by each (a) Trade Fair, (b) Sales Representative, and (c) expense type. Use Pivot Table(s) and appropriate graph(s)/chart(s) to summarise these calculations.
d. total hours worked, sub-totalled by each (a) Trade Fair, and (b) Sales Representative. Use Pivot Table(s) and appropriate graph(s)/chart(s) to summarise these calculations.
e. changes to profitability over the past decade, including 2014 figures, sub-totalled by each Trade Fair. Use an appropriate graph/chart to summarise these changes.
Ms Holt requires you to make observations to help her with the following questions.
f. Who are BTFC's five best and five worst customers by total sales? Use an appropriate table and graph/chart to summarise these observations.
g. What are BTFC's best and worst value-added services by total profit? Use an appropriate table and graph/chart to summarise these observations.
h. What are BTFC's best and worst Trade Fairs by total profit? Use an appropriate table and graph/chart to summarise these observations.
i. What would happen to profits if the rate of pay to Sales Representatives for hours worked on sales was increased by 40%? Use an appropriate table and graph/chart to summarise these calculations.
j. What are the best Sales Representative's best- and worst-selling services (by total profit)? Use an appropriate table and graph/chart to summarise these calculations.
k. What would happen to profits if the amount of space required to be sold to change the scale of commission paid was changed from 22 sq.m. to (a) 25 sq.m. and (b) 20 sq.m. Use an appropriate table and graph/chart to summarise these calculations.
Ms Holt also requires you to make recommendations concerning the following business-level questions.
l. Should BTFC 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 redundancy issues observed in the workbook?
n. What are your recommendation regarding what other data should be collected to improve decision making for BTFC?
o. What are your recommendation regarding record-keeping to improve the quality of data collection and management?
p. What changes should BTFC make regarding any currently employed Sales Representative(s), or to the fees paid to the Sales Representatives, and why?
|
Determine the focal length of the magnifying glass
: When you place a saltshaker 30 cm from your magnifying glass, a real image forms 30 cm from the lens on the opposite side. What is the focal length of the magnifying glass
|
|
Explain how much sylvanite would you need to dig up
: Sylvanite is a mineral that contains 28.0 gold by mass. How much sylvanite would you need to dig up to obtain 50.0 of gold
|
|
What was the magnitude of the average force
: A 0.160-kg baseball traveling 30.0m/s strikes the catcher's mitt, which, in bringing the ball to rest, recoils backward 11.0cm . What was the magnitude of the average force applied by the ball on the glove?
|
|
How many photons does it emit each second
: If a low-pressure sodium vapor lamp emits 50 W of yellow light, how many photons does it emit each second
|
|
Who are btfcs best and worst customers by total sales
: What are BTFC's best and worst value-added services by total profit? Use an appropriate table and graph/chart to summarise these observations.
|
|
The redesign of a hilly portion of a city
: A city planner is working on the redesign of a hilly portion of a city. An important consideration is how steep the roads can be so that even low-powered cars can get up the hills without slowing down. A particular small car, with a mass of 92..
|
|
Three indistinguishable balloons
: Three indistinguishable balloons are given charges of -1.9 μC, -2.5 μC, and +2.0 μC respectively. You are given two of them at random, and you observe that they repel each other. Find the total charge of the balloons you have been handed.
|
|
Prepare a statement of changes in net assets
: The City of Shipley maintains an Employee Retirement Fund; a single-employer, defined benefit plan that provides annuity and disability benefits.
|
|
Determine the speed of electrons in the beam
: Early black-and-white television sets used an electron beam to draw a picture on the screen. What is the speed of electrons in the beam
|