mha506week 6

Problem #2 A & B please Problem #3 A please

9

Sarah has been custom manufacturing sweaters now for 7 years. Her annual sales are shown below. Year Sales 1 178 2 215 3 233 4 301 5 337 6 330 7 361   What are her forecasted sales for year 8 using a 3 year moving average? What are her forecasted sales for year 8 using a 5 year weighted average where w1=.4, w2=.3, w3=.15, w4=.1, w5=.05? What are her forecasted sales for year 8 using exponential smoothing? Assume year 7 forecast was 323. Select your own alpha. Which forecast method is the best for Sarah to use based on MAD? Why?

In an effort to cut costs and improve profits, many U.S. companies have been turning to outsourcing. In fact, according to Purchasing magazine, 54% of companies surveyed outsourced some part of their manufacturing process in the past two to three years. Suppose 560 of these companies are contacted. Appendix A Statistical Tables a. What is the probability that 336 or more companies outsourced some part of their manufacturing process in the past two to three years?b. What is the probability that 287 or more companies outsourced some part of their manufacturing process in the past two to three years?c. What is the probability that 51% or less of these companies outsourced some part of their manufacturing process in the past two to three years?

A small airplane company called Just-in-Time flies between cities in Florida. It is trying to decide whether to add one extra plane to its fleet next year. Passenger demand that last four quarters are as follows: Q1 = 4,403, Q2 = 4,008, Q3 = 3,750, and Q4 = 4,508 passengers. The forecast for passengers in the second quarter was 4,223 passengers. 1) What is the forecast for the fifth quarter using exponential smoothing with  = 0.1? 2) Given only what you learned in a, should the airline add another plane?

5-17 Data collected on the yearly demand for 50-pound bags of fertilizer at Wallace Garden Supply are shown in the following table. Develop a 3-year moving average to forecast sales. Then estimate demand again with a weighted moving average in which sales in the most recent year are given a weight of 2 and sales in the other 2 years are each given a weight of 1. Which method do you think is better? YEAR DEMAND FOR FERTILIZER (1,000s OF BAGS) 1 4 2 6. 3 4 4 LO

. 4.5 The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the antici- pated mileage to be driven next year. The miles driven during the past 5 years are as follows: YEAR MILEAGE 1. 3,000 4,000 3,400 4. 3,800 5. 3,700 a) Forecast the mileage for next year (6th year) using a 2-year moving average. b) Find the MAD based on the 2-year moving average. (Hint. You will have only 3 years of matched data.) c) Use a weighted 2-year moving average with weights of .4 and 6 to forecast next year's mileage. (The weight of .6 is for the most recent year.) What MAD results from using this approach to forecasting? (Ilint: You will have only 3 years of matched data.) d) Compute the forecast for year 6 using exponential smoothing, an initial forecast for year of 3,000 miles, and a .5. Px

A battery manufacturing plant has been ordered to cease discharging acidic waste liquids containing mercury into the city sewer system. As a result, the firm must now adjust the pH and remove the mercury from its waste liquids. Quotations from three firms are included in the following table of costs. Bidder Installed Cost Annual Operating Cost Annual Income from Mercury Recovery Salvage Value Foxhill $ 70,000 $5000 $6500 $10,000 Instrument         Quicksilver 50,000 5000 2500 0 Almaden 90,000 5000 7800 10,000 If the installation will last 15 years and money is worth 12%, which equipment should be purchased?

Roger Co. implemented activity-based costing in the current year. To select the appropriate driver for Cost Pool A, Roger performed regression analyses for two independent variables, Driver 1 and Driver 2, using monthly operating data. The monthly levels of Cost Pool A were the dependent variables in both regressions. Output results from the regression analyses were as follows: Driver 1 R squared Intercept X variable (slope) At the budgeted production level for next month, the levels of Driver 1 and Driver 2 are expected to be 5,880 and 7,000, respectively. Based on this information, what is the budgeted amount for Cost Pool A for next month? O A. $3,280 OB. $2,624 O C. $3,464 O D. $3,785 0.46 $551.00 Driver 2 $0.55 0.80 $970.00 $0.33

Competitive Analysis of Natural Hair Salon for curly hairs in Dorchester for business plan.

12.7 The Intrepid mutual fund of growth stocks has had the following average monthly price for the past 10 months. Month 1 2 3 4 5 6 7 8 9 10 Fund Price 62.7 63.9 68.0 66.4 67.2 65.8 68.2 69.3 67.2 70.1 Compute the exponentially smoothed forecast with a = 0.40, the adjusted exponentially smoothed forecast with a = 0.40 and ß = 0.30, and the linear trend line forecast. Compare the accuracy of the three forecasts using cumulative error and MAD, and indicate which forecast appears to be most accurate.

Gargash Car Service have repaired the following number of cars from January to May. Month Number of cars sold January 120 February 123 March 145 April 141 May 138 A. Calculate the three-period moving average forecast for the month of June. Show your work.8. Given the historical data and weights of 0.42, 0.33, and 0.25, calculate three-period weighted moving average forecast for June? Show your work.C. Calculate the naive forecast for June. Show your work.D. Would you prefer any of these forecasts above the other? Justify your answer.E. Suppose that the June's actual sales is 5 percent lower than May's sales. What will the error of your(preferred) forecast?

Requirement Show your working calculation

part b