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

  Review problem on the internal revenue service

Ms. Walker was a permanent clerk typist in the Internal Revenue Service's Atlanta office. Ms. Walker is a light-skinned black person.

  Encourage a college graduate in your area

Housing prices in many parts of the United States are falling. What is the situation where you live? Would you encourage a college graduate in your area to buy a home or rent?

  Give the extensive and strategic forms of the game

Players 1 and 2 must decide whether or not to carry an umbrella when leaving home. They know that there is a 50-50 chance of rain.

  Describe the campaign and identify the goal of the campaign.

Describe the campaign and identify the goal of the campaign.

  Why are stereotypes often inaccurate

Why and how do tourists develop and/or resort to stereotypes while traveling away from their home environment? Why are stereotypes often inaccurate?

  Appear to be a straightforward set of calculations

Although budgeting may appear to be a straightforward set of calculations, there are still many areas in the budgetary process where unethical practices may occur.

  Influencing the field of productivity

Identify and explain a current trend that is influencing the field of productivity. Provide a specific example of how it is impacting productivity. Use the internet and share a website that supports your example.Thinking ahead five years, will this s..

  Comprehensive overview of the concept of ethnocentrism

Provide a comprehensive overview of the concept of ethnocentrism. Use your cultural experience of watching the selected movie or TV show to discuss the effect of ethnocentrism on individuals and societies

  Outside of the federal system there is no single standard

write 400-600 words that respond to the following questions with your thoughts ideas and comments. be substantive and

  Explain briefly the matrix approach to structure

Explain briefly the matrix approach to structure and it's application to both domestic and international organisations.

  Talent-related risks on your business and future capabilitie

How can you determine the impact of specific talent-related risks on your business and future capabilities?

  How many barrels are left over

How many barrels of each type of paint should they produce in order to maximize their profit, what is that maximized profit, how many man-minutes are left over in each department, and how many barrels are left over? Report your answer in Excel

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