Applications of Linear Programming Problem 1: Blending Problem Muscat Foods produce two types of honey, Blacken and Golden, which are both made by blending different proportions of raw honey purchased from three different countries: Tunisia, Australia and Canada. The raw honey costs OR2/kg from Tunisia, OR3/kg from Australia and OR4/kg from Canada. The proportions of the raw honeys in each product are shown in the following table: Blacken Golden Tunisia 50% 60% Australia 40% 20% Canada 10% 20% In the coming planning period there is 600kg of raw honey available from Tunisia, 500kg from Australia and 300kg from Canada. At least 200kg of Blacken and at least 300kg of Golden must be produced to satisfy the demand, and there is no limit on how much can be sold. The company receives revenues of OR4/kg for Blacken and OR3/kg for Golden. Muscat Foods wishes to plan production to maximise the profit. Formulate the problem as a linear programming model where B and G represent the amounts of Blacken and Golden to be produced in kg.
Q: Using trend projection, develop a formula to predict sales for years 11 and 12. You have to show all…
A: Trend projection forecast technique is a technique that is used to predict the future of a trend. It…
Q: It costs Gordon $1 to move 1 work piece 1 foot. The weekly total material handling cost of the…
A: Production is the process in which inputs are combined to have the required output. It includes a…
Q: Mr. Jack is in the process of expanding his manufacturing business. He decided to open a plant in…
A: i) Total Cost (Location A) = 60000+30x Total Cost (Location B) = 80000+20x Total Cost (Location C) =…
Q: What is the best choice of the crop given a constraint of 1000 acres?
A: Let Wheat be A, Strawberries be B, Sweet Corn be C, Perennial Ryegrass be D and Green Beans be E…
Q: Daniel Tracy, owner of Martin Manufacturing, must expand by building a new factory. The search for a…
A: Find the Calculations methods below: Total Weighted Score = ∑ (Weights * Site Scores) Given details:…
Q: Mr. Jack is in the process of expanding his manufacturing business. He decided to open a plant in…
A: Find the Calculations below: Total cost = (Fixed cost + (Number of units * Variable Cost)) Cost…
Q: The goal of supply chain management is to ensure that the right product is delivered to the right…
A: Today, the world has become a global market. Anything can be bought from any corner of the world.…
Q: Problem 3: Consider the following linear programming problem: Min s.t. 6X5Y+24Z -4X + 3Y +9Z ≤ 509…
A: Max Z=∑cixisubject to Ax=Bxi≥0 A standard form of LPP; - is a Maximization problem - has equality…
Q: b. The following table shows the number of televisions sold over the last ten years at a local…
A: First we need to arrange the given data and arrange extra calculation columns: Year (x) Sales (y)…
Q: Mr. John produces a special type of shoes on an assembly line. The process involves eight different…
A: To ensure the smooth flow of work in a product line, assigning tasks to workstations with…
Q: Baton Rouge's Mt. Cedar Hospital is a large, private, 600-bed facility complete with…
A: Based on the given information, the decision variables are X1 and X2. Here, the revenue details are…
Q: A company produces drinks in liters (33.8 oz.) and single serving (16.9 oz.) containers that utilize…
A: Here, I would formulate the LP, The decision variables are stated below, The number of litre…
Q: I only need help Question 4 please!! A large insurance company maintains a central computing…
A: Given data: Arrival rateλ = 44 calls per hour Service rate μ= 24 calls per hour
Q: Flores Manufacturing, Inc., is moving to kanbans to support its electronic-board assembly lines.…
A: Ans) Input Data: Setup Cost= S = $16 Annual Holding Cost subassembly = H = $250 Daily Production = p…
Q: months, and expected peak sales of 1 k units/month. What is the forecast number of sales for the…
A: Here, the given data stated below, The projected lifespan would be 12 months, with the expected…
Q: hat are the top ten risks associated with IT project management?
A: 1. Technology riskThe technological part of running a project is a complex deliverable since there…
Q: Pam’s demand for hats is normally distributed with mean 500 and standard deviation 100. She sells…
A: Optimal order quantity is a term used in the business world to describe the number of units that…
Q: Explain the three different source of information and forecast assumptions
A: The term "forecasting" describes the process of speculating on what will occur in the future based…
Q: Discuss the role of the Literature Review in a scholarly article. What is it? Why are writing…
A: The goal of a literature review is to increase understanding of current research and conversations…
Q: UCLc= _______ (round your response to two decimal places). LCLc= _______ (round your response…
A: Control charts are also known as process-behaviour charts. It is a statistical process that helps in…
Q: Quality control in a factory pulls 40 parts with paint, packaging, or electronic defects from an…
A: Quality control in a factory pulls 40 parts with paint, packaging, or electronic defects from an…
Q: Goop Inc needs to order a raw material to make a special polymer. The demand for the polymer is…
A: Mean μ = 250 gallons Standard deviation σ = 125 gallons Cost (c) = $10 per gallon Selling price (p)…
Q: A simple three month moving average. ii. A three period weighted moving average using weights of…
A: Forecasting is the process of predicting future events by looking at past data and trends.…
Q: how would you input the formula into exce
A: FIT = Forcast Including Trend FIT = Ft + Tt Ft = FITt-1 + a {(At-1) -(FITt-1)} Tt = Tt-1 + b…
Q: Describe the seven work processes of how project time management can be divided as defined by the…
A: The ability to keep things on schedule is also crucial while leading a project. As such, it is seen…
Q: A teller at a drive-up window at a bank had the following service times (in minutes) for 20 randomly…
A: Find the Given details below: Samples Observations 1 2 3 4 1 4.5 4.6 4.5 4.7 2 4.2 4.5 4.6…
Q: Please answer part D to the below four part question. I've included the answers for the first three…
A: Please note that the provided answers are not relevant to the actual questions. here I have solved…
Q: Describe how MRP concepts could be used for the following service operations: a. Hotel
A: The term MRP is an acronym for Manufacturing Resource Planning. The MRP system was developed in the…
Q: Solve using dual simplex method Maximize Xo = X1 + 2x2-3x3 + 4X4 -X1 + 2x2 + x3 3x4 = 5 6X1 +…
A: Problem is Max Z = x1 + 2 x2 - 3 x3 + 4 x4 subject to - x1 + 2 x2 + x3 -…
Q: Planning for quality is necessary but often forgotten or dismissed function on a project. Discuss…
A: A project quality plan is a set of documented standards or procedures that are followed during a…
Q: The table below shows the sales figures for a brand of shoe over the last 12 months. Months Sales…
A: (i) (ii)
Q: is it possible to show the formula in a excel spreadsheet, so i can have a better understanding.
A: Formulae used: Adjusted exponential smoothing method:- Ft=FITt-1+ α (At-1 – FITt-1) Tt= Tt-1+ β(Ft–…
Q: What skills do you think must be available when implementing the project?
A: Project implementation is the significant stage to ensuring that processes & plans are…
Q: Eastman Publishing Company is considering publishing an electronic textbook about spreadsheet…
A:
Q: y local in operation manageme
A: Operations management is crucial to corporate operations because it establishes the organizational…
Q: 4. Tom would like 3 pints of home brew today and an additional 6 pints of home brew tomorrow. Dick…
A:
Q: The software package most commonly used for creating simple charts is: XLMiner OR Excel O SAS
A: Ans) XL Miner, R, Excel and SAS are all tools used for creating charts. R involves a R programming…
Q: Ram Roy's firm has developed the following supply, demand, cost, and inventory data. Supply…
A: The transportation method is a special kind of linear programming. It is used to determine the…
Q: a) The correct precedence relationship with one of the possible assignment of tasks to workstations…
A: Project schedule helps in calculating different values all related to the production cycle like the…
Q: 4. It takes Susan 30 minutes to solder 10 circuit boards to fill a container and 2 minutes to…
A: NOTE: We are allowed to do one question only. Ans 4. Given: no.of kanbans K 5 processing…
Q: Explain the concept of user centered design. How is it different from participatory design concept?
A: User-centered design (UCD) is a collection of processes that emphasis on putting users at the center…
Q: “Coady used a strategy of focusing on reducing the number of projects in the portfolio.” Briefly…
A: According to the case study - Frontier Airlines Holdings has bankrupt a few years later, they…
Q: Give typed explanation of all question Don't upload any type of photos 1. Discuss 5 benefit of…
A: Today companies gain a competitive edge in the business by using an automated warehouse, Without it,…
Q: Jack Ltd is a market leader in the manufacture of apple juice. They operate a reorder level system…
A: Inventory is the raw material that is particularly used in the production of goods. Inventory is the…
Q: Activities' estimated duration and the time intervals at which the actual progress is analyzed…
A: An activity's estimated duration can be defined as the approximated time that will be taken by a…
Q: Assume that total sales revenue for 2018 is projected to be $1,290,518. Assume also the following…
A: Given, Total sales revenue = $1,290,518 NMC = Net Market Contribution / Total sales revenue Net…
Q: The critical path method is a. capital oriented b. personnel oriented c. activity oriented d.…
A: Project management is the specific form of management that assists in handling projects To set it…
Q: To cut the number of projects, the steering committee used a weighting scheme that reflected the…
A:
Q: Calculate the average inventory
A: EOQ stands for economic order quantity. It is a company's optimal order quantity that undervalues…
Q: Solve the following Assignment Problem using Hungarian method. PERSON 1 3x N W TASK 2 3 8 20 15 17 X…
A: The number of rows = 4 and columns = 4 1 2 3 4 W 8 20 15 17 X 15 16 12…
Please formulate the LP with clear steps
Step by step
Solved in 2 steps
- Assume the demand for a companys drug Wozac during the current year is 50,000, and assume demand will grow at 5% a year. If the company builds a plant that can produce x units of Wozac per year, it will cost 16x. Each unit of Wozac is sold for 3. Each unit of Wozac produced incurs a variable production cost of 0.20. It costs 0.40 per year to operate a unit of capacity. Determine how large a Wozac plant the company should build to maximize its expected profit over the next 10 years.The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.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%.
- Lemingtons is trying to determine how many Jean Hudson dresses to order for the spring season. Demand for the dresses is assumed to follow a normal distribution with mean 400 and standard deviation 100. The contract between Jean Hudson and Lemingtons works as follows. At the beginning of the season, Lemingtons reserves x units of capacity. Lemingtons must take delivery for at least 0.8x dresses and can, if desired, take delivery on up to x dresses. Each dress sells for 160 and Hudson charges 50 per dress. If Lemingtons does not take delivery on all x dresses, it owes Hudson a 5 penalty for each unit of reserved capacity that is unused. For example, if Lemingtons orders 450 dresses and demand is for 400 dresses, Lemingtons will receive 400 dresses and owe Jean 400(50) + 50(5). How many units of capacity should Lemingtons reserve to maximize its expected profit?A mixture of pellets is to be made containing x regular pellets, y large pellets and z extra large pellets. Cost, weight and volume data for each type of pellet are shown in the table. Is it possible to make mixture of 55 pellets at a cost of $0.85 if the mixture is to have 120 weight units and 130 volume units? If so, how many each type of pellet should be in the mixture? Pellet Type 5. Number of Cost per Pellet in Cents Weight Units per Pellet Volume Pellets Units per Pellet Regular Large Extra large 2 1 4 y 1 4 3Briefly explain these terms:a. Basic variableb. Shadow pricec. Range of feasibilityd. Range of optimality
- SIMPLEX METHOD A factory makes tennis rackets and cricket bats. A tennis racket takes 1.5 hours of machine time and 3 hours of craftsman’s time in its making while a cricket bat takes 3 hour of machine time and 1 hour of craftsman’s time. In a day, the factory has the availability of not more than 42 hours of machine time and 24 hours of craftsman’s time. If the profit on a racket and on a bat is Php 20.00 and Php 10.00 respectively, find the maximum profit of the factory when it works at full capacity.Formulate an LP model for the following problems.1. Bernadette intends to invest up to ₱50,000 in either Best Fund, or a time deposit orboth. The Best Fund pays 8% per year and the time deposit pays 9%. Because theBest Fund is riskier than the time deposit, so she intends to put at most ₱30,000 intothe time deposit and at least ₱10,000 into the Best Fund. How much should she allotto each investment in order to maximize her returns?4) The making of rivet holes in structural steel members can be done by 2 methods. The first method consists of laying out the position of the holes in the members and using a drill press costing P100k. The machinist is paid P60 per hour and he can drill 80 holes per hour. The second method makes use of a multiple-punch machine costing P80k. The punch operator is paid P40 an hour and he can punch out 1 hole for 3 seconds. This method also requires an expense of P1.25 per hole to set the machine. (a) if all other costs are assumed equal, what is the total cost for each machine for 10k holes, assuming the total cost of each machine to be charged to these holes? (b) for how many holes will the costs be equal?
- An investor is looking to invest R 250,000 with the intent of getting the highest possible return. He plans to do this by holding a diverse stock portfolio with different hypothetical stocks with varying expected returns as seen in the table below. Stock Return earned Naspers 6% Sasol 15% ABSA 9. Capitec 3% To control for risk, the following constraints are put into place: a) No more than 15% of the total investment can be put into ABSA stocks. b) At most 40% must be invested in Sasol stocks and the Capitec stocks combined. c) The amount put in Naspers stocks must be no more than the amount invested into all the other remaining stocks combined. d) All the R250,000 must be invested and no shorting is allowed. Formulate a linear programming model for this problem to get the highest return (i.e., Define and outline your decision variables, objective function and constraints). How much of the budget should be invested into each investment option? (Show your workings in Microsoft Excel)The cost data for Evencoat Paint for the year 2019 is as follows: Month Gallons ofPaintProduced EquipmentMaintenanceExpenses January 110,000 $70,700 February 68,000 66,800 March 71,000 67,000 April 77,000 68,100 May 95,000 69,200 June 101,000 70,300 July 125,000 70,400 August 95,000 68,900 September 95,000 69,500 October 89,000 68,600 November 128,000 72,800 December 122,000 71,450 A. Using the high-low method, express the company’s maintenance costs as an equation where x represents the gallons of paint produced. Then estimate the fixed and variable costs. Fixed cost $ Variable cost $Fopic 4- Linear Programming: Appli eBook Problem 9-05 (Algorithmic) Kilgore's Deli is a small delicatessen located near a major university. Kilgore's does a large walk-in carry-out lunch business. The deli offers two luncheon chili specials, Wimpy and Dial 911. At the beginning of the day, Kilgore needs to decide how much of each special to make (he always sells out of whatever he makes). The profit on one serving of Wimpy is $0.46, on one serving of Dial 911, $0.59. Each serving of Wimpy requires 0.26 pound of beef, 0.26 cup of onions, and 6 ounces of Kilgore's special sauce. Each serving of Dial 911 requires 0.26 pound of beef, 0.41 cup of onions, 3 ounces of Kilgore's special sauce, and 6 ounces of hot sauce. Today, Kilgore has 21 pounds of beef, 16 cups of onions, 89 ounces of Kilgore's special sauce, and 61 ounces of hot sauce on hand. a. Develop a linear programming model that will tell Kilgore how many servings of Wimpy and Dial 911 to make in order to maximize his profit today.…