Plot the monthly data on a sheet of graph paper

Assignment Help Business Management
Reference no: EM131408023

Ms. Winnie Lin's company sells computers. Monthly sales for a six-month period are as follows:

Jan 18,000

Feb 22,000

Mar 16,000

Apr 18,000

May 20,000

Jun 24,000

  • Plot the monthly data on a sheet of graph paper.
  • Compute the sales forecast for July using the following approaches:  1) a three-month moving average;  2) a weighted three month moving average using  .50 for June,  .30 for May, and .20 for April;  3) a liner trend equation; 4) exponential smoothing with a (smoothing constant) equal to .40, assuming a February forecast of 18,000.
  • Which method do you think is the least appropriate? Why?
  • Calculate the MAD for each of the four techniques in part b.  Which is the best? Why?

Reference no: EM131408023

Questions Cloud

Prepare entry to record the reissuance of the treasury stock : If Tracey Corporation did not declare or pay any dividends during 2010, and again assuming a net income during 2011 of $2 million, compute the amount declared as dividends to common stockholders during 2011.
Business analysis using excel : Is there anyone willing to log onto a website to take an online 'business analysis using excel' test?
Create an apa-style list of references : Using the online sources that your found for part 1, create an APA-style list of references and an MLA-style works-cited list from your collective online sources.
Benefits of higher education and academic integrity : A discussion of the benefits of higher education and a reflection on academic integrity and why students should uphold university standa
Plot the monthly data on a sheet of graph paper : Plot the monthly data on a sheet of graph paper. Compute the sales forecast for July using the following approaches:  1) a three-month moving average;  2) a weighted three month moving average using  .50 for June,  .30 for May, and .20 for April;  ..
What effect would option 3 have on the financial statements : Prepare the journal entries for Options 1 and 2, and comment on why these alternatives may not be attractive. Why do companies issue stock dividends?
What is the effect of feedback resistance on output voltage : The purpose of this lab is to allow students to gain experience constructing Digital to Analog Converters in Multisim. Students will extend the concepts learned in the module and homework to build an 8-Bit DAC. Several binary inputs and the associ..
Replaced the cold war system : Is globalization the dominant international system that has replaced the Cold War system? What are its unique characteristics?
Explain the three frequency distributions : Below you see the SPSS-output from the Frequency-command. The first table shows univariate frequency distributions from each country. The three graphs are histograms for each country. We want you to explain the three frequency distributions and th..

Reviews

Write a Review

Business Management Questions & Answers

  Management models - autocratic

Management Models: Autocratic, centralized vs decentralized, informal vs formal

  What are the key elements that provide the historic context

What are the key elements that provide the historic context to the study?  - How does the research literature create or support that historic context?

  Create an e-r crows foot data model for a real estate firm

Create an E-R Crow's Foot data model for a real estate firm that lists property for sale. Specifically, identify and specify each entity type, attribute, and relationship on your diagram.

  Prepare the chief human resources

Summary. The purpose of this section is to prepare the chief human resources officer for entering the arena of this particular negotiation. Be sure to:

  Create a detailed physical ability test plan

Select a job that requires a moderate level of physical ability, such as security staff, office delivery personnel, door-to-door salespersons, retail salesperson, or nurses at hospitals and conduct an interview to determine their level of physical..

  Summarize findings by creating a written report

As Vice President of Marketing you ask to encounter with your Marketing Director of Consumer Products in order to gather more information. After your meeting you will want to summarize

  Summarize the article the criminality of wall street

Summarize the article The Criminality of Wall Street by Tabb and William K. Monthly. In a double-spaced document, briefly explain the author's purpose for writing the article.

  Explain the role of the female expatriate

Explain the role of the female expatriate. Investigate reasons why they may not be selected for international assignments. What can multinational companies do to help them succeed?

  What happens when the exchange rate of the domestic economy

The industry pledges to increase its dividend by 6.00 percent per year indefinitely. If you require an 15.00 percent return on your investment, explain how much will you pay for the industry's stock today?

  Less tax revenue

A self-employed commercial artist reports taxable income of $7,000. In reality, her income is considerably higher however much of it takes the form of cash for small projects and thus is easy to conceal

  Quantitative and qualitative factors for decision

What quantitative and qualitative factors are relevant for his decision? Why?

  Define supply chain management

Define Supply Chain Management and its role in a company's ability to compete effectively in the market.

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