Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting Parameters for SUMPRODUCT Results
I am working on a spreadsheet with SUMPRODUCT results that have set parameters.
The problem I am to solve says: A factory builds TVs, stereos, and speakers. There are five types of parts: chassis, picture tubes, speaker cones, power supplies, and electronics units. A TV earns $75 gross profit, a stereo earns $50, and a speaker cone earns $35. There are 450 chassis, 250 picture tubes, 800 speaker cones, 450 power supplies, and 600 electronics units. I have created SUMPRODUCT formulas to determine how many TVs, stereos, and speakers will produce maximum profit. I need to set parameters for the formulas so that for each part, the result does not exceed the number of such parts available. The site, http://www.solver.com/stepbystep2.htm, mentions solver dialogs, but I cannot locate these. Pleaae help - the problem is supposed to be solved before midnight Mountain Time this Sunday, October 5! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting Parameters for SUMPRODUCT Results
I've not used SOLVER, but in 2003, you need to load the add-in first. I
went to Tools- Add-Ins and selected SOLVER. Barb Reinhardt "J and N" wrote: I am working on a spreadsheet with SUMPRODUCT results that have set parameters. The problem I am to solve says: A factory builds TVs, stereos, and speakers. There are five types of parts: chassis, picture tubes, speaker cones, power supplies, and electronics units. A TV earns $75 gross profit, a stereo earns $50, and a speaker cone earns $35. There are 450 chassis, 250 picture tubes, 800 speaker cones, 450 power supplies, and 600 electronics units. I have created SUMPRODUCT formulas to determine how many TVs, stereos, and speakers will produce maximum profit. I need to set parameters for the formulas so that for each part, the result does not exceed the number of such parts available. The site, http://www.solver.com/stepbystep2.htm, mentions solver dialogs, but I cannot locate these. Pleaae help - the problem is supposed to be solved before midnight Mountain Time this Sunday, October 5! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Setting Parameters for SUMPRODUCT Results
Did that and plugged in the information from the site. However, we cannot
get the problem to "solve" itself. We had some "trial" numbers in the three "# to Build" cells, and we got a strange answer: -E4... We therefore cleared Cells E12:G12 and E22; the solver result is 0. Why is this happening?! "Barb Reinhardt" wrote: I've not used SOLVER, but in 2003, you need to load the add-in first. I went to Tools- Add-Ins and selected SOLVER. Barb Reinhardt "J and N" wrote: I am working on a spreadsheet with SUMPRODUCT results that have set parameters. The problem I am to solve says: A factory builds TVs, stereos, and speakers. There are five types of parts: chassis, picture tubes, speaker cones, power supplies, and electronics units. A TV earns $75 gross profit, a stereo earns $50, and a speaker cone earns $35. There are 450 chassis, 250 picture tubes, 800 speaker cones, 450 power supplies, and 600 electronics units. I have created SUMPRODUCT formulas to determine how many TVs, stereos, and speakers will produce maximum profit. I need to set parameters for the formulas so that for each part, the result does not exceed the number of such parts available. The site, http://www.solver.com/stepbystep2.htm, mentions solver dialogs, but I cannot locate these. Pleaae help - the problem is supposed to be solved before midnight Mountain Time this Sunday, October 5! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting axis parameters for a chart in the worksheet | Charts and Charting in Excel | |||
Fine tune the counting area by setting up parameters | New Users to Excel | |||
help with setting up a spread sheet to track survey results | Setting up and Configuration of Excel | |||
Setting colors of results in a column | Excel Discussion (Misc queries) | |||
Using function results as parameters in another function | Excel Worksheet Functions |