Describe monthly sales by region and by sales people

Assignment Help Finance Basics
Reference no: EM13757919

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 (as described in the 7 ways above). 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 differentiate areas of your spreadsheet.

Attachment:- sales spredsheet.xls

Reference no: EM13757919

Questions Cloud

What is applied behavior analysis : What is Applied Behavior Analysis (ABA) and how can this be used to teach children with ASD new skills? What needs to be considered when designing effective academic?
Design an audit program for the cycle : Design an audit program for the cycle in no more than 1,050 words. Consider using a checklist or flowchart to outline your process.
Discuss the diseases gerd and copd : Discuss the diseases GERD and COPD. Identify what each eponym stands for, the system that each affects, how they are treated, and the type of specialist that treats them
What intervention strategy you observe educator to be using : Describe the skills you think Ayah is working on during this video clip. What intervention strategies you observe the educator to be using?
Describe monthly sales by region and by sales people : 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
Describe current trends in reading instruction strategies : How can early childhood professionals integrate language experiences across the curriculum? Describe some current trends in reading instruction and teaching strategies?
Initial impression of accounting and intellipath : Discussion Board consisting of 400-500 words describing your initial impression of accounting and intellipath
What are the minimun and maximun height : Using Chebyshev's theorem, what do we know about the percentage of women with heights that are within 2 standard deviations of the mean? What are the minimun and maximun height thats are within 2 standard deviation of the mean
Meaning of marketing and its history : It is important to have a thorough understanding of the meaning of marketing and its history. This foundation is important for you to see where the industry has been and where it is moving.

Reviews

Write a Review

 

Finance Basics Questions & Answers

  Ipo-opportunities and threats

Write down the name of some opportunities and threats associated with going public through an IPO.

  Futures contracts and portfolio management

A strategy to take advantage of anticipated changes in world uncertainty is the spread.TED

  What is the required rate of return on the security

The Jones Company's common stock has a beta of 1.2. The risk-free rate is 4%. The expected market rate of return is 12%. What is the required rate of return on the security?

  International opportunities

International Opportunities

  Explain why the consultant advice is not logical

Clearly explain why the consultant's advice is not logical. That is, explain why Carazona's cost of equity in Indonesia would not be less than Carazona's cost of debt in Indonesia.

  Explain the differences in the responsibilities of the

explain the differences in the responsibilities of the treasurer and the controller in a large

  Describe how the degree of operating and financial leverage

Describe how the degree of operating and financial leverage can change the profitability of the firm when sales levels change significantly

  Demonstrate the ability to calculate both the future value

demonstrate the ability to calculate both the future value and present value formulas over a period of at least 3

  A company is offering a bonus plan to its employees the

a company is offering a bonus plan to its employees. the company will set aside 1 of sales as a bonus. the first year

  If d1150 gwhich is constant53 and p056 whats the stocks

if d11.50 gwhich is constant5.3 and p056 whats the stocks expected capital gains yield for the coming

  How large a sales increase can the company achieve without

bannister legal services generated 2000000 in sales during 2010 and its year-end total assets were 1500000. also at

  Q drake wishes to evaluate value of the asset expected to

q. drake wishes to evaluate value of the asset expected to give cash inflows of 3000 each year at the end of years 1

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