A firm is attempting to minimize its shipping costs. The firm has 3 factories and must supply the needs of its 3 customers without shortages. Since the firm has no storage facilities, each factory must make daily shipments to its customers. The table below shows the capacity of each factory, the amount required by each customer, and the cost of shipping from each factory to each customer. Factory/Capacity A/130 units B/110 units C/100 units Factory A B C Customer 1 10 8 5 Requirement-170 units Total cost Shipping Costs ($/unit) Customer 2 Shipping Costs ($/unit) Customer 1 Customer 2 Customer 3 14 7 9 Requirement-57 units Complete the table below to show the quantity shipped from each factory to each customer. (Leave no cells blank - be certain to enter "0" wherever required.) What is the total cost of meeting customer requirements each day? Customer 3 14 12 7 Requirement-113 units.
Q: Mary Williams, owner of Williams Products, is evaluating whether to introduce a new product line.…
A: Given: Fixed cost = 70000 Variable cost = 8 Selling price = 15 Unit sales = 12000
Q: Activity Predecessor Duration A - 6 B A 8 C A 6 D C 4 E B 6 F b.d 7 G C 5 H…
A: Activity Immediate Predecessors Duration A - 6 B A 8 C A 6 D C 4 E B 6 F B,D 7 G C 5…
Q: vide to an organization's operations
A: Complex software is used to handle every aspect of the company, including supply chains, business…
Q: The minimum cost plant food is made with kg of chemical I, kg of chemical II, and (Type integers or…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: a) The expected (estimated) time for activity C is b) The variance for activity C is c) Based on the…
A: As per Bartleby guidelines, we can only solve the first three subparts of one question at a…
Q: You have a used CD store. At an estate sale, you can purchase 260 compact discs for $400. You…
A: Net Benefit means subtracting the all sost of a project from total revenue. Formula for calculating…
Q: explain the role of upstream strategic logistics (supply logistics) towards the success of the…
A: Upstream strategic logistics is the process of managing the distribution of goods from the point of…
Q: Describe what panel data is and the reasons for using it
A: Since you have posted a question with multiple questions, we will solve the first question for you.…
Q: Complete the following perishable product quotation/call sheet. Indicate the preferred supplier: a.…
A: Find the Given details below: Given details: Amount Supplier Item Needed On Hand Order 1 2 3…
Q: Table gives observations regarding customers at a single-server FCFS queue. (a) Compute the average…
A: Find the Given details below: Given details: Customer Interarrival time Service time 1 1 3…
Q: A company incurs an ordering cost of $40 each time it places an order, regardless of the order size.…
A: Given: Q = 439 Annual demand (D) = 10850 Ordering or Setup cost (S) = 40 Holding cost (H) = 45*10% =…
Q: Use the direct clustering algorithm to form cells for the machine-part matrix shown be- low. Propose…
A: The direct clustering algorithm is the technique to group the parts of the product together to make…
Q: The cost of an hour of semi-skilled labor is Php 100 and that of an hour of skilled labor is Php…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: Activity normal durations, crash durations and cost Crash Normal Duration Duration Activity (weeks)…
A: Find the Given details below: Activity Normal Time (NT) (Weeks) Normal cost (NC) ($) Crash Time…
Q: A manufacturing plant is trying to determine standard production per day for an incentive program.…
A: Production is the process in which inputs are combined to have the required output. It includes a…
Q: What is strategic change?
A: The movement of a business from its current condition toward a targeted future state in order to…
Q: I think there is an error with a when multiplying 12 by 600
A: Given- Monthly Demand (d) = 50 bagsAnnual Demand (D) = 50×12 = 600 bagsFixed Ordering Cost (S) =…
Q: Customer Retailer Time Supply Chain Distributor Customer Order Cycle Replenishment Cycle maa…
A: Supply chain stages: The supply chain process considers the following stages, these…
Q: Romans Food Market, located in Saratoga, New York, carries a variety of specialty foods from around…
A: BR = pound of Brazilian bean purchased to produce Regular BD = pound of Brazilian bean purchased…
Q: An Soda company sells about 400 gallons of its highly demanded beverage each week. The estimated…
A: EOQ = 2DSHHolding cost = Q*H2Setup cost = D*SQTotal cost = holding cost + setup costReorder level =…
Q: What measures would you take if an organization didn't currently have the knowledge necessary to…
A: Organizations can evaluate whether they have the technical capabilities to conceive an idea into a…
Q: a) The time Determine and also estimate: Activity A estimates. the find expected to 10 which of…
A:
Q: Use the Big M method, work through the simplex method step by step to solve the following problem.…
A: The Big M technique is a modified version of the simplex approach used in linear programming (LP),…
Q: This exercise contains only parts a and b. a) For the given data, the x = hours (round your response…
A: NOTE: We are allowed to do the first three sub-parts only. UCL(x-DOUBLE BAR) = X-DOUBLE BAR+A2*R-BAR…
Q: Discuss the importance of the expected benefits and risks in a Project Proposal,
A: A project proposal is a document used to brief a company's board or management team on the plan's…
Q: EZ-Windows, Inc., manufactures replacement windows for the home remodeling business. In January, the…
A: Objective function: Minimize Z = 1I1+1I2+1I3+0.65D1+0.65D2+0.65D3 Constraints: 1. February demand:…
Q: Why should a business successfully integrate its outside suppliers?
A: Any supply chain must include external suppliers since they are an essential component. In the…
Q: To keep up with the volume of information transmitted between origin and destination points, use the…
A: Linear programming is a mathematical technique that is also used in operations management…
Q: What is the orrect graph that shows the feasible region for the problem. b. What are the extreme…
A: Linear programming is a type of mathematical optimization problem. Linear programming problems are…
Q: Asia Furnishing is a retailer of modular toilet products. Currently, the lead time for one of the…
A: Lead time for 1st supplier = L1 = 5 weeks Average demand = d = 200 per week Std. Deviation of demand…
Q: Note: Formulas to solve the following problems are given in the class and example problems were…
A: Arrival rate λ = 603 =20 per hour Service rate μ = 602.4…
Q: Describe the market requirements and product characteristics in global competition.
A: Market requirements means - what the specific market requires to survive or something related to the…
Q: L.P. Model: Minimize Subject to: Z = 4X+3Y 1X + 2Y 240 3X+1Y275 X,Y 20 On the graph on right,…
A: An LPP problem identifying the optimal value as minimum cost or maximum profit. Here, we can…
Q: A manufacturer of engine parts produces valves and pistons at its main plant. Both parts are…
A:
Q: What are the strategies to maintain adequate production levels in terms of land, buildings,…
A: As a business, you will need to make sure that you maintain adequate production levels in terms of…
Q: #5) Solve the following LP a) Write the original optimal solution and objective function value.…
A: Note: - As we can answer only up to three subparts we will answer the first three subparts here. If…
Q: The following tabulations are actual sales of units for six months and a starting forecast in…
A: Simple exponential smoothing is the part of time series of the forecasting method. It is calculated…
Q: Each day, a FedEx competitor processes approximately 50,000 shipments. Suppose that they use the…
A:
Q: Additional Algo 11-6 Holding Cost per Unit A company usually holds 340 pounds of wax in its…
A: Given: Units in warehouse 340 Usage per day 42 Lead time 5 Holding cost per day 0.28
Q: in a coffe shop, inc
A: The arduous effort of managing a coffee business requires precision, which is the only way to…
Q: Maryland transportation authority decided to setup toll booths on either side of the Fort McHenry…
A: Given data: Total number of vehicles (n) = 3900/hr Time spend at 1 tollbooth (t) = 2min/vehicle
Q: SKU A B C D E F G Total 12.6 A company wants to store the following seven SKUs so there is a 100%…
A: Given-
Q: Find the minimum value of the function z=2x+2y subject to the following constraints. x≤17 y≤16…
A: Linear programming is a mathematical technique for the optimization of resources, such as time and…
Q: You are the manager of a local bank where three tellers provide services to customers. On average,…
A: Given data is Arrival rate (lambda) = 40 per hour Service rate = 4 minutes per customer Service…
Q: Defect A B C D E Defect Description Poorly Covered Etiqueta corrida Volume out of specifications…
A:
Q: Given a model of a simple queue, describe, in a simplified way, what is a source of customers.
A: Queueing model is used to explain the waiting line and help the decision maker to plan the capacity.…
Q: Solve the following linear programming problem graphically: Maximize Z=3X+5Y Subject to: 4X+4Y≤48 C₁…
A: When using a graphical technique, the viable zone is used to discover the solution to problems based…
Q: Select the best completion. With reference to the Product-Process matrix... A. Sugar production…
A: The product-process matrix is described as the matrix that allows effective analysis of the…
Q: Chris LeBlanc estimates that if he does five hours of research using data that will cost $175, there…
A: Total Hours = 5 Hours Cost = 175 Expected Return = 10000 One-year investment increases from 6% to…
Q: explain why a linear programming model would be suitable for this case study. Formulate a Linear…
A: Here, we would formulate the LP for this situation, as This represents an optimization problem,…
please see attached
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 6 images
- The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Can you guess the results of a sensitivity analysis on the initial inventory in the Pigskin model? See if your guess is correct by using SolverTable and allowing the initial inventory to vary from 0 to 10,000 in increments of 1000. Keep track of the values in the decision variable cells and the objective cell.The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. As indicated by the algebraic formulation of the Pigskin model, there is no real need to calculate inventory on hand after production and constrain it to be greater than or equal to demand. An alternative is to calculate ending inventory directly and constrain it to be nonnegative. Modify the current spreadsheet model to do this. (Delete rows 16 and 17, and calculate ending inventory appropriately. Then add an explicit non-negativity constraint on ending inventory.)The Pigskin Company produces footballs. Pigskin must decide how many footballs to produce each month. The company has decided to use a six-month planning horizon. The forecasted monthly demands for the next six months are 10,000, 15,000, 30,000, 35,000, 25,000, and 10,000. Pigskin wants to meet these demands on time, knowing that it currently has 5000 footballs in inventory and that it can use a given months production to help meet the demand for that month. (For simplicity, we assume that production occurs during the month, and demand occurs at the end of the month.) During each month there is enough production capacity to produce up to 30,000 footballs, and there is enough storage capacity to store up to 10,000 footballs at the end of the month, after demand has occurred. The forecasted production costs per football for the next six months are 12.50, 12.55, 12.70, 12.80, 12.85, and 12.95, respectively. The holding cost incurred per football held in inventory at the end of any month is 5% of the production cost for that month. (This cost includes the cost of storage and also the cost of money tied up in inventory.) The selling price for footballs is not considered relevant to the production decision because Pigskin will satisfy all customer demand exactly when it occursat whatever the selling price is. Therefore. Pigskin wants to determine the production schedule that minimizes the total production and holding costs. Modify the Pigskin model so that there are eight months in the planning horizon. You can make up reasonable values for any extra required data. Dont forget to modify range names. Then modify the model again so that there are only four months in the planning horizon. Do either of these modifications change the optima] production quantity in month 1?
- If a monopolist produces q units, she can charge 400 4q dollars per unit. The variable cost is 60 per unit. a. How can the monopolist maximize her profit? b. If the monopolist must pay a sales tax of 5% of the selling price per unit, will she increase or decrease production (relative to the situation with no sales tax)? c. Continuing part b, use SolverTable to see how a change in the sales tax affects the optimal solution. Let the sales tax vary from 0% to 8% in increments of 0.5%.Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pen...Maxwell Manufacturing makes two models of felt tip marking pens. Requirements for each lot of pens are given below.Fliptop Model Tiptop Model AvailablePlastic 3 4 36Ink Assembly 5 4 40Molding Time 5 2 30The profit for either model is $1000 per lot.What is the linear programming model for this problem?What are the boundary points of the feasible region?What is the profitability at each boundary point of the feasible region?Find the optimal solution.Quality Air Conditioning manufactures three home air conditioners: an economy model, a standard model, and a deluxe model. The profits per unit are $67, $95, and $133, respectively. The production requirements per unit are as follows: Number ofFans Number ofCooling Coils ManufacturingTime (hours) Economy 1 1 8 Standard 1 2 12 Deluxe 1 4 14 For the coming production period, the company has 300 fan motors, 340 cooling coils, and 2000 hours of manufacturing time available. How many economy models (E), standard models (S), and deluxe models (D) should the company produce in order to maximize profit? The linear programming model for the problem is as follows: Max 67E + 95S + 133D s.t. 1E + 1S + 1D ≤ 300 Fan motors 1E + 2S + 4D ≤ 340 Cooling coils 8E + 12S + 14D ≤ 2000 Manufacturing time E, S, D ≥ 0 The computer solution is shown in the figure below. Optimal Objective Value = 17380.00000 Variable Value…
- 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 $13 $14 $15 2 $11 $12 $11 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 400 800 600 If the Edwards production plan for the next period includes 800 units of component 1 and 600 units of component 2, what purchases do you recommend? That is, how many units of each component should be…An XYZ company has a W, H, O plant with a monthly production capacity of 60 tons, 50 tons, and 42 tons, respectively; and has 3 sales warehouses in cities A, B, C, D Where each warehouse has a monthly requirement of 30 tons, 34 tons, 44 tons and 25 tons. With shipping cost W to ABCD = IDR 12,000,-, IDR. 8.000,-, Rp. 12.000,-, Rp. 14,000,-; H to A B C D = Rp. 8.000,-, Rp. 18.000,-, Rp. 10,000,-, Rp. 6.000,-; and O to ABCD = Rp. 16.000,-, Rp. 16.000,-, Rp. 2,000, Rp. 10,000,-. Please calculate using Vogel's Approximation Method or VAM Question a. What is the best transportation model in your opinion to solve the above problems? b. What is the minimum transportation cost to solve the shipping transportation problem! c. Based on these calculations, give suggestions regarding the transportation model and the amount of costs incurred by the company!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 $12 $12 $15 2 $11 $10 $12 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 575 950 800 If the Edwards production plan for the next period includes 1050 units of component 1 and 775 units of component 2, what purchases do you recommend? That is, how many units of each component should be…
- The demand for subassembly S is 100 units inweek 7. Each unit of S requires 1 unit of T and 2 units of U.Each unit of T requires 1 unit of V, 2 units of W, and 1 unit ofX. Finally, each unit of U requires 2 units of Y and 3 units ofZ. One firm manufactures all items. It takes 2 weeks to makeS, 1 week to make T, 2 weeks to make U, 2 weeks to make V,3 weeks to make W, 1 week to make X, 2 weeks to make Y,and 1 week to make Z.a) Construct a product structure. Identify all levels, parents,and components.b) Prepare a time-phased product structure.The Scottsville Textile Mill produces several different fabrics on eight dobby looms that operate 24 hours per day and are scheduled for 30 days in the coming month. The mill will produce only Fabric 1 and Fabric 2 during the coming month. Each dobby loom can turn out 4.62 yards of either fabric per hour. Assume that there is a monthly demand of 16,000 yards of Fabric 1 and 12,000 yards of Fabric 2. Profits are calculated as 33¢ per yard for each fabric produced on the dobby looms. (a) Will it be possible to satisfy total demand? (b) In the event that total demand is not satisfied, the Scottsville Textile Mill will need to purchase the fabrics from another mill to make up the shortfall. Its profits on resold fabrics ordered from another mill amount to 20¢ per yard for Fabric 1 and 16¢ per yard for Fabric 2. How many yards of each fabric should it produce to maximize profits? (Round your answers to one decimal place. If total demand is satisfied, enter NONE.)The Scottsville Textile Mill produces several different fabrics on eight dobby looms that operate 24 hours per day and are scheduled for 30 days in the coming month. The mill will produce only Fabric 1 and Fabric 2 during the coming month. Each dobby loom can turn out 4.65 yards of either fabric per hour. Assume that there is a monthly demand of 16,000 yards of Fabric 1 and 12,000 yards of Fabric 2. Profits are calculated as 33¢ per yard for each fabric produced on the dobby looms. Will it be possible to satisfy total demand? (a)Yes, the mill can produce enough to meet the demand. (b)No, the mill can not produce enough to meet the demand. In the event that total demand is not satisfied, the Scottsville Textile Mill will need to purchase the fabrics from another mill to make up the shortfall. Its profits on resold fabrics ordered from another mill amount to 20¢ per yard for Fabric 1 and 16¢ per yard for Fabric 2. How many yards of each fabric should it produce to maximize…