Compute a three-week moving average demand and a four-week moving average demand for weeks 5, 6, and 7. Compute the MAD for both forecasting methods. Which model is more accurate? Forecast week8 with the more accurate method

SOLVE USING EXCEL Chapman Pharmaceuticals, a large manufacturer of drugs, has this aggregate demand forecast (in thousands of liters) for a liquid cold medicine. Month January February March April May June Demand 200 120 75 40 15 7   The firm has a normal production rate of 90 thousand liters per month, and the initial inventory is 100 thousand liters. Inventory holding costs are $30 per 1,000 liters per month, regular-time production costs are $400 per 1,000 liters. Overtime costs an additional 20 percent, and undertime costs an additional 12 percent. Assume that there are no lost sales or rate change costs. Compute and compare the total cost of a level production rate of 90 thousand liters per month and a chase demand production plan.

Calculate the EOQ for exercise 8 if annual demand is 10,000 units,inventory storage costs average 20 percent, unit price is $50, and orderingcosts are $30.

A dairy processor that makes ice cream reviews its historical sales in relationship to summer temperature. It finds that sales drop below a critical value if summer temperature is 10% cooler than average, i.e., below 680 CDDs. Sales drop by $5,000 per seasonal CDD below 680. (the higher the CDD, the warmer the summer). What is the payout per option contract if the cumulative CDD for the month was 550 for the summer season? The payoff per degree day is $20 and the maximum payoff is $12,000. $130 $12,000 $2,600 $13,600 $11,000

Please solve with hte full step thank u

can you help me figure out the answer to a.

The monthly sales for Yazici Batteries, Inc., were as follows: Month Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec Sales 20 21 17 12 15 15 15 19 22 22 23 24 This exercise contains only parts b and c. b) The forecast for the next month (Jan) using the naive method = sales (round your response to a whole number). The forecast for the next period (Jan) using a 3-month moving average approach = sales (round your response to two decimal places). The forecast for the next period (Jan) using a 6-month weighted average with weights of 0.10, 0.10, 0.10, 0.20, 0.20, and 0.30, where the heaviest weights are applied the most recent month = sales (round your response to one decimal place). Using exponential smoothing with a = 0.35 and a September forecast of 18.00, the forecast for the next period (Jan) = sales (round your response to two decimal places). Using a method of trend projection, the forecast for the next month (Jan) = sales (round your response to two decimal places). c) The method…

A UAE based company of Solar Panel supplies has developed monthly forecasts for a family of products. Data for the 6-month period January to June and cost information are presented in the tables 1and 2 below. Use Plan 2-by using subcontractors with constant workforce at lowest demand per day and calculate Total Cost of the Plan. Table 1 PRODUCTION DEMAND DAYS FORECAST DEMAND PER DAY 22 1,073 18 903 1,000 1,000 1,272 1,388 29 $ per unit 95 per hour ( Working hours per day) 1.6 hours per unit MONTH Jan Feb Mar Apr May June Table 2 Cost Information Subcontracting cost per unit Average pay rate Labor-hours to produce a unt 21 24 24 22 2

please answer within 30 minutes.

Please don't give image format