The demand manager of Maverick Jeans is responsible for ensuring sufficient warehouse space for the finished jeans that come from the production plants. It has occasionally been necessary to rent public warehouse space, something that Maverick would like to avoid. In order to estimate the space requirements, the demand manager is evaluating moving-average forecasts. The demand (in 1,000 case units) for the last fiscal year is shown below. Month 1 2 Demand 20 18 3 21 4 5 25 24 6 7 8 27 22 30 9 10 11 12 23 20 29 22
Q: Cutlery Corner sells specialty knives to knife enthusiasts. They have a generous advertising budget…
A: T = dollars spent on a TV campaignN = dollars spent on newspaper advertisementsRF = dollars spent on…
Q: Analyze the impact of globalization on quality management practices, considering factors such as…
A: Quality management is the act of supervising numerous roles and operations inside a company to…
Q: A midsize mobile carrier keeps records of complaints received from its customers. Complaints for…
A: The objective of the question is to find out the percentage of complaints that are due to the…
Q: Develop appropriate control charts and determine whether there is any cause for concern in the…
A: Let me show the table data, HourX…
Q: Discussion Questions 1. The discussion of the framework for MPC seems to imply that overall…
A: For question 1, the issue is to decide if setting the general bearing before taking part in itemized…
Q: what are the status filters at the top of the tasks screen in quickbooks online advanced once a task…
A: QuickBooks is the aspect of a business information system that is software concerned with managing…
Q: Describe the basic types of business with their inherent advantages and disadvantages.
A: The objective of this question is to understand the basic types of business structures and their…
Q: A) Formulate this problem as Assignment Model (the objective function and constraint equations for…
A: First, I will formulate the problem as an assignment model, Here, one team can be assigned to one…
Q: Suppose Benihana increases its restaurant seating capacity by 10% and also decreases the length of…
A: Increased seating capacity by 10%: This means Benihana can now accommodate N customers per…
Q: Arguments that labor unions create market conflict that result in less-than-optimal results reflect:…
A: The question is asking us to identify the ethical belief system that would argue that labor unions…
Q: Determine the observed time (OT) for each element. Note: Some of the elements occur only…
A: Let me state the given data, CycleElement12345612.122.22.12.1-2 -1.1 -1 -1.233.43.53.33.53.43.344 -…
Q: discuss what role does project management play in operations management, particularly in the context…
A: Project management is the preparation and organization of an organization's resources to move a…
Q: Understand the role of the project manager by describing what project managers do, what skills they…
A: With the help of project management, we can build a unique value for people and society, Project…
Q: Weekly demand for motors is normally distributed with a mean of 1500 and a standard deviation of…
A: Mean weekly demand = 1500The standard deviation of weekly demand = 1009Assembling and Delivery cost…
Q: When designing a supply chain network, how can organizations intricately balance and optimize…
A: With the help of supply chain networks, firms can see the broad picture and have a better knowledge…
Q: please provide a excel solver solution
A: Set-up of the Excel Model to determine the location of offices is shown :
Q: Identify the industry life cycle that Tupperware is and suggest the strategies that they can employ…
A: The objective of the question is to identify the current phase of the industry life cycle that…
Q: A company has seven products that are processed through 13 types of machines. The table below gives…
A: Find the given details below:
Q: The Childfair Company has three plants producing child push chairs that are to be shipped to four…
A: A transportation problem is a type of linear programming problem that involves determining the most…
Q: Jim's Outfitters, Inc., makes custom western shirts. The shirts could be flawed in various ways,…
A: ShirtsDefects1620374105669718594108
Q: QUESTION 2 The manager of AGO Corporation must decide whether to hire 1, 2, or 3 new workers. He…
A: State of natureDecision (strategy) Number of workersLowMediumHigh150505021006020315070-10
Q: Decision Alternative Maximum Minimum Delphi Inc. $ $ CRM International $ $ Murray Analytics…
A: Let me state the given data, Decision alternativeShortMediumLongDelphi Inc4.24.55.75CRM…
Q: In response to illegal or unethical behaviors of local union officials, the Landrum-Griffin Act of…
A: The objective of the question is to identify the correct provision of the Landrum-Griffin Act of…
Q: Create a table including when during the employee's employment, each specific activity should occur,…
A: Human resource management is the aspect of management that is concerned with managing, supporting,…
Q: Mean and Median are two representative measures for identifying central location. What are the pros…
A: Mean can be understood as the central value or the average of the given numbers. Means can be…
Q: evaluate the need for human resource risk management in the context of South African organisations.
A: Increased scrutiny: South African companies face higher scrutiny from international stakeholders…
Q: QUESTION 5 Choose the answer with the best match. Elements of a Good Forecast, Meaningful:…
A: “Since you have posted a question with multiple sub parts, we will provide the solution only to the…
Q: act negotiator for Nebula Airframe Company, is currently involved in bidding on a follow-up gover…
A: Labor Hour data for the first three units is given below,UnitsLabor Hours120002180031692
Q: A prospective employer reviews an applicant's work history and personal references. In addition, he…
A: Employers may be interested in reviewing a job applicant's credit report for several…
Q: Describe Lewin's Force Field Analysis and provide an example of how it can be used to solve an…
A: Lewin's Force Field Analysis is a strategic management tool developed by psychologist Kurt Lewin. It…
Q: a CRM system: Delphi Inc., CRM International, and Murray Analytics. The costs of the system are…
A: Let me state the given data, Decision alternativeShortMediumLongDelphi Inc4.24.55.75CRM…
Q: What is the reliability of each design in Figures 1 through 3 above?
A: Here, there is a total of three options, Each option has elements, These elements are either…
Q: Topic 1 - SCM STRATEGY & DESIGN a. SCOR might serve as an international supply chain…
A: Supply Chain Operations Reference (SCOR) model is a process reference model developed and endorsed…
Q: A column chart can sometimes be used instead of a line chart for time series data. Select one: True…
A: Data is the aspect of statistics, research, or business that is concerned with information that can…
Q: I am doing a Project Study so please prepare a journal entry sharing your reflections on your…
A: The center issue recognized for this examining project revolves around figuring out the diverse…
Q: 10. How often should person-centered plans be updated? Annually Twice a year Every month As needed
A: Planning is the process of identifying objectives, determining strategies, and developing actions…
Q: quantities of resources used to produce a car and truck. Below are the restrictions on this.…
A:
Q: Jack Welch famously said "Shun the incremental; go for the quantum leap"; the quantum leap being…
A: Production management is the aspect that deals with all the activities and functions of the…
Q: Describe project integration management. Briefly describe the strategic planning process, including…
A: Project management is an organized methodology, It includes starting, organizing, executing,…
Q: Discuss the role of location planning in disaster recovery and business continuity planning.
A: Location planning is the process of determining where to establish a business or operation. The goal…
Q: Discuss the role of cross-functional teams in Lean Operations implementation and problem-solving.
A: "Lean manufacturing" is a production method that aims to maximise output while minimising waste in…
Q: What are some common challenges faced by organizations in managing international logistics?
A: International logistics management involves the coordination and movement of goods across borders,…
Q: Explain what strategies can organizations use to improve productivity and reduce production costs?
A: Efficient productivity and cost management are vital for the success of any organization. To enhance…
Q: Topic 4 - PROCESS&TECHNOLOGY AND CAPACITY&FACILITY DESIGNa.Discuss a few objectives of…
A: Facility layout refers to the arrangement of physical facilities such as machinery, equipment,…
Q: The following tabulations are actual sales of units for 6 months and a starting forecast in January.…
A: Find the given details below:
Q: You are the project manager for a smart watch development project. The project has a budget of SAR…
A: It is basically analyzing how a project is performing and planning for the futures. It involves…
Q: Question 1 A company must decide which of its factories to keep operational and how to distribute…
A: The objective of this problem is to determine which factories to operate and how to distribute…
Q: You work for the Brad's Nailer Company which manufactures two types of nailers: a pneumatic model…
A: Find the given details below:
Q: Create an informative infographic page using no less than 7 terms associated with the stages of team…
A: An infographic is the aspect of the information system of an organization that includes all the…
Q: How does productivity management contribute to organizational efficiency and competitiveness?
A: Productivity management is an organizational structure or method that helps individuals and teams…
a. Use a 3-month moving average to estimate the month-in-advance forecast of demand for months 4–12 and generate a forecast for the first month of next year. Calculate the average forecast error and mean absolute error.
b. Use a 3-month weighted moving average with weights of 0.6, 0.3, 0.1 (most recent to least recent, respectively) to calculate month-in-advance forecasts for months 4–12 and forecast for the first month of next year. Calculate the average forecast error and mean absolute error.
c. Compare the average forecast error and MAD for the
Step by step
Solved in 6 steps with 7 images
- 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_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.
- 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?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 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?b. Kim’s department at a local department store has tracked the sales of a product over thelast nine weeks. The demand can be seen in the table below.Period Demand1 242 233 264 365 266 307 328 269 25i. Forecast demand using exponential smoothing with an alpha of 0.3, and an initialforecast of 30.0 for period 2 to 9.ii. Use a 5-period moving average, forecast the demand up to period 9.iii. Using MAD, determine which forecasting technique is better.
- 12-1. The Hartley-Davis motorcycle dealer in the Minneapolis- St. Paul area wants to be able to forecast accurately the de- mand for the Roadhog Super motorcycle during the next month. From sales records, the dealer has accumulated the data in the following table for the past year. Month January February March April Мay June Motorcycle Sales 7 10 8 7 12 July August September 10 11 12 October 10 November December 14 16 a Compute a three-month moving average forecast of demand for April through January (of the next year). b. Compore a five-month moving average forecast for June drough January. c. Compare the two forecasts computed in parts (a) and (b) using MAD. Which one should the dealer use for January of dhe next year?5. Demand for patient surgery at Washington General Hospital has increased steadily in the past fewyears, as seen in the following table. The director of medical services predicted six years ago thatdemand in year 1 would be 42 surgeries. Using exponential smoothing with a weight of 20%,develop forecasts for years 2 through 6. Compute for the MAD.Given the following history, use a three-quarter moving average to forecast the demandfor the third quarter of this year. Note that the 1st quarter is Jan, Feb, and Mar; 2ndquarter Apr, May, Jun; 3rd quarter Jul, Aug, Sep; and 4th quarter Oct, Nov, JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DECLast year 120 140 145 195 205 220 165 155 145 220 245 265This year 140 145 200 210 240 255