QUESTION 9 The following is the actual sales for Manama Company for a particular good: t Sales 19 23 3 22 4 27 5 34 The company wants to determine how accurate their forecasting model, so they asked their modeling expert to build a trend model. He found the model to forecast sales can be expressed by the following model: Ft= 5+2.4t Calculate the amount of error occurred by applying the model is: Hint: Use MSE (Round your answer to 2 decimal places) 1 2
Q: a. The probability there are no cars in the system. b. The average number of cars waiting in line.…
A: Given that Arrival rate = 2 per hour Service rate = 3 per hour
Q: 2- Quality Control Charts A local brewery and bottling plant wants to keep track of the bottling…
A: Control charts representing a a statistical tool which helping to measure the controllability of a…
Q: This large business has 127 employees, 19 of whom are managers or supervisors; its reduced…
A: Productivity is the relationship between the volume of the input and output that is calculated in…
Q: The following tables show the relevant information for the distribution of products from the plants…
A: Draw a transportation network for the given problem as shown below:
Q: Discuss the differences in effective communication methods, if any, between communicating…
A: A project is described as a sequence of activities that must be achieved to attain a particular…
Q: ulent activities in procurement processes and determine possible ways of preventing such fraud
A: Falsely acquiring an advantage, evading a duty, or causing damage to public property by whatever…
Q: To achieve compliance with a new industry standard, a company develops a five-year plan in which…
A: Organizational change can be stated as the activities or actions in which an organization or…
Q: Calculate the normal time for each element.
A: NORMAL TIME = Mean time* Rating factor* Frequency
Q: A company wants to hire 4 vendors for the sale of 4 products, they could only sell one type of…
A: Find the Given details below: Given details: Seller Product 1 2 3 4 1 14 5 8 7 2 2 12 6 5…
Q: A restaurant serves an average of 623 desert (leche flan) servings every week. The manager places…
A: The current order quantity =1000 servings, Average weekly demand=623 servings, Let me assume the…
Q: mitted for this question are all incorrect
A: Given: Input information 4 5 6 7 8 Planned input 60 70 70 80 80 Actual input 15 25 25 30 30…
Q: A company annually uses 1,200 of a certain spare part that costs $25 for each order and has a $24…
A: The EOQ is the number of items that a company can order from a supplier without incurring inventory…
Q: Questions 1. What is the optimal solution? 2. What is the total estimated net present value at the…
A: Here, LP formulation data are given, I would use the Ms Excel solver to solve this problem, This is…
Q: what are the futuristic planning and it's implementation of Apple Inc!?
A: Top-performing corporations know that purpose is both a differentiating factor & is a must-have.…
Q: how to interpret the 2.31 (EFE)
A: Here, by taking the values of the weights and rating the total sum value is coming 2.24 and not…
Q: Bruno Fruscalzo decided to start a small production facility in Sydney to sell gelato to the local…
A: Note: - Since we can answer only up to three subparts we will answer the first three subparts(a, b,…
Q: pose now that the unit cost for every speaker is $11 if less than 10,000 speakers are produced, $10…
A: Consider basic EOQ model The total cost per unit time is TJ Unit cost is CJ TJ=dKQ+dcj+hQ2 for…
Q: How is the production of services different from the production of manufactured goods?
A: Service production is the process of delivering the services to the final consumers. Goods…
Q: what issues should expatriate focus on in making decision?
A: Decision making is the course of creation choices by classifying a decision, congregation…
Q: Jasmine has extensive experience and knowledge in ergonomic product design. Though she is not a…
A: Jasmine has extensive experience and knowledge in ergonomic product design. Though she is not a…
Q: What is the optimal order quantity for MBC? Q* = 20,000 How frequently should MBC order to…
A: Here, The given data, ordering cost for each order=300, lead time=10 days, holding cost per gallon…
Q: 11. Hart Manufacturing makes three products. Each product requires manufacturing operations in three…
A: Suppose- P1= No. of units produced of Product 1 P2= No. of units produced of Product 2 P3= No. of…
Q: 15. Does contract farming happen when individuals or a group of farmers enter formal (written) or…
A: Contractual farming is used for a long period of time and it is also very popular in recent years.…
Q: Describe the difficulties that governments and organizations confront in dealing with transportation…
A: In the context of the freight industry, security has been always a major concern. Illegal…
Q: State and explain 2 reasons why we work.
A: Work is nothing but the process of doing something which in order to make money or to obtain goals…
Q: Why do today’s workers need to be resilient and flexible?
A: Being adaptable generally means that an individual has the ability or willingness to change in order…
Q: You are required to write a SERVICE or PRODUCT LINE of a POULTRY CHICKEN FARMING which will convince…
A: Poultry chicken farming is a highly viable business in Australia. The demand for chicken meat and…
Q: You have an idea for a new web service that offers customized workouts for subscribers. Build a…
A: given, subscription volume = 60 months total market potential = 100,000
Q: Eggs in the poultry farm Dresses in a ready-to-wear shop Fresh fruits in a market stall Chairs in a…
A: An inventory is a list of all the items in a specific location. The term is often used in business…
Q: nd the benefits and opportunities available to suppliers and the end customers. Use Toyota and…
A: The success of this worldwide supply chain hinges on logistics. For Toyota's supply chain, a…
Q: the manpower requirement for each activity in a construction project is given in the attached table.…
A: Given data is
Q: If you are managing a large project, would you prefer Gantt charts or PERT/CPM charts to represent…
A: Two typical project management visualization tools are PERT and Gantt charts. Both of these diagrams…
Q: Describe the Project Benefit Realization process.
A: Benefits realization management (BRM) is a program that helps in measuring the added value of the…
Q: Q.3.1 Gill Enterprises produces a number of consumer items, including a stove. A key component of…
A: Economic Order Quantity is that level of inventory at which Carrying Cost and ordering cost are…
Q: What is the objective of operational planning?
A: Operational planning is the planning that provide the detailed and key activities and tasks that…
Q: Make a visualization using excel and interpret (show the step by step process in excel)
A: In the above table, we have Sales data for cell phones and accessories, these data are presented…
Q: ABC Company placed an order on December 1. It normally receives the order after 9 days. If the…
A: The reorder point is the level reached at which the order is placed to replenish the inventory…
Q: Why managers are concerned with timing when scheduling production?
A: Time is money. This opinion is not just a cliché. The timely production of goods and services is…
Q: Discuss Sseko’s social entrepreneurship model and how it differs from traditional charitable…
A: Entrepreneurship models are constantly evolving as new technology and ideas enter the marketplace.…
Q: /Find the optimal solution of the following (T.P) by using Least-Cost method. 40 50 70 90 90 100 120…
A: Given data is
Q: Discuss Hoshin Planning its implementation, types and benefits with company examples?
A: Since you have asked two questions, we will solve the first question for you. If you want any…
Q: Company Z is contemplating a product development program encompassing 6 major projects. The company…
A: Here, let me formulate the Linear programming problem, Decision variable: Project 1 is 1, If…
Q: The local driver's license center processes applications for driver's license renewals through the…
A: Given data: Step 1 = Receptionist Process time = 3 minutes per customer No. of resources = 1 Step 2…
Q: ng being applied in the
A: Dynamic Programming This is a notion that almost all computer programmers have run across at some…
Q: Critically analyse the compensation system in an organization of your choice and suggest improvement…
A: Compensation system is giving rewards to the employees who are working in an organization. Rewards…
Q: why e-commerce self-service remains unpopular
A: ‘Self-service’ is the capability for consumers to serve themselves. This is applied mainly to…
Q: Amber's Fabrication has the following aggregate demand requirements and other data for the upcoming…
A: In chase plan production is always kept more than the demand (thats why it is called as chase as…
Q: What is meant by Design planning?
A: Design planning process is an essential part of the project. A proper design plan brings benefits to…
Q: ROP With Variable Demand and Lead Time Data Risk of Stock Out Assume the maximum risk of stock out…
A: “Since you have asked multiple question, we will solve the first question for you. If you want any…
Q: Which of the following can affect the ways in which learning curves may be applied? Multiple Choice…
A: A learning curve can be stated as the notion or conception that graphically represents the…
Trending now
This is a popular solution!
Step by step
Solved in 4 steps
- 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.Under what conditions might a firm use multiple forecasting methods?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_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?Do the sales prices of houses in a given community vary systematically with their sizes (as measured in square feet)? Answer this question by estimating a simple regression equation where the sales price of the house is the dependent variable, and the size of the house is the explanatory variable. Use the sample data given in P13_06.xlsx. Interpret your estimated equation, the associated R-square value, and the associated standard error of estimate.
- The file P13_25.xlsx contains the quarterly numbers of applications for home mortgage loans at a branch office of Northern Central Bank. 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? Is it guaranteed to produce better forecasts for the future?The file P13_19.xlsx contains the weekly sales of a particular brand of paper towels at a supermarket for a one-year period. a. Using a span of 3, forecast the sales of this product for the next 10 weeks with the moving averages method. How well does this method with span 3 forecast the known observations in this series? b. Repeat part a with a span of 10. c. Which of these two spans appears to be more appropriate? Justify your choice.2. What is the Mean Absolute Deviation (MAD)? 3. Use the following set of data to calculate the Mean Absolute Deviation (MAD) for the following set of data. Month Actual (At) Forecast (Ft) Forecast Error Absolute (Deviation) Forecast Eror January February 45 45 42 50 March 34 45 April May 48 40 38 45 MAD =