Develop linear regression model and compute forecast

Assignment Help Operation Management
Reference no: EM131117000

1. The historical demand for the Panasonic Model 304 Pencil Sharpener is: January, 160; February, 280; March, 175; April, 295; and May, 190 units.

a. Using a 2-month moving average, what is the forecast for June? If June experienced a demand of 100, what is the forecast for July?

a. Using single exponential smoothing with α = 0.5, if the forecast for January had been 70, compute what the exponential forecast would have been for the remaining months through June.

a. Develop a linear regression model and compute a forecast for June, July, and August.

(You may use any software package of your choice to solve this problem, including Excel or QM, or…….)

Reference no: EM131117000

Questions Cloud

Investment toward improving the club : The third way is to become an equity member, whereby the prospective member pledges a significant investment toward improving the club. Members who have been a member of any type for over twenty years are entitled to senior membership status.
Complete the timing diagram for this counter : When the J and K inputs of a JKFF are tied to logic 1, this device is known as a divide-by-2 counter. Complete the timing diagram shown in Figure P6.1.49 for this counter.
Internal control and end-user computing : The National Commercial Bank has fifteen branches and maintains a mainframe computer system at its cor- porate headquarters.
Describe the analytical use of each of the six ratios : Discuss what the financial ratios presented in the question reveal about how ser. Support your answer by citing specific ratio levels and trends as well as the interrelationships between these ratios.
Develop linear regression model and compute forecast : The historical demand for the Panasonic Model 304 Pencil Sharpener is: January, 160; February, 280; March, 175; April, 295; and May, 190 units. Using a 2-month moving average, what is the forecast for June? If June experienced a demand of 100, what i..
What are the priority nursing diagnoses : What are the priority nursing diagnoses at this time - what are the expected outcome associated with these diagnoses?
Assigned on the basis of direct labor : Overhead is assigned on the basis of direct labor hours at a rate of $11. During August, Job 64 was completed and transferred to Finished Goods. Job 65 was the only unfinished job at the end of the month.
How various functions of hr support strategy of organization : Summarize what you learned from the Learning Resources, Assignments, and Discussion activities throughout the course. Explain how you could apply the course concepts to strengthen the role of Human Resources as a strategic contributor to an organi..
Experts to work on the project from different perspectives : BioTech Research Center is working to develop a new vaccine for the West Nile Virus. The project is so important that the firm has created three teams of experts to work on the project from different perspectives. Team 1 has a 73 percent chance of su..

Reviews

Write a Review

Operation Management Questions & Answers

  About engraving league-team-individual reward plaques

A certain custom engraving shop has traditionally had orders for between 1 and 50 units of whatever a customer orders. Typically, a single worker would work all of the tasks needed for these traditional orders. A large company has contacted this shop..

  Explain how much will this price the co-op per year

The supplier would like to deliver sweatshirts once a week. Explain how much will this price the co-op per yr. Under illustrate what conditions would you agree to the supplier's proposal.

  Improve performance and reduce human errors

You have been appointed to a Manufacturing/Operations Manager position. Your group consist of 120 operators, and 3 supervisors. The workforce is divided in 3 shifts (i.e. 6AM-2PM; 2PM-10PM; 10PM-6AM with 1 supervisor and 40 operators per shift.  You ..

  Sales and operations planning can be integrated

Summarize the ways through which sales and operations planning can be integrated. Then, extend your findings to additional supply chain management processes that you feel could be better integrated. Which two (or more) processes did you integrate? Wh..

  Can julia delete one of the financial alternatives

Can Julia delete one of the financial alternatives also still offer investment choices for both risk seekers also risk avoiders.

  What is the volume of units required per month to break even

A manufacturer is considering adding a new facility to keep up with demand. The location being considered will have fixed costs of $15,000/ month and variable costs of $15/ unit. The selling price will be $25/ unit. What is the volume of units requir..

  Participation of union in the manufacture

Modern Clothing, Inc., and National Denim Corporation use the mark "Made by Members of the U.S. Textile Workers Union" on the tags of their products to indicate the participation of the union in the manufacture. Modern and National are not in busi..

  Discuss the principal reasons why project management

Discuss the principal reasons why project management has become such a popular business tool in recent years.

  Equilibrium quantity and price in market

What are the equilibrium quantity and price in this market?

  Craft a job description for the position you wish to hire

Imagine a business that you would like to start and that it is at the stage of adding one or more employees. In a minimum of 2-3 pages, complete or answer the following- Craft a job description for the position you wish to hire.

  Vacated under the federal arbitration act

Under what circunstances an award could not be vacated under the Federal Arbitration Act? a) Where the arbitrator's ruling is contrary to other rulings in similar cases, b) Where the award itself was acquired through fraud, c) Where evidence was avai..

  Evaluate the financial impact of this strategy

The financial performance of any business depends on a number of factors. Other than the strategy in e-activity, explain in detail how two other factors specific to this MCDonald's might make it difficult to evaluate the financial impact of this s..

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