Question: Consider the demand for trading cards as listed below. Month January February March April May June July August September Demand 47,000 42,000 53,000 62,000 76,000

Consider the demand for trading cards as listed

Consider the demand for trading cards as listed below. Month January February March April May June July August September Demand 47,000 42,000 53,000 62,000 76,000 71,000 78,000 93,000 97,000 Use Excel to prepare a forecast for October, November, and December using linear regression. Please show the slope and the intercept of the linear regression model. a) The slope is (round your response to two decimal places). b) The intercept is (round your response to two decimal places). c) The forecast demand for October is (round your response to the nearest integer). d) The forecast demand for November is (round your response to the nearest integer). e) The forecast demand for December is (round your response to the nearest integer)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

The state diagram for a sequential circuit appears in Figure 4-51. Figure 4-51 (a) Find the state table for the circuit. (b) Make a state assignment for the circuit using 3-bit codes for the six...

Present an analysis on a business' profit, cost and revene. Does the company have any particular challenges? From a financial perspective? If yes - please show them and make suggestions on how to...

Census Education Data Not a High High School Some College Associate's Bachelor's School Grad Graduate No Degree Degree Degree 29,620,292 58,207,318 29,620,292 12,915,825 28,242,604 Total Persons Age...

1. What is the average annual (historic) return on the hedge fund? Remember the reported returns are monthly. Multiply by 12 to get annual returns. 1 Round to three decimals. 1 This is an...

\fDemand Prediction Models Linear Model a b 20,000 10 Price Demand $80.00 $19,200 $90.00 $19,100 $100.00 $19,000 $110.00 $18,900 $120.00 $18,800 Nonlinear Model c d Price $70.00 $80.00 $90.00 $100.00...

Please help with assignment 2 MAC2601. assignment attched MAC2601/103/1/2016 Tutorial letter 103/1/2016 Principles of Management Accounting MAC2601 Semester 1 Department of Management Accounting...

You are the Director of Supply Chain Management for Rencor Manufacturing in Tucson, Arizona. Rencor supplies a key component for automobile interiors to U.S. assembly plants across the country. The...

The following expenditures relating to plant assets were made by Prather Company during the first 2 months of 2014. 1. Paid $5,000 of accrued taxes at time plant site was acquired. 2. Paid $200...

Prepare the history of SAP, Including the Introduction, Discussion, and Conclusion.

A call provision, which allows the corporation to force an early maturity on a bond issue, usually contains all but which of the following characteristics? A . Most bonds must be outstanding at least...

Make versus buy (LO1, LO2, LO3). Sakura is a part-time artist who produces exquisite Japanese calligraphy prints on rice paper. Sakura typically makes 50 prints per month and sells most of the prints...