User Account

All Pages

Determine the projected sales for given month

Assignment Help Management Theories
Reference no: EM131908929

Question: In order to prepare the Chippewa Chocolates (CC) master budget in your ACC 255 class, you will first need to gather and analyze data from the CC company database. Specifically, you need to complete the following tasks:

1. Determine the projected sales for next January.

a. Create a query to report the total SalesAmount by SalesMonth. Save the query as: Task 1 Sales By Month.

b. Copy the results and paste them into a worksheet in Excel. Make sure the data is in calendar order and then use the TREND function to determine the sales for January. Format the answer as currency with 0 decimal places.

c. Rename your worksheet tab to "Task 1".

2. Determine the average monthly sales increase (as a percentage).

a. Using the Excel worksheet from Task 1, copy the data from the first sheet into a new worksheet. Create a column next to the sales data called Monthly Sales Increase (%). Calculate the Monthly Sales Increase (%) as follows:

= (Current Month's Sales - Previous Month's Sales) / Previous Month's Sales

Calculate the values for February through December only. Format the values as percentages with 0 decimal places.

b. Use the AVERAGE function to average the Monthly Sales Increase (%) values.

c. Rename your worksheet tab to "Task 2"

Reference no: EM131908929

Questions Cloud

Why transmission systems have relatively high profit impact : Why do transmission systems have a relatively high profit impact? Contrast this with one or two examples of items needed by an automobile manufacturer.
How many options are needed to create the hedge : A call option is available on the stock and has a delta of 0.2. How many options are needed to create the hedge?
How much will oxford engineerings total profits change : How much will Oxford Engineering's total profits change if they decide to buy the starter assembly from Tidnish Electronics instead of making it themselves?
Describe Vygotsky developmental methods of mental processes : Describe Vygotsky's developmental methods and the context of higher mental processes through the Zone of Proximal Development
Determine the projected sales for given month : In order to prepare the Chippewa Chocolates (CC) master budget in your ACC 255 class, you will first need to gather and analyze data from the CC company.
What quantity of labor to demand : Explan how AT&T determines what quantity of labor to demand and what events could shift the demand and supply of that labor.
Siblings according to ascending annual effective yield rates : Order the siblings according to ascending annual effective yield rates.
What did the practice of foot binding suggest about gender : "Women had for long centuries lived under the strictures of a Confucian society. How did Confucian ideals in the Ming and Qing dyansties affect attitudes.
Present the title of periodicals in headline style : Present the title of periodicals in headline style. When no author is identified, list the source by title.

Reviews

Write a Review

Management Theories Questions & Answers

  Learning in action

Learning contract proposal that will form the basis of your learning contract report.

  Change is the only constant

"Change is the only constant " Evaluate the different types of change that have occurred in Sony.

  How do advertisers try to use group influence

How do advertisers try to use group influence?  Will you find any specific examples and explain the relevant theory of group behavior and influence?

  Case study:saving sony

You have been appointed by Sony as a consultant on change management. Advise Sony on how they could implement the change by using the various theories of change you have learnt.

  How the stock market works

The purpose of this project is to help you to gain an understanding of how the stock market works and of the relationship between theory and practice.

  Find the optimal production quantities

Find not only the optimal production quantities, but also the optimal total cost.

  Describe the management process

Describe the management process and identify the skills required to manage business organizations.

  Case study : bert''s bonsai and aquatic sport museum

Case Study : Bert's Bonsai and Aquatic Sport Museum Prepare a knowledge management system.

  Knowledge management techniques

Demonstrate understanding of the many-sided nature of knowledge management

  Theory of transtheoretical model

Demonstrate understanding of the many-sided nature of knowledge management

  Write a paper on historical trends of management

Write a paper on Historical Trends of Management.

  Theory of reasoned action

Theory of Planned Behavior and Integrated Behaviors Model

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd