Profit = Sales - variable cost - fixed cost
Let c = variable cost per unit and X = demand.
a)
Thus, the profit model is as follows
Profit = Sales - variable cost - fixed cost
Profit = $35X - cX - $27,000
b)
Base case- Demand will be 1500 units and variable cost per unit = $19
Substituting the values in the profit model, we get
Profit = $35 * 1500 - $19 * 1500 - $27,000
Profit = $52,500 - $28,500 - $27,000
Profit = -$3,000
Best case- Demand will be 2000 units and variable cost per unit = $16
Substituting the values in the profit model, we get
Profit = $35 * 2000 - $16 * 2000 - $27,000
Profit = $70,000 - $32,000 - $27,000
Profit = $11,000
Worst case- Demand will be 700 units and variable cost per unit = $22
Substituting the values in the profit model, we get
Profit = $35 * 700 - $22 * 700 - $27,000
Profit = $24,500 - $15,400 - $27,000
Profit = -$17,900
Thus, there is a loss of $17,900
Que 2:
Ans:
a) Using 500 simulation trials, formula used are displayed below:


Mean profit of the simulation:Profit for 500 simulation Trials

From the Summary Statistics , Mean profit is $5519.46
b) The probability that the project will lead to a loss,

The probability that the project will lead to a loss is 0.294
The management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed...
The management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed cost to begin the production of the product is $35,000. The variable cost for the product is uniformly distributed between $17 and $23 per unit. The product will sell for $55 per unit. Demand for the product is best described by a normal probability distribution with a mean of 1,300 units and a standard deviation of 300 units. Develop an Excel worksheet simulation for...
Problem 12-02 (Algorithmic) The management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed cost to begin the production of the product is $31,000. The variable cost for the product is expected to be between $20 and $26 with a most likely value of $24 per unit. The product will sell for $50 per unit. Demand for the product is expected to range from 500 to 1600 units, with 1300 units the most likely demand....
Problem 12-14 (Algorithmic) The management of Madeira Manufacturing Company is considering the introduction of a new product. The fixed cost to begin the production of the product is $38,000. The variable cost for the product is uniformly distributed between $18 and $24 per unit. The product will sell for $58 per unit. Demand for the product is best described by a normal probability distribution with a mean of 1,100 units and a standard deviation of 300 units. Develop an Excel...
Problem 12-01 (Algorithmic) The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. The selling price for the product will be $45 per unit. Probability distributions for the purchase cost, the labor cost, and the transportation cost are estimated as follows: Transportation Labor Probability Cost ($) Probability 20 23 24 26 Procurement Cost ($) 10 Cost ($)Probability 0.72 0.2 0.25 0.35 0.2 0.35 0.25 0.4 0.28 13 a. Compute profit...
(Fill in the blanks) The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. The selling price for the product will be $50 per unit. Probability distributions for the purchase cost, the labor cost, and the transportation cost are estimated as follows: Procurement Cost ($) Probability Labor Cost ($) Probability Transportation Cost ($) Probability 10 0.3 20 0.15 3 0.7 11 0.35 22 0.25 5 0.3 12 0.35 24 0.3...
(Fill in the blanks) The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. The selling price for the product will be $50 per unit. Probability distributions for the purchase cost, the labor cost, and the transportation cost are estimated as follows: Procurement Cost ($) Probability Labor Cost ($) Probability Transportation Cost ($) Probability 10 0.3 20 0.15 3 0.7 11 0.35 22 0.25 5 0.3 12 0.35 24 0.3...
Problem 12-01 (Algorithmic)The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. The selling price for the product will be $ 45 per unit. Probability distributions for the purchase cost, the labor cost, and the transportation cost are) estimated as follows:a. Compute profit per unit for the base-case, worst-case, and best-case scenarios.Profit per unit for the base-case: $Profit per unit for the worst-case: $Profit per unit for the best-case: $b....
Problem 16-01 The management of Brinkley Corporation is interested in using simulation to estimate the profit per unit for a new product. The selling price for the product will be $45 per unit. Probability distributions for the purchase cost, the labor cost, and the transportation cost are estimated as follows: Procurement Cost ($) Probability Labor Cost ($) Probability Transportation Cost ($) Probability 10 0.25 20 0.10 3 0.75 11 0.45 22 0.25 5 0.25 12 0.30 24 0.35 25 0.30...
Barbour Electric is considering the introduction of a new product. This product can be produced in one of several ways: (a) using the present assembly line at a cost of $40 per unit, (b) using the current assembly line after it has been overhauled (at a cost of $15,000) with a cost of $30 per unit; and (c) on an entirely new assembly line (costing $35,000) designed especially for the new product with a per unit cost of $20. Barbour...
6. Barbour Electric is considering the introduction of a new product. This product can be produced in one of several ways: (a) using the present assembly line at a cost of $25 per unit, (b) using the current assembly line after it has been overhauled (at a cost of $5,000) with a cost of $22 per unit; and (c) on an entirely new assembly line (costing $20,000) designed especially for the new product with a per unit cost of $20....