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

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

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

14) Use the following formulas: SELL THRU PERCENT (ST%) = SALES/BOH BOH = Beginning of week on hand inventory REC = Receipts EOH = Ending of week on hand inventory Below are the numbers for LAST week: SALES = 8,500 BOH = 56,700 REC = 4,500 EOH = 52,700 If a Buyer expected to have a 12% ST% NEXT week. How many dresses are they planning to sell?
Jae's Shoes is considering a change of their current inventory control system for sneakers. The information regarding the neckties is: Demand = 1000 pairs/week; Lead time = 3 weeks; Order cost=$20/order; Holding cost= $10.00/pair/yr; Cycle service level = 95%; Standard deviation of weekly demand = 48; and Number of weeks per year = 52. To calculate the relative frequency use the following values: a) Units Sold and Number of Days b) Number of Days and Standard Deviation of Weekly Demand c) Units Sold and Demand d) Lead Time and Holding Cost
Please help me with show all calculation thanku
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