Month Sales (000) Unites Feb 19 Mar 18 Apr 15 May 20 Jun 18 Jul 22 Aug 20 Forecast September sales volume using a weighted average approach using 0.60 for August, 0.30 for July, and 0.10 for June.
Q: What types of information are needed by an inventory manager when making decisions within his or her…
A: A manager of inventory is in charge of overseeing product stock levels. They prepare the sizes of…
Q: 3) Consider the assignment problem having the following cost table. Assignee A B C D a) Formulate…
A: Part (A): Decision Variables: Suppose-Xij be the decision variable, where assignee (i=1,2,3,4)…
Q: Stanford Rosenberg Computing wants to establish an assembly line for producing a new product, the…
A: Given data is Production goal = 180 PDAs
Q: Suppose company’s manufacturing facility has a design maximum of 245 clients per week. Its actual…
A: Capacity utilization is the measurement rate which uses to analysis the percentage of company's…
Q: What ethical, social, and political issues are raised by information systems? What specific…
A: Ethical, social and political issues are interrelated. These issues cannot be talked about in…
Q: Find a Doctor is a small startup that helps people find a physician who best meets their needs…
A: Queueing theory is a part of operations management. It is studied and executed to determine the…
Q: You know that the average defect rate for a pen producer is 0.018. This production process is…
A: Upper control limit refers to greater value of maximum value . It is shown in the control chart.
Q: Manufacturing standardized products tends to be customized products. O Aless; larger OB. more;…
A: A standardized product is one that, regardless of the firm that manufactures it, consumers perceive…
Q: What is the number of customers waiting in the queue on average?
A: Given, Arrival rate a = 24 / hour Service rate s = 2 min / customer = 60/2 = 30 / hour
Q: Use the Inventory Control information above to answer this question. Since it costs $0.50 to store a…
A: Given, Demand D = 20000 copies Cost to store book for an year = $0.5 Setup S = $200 x = number of…
Q: Wreckem Industries Inc., is a company that markets calculators to universities. Mr. Red, it's CEO,…
A: Given, Annual demand D = 100000 Order cost S = $10 Carrying cost H = $2 Number of days = 250 days…
Q: Content Audit: Propose the type of content audit you recommend be undertaken as part of the effort…
A: Introduction: Content audit is a very useful and important approach to determine the efficiencies of…
Q: a) What is Baker's inventory turnover? _______ times per year (round your response to two…
A: Given, Inventory turns = 13 times per year Assets invested = 8% Baker Mfg. Inc. Net…
Q: a) the 10th transplant b) The cost of 10th surgery to Beth Zion Hospital = $ 10.40 hours (round your…
A: Given : Learning rate = 75% Time required for the first transplant = 27 hrs
Q: Supply chain management covers the planning and execution of processes required to execute a…
A: Supply chain management, which covers all procedures that convert raw materials into finished…
Q: Question 1 You are given the following information about a wooden crate that is being shipped to by…
A: Given- Rate = $6 pounds w/mWeight = 200 poundsShipment Dimension-L = 30 inW = 40 inH = 36 in
Q: Custom Fabrication recorded the following information on their defects from their Quality Control…
A: Given, Reason Count Software error 69 Machine error 19 Material defect 27…
Q: 1 10 3 10 (b) 2 4 1 10 67 2 12 5 11 10
A: The transportation model is used to calculate the minimum cost of the route by selecting different…
Q: You work for shipping company ABC and your company is shipping 15 bottles of cylinders and 20 crates…
A: A dangerous products specialist is in charge of marking and packing hazardous commodities in…
Q: Activity A B C D E F G Expected Completion Time (minutes) 5 2 7
A: Ans) Possible Paths from start to end: 1) A-C-F-H-I = 5 + 6 + 2 +8 +4 = 25 2) A-D-G-I = 5+9+7+4 =…
Q: The Dubuque Cement Company packs 80-pound bags of concrete mix. Time-study data for the filling…
A: Remember the formula: Mean time = Average of all valid observationsNormal time = Mean time ×…
Q: A farmer is considering planting live possible crop mixes. The outcomes depend on the weather (dry,…
A: Given- Dry Average Rainy Mix A -1 1 9 Mix B 1 -1 5 Mix C -1 5 4 Mix D 2 2 3 Mix E 5 3…
Q: ue to a product using either Porter’s or Hines’ model.
A: Michael Porter created the value chain, commonly referred to as Porter's Value Chain Analysis, as a…
Q: ctional organizations. Describe the effects of each structure on proj
A: Organizations may be generically categorized into three types: matrix, projectized, and functional.…
Q: forecasting
A: b.2
Q: Suppose an Excel spreadsheet model has been partially created as shown below. A 1 2 3 4 5 6 7 8 9 10…
A: Given, A table of lead time with cumulative probability. Vertical Lookup is referred to as VLOOKUP.…
Q: Suppose you work in a textiles factory. You know that it's normal for machines to print an average…
A: Business operations require some tools and techniques to have an insight into their chances of…
Q: Was this a negligent hire? Why or why not? If the employee came to work one day under the influence…
A: 1) This did not at all involve a negligent hiring decision. The employer verified the employee's…
Q: fish distributor is trying to perfect his business to maximize the money he saves. Daily fish sales…
A: Given data: Mean (μ) = 250 Standard deviation (σ) = 30 Purchase cost = $1.65 Selling price = $4.50…
Q: The NRC (National Research Council) of Canada is sending out a request for proposal for a very large…
A: Here, there are two different questions, as per the said guideline, The first question is taken for…
Q: Mark Gershon, owner of a musical instrument distributorship, thinks that demand for guitars may be…
A: Given data is
Q: What is the probability of completion of the project before week 42?
A: A network diagram related to the project is which shows the set sequence of the task that is done to…
Q: First Printing has contracts with legal firms in San Francisco to copy their court documents. Daily…
A: Given- Daily Demand (d)= 8,600 pages of documentsLead Time (LT)= 1 dayStandard Deviation (σ)=1…
Q: The "Eclectic Paradigm" by John Dunning identifies three categories of gains from international…
A: The eclectic paradigm is an economic and commercial strategy for evaluating the desirability of…
Q: K Consider a firm with an annual demand of 6000 units, a setup cost of $20 per order, and an annual…
A: Annual demand(D) = 6000 setup cost(S) = $20 Holding cost(H) = $2 Purchase cost = 1200
Q: a) Formulate a balanced transportation problem that can be used to minimize Gursoy Cars'…
A: The transportation model is used to calculate the minimum cost of the route by selecting different…
Q: What is the length of the critical path? What is the slack for task E?
A: A network diagram related to the project is which shows the set sequence of the task that is done to…
Q: Typed solution The product design group of Iyengar Electric Supplies, Inc., has determined that it…
A: Total cost = Fixed Cost + Variable costFixed cost for Low tech = $40,000Fixed cost for Subcontract…
Q: The Vice President of the Republic of Zambia launched a pilot project to clear canals on the Barotse…
A: Benefits from any project are of two types namely: Tangible Benefits - As the term says tangible…
Q: A manager tracked equipment failures and found 1 failure on 12 days, 2 failure on 11 days, 3…
A: Given data: Equipment Failure (x) Frequency 1 12 2 11 3 9 4 7
Q: Kelly-Lambing, Inc., a builder of government contracted small ships, has a steady work force of 10…
A: Total time available = 2440×10= 24400 hours (given)Time taken in completing 1st boat = 6100…
Q: A certain type of chair costs $10, and the annual carrying cost rate is 0.20. Annual demand is 12,…
A: Given data is Annual demand (D) = 12 Order cost (S) = $3 Carrying cost (H) = 0.20%(10)=$2
Q: Your manager is keen to improve your company's supply chain management, in particular to reduce…
A: Supply Chain Management - In general, it is signified as the storage and movement of raw materials…
Q: What is the Late Start on Activity C? What is the slack on Activity C? What is the slack on…
A: A network diagram related to the project is which shows the set sequence of the task that is done to…
Q: your company is facing the situation in which the demand is stochastic but the lead time is known…
A: Inventory management is a wide concept under operations management. By just reading this term, it…
Q: A flow shop is characterized by the: Few-standard product variety Many, unique set-ups Low…
A: In a flow shop, the production procedure adheres to a predetermined linear framework, and this…
Q: K sequence? OA. V OB. T O C. S OD. U OE. R Job RSTU> V Alpha 20 19 50 26 11 Beta 22 35 20 26 75
A: Given-
Q: Professor Very Busy needs to allocate time next week to include time for office hours. He needs to…
A: Forecasting is a technique used in business operations where past data patterns are recognized and…
Q: What is the expected monetary value (EMW) of taking Airlines 1&2? Airline -1 (Fare $700, on-time…
A: The statistical meaning/concept of expected monetary value (EMV) assessment determines the…
Q: Just what does "test strategy" entail?
A: There are two important categories that must be taken into consideration before beginning a software…
ABC Inc. sells patio sets. Monthly sales for a seven-month period were as follows:
Month | Sales (000) Unites |
---|---|
Feb | 19 |
Mar | 18 |
Apr | 15 |
May | 20 |
Jun | 18 |
Jul | 22 |
Aug | 20 |
Step by step
Solved in 2 steps
- 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_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_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 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_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?
- 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?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.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?
- 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_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.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?