1. A company would like to develop an aggregate plan and evaluate its cost using the transportation method. Solve using Excel of the QM software. Note: do not do this manually Related data are shown in the tables below Demand forecast Period Demand (Unit) 1 2 3 Period 1 2 3 Supply Capacity available (units) 80 90 40 Other Data Regular time 40 65 30 Beginning Inventory Regular-time cost per unit Overtime cost per unit Subcontract cost per unit Carrying cost Overtime 20 12 10 30 R 100 R 150 R 200 R 5 Subcontract 10 5 5
Q: Critique the demand management and forecasting as an effective tool to avoid stock outs
A: Demand management is a supply chain process that helps the company forecast and manage the demand…
Q: Consider the following model. Maximize subject to x₂ + x₂ x1 x₂ + x3 Z = 4x₁ + 8x₂ + 10x3 + 6x4 x3 +…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: a. Determine each alternative's break-even point in units. b. At what volume of output would the two…
A: The breakeven point is the point at which the returns of an investment or business venture equal its…
Q: The following data relate the sales figures of the bar in Mark Kaltenbach's small bed-and-breakfast…
A: Linear Regression Assume X = Guests Y = Bar sales X Y XY X2 16 320…
Q: Laplace Criterion? Minimax Regret?
A: Mathematic models of decision-making help businesses take the correct decision for their operational…
Q: A renovation of the gift shop at Orlando Amway Center has six activities (in hours). In the…
A: The given data as follows: Activity a m b A 10 15 19 B 28 31 40 C 18 18 18 D 9 13 18 E…
Q: Article 1: South African pears will soon be on sale in China for the first time • Consumers in China…
A: Mainly, the company can use two transport modes to get their products to China, they are airways and…
Q: What is the time constraint?
A: Linear programming is a mathematical technique that is also used in operations management…
Q: (i) Determine the upper and lower control limits for an X-Bar chart and R-chart with a sample size…
A: X-bar chart: The x-bar chart is used to track one variable over time. It can be used for tracking…
Q: The following are monthly actual and forecast demand levels for May through December for units of a…
A: Given data: Month Actual Forecast May 100 100 June 78 104 July 108 97 August 112 104…
Q: Solve the linear programming problem by the simplex method. Minimize x-7y subject to the constraints…
A: Min Z = x + 7 y subject to 2 x + 5 y ≥ 30 - 3 x + 5 y ≥ 5 8 x + 3 y ≤ 85 -…
Q: You are trying to forecast the future production cost in your department. You observed that in the…
A: Given data is
Q: A cafeteria serving line has a coffee urn from which customers serve themselves. Arrivals at the urn…
A: Given data is Arrival rate (lambda) = 2 per minute Service rate (mu) = 25 seconds = 6025=2.4 mins
Q: Explain how to run a company with good structure and quality management as a operation manager with…
A: The things an operation manager follows to run a company with a good structure are -: 1. To look…
Q: Fill in the table below for maximum and minimum profit payoffs under each model. Round your answers…
A: Decision-making is a complex process. It requires the consideration of many variables and various…
Q: Disucss the functions of operation management in the manufacturing and production in any company.…
A: The role of operation management is to see that resources are properly transformed into goods and…
Q: A Omani Olive oil merchant imports two Olive oil brands, A and B, from Barazil, then blends and…
A: Due to the different proportions of oils in brands G and N, the decision variables will be as…
Q: invest a total of $50,000. Because of the risk, he will limit his investment in oil leases and…
A: Linear programming is an optimization technique that can be used when there are limited resources…
Q: A project manager is in charge of 3 ongoing projects, A, B, and C. Due to recent reorganization, the…
A: Let, A = Number of employees assigned to Project A B = Number of employees assigned to project B C =…
Q: Up, Up, and Away is a producer of kites and wind socks. Relevant data on a bottleneck operation in…
A: Given data: No. of machines = 4 No. of shifts = 2 shifts per day No. of hours in a shift = 8…
Q: Imagine a company that has a corporate strategic goal of operating a new food delivery service line.…
A: Imagine a company that has a corporate strategic goal of operating a new food delivery service line.…
Q: Which option (a, b, c, or d) shows the correct objective function and constraints for this…
A: Linear programming is a mathematical optimization technique for determining an optimal solution to a…
Q: Maximize C = 16A +218 subject to 9A +15B ≤ 22 10A + 3B ≤ 29 and A≥0, B20. What is the optimal value…
A: The graphical method of solving linear programs is a technique that uses graph paper and pencils to…
Q: information be made available to everyone through public records?
A: Information Sharing is a Crucial part for a firm to know its stay in the market.
Q: Consider the following OLS regression results, ĝ-10.46+0.271x, R²-0.13. Calculate the predicted…
A: In given equation: y= 10.46+0.271x 10.46 is the intercept 0.271 is the slope y is the dependent…
Q: A grocery store manager must decide how to best present a limited supply of milk and cookies to its…
A: The detailed solution is given in Step 2
Q: one of your projects team members is highly regarded for her skills in the company. she is assigned…
A: A high-visibility project means that the project is highly important for the company and in market…
Q: Which is a viable strategy to manage an intermittent flow system better?
A: Note: We are required to do one question only. The intermittent flow system is different from the…
Q: Comfort Zone Furniture has plants in Boston, Dallas and Seattle, ich ship their production to four…
A: The transportation model is used to calculate the minimum cost of the route by selecting different…
Q: Chiltern Farms “[T]he beautiful valley of Vyeboom nestled between the majestic Franschhoek Mountains…
A: The case is about a firm that grows and packs fruits for local and international markets. The…
Q: Problem #1 Name: Frank Smith Date 4/6 4/7 4/8 4/9 4/10 4/11 In 8:00 8:00 7:45 7:45 8:15 10:00 Out…
A:
Q: Which of the following statements is NOT true? O A feasible solution satisfies all constraints. An…
A: Feasible solution in linear programming problem indicating the region which satisfy all constrain…
Q: enterprise wide risk management system (EWRMS) with particular emphasis on how this differs from a…
A: Basic risk management Organizations with…
Q: 8. The capacity of a process is determined by OA. the flow of materials. OB. the maximum of the…
A: A process is any sequence of steps that produces a specific outcome.
Q: In the problem on excel : 1.What are the decision variables 2.What is the objective functions 3.…
A:
Q: Calculate the forecasted sales revenue for May using the following data. Month Sales…
A: Here, the data set contains the month column and sales revenue column, the dataset table is…
Q: 6. A business hands out promotional fliers to 15,000 people. It is estimated that of those they…
A: Number of people to whom promotional fliers are handed = 15000 people Percentage of individuals who…
Q: Compute the (s,Q) ordering policy that gives a 95% service level and the annual cost of the safety…
A:
Q: The total completion time is 25 days. Task A is planned to take seven days. Task B is planned to…
A: Slack time is the time that is free from work. This can be used to take care of personal needs, such…
Q: 6. Marina also wants to insert a PivotTable that includes other Customer information so that she can…
A: The given excel sheet is prepared in excel as follows. Please note that only visible data (up to row…
Q: Given the following table solve by vogel approximation method
A: The transportation model is used to calculate the minimum cost of the route by selecting different…
Q: An airline trying to make customers happy, always had their plane dock at a gate close to the…
A: The given scenario is about process improvement using innovative ideas. Here, the passengers reach…
Q: A retired couple supplement their income by making fruit pies, which they sell to a local grocery…
A: Decision Variables: Suppose-A be the no. of apple pies producedG be the no. of grape pies produced…
Q: Discuss how the Sixty60 service is a logistics link in the value chain of Checkers.
A: Shoprite group has entered into a joint venture with its existing checkers sixty60 logistics…
Q: Level 1. Determine the gross requirements for each of the items if the demand for Omega is 100…
A: Note: - Since the exact question that has to be answered is not specified we will answer the first…
Q: Lincoln Electric Inc. has a direct manufacturing cost of $147/welding unit and defective units can…
A: yield = output/input yield = 100% - scrap rate scrap rate = % of non workable X (total…
Q: Office Automation Inc., developed a proposal for implementing a software system that will…
A: NOTE: We are allowed to do first 3 sub-parts only. In project management, a critical path is the…
Q: Consider the following LP problem developed at Zafar Malik's Carbondale, Illinois, optical…
A: Given data is Objective function: Max Z=1X1+1X2 Subject to constraints: C1.) 2X1+1X2≤100C2.)…
Q: You are a mass merchandiser based out of Dubai. You deal in multiple products ranging from…
A: 1. Taichi Ohno Framework: According to Taichi Ohno, there are seven wastes in production.…
Q: Rent’R Cars is a multisite car rental company in Huntsville/Madison area. It is trying out a new…
A: Find the Given details below: Transportation table From To D E F G Supply A $…
Step by step
Solved in 4 steps with 5 images
- 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?TIRES FOR YOU - Forecast & EOQ Forecast Tires for You, Inc. (TFY), founded in 1987, is an automotive repair shop specializing in replacement tires. Located in Altoona, PA, TFY has grown successfully over the past few years because of the addition of a new general manager, Katie McMullen. Since tire replacement is a major portion of TFY's business (it also performs oil changes, small mechanical repairs, etc.), Katie was surprised at the lack of forecasts for tire consumption for the company. Her senior mechanic, Skip Grenoble, told her that they usually stocked for this year what they sold last year. He readily admitted that several times throughout the season stockouts occurred and customers had to go elsewhere for tires. Although many tire replacements were for defective or destroyed tires, most tires were installed on cars whose original tires had worn out. Most often, four tires were installed at the same time. Katie was determined to get a better idea of how many tires to…Matrix uses simple exponential smoothing with S.F = 0.6 to forecast demand. The forecast for the week of Nov 1 was 350 units, whereas the actual demand turned out to be 400 units. Forecast the demand for the week of Nov 8 to week Nov 22 Week Actual Demand Forecast Nov 01 350 400 Nov 08 460 430 Nov 15 501 448 Nov 22 495 479.8 Element of Competency Determine the quantity of raw materials and other products order.
- Thus historical demand for periods is 70, 60, 80 , and respectivelyWhat is the two-period weighted moving average forecast for period assuming equal weights of 0.5 eachI'm trying to determine optimal order quantity but only have a Mean forecast and a standard deviation of it to use for sales data. How would I determine the sales data to use in the optimal order quantity formula?Tasty Bread Company has monthly demand for one of its products as follows: March= 520; April=490; May=550; June=580; July=600; August=420. Compute the three-month moving average for July.
- Tracy is the the Director of Supply Chain at Circuits Inc. An accurate forecast at Circuits Inc. is very important because of the long lead times for raw materials. Tracy has asked you to quickly pull together forecast accuracy information over the last 5 months to share at the upcoming S & OP meeting. Month Demand Forecast 1 1,200 1,150 2 1,750 1,530 2,250 1,962 4 1,600 1,745 1,550 1,628 What is the MAD for month 5? (use 2 decimal places) O Less than or equal to 100 O Greater than 150 but less than or equal to 200 Greater than 250 O Greater than 200 but less than or equal to250Problem 18-3 (Algo) Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note, the 1st quarter is Jan, Feb, and Mar; 2nd quarter Apr, May, Jun; 3rd quarter Jul, Aug, Sep; and 4th quarter Oct, Nov, Dec. Last year This year JAN 150 170 FEB MAR 170 190 190 APR MAY 235 225 175 245 270 Forecast for the third quarter JUN 250 215 SEP 175 AUG JUL 195 185 OCT 250 ▸ NOV DEC 275 2952G MTN Zambia ll 78% 3:30 PM < OperationsManagement_HW1.. 4.12 Consider the following actual and forecast demand lev- els for Big Mac hamburgers at a local McDonald's restaurant: Day Actual Demand Forecast Demand Monday Tuesday Wednesday Thursday Friday 88 88 72 88 68 84 48 80 The forecast for Monday was derived by observing Monday's demand level and setting Monday's forecast level equal to this demand level. Subsequent forecasts were derived by using exponen- tial smoothing with a smoothing constant of 0.25. Using this expo- nential smoothing method, what is the forecast for Big Mac demand for Friday? Px Download- (1.009 9KB) Comments (0) Send More
- Discuss how flexibility in production systems relates to the forecast horizon and forecast accuracy?Prepare a graph of the monthly forecasts and average forecast demand for Chicago Paint Corp., a manufacturer of specialjzed paint for artists.The following table shows the actual demand observed over the last 11 years: Year 1 2 3 4 5 6 7 8 9 10 11 Demand 6 8 4 9 13 8 11 14 9 13 7 Part 2 Using exponential smoothing with α = 0.40 and a forecast for year 1 of 5.0, provide the forecast from periods 2 through 12 (round your responses to one decimal place). Year 1 2 3 4 5 6 7 8 9 10 11 12 Forecast 5.0 5.45.4 6.46.4 5.55.5 6.96.9 9.39.3 8.88.8 9.79.7 11.411.4 10.410.4 11.511.5 9.79.7 Part 3 Provide the forecast from periods 2 through 12 using the naive approach (enter your responses as whole numbers). Year 2 3 4 5 6 7 8 9 10 11 12 Forecast enter your response here enter your response here enter your response here enter your…