Mathematically formulate a linear optimization model

Assignment Help Basic Computer Science
Reference no: EM133016163

Problem #1 (Developing Linear Optimization Models): Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. The firm can sell all it produces. Both models use the same electronic components. Two of these can be obtained only from a single supplier. For the next month, the supply of these is limited to 4,000 of component A and 3,500 of component B. The number of each components required for each product and the profit per unit are given in the table:
Components Required per Unit
Product A B Profit/Unit
LaserStop 18 6 $124
SpeedBuster 12 8 $136

Part a: identify the decision variables, objective function, and constraints in simple verbal statements.

Part b: mathematically formulate a linear optimization model.

Problem #2 (Developing Linear Optimization Models): A brand manager for ColPal Products must determine how much time to allocate between radio and television advertising during the next month. Market research has provided estimates of the audience exposure for each minute of advertising in each medium, which it would like to maximize. Costs per minute of advertising are also known, and the manager has a limited budget of $25,000. The manager had decided that because television ads have been found to be more effective than radio ads, at least 75% of the time should be allocated to television.

Part a: identify the decision variables, objective function, and constraints in simple verbal statements.

Part b: mathematically formulate a linear optimization model.

Problem #3 (Developing Linear Optimization Models): A business student has $2,500 available from a summer job and has identified three potential stocks in which to invest. The cost per share and expected return over the next two years is given in this table:

Stock A B C
Price/share $12 $15 $30
Return/share $8 $7 $11

Part a: identify the decision variables, objective function, and constraints in simple verbal statements.

Part b: mathematically formulate a linear optimization model.

Problem #4 (Solving Linear Optimization Models): Implement the linear optimization model that you developed for Valencia Products in Problem #4 on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver Answer Report, identify the binding constraints, and verify the values of the slack variables by substituting the optimal solution into the model constraints.

Problem #5 (Solving Linear Optimization Models): Implement the linear optimization model that you developed for the investment scenario in Problem #7 on a spreadsheet and use Solver to find an optimal solution. Interpret the Solver Answer Report, identify the binding constraints, and verify the values of the slack variables by substituting the optimal solution into the model constraints.

Problem #6 (How Solver Works): For the Valencia Products model in Problem #4, graph the constraints and identify the feasible region. Then identify each of the corner points and show how increasing the objective function value identifies the optimal solution.

Problem #7 (How Solver Works): For the ColPal model in Problem #5, graph the constraints and identify the feasible region. Then identify each of the corner points and show how increasing the objective function value identifies the optimal solution.

Problem #8 (Integer Linear Optimization Models): Solve the following problem (which is #12 from Chapter 13) ensuring the number of units produced is an integer. How much difference is there between the optimal integer solution objective function and the linear optimization solution objective function? Would rounding the continuous solution have provided the optimal integer solution?

Reference no: EM133016163

Questions Cloud

What is the cost of common equity : Summerdahl Resort's common stock is currently trading at $20 a share. What is the cost of common equity
How to calculate break even : How to calculate break even if you wanted to more than break even. If you had a sales price of $10, COGS of $4.00. FC=$1000
How much is the account worth today : If Jennifer started saving at age 24 and has earned an average annual return of 4%, how much is the account worth today
Prepare financial statements for the month : Journalize the above transactions in a two-column journal and Prepare post-dosing trial balance - Prepare financial statements for the month
Mathematically formulate a linear optimization model : Identify the decision variables, objective function, and constraints in simple verbal statements and mathematically formulate a linear optimization model
Demonstrate derivational paths of crucial examples : List all relevant phonological rules, and indicate if rule ordering is needed and Demonstrate derivational paths of crucial examples
Calculate the minimum transfer price : GS can purchase comparable barbeques from a Weber BBQ for $485. Calculate the minimum transfer price that SG would charge to remain financially neutral
MCROO1 Economics Assignment : MCROO1 Economics Assignment Help and Solution, Universal Business School Sydney - Assessment Writing Service
Do you think the bond is overpriced : Ron Rhodes calls his broker to inquire about purchasing a bond of Golden Years Recreation Corporation. Do you think the bond is overpriced

Reviews

len3016163

10/21/2021 9:41:16 PM

Please complete every problem using screenshots from excel. Highlighted problems are the ones already completed but included for reference. Need done by 11pm central time tonight.

Write a Review

Basic Computer Science Questions & Answers

  Identifies the cost of computer

identifies the cost of computer components to configure a computer system (including all peripheral devices where needed) for use in one of the following four situations:

  Input devices

Compare how the gestures data is generated and represented for interpretation in each of the following input devices. In your comparison, consider the data formats (radio waves, electrical signal, sound, etc.), device drivers, operating systems suppo..

  Cores on computer systems

Assignment : Cores on Computer Systems:  Differentiate between multiprocessor systems and many-core systems in terms of power efficiency, cost benefit analysis, instructions processing efficiency, and packaging form factors.

  Prepare an annual budget in an excel spreadsheet

Prepare working solutions in Excel that will manage the annual budget

  Write a research paper in relation to a software design

Research paper in relation to a Software Design related topic

  Describe the forest, domain, ou, and trust configuration

Describe the forest, domain, OU, and trust configuration for Bluesky. Include a chart or diagram of the current configuration. Currently Bluesky has a single domain and default OU structure.

  Construct a truth table for the boolean expression

Construct a truth table for the Boolean expressions ABC + A'B'C' ABC + AB'C' + A'B'C' A(BC' + B'C)

  Evaluate the cost of materials

Evaluate the cost of materials

  The marie simulator

Depending on how comfortable you are with using the MARIE simulator after reading

  What is the main advantage of using master pages

What is the main advantage of using master pages. Explain the purpose and advantage of using styles.

  Describe the three fundamental models of distributed systems

Explain the two approaches to packet delivery by the network layer in Distributed Systems. Describe the three fundamental models of Distributed Systems

  Distinguish between caching and buffering

Distinguish between caching and buffering The failure model defines the ways in which failure may occur in order to provide an understanding of the effects of failure. Give one type of failure with a brief description of the failure

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd