i. What are the 3-months moving average forecasts for months 4, 5, 6 & 7? ii. What are the 3-month Wt. Moving Average (weights: 0.2, 0.3, 0.5) for months 4, 5, 6 & 7? ii. Calculate an exponential smoothing forecast for the given data with an alpha of 0.1 for months 2, 3, 4, 5, 6 & 7. Assume a forecast of 650 for month 1.
Q: A company sells its products to wholesalers in batches of 1,000 units only. The daily demand for its...
A: Given data is
Q: Material management relies on five (5) areas in the organization as a) Inventory Control. b) Store...
A: Materials management is planning and executing processes in a supply chain in order to fulfill the m...
Q: Stakeholder interest and potential and the impact of the project
A: Stakeholders are individuals who have interest in a business venture and business or projects. These...
Q: answer it in a short answer? please John was thrilled when, after completing his MPA degree, he was...
A: Organizational politics is described as the agenda and the self-interest of a person within an organ...
Q: The hotel has adopted an ethnocentric human resource management strategy, do you believe that this a...
A: The successful running of a hotel depends on the customer satisfaction.
Q: State how does the long term capacity considerations differ from that of short term capacity conside...
A: To be determined: how does the long term capacity considerations differ from that of short term capa...
Q: Calculate the efficiency of the newly design process.
A: A line balancing efficiency indicates the proportion between total task time and total workstation t...
Q: If the manufacturing cycle efficiency is 65% and the total manufacturing time is 45 minutes then by ...
A: Given data is Manufacturing cycle efficiency(MCE) = 65% Total manufacturing time = 45 minutes
Q: Determine the Mean Absolute Deviation Using a- 0.20. Period Demand Forecast 20 35 20 46 23 4 40 27.6...
A: Forecasting is the process of estimating the future demand based on previous or historic data and in...
Q: The quarterly sales in millions for Autoko Corporation, an automobile dealership company over the pa...
A: Seasonal factor helps to predict the future demand based on the past information while considering t...
Q: How can matrix operations solve problems in health care
A: The matrix operations could provide an important framework, here, care practices can be improved by ...
Q: According to the latest unemployment report, American manufacturing added 24,000 jobs last month bu...
A: The primary objective of globalization is to provide the organizations a superior competitive positi...
Q: 1) What is the annual holding (carrying) cost for the EOQ that you calculated? 2) What is the an...
A: EOQ is the optimal order quantity that the companies need to purchase so that they can minimize thei...
Q: A company has the following demand data for the last three years of sales for their popular product ...
A: Month 2017 2018 2019 January 80 82 93 February 70 98 121 March 85 90 138 April 101 113 124 ...
Q: A queueing system has an arrival rate of 29 patients per minute (standard deviation of 21) and a ser...
A: Given, Arrival rate a = 29 per minute Standard deviation of arrival rate Sa= 21
Q: The initial tableau of a linear programming problem is given. Use the simplex method to solve the pr...
A: The initial tableau can be written as follows.
Q: A retailer uses a periodic review order-up-to model to control the inventory of one of its high volu...
A: In this question, we have been given, Average demand=2580 units per week The standard deviation of d...
Q: tem SKU A3378 has a demand that is normally distributed during the lead time, with mean of 360 units...
A: SKU A3378 Mean = 360 Standard deviation = 12 Probability of stocking out =100-10%=90% z=1.29 Reorde...
Q: A supermarket is trying to decide how many cash registers to keep open. Suppose an average of 18 cus...
A: A normal of 18 clients show up every hour at the general store and the normal look at time for a cli...
Q: PRODUCT MIX: The JP Manufacturing Company produces two products. Resource requirements for productio...
A: Decision Variable:Suppose- A be the no. of units produced per week of the product ‘A’ B be the no...
Q: 1. The following solved problems refer to this payoff table: New Bridge Built No New Bridge 14 Alter...
A: Given- Payoff Table-
Q: The organizers of a conference in the Houston Convention Center are evaluating the possibility of se...
A: Given data Arrival rate (λ) = 19 attendee per hour Service rate (μ) = 14 minutes Service rate (μ)...
Q: The statement that best to describe the productivity challenge is, except. Group of answer choices ...
A: Productivity relates to the physical connection between the quantity yielded (output) & the no. ...
Q: 3 The M/M/1 Queue During peak time, customers arrive at a bank teller window (with a single teller) ...
A: λ = Arrival rate = 23 customers/hrμ = Service rate = 25 customers/hr1λ=a = Inter arrival time
Q: Camile owns Crunch Code, a company that provides quick programming solutions. Clients send Crunch pr...
A: Given data Arrival time (λ) =14.4=0.23 projects per hour Service time (μ) =119.3=0.052 Number of ...
Q: Larry Edison is the director of the Computer Center for Buckly College. He now needs to schedule the...
A: Decision Variable:Suppose-f1 = No. of full-time consultants working the morning shift (8 a.m.-4 p....
Q: Troy and Tristan have decided to open a competitive Cheer and Dance business. Troy’s expertise is in...
A: given, Troy and Tristan have decided to open a competitive Cheer and Dance business. Troy’s expertis...
Q: If the projected or forecasted sales of Malinao Bakery for the month of January is 2100 loaves of br...
A: Projected sale will be the sum of forecasting sales multiplied by the unit sale values. Using the gi...
Q: Don’t Drink And Drive Brewery (DDAD) produces beer and ale. Beer sells for $5.70 per barrel, and ale...
A: Profitability is the degree wherein an organization, or a single business, produces a profit (cash a...
Q: In a fabric manufacturing factory, the quality control process using control charts from SPC. In an ...
A: Given samples-
Q: After training, Mary Fernandez, a computer technician, had an average observed time for memory-c...
A: The detailed solution is given in Step 2.
Q: 9.) you run a small bottle distributor, and youre trying to decide where to put the various items yo...
A: Number of red bottles = 11 Number of green bottles = 27 Number of yellow bottles = 49 Each type of b...
Q: identify your own example of improper sampling from your day-to-day life. Be sure to provide the sam...
A: First, I would identify the example of improper sampling that could happen in our day-to-day life, I...
Q: Virginia College promotes a wide variety of executive training courses for firms in the Arlington, V...
A: Given data Allowance = 12%
Q: Question 2 The ISO 9000 certification process does not include: O On-site assessments O An ongoing s...
A: ISO 9000 is described as a set of global standards on the quality management & quality assurance...
Q: Max Stamp approves study abroad documents for the university. Students must wait in line with their ...
A: A queuing system refers to the system that has service facility where the customers arrive for servi...
Q: How do you distinguish between research method and research design?
A: Note - Hi! Thank you for the question As per the honour code, We’ll answer the first question since ...
Q: Bag Company produces leather jackets and handbags. A jacket requires of leather and a handbag only ...
A: Let, J = Units of Jackets to be produced H = Units of handbags to be produced
Q: Explain the importance of Process Selection in Facility Layout
A: Note: As per the Bartelby guidelines only the first question has been answered. Process selection...
Q: True or False: Write T if the staten 1. The introductory part of the review of related literature an...
A: A literature review is an inquiry and assessment of the accessible literature in your given subject ...
Q: David Aquino, engineering director, started out the day uptight. His young child had the flu the ni...
A: Engineering management is described as the implementation of various types of managerial practices i...
Q: There is a canteen setup serving food (Breakfast, Lunch, Snacks-tea and Dinner) to 500 students in a...
A: Provide one relatable and relevant example of five of the eight wastes under Lean systems which are ...
Q: Why is project management important? Provide 1 reason and explain.
A: Project management is characterized as the most common way of controlling a project from the beginni...
Q: A company which installs swimming pools has recently merged with another regional installer. It is b...
A: Forecasting in advance helps to estimate the sales that could be generated in the future period. Thi...
Q: Discuss the several types of changes that may suggest a need to revaluate and/or redesign firm's log...
A: A logistics network is an effective logistics network modeling to move goods from their raw state th...
Q: Round "Utilization" to a whole percent, and "Cycle Time" to 1 decimal. What is the capacity of the n...
A: Here, we have the following data, each nurse would take 1.25 hours to complete the visit of one pati...
Q: Soledad Bautista, the engineering manager, delegates tasks as a good manager should. However, Mark H...
A: given Soledad Bautista, the engineering manager, delegates tasks as a good manager should. However, ...
Q: Which elements of lean systems would be most troublesome for manufacturers to implement?
A: The lean system is the system in which different lean principles are used to plan and manage busines...
Q: Why is it important to avoid Type 1 Errors?
A: The null hypothesis can be stated as the typical statistical theory which recommends that no statist...
Q: Suppose you are made a warehouse manager of an exporting firm. Which factors will you consider befor...
A: Being a warehouse manager of an exporting firm, we must consider multiple factors before setting up ...
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?
- 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?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_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?Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. Ethical decisions that affect a buyers ethical perspective usually involve the organizational environment, cultural environment, personal environment, and industry environment. Analyze this scenario using these four variables.Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What should Sharon do in this situation?
- Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling contract submitted by four suppliers. She was evaluating the quotes based on price, target quality levels, and delivery lead time promises. As she was working, her manager, Dave Cox, entered her office. He asked how everything was progressing and if she needed any help. She mentioned she was reviewing quotations from suppliers for a tooling contract. Dave asked who the interested suppliers were and if she had made a decision. Sharon indicated that one supplier, Apex, appeared to fit exactly the requirements Visionex had specified in the proposal. Dave told her to keep up the good work. Later that day Dave again visited Sharons office. He stated that he had done some research on the suppliers and felt that another supplier, Micron, appeared to have the best track record with Visionex. He pointed out that Sharons first choice was a new supplier to Visionex and there was some risk involved with that choice. Dave indicated that it would please him greatly if she selected Micron for the contract. The next day Sharon was having lunch with another buyer, Mark Smith. She mentioned the conversation with Dave and said she honestly felt that Apex was the best choice. When Mark asked Sharon who Dave preferred, she answered, Micron. At that point Mark rolled his eyes and shook his head. Sharon asked what the body language was all about. Mark replied, Look, I know youre new but you should know this. I heard last week that Daves brother-in-law is a new part owner of Micron. I was wondering how soon it would be before he started steering business to that company. He is not the straightest character. Sharon was shocked. After a few moments, she announced that her original choice was still the best selection. At that point Mark reminded Sharon that she was replacing a terminated buyer who did not go along with one of Daves previous preferred suppliers. What does the Institute of Supply Management code of ethics say about financial conflicts of interest?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_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?