The Week 1 by Truck and Week 1 by Rail constraints each have a shadow price of −360. Unfortunately, competing demands limit the availability of each mode of transportation each of the three weeks to the following levels (all in thousands of tons): The following is the LP model for this logistics problem. The fixed cost to begin the production of the product is 30,000. Contracts in place with the transportation companies call for at least 45% of the total delivered be delivered by trucking, at least 40% of the total delivered be delivered by railway, and up to 15% of the total delivered be delivered by air cargo. (All answers generated on the Analytic Solver Platform using 10,000 trials and random seed 1994.) The management of Madeira Manufacturing Company is considering the introduction of a new product. Their contract calls for 120,000 tons delivered by the end of week one, 80% of the total delivered by the end of week two, and the entire amount delivered by the end of week three. Carlton's supply depot has access to three modes of transportation: a trucking fleet, railway delivery, and air cargo transport. Their contract calls for a total of 250,000 tons of material to be delivered over a three-week period. To solve larger models (up to hundreds of thousands or millions of decision variables), please contact Frontline Systems at or 77.The following questions are based on the problem below and accompanying Analytic Solver Platform sensitivity report.Ĭarlton construction is supplying building materials for a new mall construction project in Kansas. This server has a finite capacity, as currently provisioned (and paid for) by Frontline Systems. When you click the Solve button in the Add-on, your model is queued for solution by Frontline's backend Solver Server. There are no fixed limits on iterations or subproblems, but the backend server currently limits solving time to 30 seconds. To see examples, visit Many textbooks also include examples and discussions of Solver models - see Problem size limits in the Solver Add-on are the same as in the Excel Solver (200 decision variables and 100 constraints in addition to bounds on the variables). Weve worked hard to make the Solver Platform SDK the premier development tool for both resource allocation models using optimization, and risk analysis. To learn more about optimization problems and what you can (and cannot) expect from solutions, visit You can use the Solver Add-on to find better ways to allocate scarce resources, maximize profits or minimize costs or risks, in a wide range of applications in finance and investment, marketing, manufacturing and production, distribution and logistics, purchasing, and human resources, as well as science and engineering. You can solve linear programming and mixed-integer programming problems with the Simplex LP Solver, nonlinear optimization problems with the GRG Nonlinear Solver, global optimization problems with the multistart method, and 'arbitrary' Sheets models containing any numeric formulas with the Evolutionary Solver. Click on the RSPAddin.xll file and then open. Below where it allows you to view the ‘File Type’ select ‘All Files’. Most problems can be resolved very quickly. Weve notified our technical support staff, and they will attempt to contact you as soon as possible to resolve the problem.
#Analytic solver platform problem software#
Were sorry that you had a problem installing our software for a 15-day trial.
#Analytic solver platform problem windows#
Step 5: Then browse in windows explorer to C:Program Files (x86)Frontline SystemsAnalytic Solver PlatformBin. Analytic Solver Platform Support - Problem with Installation. With the Solver Add-on, created by Frontline Systems, developers of the Solver in Microsoft Excel (you can define and solve many types of optimization problems in Google Sheets, just as you can with the Excel Solver and with Frontline's Solver App for Excel Online. Step 4: Check to see if ‘Analytic Solver Platform’ is in there and checked.