Find the best estimates for the linear trend line

Assignment Help Operation Management

Reference no: EM131803150

Vandelay Industries manufactures sailboats. Actual demand for their sailboats for each season over the past four years was as follows:

	YEAR
SEASON	1	2	3	4
Winter	1,400	1,200	1,000	900
Spring	1,500	1,400	1,600	1,500
Summer	1,000	2,100	2,000	1,900
Fall	600	750	650	500

Complete all parts of this problem in Excel. Clearly identify the responses to each part of the question.

a. Enter the necessary data and formulas for this problem into a spreadsheet.

b. Use Excel Solver to find the best estimates for the linear trend line and the seasonal indices for this data. Provide a screenshot (or Snipping Tool capture) of the Solver Dialog Box.

c. Use your estimates of the linear trend line and the seasonal factors to determine a forecast for sailboat demand for every season of the next year (Year 5).

Reference no: EM131803150

Questions Cloud

Why is the reporting of investments and fair value required : Why is the reporting of investments and fair value required, and what information is disclosed about Starbucks' investments and fair value reporting?

What controls are missing and what could be done to prevent : What controls are missing and what could be done to prevent, the person would cash the check, keep $200 and pay Art $1,000

What is the value of risk management : What is the value of risk management? Consider how you would pitch good risk management practices to your manager.

Define marketing and outline steps in the marketing process : This module provides an introduction to the basic concepts of marketing. The premise is that marketing is the delivery of customer value at a profit.

Find the best estimates for the linear trend line : Use Excel Solver to find the best estimates for the linear trend line and the seasonal indices for this data. Provide a screenshot of the Solver Dialog Box.

Historical cost-cash paid plus the current dollar : Requires assets to be recorded at historical cost-cash paid plus the current dollar value of all none cash considerations given on the date of the exchange.

What is the correct amount of lease expense : What is the correct amount of lease expense for 2017

Represent claim and comfort with gaap : Is an examination of the financial reports to ensure that they represent claim and comfort with GAAP.

Discuss magazine subscriptions revenue : Magazine subscriptions revenue: Most magazine publishers sell subscriptions for future delivery of the magazine.

User Account

All Pages