ADM 2302 Chapter Notes - Chapter 2: Feasible Region, Straight Edge, Spreadsheet

41 views1 pages

Document Summary

Characteristics of a linear programming model on a spreadsheet. Decisions need to be made on the level of a number of activities, so changing cells are used to display these levels. These activities levels can have any value that satisfy a number of constraints. The decisions on activity levels are to be based on an overall measure of performance, which is entered in the objective cell. The goal is either to maximize the objective cell or minimize the objected cell, depending on the nature of measure of performance. The excel equation for each output cell can be expressed as a sumproduct function, where each term in the sum is the product of a data cell and a changing cell. Enter the data into data cells on a spreadsheet. Identify the decisions to be made on the levels of activities and designate changing cells for displaying these decisions.

Get access

Grade+20% off
$8 USD/m$10 USD/m
Billed $96 USD annually
Grade+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
40 Verified Answers
Class+
$8 USD/m
Billed $96 USD annually
Class+
Homework Help
Study Guides
Textbook Solutions
Class Notes
Textbook Notes
Booster Class
30 Verified Answers

Related Documents

Related Questions