Use the data below to solve for the following: 2. Naïve method 3. Unweighted 3 month moving average 4. Weighted Moving Average (3 months, with the following weights: 0.45, 0.35, 0.20) 5. Simple Exponential Smoothing with the following parameters: Ft+1=32 and the α = .15 6. Time Series Regression Months 1 2 3 4 5 6 7 8 9 10 11 12 Firm's Actual Market share 30 32 33 34 28 33 29 27 32 33 28 33 7. Which of the following forecasting method will you use? 8. What are your basis in choosing for your forecasting techniques? Explain briefly. ONLY DO 234
Q: Rick Jerz is attempting to perform an inventory analysis on one of his most popular products. Annual…
A: Annual demand, d =5000 units Carrying cost, h =$50 per unit per year Ordering cost, o =$30 per order…
Q: (a) (b) State the optimal delivery plan and cost. Contactgear must change couriers for the Selangor…
A: The transportation model is used to calculate the minimum cost of the route by selecting different…
Q: b) As a purchasing manager of a big retailer that operates a chain of grocery stores, discuss four…
A: SCM:- A solid supply chain management (SCM) system can help you with both of these goals. In this…
Q: Chester’s a local butchery expects to sell 419 675 kilograms of meat for the year 2022. Carrying…
A: Given data: Annual Demand (D) = 419675 kg Carrying Cost ( Ch) = Rs 16.25 per Kg Ordering Cost (Co)…
Q: In an expansionist strategy, if the demand is increasing and the time between increments increases,…
A: An expansion strategy can be stated as the synonym of a growth strategy. An organization seeks to…
Q: is the bottleneck. b) The bottleneck time is minutes per unit (round your response to two decimal…
A: Processing time = 60 minutes/Capacity Sewing = 60/1.8 = 33.33 minutes per unit Sanding = 60/5 = 12…
Q: A Quality Analyst wants to construct a control chart for determining whether three machines, all…
A: Given data
Q: Identify and explain the role of three primary stakeholders of a project. Explain the 4 different…
A: The primary stakeholders of the project can be classified as, 1. Customers: These are the people…
Q: Reliance Fresh is sourcing electric tandoori ovens from Panasonic for its Indian retail operations.…
A: Find the Given details below: Given details: Demand Probability 4361 6% 4789 14% 4935 21%…
Q: Explain the need for a robust employee orientation process.
A: The employee orientation process can be stated as the process of initiating newly recruited or hired…
Q: Hart Manufacturing makes three products. Each product requires manufacturing operations in three…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: Chicago's Hard Rock Hotel distributes a mean of 1,000 bath towels per day to guests at the pool and…
A: From the given information, Average daily demand, AVG =1000 bath towels Standard deviation, STD= 95…
Q: b. De Industries. program ming model, and brie explain its as umptic lons and scope
A: Ans) Defining linear programming: Linear programming is a type of mathematical problem in which…
Q: Suppose you want to invest a maximum amount of $20,000 in a portfolio with the objective to maximize…
A: note: only formulation has been asked.
Q: Ned's Natural Foods sells unshelled peanuts by the pound. Historically, Ned has observed that daily…
A: Given data: Mean Daily Demand (d) = 80 pounds Std. Deviation of daily demandσd = 26 pounds Mean…
Q: Given the information below for the manufacturing of two different laptops, calculate the labour…
A: Labor productivity = Total outputs/ Total labor inputs
Q: ts utilized to define IT project
A: Projects involving computer systems, databases, and related infrastructure are all considered IT…
Q: "Nordlund Boat Company has been repairing, refitting, and building custom boats for over 60 years in…
A: Order release = Every 4 weeks Annual demand = 400 units (2 units per day) Working days = Annual…
Q: Consider a fixed period inventory model. The daily demand of the product has a mean of 30 and…
A: Given, Average daily demand, AVG =30 Standard deviation, STD =4 Orders are placed, r =18 days Lead…
Q: Examine how a project manager should handle change requests and procurements.
A: Definitions: Change request: - A change request is when an employee of a company suggests a change…
Q: Explain project portfolio management
A: If there are various projects run by the company, it is essential for the companies to control their…
Q: Provide the reason why these two types of security (Importance of Operations and Physical Security)…
A: Operations are the core functioning of the importance of the organization. Every task that is to be…
Q: Reverse logistics is important in managing the supply chain. Distinguish between forward logistics…
A: Reverse logistics:- Reverse logistics refers to the series of steps necessary to recover value and…
Q: take a look at some of the products that are offered for sale there. What are some of the logistical…
A: In contrast to Amazon, which is largely a shop, Alibaba is a platform that connects buyers and…
Q: analyse the characteristics of different organisational structures
A: An organizational structure can be stated as the system that shapes or frames how particular tasks…
Q: small project consisting of ten activities has the following characteristics: Determine the…
A: Ans) PERT Table Formula: PERT Table Excel Formula: PERT Table Calculation: Arrow on node…
Q: What is the Ealiest and Latest start for Activity I and Latest finish for Activity G?
A: Formulae used: Forward Pass- Early Start (ES) = Maximum (or Highest) EF value from immediate…
Q: Which one of the following statements is more of a general characteristic of a service organization,…
A: Operation management often called OM can be stated as the administration or legislation of business…
Q: Explain why businesses should internalise production within the firm and what are the transaction…
A: Business is unpredictable and dynamic in nature. All processes and systems that are happening inside…
Q: An electronics firm produces two models of pocket calculators: the A-100 (A), which is an…
A: Decision Variable: Suppose- A be the no. of A-100 model pocket calculator to be produced each…
Q: Great Harvest bakery distributes an average of 1,000 breads per day to local stores and restaurants.…
A: Safety stock is a stock that company hold and store for the emergency during shortage.
Q: Explain how you would apply ‘controlling’as a process management activity to a project you have been…
A: Controlling can be stated as one of the key functions of management. The prime objective of…
Q: Rick Jerz is attempting to perform an inventory analysis on one of his most popular products. Annual…
A: From the above given information, Annual demand, d =5000 units Ordering cost, o =$30 Holding cost, h…
Q: The information of a project is shown below. Activity A, 7 days, 13 workers, IP =none Activity B, 3…
A: Activity Duration Immediate Predecessor A 7 - B 3 - C 4 - D 3 A E 6 B F 8 C
Q: Explain in your own words at least 3 important reasons why need to study Productions and Operations…
A: Operations management can be broadly defined as an approach the involves the understanding of nature…
Q: What are the most crucial considerations to bear in mind while doing performance testing?
A: Ans) Performance Testing is very crucial. It helps in knowing the scalability, Responsiveness,…
Q: Briefly Explain Risk Management, How you will calculate Risk in Logistical Operations and what are…
A: Risk Management: Logistics risks are major risks and it is related to production,…
Q: Offer, acceptance, and consideration are necessary elements of: OA. a warranty a representation OB.…
A: A warranty can be stated as the written promise from the organization or an individual to provide…
Q: Tobacco is shipped from North Carolina to a cigarette manufacturer in Cambodia once a year. The…
A: From the given information, Service level, α = Stock out cost÷Stockout +holding cost…
Q: Three departments-milling (M), drilling (D), and sawing (S)-are assigned to three work areas in…
A: As an operational technique, location planning strives to increase productivity and safety by…
Q: a. Identify the feasible solution. b. Obtain the optimal solution. Note: Assumer or determine the…
A:
Q: Vell Inc. uses lean principles to reduce cycle time. Through production improvements the process…
A: a) Process time refers to time actually used to work on the product Move time refers to time…
Q: Mr. Peter, of PM Enterprises, has an ice cream manufacturing facility located in downtown…
A: In searching for a core supplier, Mr peter needs a necessary negotiation skill, here, to better…
Q: 3c. Customers arrive at a Starbucks that has 1 barista and they wait in line on a first-come, first-…
A: Given, Arrival rate,λ =12 per hour Service rate, μ=3.5×60 =17.14 customers per hour Standard…
Q: A local nursery, Greens, uses 1,780 bags of plant food annually. Greens works 52 weeks per year. It…
A: Given data, The annual usage=1780 bags This local nursery works 52 weeks per year, The cost to…
Q: Assess the costs of quality that could be incurred if root problems are not addressed.
A: Cost of quality can be termed as the methodology which would measure, determine how various firms…
Q: The activities required to service a car at a dealer can be viewed as a mini-project summarized in…
A: A network diagram is a visual representation of a project which helps to identify the activity…
Q: What are major factors to consider when designing logistics strategy
A: Logistics management is described as a means through which the supply chain is operated and managed.…
Q: Question Four (4) You have been appointed as a member of the Evaluation Committee at your…
A: Evaluation:- A subject's validity, worth, and relevance are methodically assessed through the use of…
Q: Period Gross requirements 1 20 total Tele an Costs 101 2 3 40 Period Gross requirements On-hand at…
A: Ans) Concept: Gross Requirements is first satisfied by on hand at beginning of period. On hand at…
PLEASE DO THIS BY EXCEL AND COMPLETE SOLUTION AND FORMULAS. I WILL UPVOTE THANK YOU
Step by step
Solved in 4 steps with 7 images
- A small computer chip manufacturer wants to forecast monthly ozperating costs as a function of the number of units produced during a month. The company has collected the 16 months of data in the file P13_34.xlsx. a. Determine an equation that can be used to predict monthly production costs from units produced. Are there any outliers? b. How could the regression line obtained in part a be used to determine whether the company was efficient or inefficient during any particular month?Suppose that a regional express delivery service company wants to estimate the cost of shipping a package (Y) as a function of cargo type, where cargo type includes the following possibilities: fragile, semifragile, and durable. Costs for 15 randomly chosen packages of approximately the same weight and same distance shipped, but of different cargo types, are provided in the file P13_16.xlsx. a. Estimate a regression equation using the given sample data, and interpret the estimated regression coefficients. b. According to the estimated regression equation, which cargo type is the most costly to ship? Which cargo type is the least costly to ship? c. How well does the estimated equation fit the given sample data? How might the fit be improved? d. Given the estimated regression equation, predict the cost of shipping a package with semifragile cargo.The management of a technology company is trying to determine the variable that best explains the variation of employee salaries using a sample of 52 full-time employees; see the file P13_08.xlsx. Estimate simple linear regression equations to identify which of the following has the strongest linear relationship with annual salary: the employees gender, age, number of years of relevant work experience prior to employment at the company, number of years of employment at the company, or number of years of post secondary education. Provide support for your conclusion.
- 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?An antique collector believes that the price received for a particular item increases with its age and with the number of bidders. The file P13_14.xlsx contains data on these three variables for 32 recently auctioned comparable items. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Is the antique collector correct in believing that the price received for the item increases with its age and with the number of bidders? Interpret the standard error of estimate and the R-square value for these data.A trucking company wants to predict the yearly maintenance expense (Y) for a truck using the number of miles driven during the year (X1) and the age of the truck (X2, in years) at the beginning of the year. The company has gathered the data given in the file P13_13.xlsx. Note that each observation corresponds to a particular truck. Estimate a multiple regression equation using the given data. Interpret each of the estimated regression coefficients. Also, interpret the standard error of estimate and the R-square value for these data.
- 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?Management of a home appliance store would like to understand the growth pattern of the monthly sales of Blu-ray disc players over the past two years. Managers have recorded the relevant data in the file P13_33.xlsx. a. Create a scatterplot for these data. Comment on the observed behavior of monthly sales at this store over time. b. Estimate an appropriate regression equation to explain the variation of monthly sales over the given time period. Interpret the estimated regression coefficients. c. Analyze the estimated equations residuals. Do they suggest that the regression equation is adequate? If not, return to part b and revise your equation. Continue to revise the equation until the results are satisfactory.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_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 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 P14_01.xlsx contains data on 100 consumers who drink beer. Some of them prefer light beer, and others prefer regular beer. A major beer producer believes that the following variables might be useful in discriminating between these two groups: gender, marital status, annual income level, and age. a. Use logistic regression to classify the consumers on the basis of these explanatory variables. How successful is it? Which variables appear to be most important in the classification? b. Consider a new customer: Male, Married, Income 42,000, Age 47. Use the logistic regression equation to estimate the probability that this customer prefers Regular. How would you classify this person?