Purchase Solution

The Texas Consolidated Electronics Company Problem

Not what you're looking for?

Ask Custom Question

The Texas Consolidated Electronics Company is contemplating a research and development program encompassing eight research projects. The company is constrained from embarking on all projects by the number of available management scientists (40) and the budget available for R&D projects ($300,000). Further, if project 2 is selected, project 5 must also be selected (but not vice versa). Following are the resources requirement and the estimated profit for each project.

Project Expense
($1,000s)
Management
Scientists required
Estimated Profit
(1,000,000s)
1 50 6 0.30
2 105 8 0.85
3 56 9 0.20
4 45 3 0.15
5 90 7 0.50
6 80 5 0.45
7 78 8 0.55
8 60 5 0.40

Formulate the integer programming model for this problem and solve it using the computer.

Purchase this Solution
Solution Summary

The solution comprises of detailed solution of the given LP problem using EXCEL Solver.

Solution provided by:
Anwesha Ghosh, MSc
Education
  • MSc, Osmania University
  • MSc, Indian Institute of Technology - Roorkee (I.I.T.-ROORKEE)
  • BSc, Banaras Hindu University
Recent Feedback
  • "Very fast turnaround. Excellent communication! Much appreciated!"
  • "excellent"
  • "excellent"
  • "excellent work"
  • "Fantastic..great solution and very well explained!!!!"
Purchase this Solution
Free BrainMass Quizzes
Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Understanding the Accounting Equation

These 10 questions help a new student of accounting to understand the basic premise of accounting and how it is applied to the business world.

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.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

View More Free Quizzes
Related BrainMass Solutions

  • Question about integer programming model

    289526 Question about integer programming model The Texas Consolidated Electronics Company is contemplating a research and development program encompassing eight research projects.

  • Mathematics - Linear Operators

    Consolidated Electronics uses a consultant to teach the training programs. During the next six months, the consultant has 84 days of training time available.

  • Causes for the rise of a strong Republican Party in Texas

    In 2002 elections, the Republicans had captured most of the statewide offices, legislature, and both Senate and House. After the polls of 2004, Republicans once again consolidated their position. The Democratic Party was started in Texas in 1848.

  • Financial Analysis of Intel

    Industry Leaders o Intel Corporation o Samsung Electronics o Texas Instruments Industry Comparative Analysis Company Intel 2003 Samsung Electronics 2003 Texas Instruments 2003 Intel 2004 Samsung Electronics Texas Instruments 2004

  • Consolidation of Accounts

    This enables a company with consolidated statements to remain profitable. An important problem with consolidation is that the financial statements that are consolidated have some details lost because of the consolidation process.

  • Modeling Excel

    The Texas Electronics Company (TEC) is contemplating a research and development program encompassing eight major projects.

  • Upstream and Downstream Sales & Multiple Stock Purchases

    Controlling interest in consolidated income Problem 7-1 Workpaper Journal Entries and Income Statement Balances Powell Company owns 80% of the outstanding common stock of Sullivan Company.

  • Consolidated Financials, Intercompany, Variable Interest Entities

    Compute the balances in problem 28 again, assuming that the intercompany transfers were all made from Broadway to Asphalt.

  • General Motors' Liability Lawsuit side-saddle fuel tanks

    A class action lawsuit with numerous state class actions was brought against GM and subsequently consolidated into a multi-district litigation (MDL) in the Federal District Court in Philadelphia with a separate class action in the state of Texas.

View More Related Solutions