Purchase Solution

Linear programming

Not what you're looking for?

Ask Custom Question

Using Excel, please solve the following:

A company produces two products that are processed on two assembly lines. Assembly line 1 has 100 available hours, and assembly line 2 has 42 available hours. Each product requires 10 hours of processing time on line 1, while on line 2 product 1 requires 7 hours and product 2 requires 3 hours. The profit for product 1 is $6 per unit, and the profit for product 2 is $4 per unit.

Formulate a linear programming model for this problem.

Attachments
Purchase this Solution

Solution Summary

Excel file contains Formulation and optimal solution of a linear programming model for the problem.

Purchase this Solution


Free BrainMass Quizzes
SWOT

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

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

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.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Business Processes

This quiz is intended to help business students better understand business processes, including those related to manufacturing and marketing. The questions focus on terms used to describe business processes and marketing activities.