LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting axis parameters for a chart in the worksheet Steve S Charts and Charting in Excel 1 July 14th 08 08:30 AM
Fine tune the counting area by setting up parameters wilchong via OfficeKB.com New Users to Excel 5 May 30th 08 03:48 AM
help with setting up a spread sheet to track survey results Elnora Setting up and Configuration of Excel 1 May 28th 07 07:05 AM
Setting colors of results in a column ERBERB Excel Discussion (Misc queries) 1 October 28th 05 01:21 PM
Using function results as parameters in another function Steve Haack Excel Worksheet Functions 1 April 24th 05 11:39 PM


All times are GMT +1. The time now is 06:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"