c) The graph to the right shows the actual registrations, registrations forecasted using a 3-year moving average, and registrations forecasted using a 3-year weighted moving average. Which method seems to be able to forecast better? (Refer to the legend or hover your mouse over any plot) OA A3-year weighted moving average is significantly better. OB. A3-year moving average is significantly better. OC The forecasts are about the same.
Q: Using exponential smoothing with a = 0.40 and a forecast for year 1 of 7.0, provide the forecast…
A: Let me state the given data, Yearactual demand1828344751367713812991013117Here, I will apply the…
Q: a. The multifactor productivity ratio with the university's plan to meet the expenses related to…
A: The ratio of input to output is the outcome of productivity. It assists in estimating the efficiency…
Q: La Jolla Beverage Products is considering producing a wine cooler that would be a blend of a white…
A: Linear programming is a mathematical method used to find the best possible outcome or solution from…
Q: A small company heats its building using a gas furnace. It expects to spend $9,020 on natural gas…
A: Amount spent on natural gas = $9020Increase in cost of natural gas every year = 10%Maintenance Cost…
Q: materials for each of the four electronic boards. Labour 4,000 3,200 2,808 2,560 1st unit 2nd unit…
A: According to the question, given data learning rate for Labor1st unit = 4,000 hours2nd unit = 3,200…
Q: The Road King Tire Company in Birmingham wants to monitor the quality of the tires it manufactures.…
A: Calculate the fraction of defective for each sample by dividing number of defectives with the sample…
Q: Explain the concept of contingency planning. Why is it important for organizations to have…
A: Having a contingency plan set up is pivotal for some organizations to be more effective and steady…
Q: A relational orientation is based on the philosophy that buyers and sellers develop O a. supply…
A: A relational orientation is based on the philosophy that buyers and sellers develop:d. a long-term…
Q: Existing facility #1 has weight 2 and coordinate (9, 10). Existing facility #2 has weight 10 and…
A: Find the given details below: Given…
Q: Complete the level production plan, using the following information. The only costs you need to…
A: Find the /given details below:…
Q: Gulf Coast Electronics is ready to award contracts to suppliers for providing reservoir capacitors…
A: Linear programming helps us to find the optimal…
Q: Please do not give solution in image format thanku Charles Lackey operates a bakery in Idaho…
A: Loaves produced (Output) = 1,800 loaves per monthLabor Cost (Work hours x Employee cost) = 640 x $8…
Q: Kilgore's Deli is a small delicatessen located near a major university. Kilgore's does a large…
A: Based on the given data,Total profit = Profit per Wimpy x No. of Wimpys sold + Profit per Dial 911 x…
Q: This exercise contains only parts d, b, and c d) Using the line drawing tool five times, draw a…
A: Here, for each activity, I am given the time data and immediate predecessor information, Using this…
Q: Q4 Costs: LayoffHiringInventory Totals: 246 246 30,000 Costs: $246,000 $492,000 $30,000 Cost of…
A: A production plan is a plan that defines the activities that are required by a manufacturer to…
Q: Determine the suitable location of a distribution centre with the below data, minimizing the…
A: Find the given details below:Here we can follow the Euclidean distance method to find the optimal…
Q: How does the Kanban system model differ from Scrum in Agile project management, and under what…
A: The Kanban system model and Scrum are both Agile project management methodologies, but they have…
Q: Describe the impact of microchip supply chain disruptions on the global electronics industry.
A: Supply chain disruptions in the microchip industry have an effect on the global electronics industry…
Q: Provide all techniques practiced previously: five (5) techniques for Decisions Making under…
A: There are situations in the business that are uncertain and that make the decision-making complex.…
Q: The manager assigns tasks to workstations and breaks ties using a longest operation heuristic. That…
A: Project schedule helps in calculating different values related to the production cycle like the…
Q: Assume Activity A starts on Day 1. 1. Draw the scheduling network based on the activities given in…
A: A project with 12 activities is given below:ActivityDurationPreceded…
Q: Alvarez Incorporated can purchase component X from 3 potential suppliers. Supplier A charges a fee…
A: Let, the order quantity = xSupplier A:Price per component = $6.50Total cost equation:Total cost…
Q: A retired couple supplement their income by making fruit pies, which they sell to a local grocery…
A: Let the number of Apple Pies made be A and Grape Pies made be G.Total Revenue = Selling Price per…
Q: The number of cases of merlot wine sold by the Connor Owen winery in an eight-year period is as…
A: Forecasting is a technique that is adopted by every business to make informed decisions about the…
Q: 2. Radiant requires cargo planes for the transportation of three distinct goods: A, B, and C. They…
A: Given,Goods AGoods BGoods CWT88 can carry18 tons12 tons20 tonsBH54 can carry15 tons20 tons15 tons(a)…
Q: Please answer this question What is the acceptable standard deviation range for running of quality…
A: Quality control is a process with the help of which a business ensures that the quality of the…
Q: f you were going into the lodging segment, which type of property would you prefer to work at and…
A: Lodging refers to the transaction of a short-run abode. those who travel and keep one's hands off…
Q: Strama, Incorporated, manufactures and sells two products: Product A6 and Product I5. The company…
A: A cost accounting method known as activity-based costing (ABC) allocates overhead and indirect…
Q: Use moving average method with N = 3 to forecast the expected number of claims for tomorrow. b. Use…
A: NOTE: We are allowed to do first three sub-parts only. DaysLost…
Q: Identify the critical path and obtain the project completion time. Calculate free float for each…
A: NOTE: We are allowed to do one question only. The free float represents the duration that an…
Q: I Love Lucy: A Colorized Celebration - "Job Switching" clip https://youtu.be/K3axU2b0dDk Watch this…
A: In the "I Love Lucy" episode titled "Job Switching," Lucy and Ethel work in a candy factory on an…
Q: Apply the Five quality definitions - anscendent, Product-based, User-based, e-based and…
A: When it comes to product quality, there are 5 main dimensions or key elements. All these elements…
Q: a) Using a 2-year moving average, the forecast for year 6 = 3800 miles (round your response to the…
A: Forecasting is knowing the outcome of future events by making predictions and estimates based on…
Q: What is the main purpose of a cost center in a hotel? a) To generate revenue in line with the hotel…
A: Cost centers in hotels are divisions or tasks that assist revenue-producing divisions but do not…
Q: The information for project X is shown below. What is your recommendation if the imposed penalty is…
A: Critical path method is project management tool (others e.g WBS, PERT). It uses flow chart of…
Q: Note: 1. Unless otherwise noted, you should round your numbers to whole numbers. 2. The rating…
A: Scheduling is the process of planning and organizing tasks to be executed in a systematic and…
Q: Compare and contrast three common types of production processes: make-to-order, make-to-stock, and…
A: A production process is a set of methodical actions performed in a predetermined order to convert…
Q: Please do not give solution in image format thanku A 60-watt outdoor lightbulb is advertised as…
A:
Q: The City Commission of Nashville has decided to build a botanical garden and picnic area in the…
A: A network diagram is a graphical representation of project that helps to identify the activity…
Q: what will be the future plan for a pizza shop including the cost, time, reasons in the answer.
A: Welcome to our future vision." We will detail our strategic goals and efforts in this plan as we…
Q: The Demand for Krispee Crunchies, a favorite breakfast cereal of people born in the 1940s, is…
A: Here we find a forecast line that best fits the data points representing the actual. Best fit means…
Q: Consider a machine which, when operated for one shift, produces 200 parts (12 of which are scrap).…
A: Overall Equipment Effectiveness (OEE) is a measure of how effectively a manufacturing operation is…
Q: escribe the key components of a typical IT disaster recovery plan. How does a disaster recovery plan…
A: An IT disaster recovery plan (DRP) is similar to an organization's digital infrastructure insurance…
Q: Please do this short answer problem and use the table in the picture A pharmaceutical company is…
A: Decision alternativeSuccessful applicationUnsuccessful applicationApply for FDA3000000-1500000Don’t…
Q: With the use of relevant diagram, discuss the main areas of service that could be provided by the…
A: Fourth-party logistics (4PL) are those external entities that offer end-to-end expertise of services…
Q: a. Which inventory model fits the best to this problem? O A. All-units quantity discounts model B.…
A: EOQ = 900 casesTime of orders = 4 monthsSetup costs (S) = $5000Holding cost (H) = $14
Q: Solve the following linear program using the graphical solution procedure. Max 5A + 5B s.t. 1A < 100…
A: Linear programming models help to get the best outcome with linear relationships. It is used in…
Q: a) Using a 2-year moving average, the forecast for year 6= 3800 miles (round your response to the…
A: Forecasting is predicting the uncertainty of the future. This can be in the context of sales or…
Q: a) Using a 2-year moving average, the forecast for year 6 = 3800 miles (round your response to the…
A: Forecasting is predicting the uncertainty of the future. This can be in the context of sales or…
Q: Routing 1 uses drying press A, and routing 2 uses drying press B. Both routings require the same…
A: Time Requirement (hr/kg)ProcessRouting 1Routing 2Capacity (hr)Mixing2254Dryer A60120Dryer…
Step by step
Solved in 3 steps
- Under what conditions might a firm use multiple forecasting methods?The file P13_42.xlsx contains monthly data on consumer revolving credit (in millions of dollars) through credit unions. a. Use these data to forecast consumer revolving credit through credit unions for the next 12 months. Do it in two ways. First, fit an exponential trend to the series. Second, use Holts method with optimized smoothing constants. b. Which of these two methods appears to provide the best forecasts? Answer by comparing their MAPE values.The Baker Company wants to develop a budget to predict how overhead costs vary with activity levels. Management is trying to decide whether direct labor hours (DLH) or units produced is the better measure of activity for the firm. Monthly data for the preceding 24 months appear in the file P13_40.xlsx. Use regression analysis to determine which measure, DLH or Units (or both), should be used for the budget. How would the regression equation be used to obtain the budget for the firms overhead costs?
- Week Sales1 27502 31003 32504 28005 29006 30507 33008 31009 295010 300011 320012 3150Develop a three-week moving average. A.What is the forecast for week 5? (Make sure no decimal place and no comma. EX: 1234) B.What is the value of MSE (mean squared error) with regard to a three-week moving average? (Make sure no decimal place and no comma. EX: 1234) C.Develop the exponential smoothing with the alpha value of 0.20. What is the forecast for week 5? (Make sure no decimal place and no comma. EX: 1234) D.What is the value of MSE (mean squared error) with regard to the exponential smoothing? (Make sure no decimal place and no comma. EX: 1234) E.Which method is more accurate? (1 for Moving average, 2 for Exponential Smoothing)The following table shows the quarterly sales (RM'000) for Afeef Café for the past 3 years. Quarter Year 2 3 4 2019 11 17 10 18 2020 19 24 17 29 2021 23 38 31 33 Based on the above data. (c) Forecast the sales for the third quarter of 2022.Dic 2 - Time Series Analysis and F eBook Problem 6-01 (Algorithmic) Consider the following time series data. Thm Week 1 2 3 4 5 6 Value 20 13 15 11 19 13 Using the naïve method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy. a. Mean absolute error. If required, round your answer to one decimal place. b. Mean squared error. If required, round your answer to one decimal place. c. Mean absolute percentage error. If required, round your intermediate calculations and final answer to two decimal places. % d. What is the forecast for week 7? If required, round your answer to two decimal place.
- 12-1. The Hartley-Davis motorcycle dealer in the Minneapolis- St. Paul area wants to be able to forecast accurately the de- mand for the Roadhog Super motorcycle during the next month. From sales records, the dealer has accumulated the data in the following table for the past year. Month January February March April Мay June Motorcycle Sales 7 10 8 7 12 July August September 10 11 12 October 10 November December 14 16 a Compute a three-month moving average forecast of demand for April through January (of the next year). b. Compore a five-month moving average forecast for June drough January. c. Compare the two forecasts computed in parts (a) and (b) using MAD. Which one should the dealer use for January of dhe next year?Suppose these data show the number of gallons of gasoline sold by a gasoline distributor in Bennington, Vermont, over the past 12 weeks. Sales (1,000s of gallons) Week 1. 17 22 20 4 24 18 6. 17 7 21 8 19 23 10 21 11 15 12 23 (a) Compute four-week and five-week moving averages for the time series. 4-Week 5-Week Time Series Moving Moving Average Forecast Week Value Average Forecast 1 17 22 20 4 24 5 18 6. 17 2.The following gives the number of pints of type Bblood used a t Woodlawn Hospital in the past 6 weeks: a) Forecast the dema nd for the week of October 12 using a3-week moving average.b) Use a 3-week weighted moving average, with weights of .I , .3,and .6, using .6 for the most recent week. Forecast demand forthe week of October 12.c) Compute the forecast for the week of October 12using exponentialsmoothing with a forecast for August 31 of 360 and a = .2
- Data collected on the yearly registrations for a Six Sigma seminar at the Quality College are shown in the following table: Year -1 2 Registrations (000) 5.0 5.0 Year Forecast 4 4.3 This exercise contains only parts a and b. a) Using a 3-year moving average, the forecasted registrations (in thousands) for years 4 through 12 are (round your responses to one decimal place): 5 4.6 4 3 3.0 5 6 6.6 7 8 4 5 6 9 10 6.0 11.0 9.0 7.0 9.0 13.0 16.0 6 7 8.7 8 9 7 9 8.3 b) Using a 3-year weighted moving average in which the registrations in the most recent year are given a weight of 2, and registrations in the other 2 years are each given a weight of 1, the forecasted registrations (in thousands) for years 4 through 12 are (round your responses to one decimal place): Year Forecast 8 10 9.6 9 11 12.6 10 12 15.3 11 11 17.0 122-1 Sales of Cool-Man air conditioners have grown steadily during the past 5 years: DEMAND ADV SEPENT 2017 450 1200 2018 495 1650 2019 518 1710 2020 563 1860 2021 584 1960 Predict the demand of Year 2021 by: a. Using 3 moving average b. Using exponential smoothing with alpha = 0.30. The sales manager had predicted, before the business started, that year 1l's sales would be 410 air conditioners. c. Using the relationship between the sales and advertainment spent Which of the above value is the best predicated demand for Year 2021? 2-2 Three trials for the company stock control system were calculated as shown in the table below. The holding cost, shortage cost and ordering costs have been estimated to be $220, $80 and $170. The company has a high competition therefore they need to keep their customer and attract more new customers. Strategy 1 Strategy 2 Strategy 3 Reorder Quantity 200 600 400 Reorder Level 300 400 200 Lead Time 1 Number of days when stock out is occurred 20 12 Number of…The table shows the values found in the error analysis. What method of forecasting would be best to use? What is the forecasted value? MSE forecast for week 13 Time Series 1.08 14.76 3-week MA 3.04 13.67 exp smoothing 11.04 9.5 Group of answer choices A.) Time Series, forecasted value = 14.76 B.) 3-week MA, forecasted value = 13.67 C.) exp smoothing, forecasted value = 9.5 D.) Time Series, forecasted value = 1.08 E.) 3-week MA, forecasted value = 3.04 F.) exp smoothing, forecasted value = 11.04