Business of manufacturing cast and stamped steel products

Assignment Help Business Economics

Reference no: EM131091587

Nemo Corp. is in the business of manufacturing cast and stamped steel products for the automotive industry. Steel ingots are purchased from the steel mills. For casted products, steel ingots have to be melted and cast. For stamped products, steel ingots have to be extruded into metal sheets and stamped. Nemo Corp. has no decision support tool in place to make the forecasting decisions for steel purchases. You are hired as a consultant to develop a decision support tool for them. Your first task is to choose a forecasting method for the company to determine the steel ingot purchases from the steel mills. The company has supplied you with the following quarterly demand data for the cast and stamped steel products in tons.

a) Plot the demand for the cast steel products and the stamped steel products separately (on a graph using excel) and comment on the trends you observe.

b) Forecast the total steel demand using the method of Moving averages where n is equal to 6 (Hint: when n=6, the first forecast should appear at the 7th data point, which is in Q3 of year 2). Compute MAD, MSE and MAPE.

c) Forecast the total steel demand using the Exponential Smoothing method where the smoothing constant is 0.15. (Hint: The first forecast should appear at the 2nd data point, which is in Q2 of year 1). Compute MAD, MSE and MAPE.

Reference no: EM131091587

Questions Cloud

What is quantity demanded and quantity supplied of cars : Consider the market for cars in a small country. Suppose the demand and supply curves for cars have been estimated and are given by. Suppose the prevailing price is the (free-trade) world price pF T = 4.5. At this price, what is the quantity demanded..

Why monopoly may operate in the upward : Show, with graphs, why a monopoly may operate in the upward or downward sloping section of its long term average cost curve but a competitive firm operates only in the upward sloping section.

The impact of change in the level of output : Complete the readings and answer the following questions:

Develop the scope portion of the framework : CSC-580 Software Engineering Spring 2016. Zachman Framework: Develop the Scope portion of the Framework: Pay close attention to the What (Data) and How (functions) sections

Business of manufacturing cast and stamped steel products : Nemo Corp. is in the business of manufacturing cast and stamped steel products for the automotive industry. Steel ingots are purchased from the steel mills. For casted products, steel ingots have to be melted and cast. For stamped products, steel ing..

Compute marginal revenue and total revenue : A publisher with a geographic monopoly faces the following demand schedule for the next novel from one of its authors: the author is paid $2,000,000 to write the book, and the marginal cost of publishing the book is a constant $10 per book. Compute t..

Describe the various levels of software testing : Describe the various levels of Software testing and draw a diagram

Sentencing in the united states : This assignment, an Article Review, will assist you in thinking critically about sentencing in the United States. To begin this assignment, please access the CSU Online Library and select an article. This article should be from a professional or s..

Determine the value of the gain k : Determine the value of the gain K so that the damping ratio ζ of the closed-loop system is equal to 0.5. Then determine also the undamped natural frequency ωn of the closed-loop system. Assuming that e(0)=1 and (0)=1 evaluate

User Account

All Pages