Federal Rent-a-Car is putting together a new fleet. It is considering package offers from three car manufacturers. Fred Motors is offering 5 small cars, 5 medium cars, and 10 large cars for $500,000. Admiral Motors is offering 5 small, 10 medium, and 5 large cars for $400,000. Chrysalis is offering 10 small, 5 medium, and 5 large cars for $300,000. Federal would like to buy at least 550 small cars, at least 500 medium cars, and at least 550 large cars. How many packages should it buy from each car maker to keep the total cost as small as possible? packages packages packages Fred Motors Admiral Motors Chrysalis What will be the total cost?
Q: BC Petrol manufactures three chemicals at its chemical plant in Kentucky: BCP1, BCP2, and BCP3.…
A:
Q: A retail chain has 8 stores in a region supplied from 3 supply sources. Trucks have a capacity of…
A: Transportation Transportation is another Key Driver in the Supply Chain which has a significant…
Q: Show your step-by-step process using THE SPECIAL PURPOSE LINEAR PROGRAMMING: MODI TRANSPORTATION…
A: TOTAL number of supply constraints : 3TOTAL number of demand constraints : 3Problem Table is :…
Q: Kara wants to open a retailing outlet in her town. Her family has been in the business of selling…
A: Disclaimer: Since you have asked multiple question, so as per company policy, we will solve the…
Q: A toy factory in Temuco currently assembles three types of toys within its production line: trains,…
A: Decision Variable: Suppose-X be the units of toy type train assemblesY be the units of toy type…
Q: Goldilocks needs to find at least 12 lb. of gold and at least 18 lb. of silver to pay the monthly…
A: Let; x1 be the number of days spent in mine 1 x2 be the number of days spent in mine 2.
Q: A brewery produces regular beer and a lower-carbohydrate Tight beer. Steady customers of the brewery…
A: R = units of regular beer L= units of light beer Minimize C = 32000 R + 60000 L…
Q: Everest (EVT) is an outdoor equipment retailer that sells camping, fishing, boating, and other…
A: In the current case, Everest (EVT) is a retail outlet offering variety of outdoor supplies such as…
Q: A trucking firm must decide at the beginning of the year on the size of its trucking fleet. If on a…
A: Trucking companies operating various trucks simultaneously in various country directions forms an…
Q: Lauren Moore has sold her business for $500,000 and wants to invest in condominium units (which she…
A: As mentioned in the question, the decision variables will be x1 and x2. x1 = Units of condominium…
Q: he Floataway Tours has $420,000 that may be used to purchase new rental boats for hire during the…
A: Given, Boat Builder Cost Max Seating Expected Daily profit speed hawk sleek boat $6000 3 $70…
Q: Mark Sumansky owns and manages the Grass, Unlimited, Lawn-care service in Middleton. His customers…
A: Given-
Q: A furniture company is producing tables and chairs for the coming week. The production of tables and…
A: Objective Functions and Constraints: Based on the given details, the objective…
Q: A plant has sufficient capacity to manufacture any combination of four different products (A, B, C,…
A: Linear programming (LPP) is subject to linear restrictions. To put it another way, linear…
Q: (A) A product line has two models: X and Y. Model X consists of 4 components: a, b, c, and d. The…
A: Product variety, P=2 (X&Y) Product quantity, Q1=1000 units Q2=1500 units Number of…
Q: Lauren Moore has sold her business for $500,000 and wants to invest in condominium units (which she…
A: A mixed integer programming model is as follows Let C= Number of units of condominiums…
Q: Tech, with a student population of 30,000, is located in a small college town in Virginia.…
A: City Representation Richmond R Charlotte C Atlanta A Greensboro G DC DC Nashville N…
Q: A furniture company manufactures desks and chairs. The sawing department cuts the lumber for both…
A: Let us consider the maximum profit, Z is possible when the quantity of chair is “X” and quantity of…
Q: The Bayside Art Gallery is considering installing a video camera security system to reduce its…
A: Formulastion of LP: Objective Function: z(min) =…
Q: Optimal Prime is leading its group of AMPLbots into battle against Gigatron and the Deceivacons,…
A: Find the Given details below: Given details: A B C D E Capacity Unit cost 1 15 20 10…
Q: A company manufactures both mountain bikes and trail bikes. The cost of materials for a mountain…
A: SOLUTION:
Q: A company produces three products, A, B, and C. The sales volume for A is at least 50% of the total…
A: Given information, Sales Volume = 50% Unsold Units = 80 Daily availability = 240 lb Usage rate of…
Q: a company possesses two manufacturing plants, each of which can produce three products: X,Y, and Z…
A: Let x1 be the number of hours of plant A in use.x2 be the number of hours of plant B in use.
Q: operate, and it can produce 400 barrels of high-grade oil, 300 barrels of medium-grade oil, and 200…
A: Below is the solution:-
Q: A steel production plant manufactures bands and coils which sell at a profit of $25 and $30 per ton,…
A: In the question, for each case, we would first formulate the LP, then, we would solve this LP with…
Q: Perth Mining Company operates two mines for the purpose of extracting gold and silver. The Saddle…
A: This question is related to the topic- decision making and this topic fall under the operations…
Q: A company produces three products, A, B, and C. The sales volume for A is at least 50% of the total…
A: This is a maximization problem. The LP formulation is as follows: Maximize Z = 20A + 50B + 35C…
Q: Please develop a linear programming model for the problem. b. Find the optimal solution via Excel.…
A: Let x and y be the time allocated to regular customers and new customers respectively. Objective…
Q: Green Vehicle Inc. manufactures electric cars and small delivery trucks. It has just opened a new…
A: Given data, To paint a truck of T1 = 1/40 day in the paint shop To paint a car of type C1 = 1/60…
Q: A large Midwestern university is opening a regional branch about an hour away from its main campus.…
A: recruitment: it is a process of searching for prospective employees and stimulating them to apply…
Q: A restaurant has a capacity of serve 150 customers during the dinner time from 5 to 9 pm. In a…
A: Dinner time capacity(D) = 150 Evening time capacity(E) = 120
Q: You are working for Advance Technology, a company that produces three different devices for the…
A: Given: In the Croswell facility Main-bus Servo Modules = 8Secondary Trigger Activators= 4 Guidance…
Q: . Real Estate Development A real estate developer is planning to build an apartment building…
A: Given data is Rent price of efficiency = $900 Rent price of 1-bed room = $1100 Rent price of 2-bed…
Q: Oriole Company manufactures and sells high-priced motorcycles. The Engine Division produces and…
A:
Q: Jeff Kaufmann's machine shop sells a variety of machines for job shops. A customer wants to purchase…
A: The decision tree is a visual representation of decision-making alternatives. The square node…
Q: Lauren Moore has sold her business for $500,000 and wants to invest in condominium units (which she…
A: Let, A = No. of condominiums purchased B = No. of acres of land purchased
Q: Suppose you are planning a road trip (by car) from San Francisco to New York City. You will need to…
A: Shortest-route model help us to decide which route should be taken without any turbulence. Main…
Q: Lauren Moore has sold her business for $500,000 and wants to invest in condominium units (which she…
A: The proposed mixed-integer programming model can be straightforwardly addressed by the blended…
Q: Tiny Toy Company makes three types of new toys: the tiny tank, the tiny truck, and the tiny turtle.…
A: Goals Description Rank Wt Goal 1 Minimize overutilization of plastic 2 0.364 Goal 2 Minimize…
Q: At the present time, market shares for University, College, Battle’s and Bill’s book stores are 0.3,…
A: Answer- Time-2 university bill's college battle Market share Time-1 University 25% 0.6 0.2 0.1 0.1…
Q: A company makes two types of sofas, regular and long, at two locations, one in Msamvu and one in…
A: Below is the solution:-
Q: BMW produces three different types of wheels – 17-inch, 18-inch, and 19-inch – in its manufacturing…
A: Given data: Wheel Demand (units/day) Production cost ($/unit) Reconfiguration cost ($) 17-inch…
Q: Hawkins Manufacturing Company produces connecting rods for 4- and 6-cylinder automobile engines…
A: Please note that as per guidelines, we can solve 3 subparts in one post. Please post the remaining…
Q: It costs $300 to buy a lawn mower from a lawn supply store. Assume that you can keep a lawn mower…
A: Build up a bookkeeping page enhancement model for mower purchasing for the following 10 years that…
Q: How many units of cabinet should the company produce to maximize the profit
A: Identifying the production combination which maximize the profit indicating the problem development…
Q: Nicholas is the facilities manager for Green Market Groceries. The store is remodeling and wants to…
A: Find the Given details below: Given Details: Alaskan Seal BRR Frost Cold Case Deep Freeze…
Q: A wood products firm uses leftover time at the end of each week to make goods for stock. Currently,…
A: The linear programming model is shown below: Board = x, holder = y Objective function:
Q: opOil, a refiner in Indiana, serves three customers near Nashville, Tennessee and maintains…
A: Large customer Medium customer Small customer Demand per year 60 24 8 Order cost 800 800 800…
Q: he Tiny Toy Company makes three types of new toys: the tiny tank, the tiny truck, and the tiny…
A:
Trending now
This is a popular solution!
Step by step
Solved in 5 steps with 4 images
- 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?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?Federal Rent-a-Car is putting together a new fleet. It is considering package offers from three car manufacturers. Fred Motors is offering 5 small cars, 5 medium cars, and 10 large cars for $500,000. Admiral Motors is offering 5 small, 10 medium, and 5 large cars for $400,000. Chrysalis is offering 10 small, 5 medium, and 5 large cars for $300,000. Federal would like to buy at least 650 small cars, at least 500 medium cars, and at least 650 large cars. How many packages should it buy from each car maker to keep the total cost as small as possible? Fred Motors packages Admiral Motors packages Chrysalis packages What will be the total cost?$Lauren Moore has sold her business for $500,000 and wants to invest in condominium units (which she intends to rent) and land (which she will lease to a farmer). She estimates that she will receive an annual return of $8,000 for each condominium and $6,000 for each acre of land. A condominium unit costs $70,000, and land costs $30,000 per acre. A condominium will cost her $1,000 per unit, an acre of land will cost $2,000 for maintenance and upkeep, and $14,000 has been budgeted for these annual expenses. Lauren wants to know how much to invest in condominiums and land to maximize her annual return. Requirements:a) Define decision variables and tabulated datab) Formulate the Integer Linear Programming Model.
- Lauren Moore has sold her business for $500,000 and wants to invest in condominium units (which she intends to rent) and land (which she will lease to a farmer). She estimates that she will receive an annual return of $8,000 for each condominium and $6,000 for each acre of land. A condominium unit costs $70,000, and land costs $30,000 per acre. A condominium will cost her $1,000 per unit, an acre of land will cost $2,000 for maintenance and upkeep, and $14,000 has been budgeted for these annual expenses. Lauren wants to know how much to invest in condominiums and land to maximize her annual return. a. Formulate a mixed integer programming model for this problem. b. Solve this model by using the computer.A furniture company manufactures chairs and desks. The sawing department cuts the lumber for both products, which is then sent to separate assembly departments. Assembled items are sent to the painting department for finishing. The daily capacity of the sawing department is 200 chairs or 80 desks. The chair assembly department can produce 120 chairs daily, and the desk assembly department 60 desks daily. The paint department has a daily capacity of either 150 chairs or 100 desks. Given that the profit per chair is $50 and that of a desk is $100. Formulate the problem as a linear program to determine the optimal product mix for the company.A large Midwestern university is opening a regional branch about an hour away from its main campus. Labor projections suggest that the company will need to hire about 200 new employees to fill cleaning, maintenance, security, and cafeteria entry-level positions. Because of traffic and bad winter weather, it is unlikely that many of the university's current staff will want to transfer to the regional branch. Most of the openings are for hands-on, manual labor jobs that do not require a college education, extensive computer skills, or office experience. The university would like to minimize the cost of its recruiting efforts. QUESTIONS 1. Why is social media the best recruiting sources for the university to fill its 200 positions? 2. Because of the new location relative to the main campus, why are external sources thebes t sourace of recuitment for the organization? Why are College and university placement offices considered as the LEAST appropriate source of recruiting for the vacant…
- Lauren Moore has sold her business for $500,000 and wants to invest in condominium units (which she intends to rent) and land (which she will lease to a farmer). She estimates thatshe will receive an annual return of $8,000 for each condominium and $6,000 for each acre of land. A condominium unit costs $70,000, and land costs $30,000 per acre. A condominium will cost her $1,000 per unit. an acre of land will cost $2,000 for maintenance and upkeep, and $14,000 has been budgeted for these annual expenses. Lauren wants to know how much to invest in condominiums and land to maximize her annual return. a. Formulate a mixed integer programming model for this problem. b. Solve this model by using the computer.The Tiny Toy Company makes three types of new toys: the tiny tank, the tiny truck, and the tiny turtle. Plastic used in one unit of each is 1.5, 2.0 and 1.0 pounds, respectively. Rubber for one unit of each toy is 0.5, 0.5, and 1.0 pounds, respectively. Also, each tank uses 0.3 pounds of metal, and the truck uses 0.6 pounds of metal during production. The average weekly availability for plastic is 16,000 pounds, 9,000 pounds of metal, and 5,000 pounds of rubber. It takes two hours of labor to make one tank, two hours for one truck, and one hour for a turtle. The company allows no more than 40 hours a week for production (priority #1). Finally, the cost of manufacturing one tank is $7, 1 truck is $5 and 1 turtle is $4; a target budget of $164,000 is initially used as a guideline for the company to follow. a) Minimize over-utilization of the weekly available supply of materials used in making the toys and place twice as much emphasis on the plastic (priority #2) b) Minimize the…Tiny Toy Company makes three types of new toys: the tiny tank, the tiny truck, and the tiny turtle. Plastic used in one unit of each is 1.5, 2.0 and 1.0 pounds, respectively. Rubber for one unit of each toy is 0.5, 0.5, and 1.0 pounds, respectively. Also, each tank uses 0.3 pounds of metal, and the truck uses 0.6 pounds of metal during production. The average weekly availability for plastic is 16,000 pounds, 9,000 pounds of metal, and 5,000 pounds of rubber. It takes two hours of labor to make one tank, two hours for one truck, and one hour for a turtle. The company allows no more than 40 hours a week for production (priority #1). Finally, the cost of manufacturing one tank is $7, 1 truck is $5 and 1 turtle is $4; a target budget of $164,000 is initially used as a guideline for the company to follow. Minimize over-utilization of the weekly available supply of materials used in making the toys and place twice as much emphasis on the plastic (priority #2) I understand…