What is the average total profit generated for the month

Reference no: EM13205294

Question 1:

Below is the December 2009 sales data bysales representative for Papier Nouveau, a distributor of commercial printing supplies. As the Director of HR for Papier Nouveau, you are responsible for calculating monthly incentives. In previous months, bonuses were based on sales volume, however this month you are considering basing them on profit margin. Create pivot tables to help you answer the following questions in analyzing the December sales:

a) What is the highest volume of our highest margin product sold in December?
b) What is the average total profit generated for the month?
c) What is the total number of commercial copiers sold during December?

Employee ID	Region	Product	Profit Margin per Unit	Volume Sold
11048	SW	Cartridges	$ 7.00	200
11048	SW	Paper (ream)	$ 25.00	1,900
11048	SW	Printers	$ 103.00	7
12345	NE	Commercial Copiers	$ 593.00	4
12345	NE	Paper (ream)	$ 25.00	2,000
12345	NE	Printers	$ 103.00	8
26427	MW	Cartridges	$ 7.00	600
26427	MW	Paper (ream)	$ 25.00	7,300
26427	MW	Printers	$ 103.00	4
62380	NW	Fax Machine	$ 121.00	7
62380	NW	Laminating Machine	$ 375.00	3
62380	NW	Printers	$ 103.00	21
67890	SW	Cartridges	$ 7.00	820
67890	SW	Commercial Copiers	$ 593.00	6
67890	SW	Paper (ream)	$ 25.00	980
73628	NW	Commercial Copiers	$ 593.00	7
73628	NW	Fax Machine	$ 121.00	8
73628	NW	Paper (ream)	$ 25.00	4,900
82745	SE	Cartridges	$ 7.00	500
82745	SE	Commercial Copiers	$ 593.00	2
82745	SE	Paper (ream)	$ 25.00	750
92857	NE	Laminating Machine	$ 375.00	5
92857	NE	Paper (ream)	$ 25.00	200
92857	NE	Printers	$ 103.00	11
95202	SE	Fax Machine	$ 121.00	2
95202	SE	Paper (ream)	$ 25.00	5,000
95202	SE	Printers	$ 103.00	9

Question 2:

Fresh Blooms, LLC is a floral wholesaler. You want to create an invoice template that references the list of products available using the VLOOKUP function. Copy the invoice template below into a new workbook and populate the highlighted cells with a VLOOKUP function referencing the product table. Hint: you will need to use an IF logical test .

Code	Product	Price
A23	Tulips	10.00
B14	Roses	15.00
A27	Carnations	5.00
C45	House plants	12.00


	Invoice Template

Invoice #	74632
Date	1/14/2010


Code	Product	Unit Cost	Quantity	Total
A23			3	$ -
A27			2	$ -
B14			1	$ -
C45			4	$ -
				$ -
				$ -
				$ -

		Subtotal		$ -
		Tax	10%	$ -
		Total		$ -

Question 3:

Below is select sales data for RX Industries. The orders range from 1 to 20, however any returned or canceled orders have been deleted from the data. Use the template below to create an order summary that automatically shows the data for any selected order ID between 1 and 20. Hint: Use the IFERROR and HLOOKUP functions. The function for any order ID in the range that has been deleted should return the phrase "Not Found."

OrderID	1	7	9	13	16	2	3	5	10	14	4	8	11	17	18
Region	East	East	East	East	East	West	West	West	West	West	Central	Central	Central	Central	Central
OrderDate	1/10/2009	3/6/2009	3/28/2009	4/8/2009	4/12/2009	5/16/2009	5/23/2009	6/2/2009	7/8/2009	7/30/2009	8/29/2009	9/9/2009	10/5/2009	11/16/2009	12/25/2009
OrderAmt	$1,122.00	$ 4,453.00	$ 1,305.00	$2,708.00	$1,502.00	$4,796.00	$1,526.00	$1,523.00	$2,068.00	$1,597.00	$ 781.00	$2,976.00	$4,145.00	$3,979.00	$2,044.00

Reference no: EM13205294

Questions Cloud

Differences between the recuperation and circadian theories : Depending on which one you support, it may change your outlook on sleep and your current sleeping habits. What are the main differences between the recuperation and circadian theories?

How is the curve related to the natural rate of unemployment : What were the aggregate supply shocks to the American economy during the 1970s and early 1980s How did these shocks affect interpretation of the Phillips Curve What are the characteristics of the long-run Phillips Curve

State the electron configuration of the alkali metal : Write the electron configuration of the alkali metal (M) that reacts with oxygen to yield an oxide, M2O, if 3.54 g of the metal reacts

What was the amount of the change in autonomous expenditures : Give the amount of the change in the equilibrium level of Real GDP due to a $6 increase in spending on goods and services by households. Give the amount of the change in the equilibrium level of Real GDP due to a $6 increase in spending on goods a..

What is the average total profit generated for the month : What is the highest volume of our highest margin product sold in December, what is the average total profit generated for the month and what is the total number of commercial copiers sold during December

Explain what is the precipitate ksp : A solution contains Ba2+ (1.0x10^-3) and Ca2+ (1.0x10^-3). Drops of a 5.0x10^-1 M solution NaF were added using a buret until the [F-] in the solution mixture reached 1.5x10^-3 M.

Use logic and numerical symbols and operations naturally : Learners who have an ability to understand and use logic and numerical symbols and operations naturally can best be described as which of the following types of learners?

Is the federal funds rate currently too high or too low : Suppose that the economy is thought to be 2% above potential (that is, the output gap is 2%) when potential output grows 4% per year. Suppose also that the Fed is following the Taylor rule, with an inflation rate of 2% over the past year.

Which policy do you think is better in the short run : Suppose that the Fed's inflation target is 2%, potential output growth is 3.5%, and velocity is a function of how much the interest rate differs from 5%: %^V= 0.5 X (i-5). Suppose that a model of the economy suggests that the real interest rate is..

User Account

All Pages