What is the annual demand of engines

Reference no: EM13691046

The manager of a Cummings engine manufacturing facility has collected some historical data on the monthly demand of hemi-diesel engines (See table 1)

Table 1 Period Monthly Demand January 240 February 150 March 350 April 297 May 497 June 566 July 200 August 450 September 300 October 240 November 300 December 350

The unit cost of an engine is $3000 and there is a 30% interest rate associated with the holding cost. It takes 6 weeks for a replenishment order to be placed. Every time the facility has to setup to make these engines the manager estimates a setup cost of around $250,000. The cost of backorders is about $150,000 per year and the manager is worried about this figure. Demand seems to be normally distributed and the manager would like to determine the following:

What is the annual demand of engines?

What is the economic order quantity?

What is the average demand of engines over the six week period for replenishment?

What is the standard deviation of the sample in table 1 (use the STDEV.S function in excel)

Determine the critical fractile of backorder cost. Use the following formula to determine this G(r^* )= b/(b+h)

What the z score of this critical fractile (Hint use the NORMSINV function in excel)

What is the reorder point?

Reference no: EM13691046

Questions Cloud

Component of trend analysis : Which of the following is not a component of trend analysis?

Broad category of forecasting techniques : Which of the following is not a broad category of forecasting techniques:

Price changes problem : "If price changes by 20 percent and quantity changes by 10 percent, demand is:"

Total costs are divided between fixed : "In the short-run, total costs (TC) are divided between fixed and:"

What is the annual demand of engines : The manager of a Cummings engine manufacturing facility has collected some historical data on the monthly demand of hemi-diesel engines (See table 1) What is the annual demand of engines?

Process of buying or selling stocks on the nyse : Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 ..

Correlation between income levels-standardized test scores : Normal 0 false false false EN-US X-NONE X-NONE MicrosoftInternetExplorer4 ..

User Account

All Pages