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

  Bill purchased the house for 70000 he put 25000 down and

bill purchased a house for 70000. he put 25000 down and agreed to pay the rest off over the next 15 years in 15 equal

  Organic chicken company has a debt-equity ratio of 065

organic chicken company has a debt-equity ratio of 0.65. return on assets of 8.5 percent and total equity is 540000.

  What happens to roe for firm u and firm l if ebit falls to

assume you have just been hired as a business manager of pizzapalace a regional pizza restaurant chain. the companys

  The housekeeping departmenent at ricardo clinic a

the housekeeping departmenent at ricardo clinic a multispecialty practice in corpus christi had 152318 in direct costs

  Types of competitive strategies

What types of competitive strategies are the most effective, and will the same strategy work in most venues? Why or why not? Please provide reference page

  What is the approximate payback period

It is estimated that the firm's after tax cash flow will be increased by $100,000 starting at the end of the second year, and that this incremental flow would increase at a 10 percent rate annually over the next 10 years. What is the approximate p..

  How would you assess the value of this liability

Explain what questions would you raise with the CEO over the firm's litigation liability - How would you assess whether the firm should record a liability for this risk, and if so, how would you assess the value of this liability?

  How much should you be willing to pay for this stock

In addition, you expect to sell the stock for $150 at the end of Year 2. If your expected rate of return is 16 percent, how much should you be willing to pay for this stock today?

  What is the firm cost of goods sold

Ellicott City Manufacturers, Inc. has sales of $6,344,210, and a gross profit margin of 67.3 percent. What is the firm's cost of goods sold?

  Describe the salary of a fund manager

A mutual fund declares that the salaries of its fund managers will depend on the performance of the fund. If the fund loses money, the salaries will be zero.

  Financial statement analysis

Select one (1) of the following publically traded health care organizations: Universal Health Services (NYSE: UHS) or Health Management Associates (NYSE: HMA).

  Without doing any calculations determine whether this bond

consider a five-year default-free bond with annual coupons of 5 and a face value of 1000.a. without doing any

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