A t-shirt company is planning a production run for an event where the attendance (and thus demand for t-shirts) is uncertain. The event planners have indicated that they think the attendance will be 500, 750 or 1000, with probabilities of 30%, 50% and

20% respectively. The company must pre-order the blank t-shirts (cost=$5 per shirt) and it can sell finished shirts for $12 apiece. Any finished shirts that cannot be sold at the event can be sold for $2 apiece to a used clothing vendor. What are the two possible cases for the amount of t-shirts that will be sold to the used clothing vendor? How would you calculate this amount in a spreadsheet model?


The company will either sell no t-shirts to the used clothing vendor (if it produces less than demand) or it will sell a surplus equal to the difference between production and demand (if it produces more than demand). This logic can be implemented in a spreadsheet model using an IF statement.

Business

You might also like to view...

What does level zero refer to?

A. The time an incident first occurs. B. The service desk using remote control to resolve incidents. C. The first point of contact for customers. D. Customers solving incidents on their own.

Business

You are shopping with a good friend. While looking at a sweater, she comments that she never buys clothes produced in China because the use of cheap overseas labour is harmful to U.S. textile workers. This type of belief is known as

A. international protectionism. B. xenophobia. C. consumer ethnocentrism. D. sociocultural bias. E. cultural fit.

Business

Writers should revise for content first and then look at audience appeal and the mechanics of putting together the document

Indicate whether the statement is true or false

Business

Managers should strive to eliminate all forms of conflict within the organization.

Answer the following statement true (T) or false (F)

Business