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

Reviews

Write a Review

Business Economics Questions & Answers

  Automatic stabilizers change the federal budget balance

If Automatic stabilizers change the federal budget balance by $70 billion for every 1 percent change in real GDP growth, what will happen to the federal budget balance if the economy falls into a recession of -3 percent from a growth path of +2 perce..

  Minimum amount that you must charge to break even on cost

You are a newspaper publisher. You are in the middle of a one-year rental contract for your factory that requires you to pay $500,000 per month, and you have contractual labor obligations of $1 million per month that you can’t get out of. You also ha..

  What is the bond yield rate per period

A bond has a face (par) value of $17,492; it will mature in 5 years. The bond coupon rate is 1.50%; there are 11 premium payments per year. If the bond is purchased for 96.99% of its face value and later sold at its face value, what is the bond yield..

  As the percentage of the consumers income accounted

As the percentage of the consumer's income accounted for by a particular good decreases, demand for the good will:

  What should the firm do to improve its performance

Consider a firm using labor and capital as its only inputs. The price of capital is $40 where the price of labor (wage) is $60. Using 500 units of labor and 500 units of capital the firm is producing 1200 units of output. At this mix of input the fir..

  What farms to produce more or less corn and in econmic

Assume that being sustitutes for one another, corn and soybean require the same raw material such as land, will farmers use their soybean farms to produce more or less corn and in econmic.

  What is the present worth of this alternative

What is the present worth of this alternative? What is the annual cost of this alternative? What would its present worth be if its life was shortened to 25 years in order to compare it to another alternative of that length?

  Advocated for greater liberalization in international trade

Why do some people and some countries advocated for a greater liberalization in international trade, meanwhile, some have favored more protectionism? Please apply both society-centered and state-centered approaches to support your argument.

  Create the perfect society

If you could create the "perfect" society that protects its citizens yet fosters personal growth and help them be productive, what will it look like? For this paper design your own society based on the above ideas and explain why you think it is the ..

  Main causes of the companys misfortunes

Eastman Kodak filed for a bankruptcy in January 2012. Using our analytical framework of nine areas of interest introduced in class explain the main causes of the company's misfortunes.

  About successful exporting can be derived from vellus case

Why does Vellus export through local distributors rather than set up its own sales force in country? What are the risks associated with using local distributors? How can these risks be reduced? What lessons about successful exporting can be derived f..

  Demand curve for a specific product is constructed

Illustrate what is being held constant when a demand curve for a specific product is constructed.

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