Monthly sales by product

Assignment Help Finance Basics
Reference no: EM13758222

Using the ABC Technologies Inc., Q1 2012 Sales spreadsheet, analyze the data on Q1 2012 Sales identifying the following:

Monthly sales by Region
Quarter One sales by Region
Monthly sales by Product
Quarter One sales by Product
Monthly sales by Region, by Sales people
Quarter One sales by Region, by Sales people
Create a graph or chart that compares the data in a meaningful way, i.e. compare regions by month, compare products by month, etc...

Create a spreadsheet formatted to present your analysis of the sales numbers to management. In your spreadsheet, use the following:

Use the SUM function
The date function
An additional math or statistical function of your choice
Fill colors to differential areas of your spreadsheet
Border lines to differential area of your spreadsheet

Attachment:- q1_2012_sales_week.xls

Reference no: EM13758222

Questions Cloud

Essay about that two companies mio and powerade zero drops : Write an essay about that two companies Mio and Powerade Zero Drops Advertisement/Billboard jam - this jam will take an advertisement (often in magazines) orbillboard and jam it with Photoshop or similar programs.
What are the various threats to information security : What are the various threats to information security in your view? Are you doing your share to protect your information? Why and why not? What can you do to improve your information security practices?
Effects of management information systems : Write a two-page paper (minimum length) describing the following effects of management information systems on organizational functions: Executive-level decision making
Draft us a proposal regarding the dissertation : Can you please let us know if it is possible by you to draft us a proposal regarding the dissertation in order to send it for approval and to continue for the rest (proposal, Dissertation) - Risk management in new technology deployment projects
Monthly sales by product : Using the ABC Technologies Inc., Q1 2012 Sales spreadsheet, analyze the data on Q1 2012 Sales identifying the following: Monthly sales by Region, Quarter One sales by Region, Monthly sales by Product
Discuss character of oedipus in oedipus rex as a tragic : Discuss the character of Oedipus in Oedipus Rex as a tragic hero in an argumentative paper following all guidelines below. Length should be 3 or more pages (including the works cited page).
Problem related to sovereign immunity : On December 21, 1988, Pan Am Flight 103 exploded 31,000 feet in the air over Lockerbie, Scotland, killing all 259 passengers and crew on board and 11 people on the ground.
Compute the tracking signal : Sales of tablet computers at Ted Glickman's electronic store in Washinton D.C over the past 10 weeks are shown in the table below". Forecast demand for each week including week 10, using exponential smoothing with a=.5 (initial forecast=20) Compute t..
Actions relate to functional-dysfunctional conflict scenario : When Allan Mulally, a former Boeing executive, was appointed CEO of Ford Motor Company, many wondered if an “airplane guy” could run a car company. Fortune magazine named him Executive of the Year in 2010. Use the Internet to research Mulally’s actio..

Reviews

Write a Review

Finance Basics Questions & Answers

  Whether the company in a position to issue debt securities

you are a capital markets product specialist at an investment bank. you have been approached by severn trent plc a uk

  Use more control variables rather than depend

In the world of bueisness Why not use more control variables rather than depend on randomization as the means of controlling extraneous variables.

  What is rollins cost of equity

The firm's marginal tax rate is 40 percent. What is Rollins cost of equity when using the CAPM approach? Express your answer in percentage (without the % sign) and round it to two decimal places.

  The companys tax rate is 30 and its discount rate is 10

a company is considering purchasing an asset for 60000 that would have a useful life of 5 years and would have a

  Abc hospital a not for profit acute care facility expects

abc hospital a not for profit acute care facility expects to have a patient load of 20000 inpatient days next year and

  Description of annuity problem

Which of the following cash flows is equal to receiving $125.00 today supposing a 9% annual discount rate?

  What will the nominal yield be

Low Corp. has a bond with annual interest payments of $109 maturing in 10 years at a value of $1,000 per bond. The current market price is $960. What will the nominal yield be?

  Monthly mortgage payment

Compute the monthly mortgage payment made at the beginning of each month on a $100,000 mortgage.

  What is the expected dividend per share for each

DPS Calculation: Warr Corporation just paid a dividend of $1.50 a share (that is, Do = $1.50). The dividend is expected to grow 7% a year for the next 3 years and then at 5% a year thereafter. What is the expected dividend per share for each of th..

  What is the apr used for this loan

you obtained a load of $20,000 to finance your home improvement project. Based on monthly compounding over 24 months, the end-of-the-month equal payment was figured to be $922.90. What is the APR used for this loan?

  Write an essay reviewing the cold war era

Write an essay reviewing the Cold War era and the threats to American families. Include what you would do to protect your family in case of an attack.

  What is the total amount of interest

Now, 1 year later, your aunt must inform the IRS and the person who bought the house about the interest that was include in the two payments made during the year. This interest will be income to your aunt and a deduction to the buyer of the house...

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