Develop a linear trend line for the data

Assignment Help Business Management
Reference no: EM133041051

Problem: Mop and Broom Manufacturing has tracked the number of units sold of their most popular mop over the past 24 months. This is shown.

Month

Sales

Month

Sales

Month

Sales

1

239

9

313

17

373

2

254

10

331

18

370

3

264

11

343

19

367

4

266

12

348

20

387

5

264

13

348

21

393

6

281

14

377

22

390

7

404

15

377

23

398

8

301

16

365

24

417

  1. Develop a linear trend line for the data. (Round your answers to 2 decimal places, e.g.,25.28.)
    Sales = ______________  + ______________________  (month)
  2. Compute a correlation coefficient for the data and evaluate the strength of the linear relationship. (Round your answer to 2 decimal places, the tolerance is +/-0.01.)
    Correlation coefficient is __________________ . It indicates ___________ linear relationship. (Use not rounded amounts to answer this question.
  • Using the linear trend line equation, develop a forecast for the next period,month 25. (Round your answer to 2 decimal places, the tolerance is +/-0.01. Do not round intermediate results used to achieve this answer.)
    Forecast for month 25 = __________________________________

Reference no: EM133041051

Questions Cloud

Case study-burger lover restaurant : Based on historical observations over the past five weeks, make a forecast for the next period using the following methods: simple average
What is the net present value of the investment : The investor's discount rate, for an alternative safe investment, is 10.41 percent after tax. What is the net present value of the investment
Evaluate the performance of the three methods : A company has used three different methods to forecast sales for the past five months.
What the amount of liabilities reported on the end-of-period : Assets = $23,000; Liabilities = ?; Common Stock = $5,300; Revenue = $11,600; What the amount of liabilities reported on the end-of-period balance sheet
Develop a linear trend line for the data : Problem: Mop and Broom Manufacturing has tracked the number of units sold of their most popular mop over the past 24 months. This is shown.
Determine the ending inventory cost using FIFO : There are 30 units of the item in the physical inventory at December 31. The periodic inventory system is used. Determine the ending inventory cost using FIFO
What is the maximum CCA deduction for the current year : BBD Company has the following information related to class 10 assets for the current? year: Beginning? Balance: $166,865, What is the maximum CCA deduction
What are the four methods of ethical reasoning : What are the four methods of ethical reasoning? Discuss the limitations of each of the four methods.
Strategy and strategic management process : Describe the strategy and the strategic management process.

Reviews

Write a Review

Business Management Questions & Answers

  Changes at the operational level

When senior managers resist change at the strategic level, they are in a position to cause more damage than employees resisting changes at the operational level.

  Highly regarded international economic advisor

Suppose you are a highly regarded international economic advisor. You have been asked to assess thepossibilities of growth in an African country. It is a country abundant in labour and some natural resources.

  Explain key issue in social policy development

1. Identify and explain one key issue in Social Policy development, as it applies to community services. What are some ways that this can be challenged?

  Describe why you would support or dispute the conclusion

In 250 to 300 words, describe why you would support or dispute this conclusion. Make sure to reference the points that have been raised in the text when creating your post

  Consumerism means for business

Write an analytic business report on what ethical consumerism means for business. choose one company evidencing how they operate ethically.this must take into account the ethics and values of the company yhou choose to focus on.

  Concepts of the american newspaper

Describe some versions or concepts of the American newspaper, from the Partisan Press through the Penny press to the including Yellow Journalism, Investigative Journalism, and Interpretative journalism?

  How can you help team overcome these challenges

What challenges do you expect the team will face because of its multicultural makeup? How can you help the team overcome these challenges?

  Importance and appropriateness of the information

Importance and appropriateness of the information provided regarding the Volkswagen and Volkswagen's industry (Products/Services, Market/Customers, and Competit

  Why is strategic planning important to the organization

Topic: Analysis & Strategic Planning Why is strategic planning important to the organization? How does strategic planning help the organization?

  Information technology organization

What would a summary on encryption for a Information Technology organization be?

  Business intelligence project for a field or organization

You are working on a business intelligence project for a field or organization of your choice to help make decisions.

  Question related to project communication plango to an

question related to project communication plango to an internet search engine e.g. google and type in project

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