Use Excel to solve the below problems. 1. Construct an exponential forecasting calculator to find (a) forecasted demand using WMA (w1=0.55 (most recent), w2-0.3, w3=0.15 ) (b) forecasting error (c) MSE and (d) forecasted demand in month 8. Month Sales 1 1257 2 2478 2500 3100 3125 3055 7 2986
Q: Complete the firs iteration of the Simplex table for the following Maximization problem. Note: If…
A: in simplex method, to remove the inequalities from constraint equations, we add slack and surplus to…
Q: 1. Give TWO (2) examples of a disrupt EC impact.
A: EC definition:- Enterprise Cloud is an integrated suite of advanced applications, databases, and…
Q: eed asap... please Is there a significant relationship between unemployment and SNAP Benefits in…
A: SNAP is a Supplemental Nutrition Assistance Program in USA where Millions of Americans have…
Q: You have the following wage progression scale HOUSEKEEPER START 6 MOS…
A: Wage progression is the gradual increase in a worker's compensation rate from a starting point to…
Q: f the FUS Corporation has the following data about 5 locations: Location Fixed Cost ($) 200,000…
A:
Q: What are the typical characteristics of a TV set with using the several dimensions of quality
A:
Q: 1- The number of orders in the inventory system (called A) is total demand (called D) divided by…
A: Random numbers are any number that does not have any pattern or the number that does not have any…
Q: A manufacturer needs to produce 300 coffee pots per 8 hour day. The discrete tasks required to…
A:
Q: c) Compute the net quantities needed if there are 25 of the base and 100 of the clamp in stock.…
A: A work breakdown structure helps to identify the dependency of various items on their parent item.…
Q: In queuing system 1.- What is the average Queue lenght 2.- What is the expected waiting time ?
A: A queuing system cab be broadly described as a system that has a service facility at which various…
Q: What impact do requirements for functionality, system output, performance, reliability, and…
A: Quality planning can be defined as the documentation which specify the standards of quality,…
Q: 6. There are 17 types of Therbligs symbols, write the appropriate symbols and give an example of…
A: Therbligs associated with the motions of the human body at the workplace and to the mental…
Q: How can a company ensure that its supply chain is resilient to unexpected events?
A: Unexpected events refers to the events which arises due to uncertainities which may have greater…
Q: The national Safety Council (NSC) estimates that off-the-job accidents cost U.S. businesses almost…
A: Given, Number of employees that average the off-the-job accidents per year = 3 So, Expected number…
Q: Consider the Union Airways problem presented in Sec- tion 3.3, including the spreadsheet in Figure…
A: The excel model is replicated as follows.
Q: Explain the current trends governing site selection?
A: Logistics has practiced a tremendous modification from a virtuously functional function that stated…
Q: Bold Vision, Inc. must purchase toner from a local supplier. The demand rate is 620 EP cartridges…
A: Weekly Demand = d = 620 units Weekly Production = p = 1735 units Set-up cost = S = $100 Cost per…
Q: An investor has $749,000 to invest in bonds. Bond A yields an average of 3% and the bond B yields…
A: Given data is Available money to invest = $749000 Yield by bond A = 3% Yield by bond B = 8%
Q: The Benefits of Achieving IT and Business Strategy Alignment.
A: The business must always review it's existing IT strategy in order to get it aligned with the new…
Q: Why is quality a critical function at Frito-Lay?
A: Quality control is the process of reviewing all the factors in the process of the production so that…
Q: ommercial Bank of Windhoek has credited Upington Solar Corporation with R550m, with a maturity of…
A: given, solar corporation R550m maturity of 2 years recovery rate =23%
Q: 38. Disclosure requirements for lease by lessee include: a. General Information about the lease b. A…
A: A lease is a contract in which one party grants another party the right to use a property or land…
Q: Direction: Suppose you are a manager of a certain company; you have a very competent employee whom…
A: Delegation is described as the process in which a person or an employee or a manager is entrusted…
Q: You are using P Chart for a process for determining the proportion of customers who complete their…
A: Given: Days No. of Defective items Sample size Monday 5 50 Tuesday 7 50 Wednesday 9 50…
Q: CASE: The manager of a community pharmacy is reordering his stock of generic atenolol when he notes…
A: Financial considerations in any businesses are more important than others considerations or…
Q: Problem 2 Duke Energy needs to determine how much electricity to produce from each of their…
A: Let, X1 = Electicity generated by gnerator 1X2 = Electicity generated by gnerator 2X3 = Electicity…
Q: The table below contains data for the installation of new equipment in a manufacturing process for a…
A: Since you have submitted a question with multiple subparts, as per guidelines, we have answered the…
Q: 11-17 The following are the activity times for the project in Problem 11-16. Find the earliest,…
A: ES -Early start time LS - Late start time EF - Early finish time LF - Late finish time ES =…
Q: (a) What are the four main sources of key success factors? Please select two of these factors and…
A: Key Success factors:- A key success factor (KSF) is something that helps contribute to achieving…
Q: How about listing and briefly defining the five risk-control approaches?
A: Risk control is an important and integral part of any organization of any sector because risks can…
Q: Which of the following is NOT true about the newsvendor model (Circle ALL statements that are NOT…
A: The newsvendor model is described as a model that the used in inventory management and supply chain…
Q: A manufacturing company preparing to build a new plant is considering three potential locations for…
A: Total cost of the location= Total fixed cost+ variable cost* number of units Fixed costs are those…
Q: Discuss why effective leadership involves both strategy creation and strategy implementation.
A: Leadership is all about guiding followers in accomplishing their tasks, leaders always tell their…
Q: In a metropolitan area, 45,000 people want to travel from the city suburbs to the city center. To do…
A: As per the given question details, x1 = Number of people drive to travel from city suburbs to the…
Q: What impact does quality planning have on functionality, system output, performance, reliability,…
A: Quality planning can be described as a methodology which is used by project managers to codify the…
Q: 15.7. Draw a product structure diagram from the bill of material for an Xavier skateboard shown…
A: Given data is
Q: 17.10. Today is day 4 of the planning cycle. Sequence the following jobs by FCFS, SPT, SLACK, and…
A: The mean flow time and mean tardiness can be computed after proceeding with the FCFS method.
Q: recommended actions by managers when dealing with Systems Risks?
A: Management is the process of administering an organization whether it is a profit, non-profit or…
Q: what aspects of Operations Management can be done most efficiently by working remotely Vs. working…
A: Operations management is the process of converting labor and raw materials into goods and services…
Q: 4. For each of the following network diagrams, determine both the critical path and the expected…
A: given,
Q: What is the purpose of a test strategy?
A: Test strategy can be described as a set of principles which guides in the determination of test…
Q: What action does the Purchasing Officer take on receiving the requisition for raw material
A: Purchasing officer is the person who is in charge for an organisation or firm to purchase raw…
Q: Activity Name Description or Instruction Please calculate the VCC, VFD, TVFD for this imported…
A: The detailed solution is given in Step 2.
Q: Under what circumstances might an employer need to maintain an OSHA injury/illness log for persons…
A: OSHA is occupational safety and health act that must be implemented in every company to maintain a…
Q: Banks have card readers on the outside doors to individuals branches for access to the ATM lobby for…
A: Suppose - Reliability of first Card Reader = R1 Reliability of Second Card Reader = R2 % of…
Q: Period 3 Gross requirements 72 53 71 Scheduled receipts Projected available balance Net requirements…
A: MRP stands for material requirements planning which helps businesses to improve productivity by the…
Q: Define Third party logistics firms? Discuss its working procedure? ( 400 words ) Please do fast ASAP…
A: In a general enterprise sense, logistics is the direction of the flow of things within the center of…
Q: Suppose we are deciding which projects to implement in the upcoming year. Let's represent each…
A: Third Project = P3 Second Project = P2 First Project = P1 Here the requirement is to complete…
Q: Design a checklist to effectively manage classroom space
A: The primary objective of effective classroom management is promoting an efficient and safe learning…
Q: What are the advantages and disadvantages of Frito-Lay drivers stocking their customers' shelves?
A: Quality management is all about managing the quality of the products or services so that good…
please solve it using excel and show the equations and pugging the numbers
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
- 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?
- The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?The file P13_26.xlsx contains the monthly number of airline tickets sold by the CareFree Travel Agency. a. Create a time series chart of the data. Based on what you see, which of the exponential smoothing models do you think will provide the best forecasting model? Why? b. Use simple exponential smoothing to forecast these data, using a smoothing constant of 0.1. c. Repeat part b, but search for the smoothing constant that makes RMSE as small as possible. Does it make much of an improvement over the model in part b?The owner of a restaurant in Bloomington, Indiana, has recorded sales data for the past 19 years. He has also recorded data on potentially relevant variables. The data are listed in the file P13_17.xlsx. a. Estimate a simple regression equation involving annual sales (the dependent variable) and the size of the population residing within 10 miles of the restaurant (the explanatory variable). Interpret R-square for this regression. b. Add another explanatory variableannual advertising expendituresto the regression equation in part a. Estimate and interpret this expanded equation. How does the R-square value for this multiple regression equation compare to that of the simple regression equation estimated in part a? Explain any difference between the two R-square values. How can you use the adjusted R-squares for a comparison of the two equations? c. Add one more explanatory variable to the multiple regression equation estimated in part b. In particular, estimate and interpret the coefficients of a multiple regression equation that includes the previous years advertising expenditure. How does the inclusion of this third explanatory variable affect the R-square, compared to the corresponding values for the equation of part b? Explain any changes in this value. What does the adjusted R-square for the new equation tell you?
- The file P13_29.xlsx contains monthly time series data for total U.S. retail sales of building materials (which includes retail sales of building materials, hardware and garden supply stores, and mobile home dealers). a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?The file P13_28.xlsx contains monthly retail sales of U.S. liquor stores. a. Is seasonality present in these data? If so, characterize the seasonality pattern. b. Use Winters method to forecast this series with smoothing constants = = 0.1 and = 0.3. Does the forecast series seem to track the seasonal pattern well? What are your forecasts for the next 12 months?The file P13_02.xlsx contains five years of monthly data on sales (number of units sold) for a particular company. The company suspects that except for random noise, its sales are growing by a constant percentage each month and will continue to do so for at least the near future. a. Explain briefly whether the plot of the series visually supports the companys suspicion. b. By what percentage are sales increasing each month? c. What is the MAPE for the forecast model in part b? In words, what does it measure? Considering its magnitude, does the model seem to be doing a good job? d. In words, how does the model make forecasts for future months? Specifically, given the forecast value for the last month in the data set, what simple arithmetic could you use to obtain forecasts for the next few months?
- Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?Scenario 3 Ben Gibson, the purchasing manager at Coastal Products, was reviewing purchasing expenditures for packaging materials with Jeff Joyner. Ben was particularly disturbed about the amount spent on corrugated boxes purchased from Southeastern Corrugated. Ben said, I dont like the salesman from that company. He comes around here acting like he owns the place. He loves to tell us about his fancy car, house, and vacations. It seems to me he must be making too much money off of us! Jeff responded that he heard Southeastern Corrugated was going to ask for a price increase to cover the rising costs of raw material paper stock. Jeff further stated that Southeastern would probably ask for more than what was justified simply from rising paper stock costs. After the meeting, Ben decided he had heard enough. After all, he prided himself on being a results-oriented manager. There was no way he was going to allow that salesman to keep taking advantage of Coastal Products. Ben called Jeff and told him it was time to rebid the corrugated contract before Southeastern came in with a price increase request. Who did Jeff know that might be interested in the business? Jeff replied he had several companies in mind to include in the bidding process. These companies would surely come in at a lower price, partly because they used lower-grade boxes that would probably work well enough in Coastal Products process. Jeff also explained that these suppliers were not serious contenders for the business. Their purpose was to create competition with the bids. Ben told Jeff to make sure that Southeastern was well aware that these new suppliers were bidding on the contract. He also said to make sure the suppliers knew that price was going to be the determining factor in this quote, because he considered corrugated boxes to be a standard industry item. As the Marketing Manager for Southeastern Corrugated, what would you do upon receiving the request for quotation from Coastal Products?MONTH DEMAND 1 45 2 3 4 5 48 43 48 49 6 54 7 8 9 10 47 50 46 47 Using the table above, calculate two forecasts using the following method:-i. First, for periods 4 through 10, develop the exponentially smoothed forecastsusing a forecast for period 3 (F3) of 45.0 and an alpha of 0.4. ii. Calculate the weighted moving average for periods 4 through 10, using weights of.70, .20, and .10, with 0.70 applied to the most recent data iii. Calculate the mean absolute deviation (MAD) for each forecasting procedure.Which forecasting procedure would you select? Why?