Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

The Ethics Of The New Economy Restructuring And Beyond

Authors: Leo Groarke

1st Edition

1554586933, 9781554586936

More Books

Students also viewed these Economics questions

Question

Embrace the basic accounting principles. L01

Answered: 1 week ago

Question

2. Ask questions, listen rather than attempt to persuade.

Answered: 1 week ago