Determine fourth-quarter potential sales

Assignment Help Financial Management
Reference no: EM132058039

Resources:

Microsoft® Office Help and Training

Other tutorials available online

Video: "Excel 2016 Essential Training"

Read the following business scenario:

Your company has asked you to create a spreadsheet to analyze the following data. The data will be reviewed for top salespeople bonuses and commissions payments based on individual sales. Averages will be used to analyze month-over-month sales throughout the years.

Use the Sales Analysis Microsoft® Excel® spreadsheet and apply formatting to accomplish the following:

Calculate total sales using the SUM function.

Calculate total sales for each quarter. (March, June, and September each represent a quarter.). A quarter is three months.

Calculate average sales for each quarter to help determine 4th-quarter potential sales.

Highlight the top salesperson in each quarter.

Generate a Microsoft® Excel® chart or graph that displays the total sales by region to identify the highest and lowest selling regions. This chart should display the TOTAL sales (i.e., the sales for the complete year), per region.

These "Total Sales" must include the fourth quarter as well, which you forecast as indicated above.

Reference no: EM132058039

Questions Cloud

Examine practicality of building multiple interface options : Examine the practicality of building multiple interface options for diverse populations, rather than building one (1) interface that meets the needs.
Calculate the amount of phosphoric acid : Calculate the amount of phosphoric acid, in moles, that is in 50.3 mL of a 4.62 mol/L phosphoric acid solution.
Calculate vendal maximum depreciation deduction : Vendal Corporation purchased and placed into service $2,300,000 of new office furniture, Calculate Vendal's maximum depreciation deduction for 2015
How much of their social security is taxable : Municipal Bond interest from City of Waterville of $ 1,000, and Social Security of $ 16,000. How much of their social security is taxable in 2014
Determine fourth-quarter potential sales : Calculate average sales for each quarter to help determine 4th-quarter potential sales.
What is her adjusted gross income : Ordinary dividends 600; cash prize awarded in a contest of 200; tuition scholarship 2500. What is her adjusted gross income for 2014
What mass of tsp is needed to make l of solution : The recommended concentration is 1.7% W/V. What mass of TSP is needed to make 3.0 L of solution?
Explain the end-to-end process of how voip works : In order to complete assignment you will need to answer the below questions. Please complete the questions in a Word document and then upload the assignment.
New anaesthetic solution : 23.0 mL of anaesthetic is added to distilled water to make a 200 mL solution. What is the % V/V of the new anaesthetic solution?

Reviews

Write a Review

Financial Management Questions & Answers

  Foreign company acquisition

Acquisition by a foreign company and the effects of that decision and the results of foreign exchange in Euro and the exchange rate differences.

  Financial management for profit and non profit organizations

In this essay, we are going to discuss the issues of financial management in a non-profit organisation.

  Method for estimating a venture''s value

Evaluate venture's present value, cash and surplus cash and basic venture capital.

  Replacement analysis

This document show the Replacement Analysis of modling machine. Is replacement give profit to company or not?

  Business finance task - capital budgeting

Your company is considering using the payback period for capital-budgeting. Discuss the advantages and disadvantages of this technique.

  Analysis of the investment

In this project, you will focus on one of these: the additional cost resulting from the purchase of an apple press (a piece of equipment required to manufacture apple juice).

  Conduct a what-if analysis

Review the readings and media for this unit, including the Anthony's Orchard case study media. Familiarise yourself with the Anthony's Orchard company and its current situation.

  Determine operational expenditures

Organisations' behaviour is guided by financial data. In the short term, such data will help determine operational expenditures; in the long term, historical data may help generate forecasts aimed at determining strategic plans. In both instances.

  Personal financial management

How much will you have left over each half year if you adopt the latter course of action?

  Sources of finance for expansion into new foreign markets

A quoted company is considering several long-term sources of finance for expansion into new foreign markets.

  Long term financial planning

This assignment is designed for analyze Long term financial planning begins with the sales forecast and the key input in the long term fincial planning.

  Explain the role of fincial manager

This assignment explain the role of fincial manager, function of manger. And what are the motives of financial manager.

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