These Excel exercises can be reviewed
as Adobe Acrobat Version 4-format documents and -- in some cases --
also online. To view an Acrobat-format file in your browser you'll need
a copy of the free Adobe Acrobat Reader. If you don't already have a
copy of the Reader, get one from Adobe's
download site. Right-click an Acrobat file link to view it. You can
print the file from within the view. If you want to save the file directly
to your hard drive without viewing it first, right-click the link and
choose the pop-up menu command that appears and reads "'Save Link
As", "Save Target As", or something similar.
Online & Adobe Acrobat formats
Click the link above for practice with basic Excel
modeling skills, the use of some specialized Excel functions, and the
Excel Solver add-in in the context of a resource optimization problem.
The Oak Products exercise is drawn from Prentice-Hall's "Introductory
Management Science" by Eppen, Gould, Schmidt, Moore, and Weatherford.
Svelte Glove is a product mix problem that takes
you step-by-step through building a worksheet to determine what mix
of products yields the highest profit. A set of production constraints
complicates the model. You first build the model to allows a manual
determination of the product mix, then apply Excel's Solver to automate
the process. The Adobe Acrobat format file is about 185K in size.
The Padgett's Widgets problem is similar to the
Oak Products and Svelte Glove problems above. For the Padgett's Widgets
model you calculate profit as a function of four price levels and identify
the optimum price with the help of a chart. You then expand and refine
the model and the chart to allow for forty prices. Although worksheet
screen shots are provided, no step-by-step help is given. The Adobe
Acrobat file is about 113K in size.