User Account

All Pages

What is the average total profit generated for the month

Assignment Help Financial Accounting
Reference no: EM13501658

Pivot Table Problem

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

 

 

Reference no: EM13501658

Questions Cloud

How many electrons flow through the bulb per second : A light bulb is rated at 60W, 120 V. how many electrons flow through the bulb per second and find the resistance of the bulb
How much energy does the accelerated electron have : In a X-ray tube, electrons are accelerated through a potential of 10, 000V. How much energy does the accelerated electron have
Explain oxalate in the compound was found by kmno4 titration : The oxalate in the compound was found by KMnO4 titration to constitute 54.81% of its mass. Molar mass of C2O4 is 88.0193 g/mol
Evaluate the molar concentrations of the oxidized : The values obtained were 0.207 and 0.900 respectively. Calculate the molar concentrations of the oxidized and reduced forms of the NAD.
What is the average total profit generated for the month : 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,
What is the magnitude of its magnetic dipole moment : a small bar magnet experiences a 2.1 x 10^-2N*m torque when the axs of the magnet is at 45 degree to a 6.00 *10^-2 T magnetic field. What is the magnitude of its magnetic dipole moment
Explain the origin of the energy being delivered to resistor : A conducting bar of length script l moves to the right on two frictionless rails, Explain the origin of the energy being delivered to the resistor
Define area of the head of an average flat headed straight : The area of the head of an average flat headed straight pin is 3.50*10(-4) inches squared. the atomic radius for the element neon is 7.0*10(1) pico meters. if you could line up a row of atoms how many neon atoms can fit across the diameter of the ..
Watch the amounts change in cells c4 and h4 : Look at the formulas in C4 and H4. They use the lookup function to compare the part number in B3 to the numbers in C6:F6, and "scan" the array table values in C7:F12 to find the sales in units for each month.

Reviews

Write a Review

Financial Accounting Questions & Answers

  Financial statement analysis and preparation

Financial Statement Analysis and Preparation

  Shareholder of a company

Describe the ways that a person can become a shareholder of a company. Why Wal-Mart would split its stock?

  Financial and accounting principles

An understanding of financial and accounting principles can be a valuable tool for managers. While not all managers will find themselves calculating financial ratios or preparing annual financial data.

  Prepare a statement of cash flow using the direct method

Prepare a Statement of Cash Flow using the Direct Method and Prepare the Operations section of the Statement of Cash Flow using the Indirect Method.

  Financial accounting assignment

This assignment has one case study and two question apart from case study. Questions related to document Liquidation question and Company financial statements question - Torquay Limited

  Prepare general journal entries for goela

Prepare general journal entries for Goela Ltd

  Principles of financial accounting

Prepare the journal entry to record the acquisition of the assets.

  Prepare general journal entries to record the transactions

Prepare general journal entries to record the transactions, assuming use of the periodic inventory system

  Global reporting initiative

Compare the view espoused by the economist Milton Friedman about the social responsibilities of business with the views express by Stigler.

  Explain the iasb conceptual frameworks

Explain the IASB Conceptual Framework's perspective of users and their decisions.

  Determine the company''s financial statements

T he focus of the report is to determine the extent to which you are comfortable relying on the financial statements as presented by management .

  Computation of free cash flow

Computation of Free Cash Flow

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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