Create a graph or chart that compares the data

Assignment Help Finance Basics
Reference no: EM13751617

Sales Analysis Spreadsheet

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:- data.xlsx

Reference no: EM13751617

Questions Cloud

Disability culture compared to other cultural identities : How do you think the nature of disability, where disabilities can either be apparent or non-apparent, affects America's disability culture compared to other cultural identities Can you think of other non-apparent identities that are similar to dis..
Challenges in the global business environment : According to the textbook, ongoing challenges in the global business environment are mostly attributed to unethical business practices, failure to embrace technology advancements, and stiff competition among businesses. Use the Internet to researc..
Determine the range of meaning for bible and james : determine the range of meaning for Bible and James. List its possible meaning with each possible meaning list all the verses that all the verses that correspond to that meaning.
Iinterpersonal communication skills : Iinterpersonal communication skills and effective project management that helped me thrive in the workplace.
Create a graph or chart that compares the data : Create a graph or chart that compares the data in a meaningful way, i.e. compare regions by month, compare products by month
Which function do you believe managers use most often : Describe that experience to your classmates using research support from the text or another viable source (you may not use Wikipedia). Which function do you believe managers use most often. What could have made the leadership function a better exper..
Role of social media in commerce in a future job interview : Write a two-paragraph summary of this exercise that you could use to demonstrate your knowledge of the role of social media in commerce in a future job interview
How was freedom defined in the spanish colonies : How was freedom defined in the spanish colonies? How was it defined in the british colonies?what liberties were extended and to whom?
Analyzed and discussed the external forces : Analyzed and discussed the external forces and industry conditions that have impacted TEOCO's performance over the years. Analyzed and discussed how the internal organization and culture at TEOCO influenced its performance.

Reviews

Write a Review

 

Finance Basics Questions & Answers

  Arithmetic average versus geometric average

Discuss and explain the difference between arithmetic average versus geometric average and which one is more effective or provides a more complete picture when valuing a stock's past performance over the last 5 years?

  Explains how a specific small, powerful, portable computer

Develop a PowerPoint presentation of 6-8 slides that explains how a specific small, powerful, portable computer that you can find available for purchase on the Internet can be fully leveraged by a corporate Sales and Marketing Team in pursuit of its ..

  Terminal value plays an important role in enterprise

Terminal Value plays an important role in enterprise valuation. What factors affect the estimate of Terminal Value? How sensitive enterprise valuation is to Terminal value?

  Abc electronics is considering an investment that will have

abc electronics is considering an investment that will have cash flows of 16000 5000 and 4000 for years 1 through 3.

  The xyz company is a new company that operates furniture

analyze a ventures performancethe xyz company is a new company that operates furniture stores in the u.s. its sales

  Debt-equity ratio

ABC Company has net income of $90,182, return on assets of 9.4 percent, and debt-equity ratio of 0.53. What is the return on equity?

  Which project should be accepted

Boston Chicken is considering two mutually exclusive projects with the following cash flows. What is the crossover rate? If the required rate of return is lower than the crossover rate, which project should be accepted?

  Determining the yield to maturity of the bond

Question: What is the yield to maturity of the bond? Note: Please provide step by step solution.

  Recommend two 2 uses of a tax shield that can improve

tax shields please respond to the followingrecommend two 2 uses of a tax shield that can improve return on the equity

  Disadvantages of utilizing debt in a firm capital structure

What are the major advantages and disadvantages of utilizing debt in a firm's capital structure (the proportion/mix of debt and equity in balance sheet)?

  What is the effective cost of borrowing

What is the penalty that must be paid if the balance of the loan is repaid after making payments for three years?

  Compare the advantages of competitive bidding for a

compare the advantages of competitive bidding for a general contractor with negotiated cost plus fee. what is the

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