Purchase Solution

OR problems using LP and IP

Not what you're looking for?

Ask Custom Question

1. (P2-38) The production department for an aluminum valve plant is scheduling its work for next month. Each valve must go through three separate machines during the fabrication process. After fabrication, each valve is inspected by a human being, who spends 15 minutes per valve. There are 525 inspection hours available for the month. The time required (in hours) by each machine to work on each valve is shown in the following table. Also shown are the minimum number of valves that must be produced for the month and the unit profit for each valve.

PRODUCT V231 V242 V784 V906 CAPACITY
(hours)
Drilling 0.40 0.30 0.45 0.35 700
Milling 0.60 0.65 0.52 0.48 890
Lathe 1.20 0.60 0.5 0.70 1200
Unit profit $16 $12 $13 $8
Minimum needed 200 250 600 450

The investor's criteria are as follows: (1) The investment should yield short-term growth of at least $1,000; (2) the investment should yield intermediate-term growth of at least $6,000; and (3) the dividends should be at least $250 per year. Determine the least amount the investor can invest and how that investment should be allocated between the three stocks.

2. (P2-43) An investor is considering three different television news stocks to complement his portfolio: British Broadcasting Company (BBC), Canadian Broadcasting Company (CBC), and Australian Broadcasting Company (ABC). His broker has given him the following information:

Short-Term Growth (per $ invested) Intermediate Growth (per $ invested) Dividend Rate
BBC 0.39 1.59 8%
CBC 0.26 1.70 4%
ABC 0.42 1.45 6%

The investor's criteria are as follows: (1) The investment should yield short-term growth of at least $1,000; (2) the investment should yield intermediate-term growth of at least $6,000; and (3) the dividends should be at least $250 per year. Determine the least amount the investor can invest and how that investment should be allocated between the three stocks.

Attachments
Purchase this Solution

Solution Summary

The solution provides step by step guide on formulating and solving OR problems using Excel Solver.

Solution Preview

Hello,

Please find attached excel file containing detailed step by step help on addressing the questions. The first sheet contains guidelines on how to ...

Purchase this Solution


Free BrainMass Quizzes
Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Motivation

This tests some key elements of major motivation theories.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.