Purchase Solution

Cost Minimization problem using Excel

Not what you're looking for?

Ask Custom Question

Given the following linear programming problem:
Min Z = 2x + 8y
Subject to (1) 8x + 4y 64
(2) 2x + 4y 32
(3) y 2
At the optimal solution the minimum cost is:

a. $30
b. $40
c. $50
d. $52
d. $53.33

Purchase this Solution
Solution Summary

This posting provides solution to cost minimization problem using excel.

Purchase this Solution
Free BrainMass Quizzes
Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

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.

Motivation

This tests some key elements of major motivation theories.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.

IPOs

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

View More Free Quizzes
Related BrainMass Solutions

  • Excel Solver: Toy Manufacturing Company

    The problem is formulated and solved using integer programming with binary variables. The solve process is demonstrated using Excel solver.

  • Hungarian method and EOQ.

    . --> Hungarian method is applicable for minimization problem. Assignment problem having maximization as objective function can be easily converted into a minimization problem and then solved using Hungarian method.

  • Linear programming problem: Minimization

    If there is any constraint, which is < kindly change in excel and you will get the new optimal values. This solution provides details on how to solve a minimization problem for a linear programming situation.

  • Short run and long run cost minimization problem

    99753 Short run and long run cost minimization problem Suppose that a firm's production function is Q = 10 L 0.5 K 0.5 The cost of a unit of L is 20$ and user cost of capital is 80$.

  • Optimization with Excel Solver

    538101 Optimization with Excel Solver I need help with the excel solver for this minimization problem. Please take a look at it and let me know if you can help me with the solver. I have included the objective and the constraints.

  • Linear Programming

    Excel Sensitivity Analysis 2 Using the model and the sensitivity report from the previous problem, a manager is offered the opportunity to make a bulk purchase of 150 additional hours for Process 1 at a cost of $1050.

  • Case Study on Transportation Model Using Minimization Method

    This solution contains explanations and analysis of data with regards to the transportation model using the minimization method (see attachments).

  • Profit Maximization, Cost Minimization

    13042 Profit Maximization, Cost Minimization: Prove that profit maximization implies cost minimization but not vice versa. Prove that profit maximization implies cost minimization but not vice versa.

  • linear business problem

    Material = M Space = S Assembly = A Cost = C Selling = S Books = B Board Games = BG Snacks = SN Videos = V c) What is the objective function? Is this a maximization or a minimization problem?

View More Related Solutions