Part I: Building a simulation model

Annie just opened an online jewelry shop at

Amazon.com and plans to sell a newly designed bracelet at $$65.$ Each

bracelet needs wire and pedants, and the combined cost of the materials $($that is$,$ wire and pendants$)$ per bracelet

amounts to $$35.$ She has enough wire and pendants to make up to $100$ bracelets this month. She has to pay $$60$ per

month to

Amazon.com for running the online shop, and each bracelet sold costs $$10$ for shipping and handling.

The completed profit model can be found in the Excel file titled "Exam $2$ Part I $24-2,"$ located in the GAView Assignment

folder under "Exam $2$ Student Files."

Complete the following tasks using the downloaded profit model.

Task $1.$ Apply the five formatting rules.

Task $2.$ Convert the profit model above to a simulation model assuming the demand follows the following

probability distribution: "Normal distribution with a mean of $100$ and a standard deviation of $20."$

Task $3.$ Run the simulation model $3500$ times using $2-$way Data Table. Use the capacity as the row input in

Data Table, and its possible values are $90,100,110,$ and $120.$