Would edi pay for itself within the first 5 years

Assignment Help Management Information Sys

Reference no: EM131189544

Problem Set 1 Information and Forecasting

1. Mike McNeely, logistics manager for the Illumination Light Company, has considered replacing the firm's manual customer order management system with electronic ordering, an EDI application. He estimates the current system, including labor, costs $2.50/order for transmission and processing when annual order volume is under 25,000. Should the order volume equal or exceed 25,000 in any given year, Mr. McNeely will have to hire an additional customer service representative to assist order reception in the manual process. This would raise the variable cost to $3.00/order. He has also estimated the rate of errors in order placement and transfer to be 12/1000 orders.

EDI would cost $100,000 upfront to implement and variable costs are determined to be $.50/order regardless of volume. EDI could acquire and maintain order information with an error rate of 3/1000 orders. An EDI specialist would be required to maintain the system at all times as well. Her salary is $38,000 in the first year and increases 3 percent each year thereafter.

Order errors cost $5.00 per occurrence on average to correct in the manual system. EDI errors cost $8.00 on average to correct since the specialist inspects the system for flaws on most occasions.

a. If the firm expects order volume over the next 5 years to be 20,000, 22,000, 25,000, 30,000, and 36,000 annually, would EDI pay for itself within the first 5 years?

b. What Effects Aside From Cost Might Mr. Mcneely Consider When Implementing Edi?

2. Mr. McNeely currently batches orders for processing under the manual order management system. The orders are batched for daily processing. If Mr. McNeely opts to implement EDI, might this affect his current means of order processing? If so, how?

3. Quality Marketing Technologies, Inc., has hired you as a sales representative. You have been asked to call on Quikee Stop, a small convenience store chain with five locations in your region. What benefits of UQPC and bar coding applications might you illustrate to encourage Quikee Stop to utilize these technologies to track sales at its retail outlets?

4. Comfortwear Hosiery, Inc., produces men's socks at its manufacturing facility in Topeka, Kansas. The socks are stored in a warehouse near the factory prior to distribution to DC locations in Los Angeles, Memphis, and Dayton. The warehouse uses a top-down forecasting approach when determining the expected quantities demanded at each DC.

The aggregate monthly forecast for June is 12,000 pairs of socks. Historically, the Los Angeles DC has demanded 25 percent of the warehouse's stock. Memphis and Dayton have demanded 30 percent and 35 percent, respectively. The remaining 10 percent is shipped directly from the warehouse.

a. Based on the aggregate forecast, how many pairs of socks should you expect each DC to demand in June?

b. Suppose the aggregate forecast for July results in a 6 percent increase over June's forecast. How many pairs of socks would each DC anticipate in July?

5. Ms. Kathleen Boyd, director of logistics for the Scenic Calendar Company, wishes to evaluate two methods of time series forecasting. She has collected quarterly calendar sales data from the years 2003 and 2004.

2003		2004
Qtr.	Actual Sales	Qtr.	Actual Sales
1	1200	1	1300
2	800	2	800
3	200	3	250
4	1000	4	1200

a. Use the moving averages technique to find forecasted sales for the third quarter of 2004 based on actual sales from the previous 3 quarters.

b. Use simple exponential smoothing to forecast each quarter's sales in 2004, given that Ms. Boyd qualitatively forecasted 900 calendars for quarter 4, 2003. Ms. Boyd has assigned an alpha factor of .1 for time series sensitivity.

c. Repeat the simple exponential smoothing problem above (part 5b) with Ms. Boyd employing an alpha factor of .2.

d. How well do the moving averages and simple exponential smoothing techniques seem to work in Ms. Boyd's situation? In what ways do the techniques appear to fail?

6. Michael Gregory, logistics manager of Muscle Man Fitness Equipment, has determined that his current forecast system for national sales has historically shown a 20 percent error rate. Due to this level of error, Muscle Man's DC managers maintain inventory at their locations costing the company, on average, $3,000 per month.

By improving his forecast methodology and shortening forecast horizons, Mr. Gregory anticipates cutting the error level down to 12 percent. With improved forecasting, Muscle Man's DC managers have indicated that they feel comfortable with lower inventory levels. Mr. Gregory anticipates monthly inventory carrying cost reductions of 40 percent.

a. If the forecast system improvement will cost $1,000 more per month than the old system, should Mr. Gregory implement the change?

b. Why might Muscle Man's customers encourage the firm to improve its forecasting capabilities?

Reference no: EM131189544

Questions Cloud

Identify and describe social psychological phenomena : Describe the major adjustment issues discussed in each story. Examine at least three (3) evidence-based strategies from each of the selected articles that could help the individuals in each article enhance their adjustment skills.

International businesses based in great britain : Describe the shifts in the world economy over the past 30 years. What are the implications of these shifts for international businesses based in Great Britain? North America Hong Kong?

Context of information technology : Can you think of any situations in the context of Information Technology where whistle-blowing would not be justified?

Discuss the long-run equilibrium of the taxi industry : MAE101 Economic Principles Individual Written Assignment. Using diagrams, illustrate and discuss the long-run equilibrium of the taxi industry and individual monopolistic competitive taxi companies before and after the introduction of UberX

Would edi pay for itself within the first 5 years : Would EDI pay for itself within the first 5 years?- What Effects Aside From Cost Might Mr. Mcneely Consider When Implementing Edi?

What might be some potentially undesirable consequences : Should the health-care industry become more like a competitive free market? Do you think that it would help bring costs down? How might such a change come about? What might be some potentially undesirable consequences?

Competition for survival among banks heats : "As the competition for survival among banks heats up across Africa, the continent remains the keyto Standard Bank's growth strategy, joint CEOs Ben Kruger and Sim Tshabalala said last week" With reference to statement, utilise relevant theory to ..

What is the lowest price firms will sell their goods : What is the lowest price firms will sell their goods at in the long run? In other words, what is the long-run industry supply curve? Explain - In this context, would Susan be better off if the government simply gives her cash (which she can spend ..

Explain whether you felt this test minimized cultural bias : Discuss possible limitations with interpretation of your results within the context of what you have learned about psychometric test properties. How would you explain the reliability and validity of this test to someone who has not taken this cours..

User Account

All Pages