Reference no: EM131593380
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
Click the Assignment Files tab to submit your assignment.
|
Calculate the break-even point for the project
: Calculate the break-even point for the project and the expected financial returns. This is the work you have been doing in the CVP template
|
|
Write a memo to vickie plato-amortize gains and losses
: (Gains and Losses, Corridor Amortization) Vickie Plato, accounting clerk in the personnel office of Streisand Corp., has begun to compute pension expense.
|
|
Aim for a 5-paragraph essay structure
: In the upper left-hand corner of the paper, place your name, the professor's name, the course name, and the due date for the assignment on consecutive lines.
|
|
How large would the balance be at the end of thirty years
: How large would the balance be at the end of thirty years? Describe how people can identify their federal tax brackets.
|
|
Compares the data in a meaningful way
: Create a graph or chart that compares the data in a meaningful way, i.e. compare regions by month, compare products by month
|
|
Conduct a macro-environment analysis for the entire industry
: Conduct a macro-environment analysis for the entire industry within which the organisation (or SBU) operates. You should use the PESTEL model
|
|
Prevent monopolization of businesses
: Name at least two legislations to prevent monopolization of businesses. Do you believe these legislations have been helpful? Discuss.
|
|
What is the overarching goal of law
: From the law and economics perspective, what is the overarching goal of law? Critique the law and economics perspective from a distinctly evangelical Christian
|
|
Calculate the expected level of demand in a typical market
: Calculate the expected level of demand in a typical market and indicate the range within which actual demand is expected to fall with 95% confidence.
|