Solution-Develop a linear trend line for the data

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

Develop a linear trend line for the data. (Round your answers to 2 decimal places, e.g.,25.28.)
Sales = ______________ + ______________________ (month)
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.

User Account

All Pages

Develop a linear trend line for the data

Reference no: EM133041051

Reference no: EM133041051

Questions Cloud

Reviews

Write a Review

Business Management Questions & Answers

Caselet on michael porter’s value chain management

Mountain man brewing company

Mountain man brewing company

Analysis of the case using the doing ethics technique

Affiliations and partnerships

Innovation-friendly regulations

Effect of regional and corporate cultural issues

Structure of business plan

Identify the purposes of different types of organisations

Entrepreneur case study for analysis

Forecasting and business analysis

Educational instructional leadership

Assured A++ Grade

Academics

Major Subjects

Majors

Get In Touch

TERMS & POLICIES

HELP & SUPPORT