Question: Develop and submit an Excel model for the following problem. Any violation of the Academic Code of Conduct, including using online resources, will result in

 Develop and submit an Excel model for the following problem. Any

Develop and submit an Excel model for the following problem. Any violation of the Academic Code of Conduct, including using online resources, will result in failing the course. Acme Paint manufacturers residential paint in different colors by adding different amounts of colorants to white base paint. They make 1quart cans of paint and sell them to paint stores. Their cost of colorants and white base varies from time to time. To make a lquart can of teal paint they add certain amounts of blue and green colorants to white base and then mix the can. The following table shows their cost and variations in cost for the colorants and the white base: Blue Colorant Green Colorant White Base Average Cost/oz $0.15 Standard Deviation 0.05 Each lquart can of teal paint requires 5 oz of blue colorant and 8 oz of green colorant, and the rest of the can is filled with white base. The process of dispensing and mixing the paint is not exact and the following table shows the variations in dispensing the colorants. After the colorants are added the can is filled with white base until the total volume reaches 1quart (Note: 32 07. = 1quart}. Blue Colorant Green Colorant Volume [oz] Standard Deviation As the result of the variations in cost and mixing the colorants and white base the actual cost of a 1 quart can varies. However, the cans are sold for $15.35 each. Therefore, the profitfloss per can varies. Create a Monte Carlo model with 5,000 simulations and compute the expected profitfloss per 1quart can of teal paint. Bonus [5 points] Use the above model to predict the percentage of paint cans that lead to a loss. Develop an Excel model for the above Monte lCarlo simulation and submit the spreadsheet via Canvas

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Economics Questions!