A machine is used to produce two interchangeable products. The daily capacity of the machine can produce at most 20 units of Product 1 and 10 units of Product 2. Alternatively, the machine can be adjusted to produce at most 12 units of Product 1 and 25 units of Product 2 daily. Market analysis shows the maximum daily demand for the two products combined is 35 units. Given that the unit profits for the two respective products are $10 and $12, formulate the Integer Linear Programming model to maximize the Total Profit.

A machine is used to produce two interchangeable products. The daily capacity of the machine can produce at most 20 units of Product 1 and 10 units of Product 2. Alternatively, the machine can be adjusted to produce at most 12 units of Product 1 and 25 units of Product 2 daily. Market analysis shows the maximum daily demand for the two products combined is 35 units. Given that the unit profits for the two respective products are $10 and $12, formulate the Integer Linear Programming model to maximize the Total Profit.

Essentials of Business Analytics (MindTap Course List)

2nd Edition

ISBN:9781305627734

Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Publisher:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson

Chapter13: Nonlinear Optimization Models

Section: Chapter Questions

Problem 4P: The profit function for two products is: Profit3x12+42x13x22+48x2+700, where x1 represents units of...

See similar textbooks

Similar questions

An industrial firm uses economic analysis to determine which of two different machines to purchase. Each machine is capable. Each machine is capable of performing the same task in a given amount of time. Assume the MARR=8%. Use the following data for analysis:Which, if either of the two machines should the firm choose?
The profit function for two products is: Profit3x12+42x13x22+48x2+700, where x1 represents units of production of product 1, and x2 represents units of production of product 2. Producing one unit of product 1 requires 4 labor-hours, and producing one unit of product 2 requires 6 labor-hours. Currently, 24 labor-hours are available. The cost of labor-hours is already factored into the profit function, but it is possible to schedule overtime at a premium of 5 per hour. a. Formulate an optimization problem that can be used to find the optimal production quantity of products 1 and 2 and the optimal number of overtime hours to schedule. b. Solve the optimization model you formulated in part (a). How much should be produced and how many overtime hours should be scheduled?
An industrial firm uses economic analysis to determine which of two different machines to purchase. Each machine is capable. Each machine is capable of performing the same task in a given amount of time. Assume the MARR=8%. Use the following data for analysis:What is the approximate equivalent uniform annual cost of Machine X?
Assume that the linear cost and revenue models apply. An item costs $13 to make. If fixed costs are $1600 and profits are $5700 when 100 items are made and sold, find the revenue equation. (Let x be the number of items.)R(x) =
Patz Company produces two types of machine parts: Part A and Part B, with unit contribution margins of $400 and $800, respectively. Assume initially that Patz can sell all that is produced of either component. Part A requires two hours of assembly, and B requires five hours of assembly. The firm has 400 assembly hours per week. Required: 1. Express the objective of maximizing the total contribution margin subject to the assembly-hour constraint. Objective function: Max Z = $400 A + $800 B Subject to: fill in the blank 1 A + fill in the blank 2 B ≤ fill in the blank 3 2. Identify the optimal amount that should be produced of each machine part. If none of the components should be produced, enter "0" for your answer. Component A fill in the blank 4 units Component B fill in the blank 5 units Identify the total contribution margin associated with this mix.$fill in the blank 6
a) Build a spreadsheet model that calculates profit or loss, using the principles of good spreadsheet design. If Harris makes 15,000 units, what is the resulting profit? b) Construct a one-way data table with production volume as the column input and profit as the output. Vary production volume from 0 to 100,000 in increments of 10,000. In which interval of production volume does breakeven occur? c) Construct a two-way data table with production volume as the column input and revenue per unit as the row input. Vary production volume from 0 to 100,000 in increments of 10,000. Input the revenue per units as $.75, $.85, $.95, $1.05. d) Use Goal Seek to find the exact breakeven point. Hint: To value: = 0.
Ptarmigan Company produces two products. Product A has a contribution margin of $44.00 and requires 8 machine hours. Product B has a contribution margin of $67.20 and requires 12 machine hours. Determine the most profitable product assuming the machine hours are the constraint. If required, round your answers to two decimal places. Contribution margin per machine hour: Product A $ Product B $ Product is the most profitable.
Harrington Corporation produces three products, A, B, and C. Pertinent information on these products is as follows: Product Selling Price per Unit Variable Cost per Unit Fixed Costper Unit DL Hoursper Unit A $ 4.00 $ 1.00 $ 2.00 2 B $ 3.50 $ 0.50 $ 2.00 2 C $ 6.00 $ 2.00 $ 3.00 3 The objective function for a linear program to maximize contribution margin from the set of three products is: Multiple Choice Z = $3A + $2.50B + $5C. Z = A + B + C. Z = A + $0.50B + $2C. Z = $3A + $3B + $4C. Z = $4A + $3.50B + $6C.
Suppose that a firm makes two products, A and B. The sales mix in units for the period is 70% for A and 30% for B. If the unit contribution margin for A is $8.83 and the unit contribution margin for B is $5.76, then the weighted-average unit contribution margin is: (Input your answer using two decimal places. Do not use commas or dollar signs. Don't round any intermediate calculations)
Use the following information for the next 2 questions (8 & 9). Division X produces and sells a product to external and internal customers. Per-unit information about its operations include: Selling price per unit to external customers $250 Variable manufacturing costs per unit 115 Fixed manufacturing overhead costs per unit 70 8. If X is operating at capacity and has unlimited external customer demand, what should be the minimum transfer price? 9. If X has sufficient excess capacity to meet internal demand, what should be the minimum transfer price?
The number of set ups is the cost driver for production scheduling and machine set ups. The number of set ups for three products are as follows: Number of set-ups is X=240, Y=260 and Z=300. If the cost of production scheduling is GH¢1.2 million and the cost of ordering is GH¢1.8 million, how much of the production scheduling should be charged to Y?A. GH¢390,000B. GH¢360,000C. GH¢702,000D. GH¢500,000
A new product is being designed by an engineering team at Golem Security. Several managers and employees from the cost accounting department and the marketing department are also on the team to evaluate the product and determine the cost using a target costing methodology. An analysis of similar products on the market suggests a price of $132.00 per unit. The company requires a profit of 0.20 of selling price. How much is the target cost per unit? Round to two decimal places.