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. Is Ben Gibson acting legally? Is he acting ethically? Why or why not?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?SOLVE USING EXCEL Metal Fabricators, Inc. manufactures gas grill tanks, Model # 1420, for four original equipment manufacturers (OEMs). Demand is forecast to be as follows: Quarter 1 = 2,800 tanks, Quarter 2 = 3,400, Quarter 3 = 3,600, and Quarter 4 = 2,900. Due to a hedging program for sheet steel and increases in international tariffs, production cost per quarter vary as follows: Quarter 1 = $23.50 per tank, Quarter 2 = $28.00, Quarter 3 = $25.90, and Quarter 4 = $29.00. Due to production contracts with the OEMs, no shortages are allowed. Beginning inventory for Quarter 1 is 300 tanks. At the end of each quarter, inventory holding costs are $4.25 per tank. a. Formulate the problem as a linear programming model (see Supplement D). b. Solve the model in (a) using Excel Solver.
- 1. Evaluate the current China/Taiwan logistics costs. Assume a current total volume of 190,000CBM and that 89 percent is shipped direct from the supplier plants in containers. Use the datafrom the case and assume that the supplier-loaded containers are 85 percent full. Assume thatconsolidation centers are run at each of the four port locations. The consolidation centers useonly 40-foot containers and fill them to 96 percent capacity. Assume that it costs $480 to ship a20-foot container and $600 to ship a 40-foot container. What is the total cost to get thecontainers to the United States? Do not include U.S. port costs in this part of the analysis.2. Evaluate an alternative that involves consolidating all 20-foot container volumes and using onlya single consolidation center in Shanghai/Ningbo. Assume that all the existing 20-foot containerUU- SCM-1200 Introduction to Supply Chain Management Page 2volumes and the existing consolidation center volumes are sent to this single…Problem 4-11 (Algorithmic) Edwards Manufacturing Company purchases two component parts from three different suppliers. The suppliers have limited capacity, and no one supplier can meet all the company’s needs. In addition, the suppliers charge different prices for the components. Component price data (in price per unit) are as follows: Supplier Component 1 2 3 1 $11 $12 $13 2 $9 $10 $9 Each supplier has a limited capacity in terms of the total number of components it can supply. However, as long as Edwards provides sufficient advance orders, each supplier can devote its capacity to component 1, component 2, or any combination of the two components, if the total number of units ordered is within its capacity. Supplier capacities are as follows: Supplier 1 2 3 Capacity 500 900 700 If the Edwards production plan for the next period includes 900 units of component 1 and 700 units of component 2, what purchases do you recommend? That is, how many units of each…fter spending $300,000 for research and development, chemists at Diversified Citrus Industries have developed a new breakfast drink. The drink, called Zap, will provide the consumer with twice the amount of vitamin C currently available in breakfast drinks. Zap will be packaged in an 8-ounce can and will be introduced to the breakfast drink market, which is estimated to be equivalent to 21 million 8-ounce cans nationally. One major management concern is the lack of funds available for marketing. Accordingly, management has decided to use newspapers (rather than television) to promote Zap in the introductory year and distribute Zap in major metropolitan areas that account for 65 percent of U.S. breakfast drink volume. Newspaper advertising will carry a coupon that will entitle the consumer to receive $0.20 off the price of the first can purchased. The retailer will receive the regular margin and be reimbursed for redeemed coupons by Diversified Citrus Industries. Past experience…
- Consider the following transportation decision-making information: Plant Capacity Store Demand A 400 X 200 B 500 Y 250 C 100 Z 300 Total 1000 Total 750 Cost to ship from plant to store (per unit of demand) Plant Store X Y Z A $2 $2 $3.5 B $4 $5 $4.5 C $3 $3 $3 A. Develop the following shipping assignment table that uses the Solver function to find the optimal shipping patterns between the plants and the stores. Plant Store X Y Z A B C B. What is the minimal shipping cost?Like FedEx, UPS is a major player in global logistics. After reading the information presented in this module and other sources, write a one-page paper that describes three IT tools that UPS uses in its global logistics. What are two differences between global logistics and domestic logistics? The availability and speed of Internet connections play a major role in the success of a GIS. After reading the information presented in this module and other sources, write a one-page paper that lists the 10 countries with the fastest Internet connections. Is the United States among the top 10? Offshore outsourcing increases with the use of GISs. After reading the information presented in this module and other sources, write a one-page paper that describes four factors a company should consider when looking for a country to provide it with IT services. What are two reasons that have made India the top IT outsourcing country in the world? Information-sharing technologies are among the major…For each alternative new plant location, determine the shipping pattern that will minimize total transportation costs. Where should the new plant be located? Plant Capacity (Cases per Week) Warehouse Demand (Cases per Week) Chicago 10,000 Miami 7,000 Houston 7,500 Denver 9,000 New plant 8,000 Lincoln 4,500 Total 25,500 Jackson 5,000 Total 25,500 Shipping Cost to Warehouse (per Case) Plant Miami Denver Lincoln Jackson Chicago $7.00 $2.00 $4.00 $5.00 Houston $3.00 $1.00 $5.00 $2.00 Buffalo (alternative 1) $6.00 $9.00 $7.00 $4.00 Atlanta (alternative 2) $2.00 $10.00 $8.00 $3.00
- ABC pharmaceutical Company has four factories that ship supplies to four warehouses. The company’s management hires you as a consultant to determine a minimum-cost shipping plan for its monthly output to the warehouses. Factory capacities, warehouse demands, and shipping cost per box are shown below. Factory Supply or capacity (boxes) Warehouse Demand (boxes) Richmond 60 Chicago 100 Santa Fe 80 Jacksonville 90 Austin 120 Huntville 50 Vacaville 90 Fresno 70 Shipping Costs per box (In Dollars) From To Chicago To Jacksonville To Huntsville To Fresno Richmond 35 35 46 60 Santa Fe 65 40 35 25 Austin 50 50 80 90 Vacaville 40 40 66 75 Draw a diagram by showing factories, warehouses, and connecting arcs. Define variables, write the objective function and constraints.2. Unbalanced. Provide the transportation model for the calculation of cost given the following data: Use the Stepping Stone Method to solve the following. Use degeneracy method or dummy method if necessary.DM Office Products (DMOP) is a wholesale supplier of office products with one facility in Pennsylvania. It has decided to build a new distribution warehouse in the state of New York to help serve the growing demand in that market. It has four major customers located in Buffalo, Syracuse, Albany, and New York City. Though New York City is the largest market, it also has the greatest competition, and DMOP is not a major player there. When DMOP ships an order to a customer, it uses its own small fleet of two trucks to deliver, so the cost of delivery is essentially the same for a full or partially full truck. The expected number of annual shipments to each city and their coordinates on an x, y grid is shown in the following table. CITY x-COORDINATES y-COORDINATES NUMBER OF SHIPMENTS Buffalo 340 865 85 Syracuse 1,435 915 89 Albany 2,315 645 129 New York City 2,290 45 69