Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Michael runs a specialty clothing store that sells collegiate sports apparel. One of his primary business opportunities involves selling sweatshirts for college football games. On

Michael runs a specialty clothing store that sells collegiate sports apparel. One of his primary business opportunities involves selling sweatshirts for college football games. On September 1st, Michaels store is delivered an order of 7,000 sweatshirts with a purchasing price of $20 per piece from his supplier. He plans to sell the sweatshirts for $35 per piece. Demand in September for sweatshirts follows a discrete uniform distribution with a minimum of 5,000 and a maximum of 10,000. At the end of September, if there are less than 5,000 sweatshirts in inventory, Michael places an order for 4,000 sweatshirts from his supplier. This order is delivered just in time on October 1st. Demand in October for sweatshirts follows a discrete uniform distribution with a minimum of 2,000 and a maximum of 6,000. At the end of October, if there are less than 4,000 sweatshirts in inventory, he places an order for 3,000 sweatshirts from his supplier. This order is delivered just in time on November 1st. During the rest of the college football season in November and December, demand for sweatshirts follows a discrete uniform distribution with a minimum of 1,000 and a maximum of 4,000. After the college football season ends, Michael plans to sell any remaining sweatshirts for $12 per piece. At this price, he believes demand for sweatshirts will follow a discrete uniform distribution with a minimum of 500 and a maximum of 4,000. At the end of December, all unsold sweatshirts are donated to homeless people shelters. Build a simulation model in Crystal Ball and run it for 1,000 replications to answer the following questions. a) Estimate the mean profit.b) Estimate the probability that Michael can generate a profit larger than $100,000.

**Using Crystal Software on Microsoft Excel

*Please post a link on how you solve if possible

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

Aviation Tax IRS Audit Techniques Guide

Authors: Internal Revenue Service

1st Edition

1304131696, 978-1304131690

More Books

Students also viewed these Accounting questions