Plot the monthly data on a sheet of graph paper

Assignment Help Finance Basics
Reference no: EM131821675

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

239_MS.png

a. Plot the monthly data on a sheet of graph paper.

b. Compute the sales forecast for July using the following approaches:

(1) a four-month moving average;

(2) a weighted three-month moving average using .50 for June, .30 for May and .20 for April;

(3) a linear trend equation

(4) exponential smoothing with α (smoothing constant) equal to .40, assuming a February forecast of 18,000

c. Which method do you think is the least appropriate? Why?

Reference no: EM131821675

Questions Cloud

Prepare a balance sheet in good form, : Prepare a balance sheet in good form, adjusting the amounts in each balance sheet classification as affected by the information given above
What is the matching principle : What is the matching principle? Explain and detail what methods of accounting and what types of assets most easily conform to the matching principle.
Please assist with response to discussion comment : The arguments that constituted the just war as far as Americans really did not have any conflict or interest in the war its was the Vietnam people.
Journalize all september entries using the allowance method : Journalize all September entries using the allowance method. Uncollectible-account expense was estimated at 2% of credit sales.
Plot the monthly data on a sheet of graph paper : Compute the sales forecast for July using the following approaches: (1) a four-month moving average; (2) a weighted three-month moving average.
Customers to gather requirements for the projects : Also, she conducts all analysis for the project team and makes recommendations to the team on the approach they should consider.
Create and define roles and responsibilities : Create and define roles and responsibilities. Discuss current incident response process within Limetree Inc., including current shortcomings
Compare and contrast the areas of risk analysis : Compare and contrast the areas of risk analysis which would be similar to both projects as well as the areas which will be different?
How concept of interest might impact decision making : Discuss the concept of interest and how it might impact decision making? Use a detailed example to explain this concept.

Reviews

Write a Review

Finance Basics Questions & Answers

  What are the differences between the operating income capita

What are the differences between the operating income, capital gains income, and dividend income of a corporation: At approximately what rates are these different types of income taxed?

  Should any other variables have been included

In a mass-transfer spray column, a liquid is sprayed into a gas stream, and mass is transferred between the liquid and gas phases.- Arrange these variables in dimensionless groups. Should any other variables have been included?

  Respiratory system which was most fascinating

Select any concept from the respiratory system which was most fascinating to you and present to your classmates.

  What is the price of the bond using a semiannual convention

Wesley Company will issue a zero-coupon bond this coming month. The projected yield for the bond is 5%. If the par value of the bond is $1,000, what is the price of the bond using a semiannual convention if a. The maturity is 20 years? b. The maturit..

  Discussion on present value-based accounting measurements

How do the concepts of present and future value help us make the kinds of decisions we must make to plan retirement - Assume that you will retire 30 years from today's date. How would concepts of time value help you understand how much to save for..

  What is xigo cost of debt

What is XiGo's cost of debt? [Hint: is XiGo's cost of debt the promised rate of return or the expected rate of return to the debt holder?]

  Abnormal earnings growth valuation and target prices

The following forecast of earnings per share and dividend per share were made at the end of 2006, The company has an equity cost of capital of 12% per annum.

  Calculate the ratios given for disney

[Ratio calculations; CFA.C, adapted] Calculate the ratios below for Disney at September 30. 2000 (use ending balance sheet amounts).

  What should the price of portage bay''s stock be

Portage Bay Enterprises has $1 million in excess cash, no debt and is expected to have free cash flow of $10 million next year. Its FCF is then expected to grow at a rate of 3% per year forever. If Portage Bay's equity cost of capital is 11% and it h..

  What rate of return does your loan earn

(Solving for r of an annuity) You lend a friend $30,000, which your friend will repay in five equal annual end-of-year payments of $10,000.

  Inventory and cost of goods sold and journal entries

Inventory and cost of goods sold and journal entries - Prepare the sales portion of the entry for this sale on Randy's books. and Prepare the cost of sales portion of the entry for this sale on Randy's books.

  Raising organisational profit and productivity

Evaluate the effectiveness of different HRM practices in terms of raising organisational profit and productivity

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