Questions from Spreadsheet Modeling


Q: Sometimes the historical data on returns and variances may be poor predictors

Sometimes the historical data on returns and variances may be poor predictors of how investments will perform in the future. In this case, the scenario approach to portfolio optimization may be used....

See Answer

Q: Barbara Roberts recently received $30,000 as a small inheritance

Barbara Roberts recently received $30,000 as a small inheritance from a distant relative. She wants to invest the money so as to earn $900 to buy a notebook computer next year when she enters graduate...

See Answer

Q: World Delivery Service (WDS) specializes in the pick-up

World Delivery Service (WDS) specializes in the pick-up and delivery of packages at homes and businesses throughout the United States and around the world. WDS utilizes a fleet of trucks that leave fr...

See Answer

Q: A mortgage company owns the following 10 mortgages. Investors will purchase

A mortgage company owns the following 10 mortgages. Investors will purchase packages of mortgages worth at least $1 million. What is the maximum number of such packages that can be created from this s...

See Answer

Q: A small printing shop has 10 jobs it must schedule. The

A small printing shop has 10 jobs it must schedule. The processing times and due dates for each job are summarized in the following table: a. Suppose the jobs are scheduled in ascending order by proc...

See Answer

Q: Consider the following function: Y 5 20.865 1 8

Consider the following function: Y 5 20.865 1 8.454X 2 1.696X2 1 0.132X3 2 0.00331X4 a. Plot this function on an X-Y graph for positive values of X from 1 to 20. b. How many local maximum solutions ar...

See Answer

Q: Walla Corporation is a privately held manufacturer of doors and windows with

Walla Corporation is a privately held manufacturer of doors and windows with annual sales in excess of $900 million. Some of the company’s products are “standard size” and sold through wholesale and r...

See Answer

Q: The Major Motors Corporation manufactures heavy trucks at a plant in Dublin

The Major Motors Corporation manufactures heavy trucks at a plant in Dublin, Virginia. The factory’s stock of spare and custom parts is stored in a huge shelving system that is sever...

See Answer

Q: Consider the following function’s 5 37.684 2 15.315X

Consider the following function’s 5 37.684 2 15.315X 1 3.095X2 2 0.218X31 0.005X4 a. Plot this function on an X-Y graph for positive values of X from 1 to 20. b. How many local maximum solutions are t...

See Answer

Q: Consider the following function: Y 5 37.684 2 15

Consider the following function: Y 5 37.684 2 15.315X 1 3.095X2 2 0.218X3 1 0.005X4 a. Plot this function on an X-Y graph for positive values of X from 1 to 20. b. How many local maximum solutions a...

See Answer