A Merchant Wants to Stock Christmas Trees

question 53

Essay

A merchant wants to stock Christmas trees.She can place only one order per season.The merchant pays $30 for each tree and sells them for $80 each.She will incur an additional cost of $6 each for unsold trees that must be hauled to the landfill.If demand for Christmas trees is normally distributed with a mean of 365 trees and a standard deviation of 46 trees, how many trees should she order?

---

Definitions:

Relative Cell Reference

In spreadsheet programs, a cell address expression that changes when it is copied to another location, relative to the position of the target cell.

Exact Cell Address

The specific location of a cell in a spreadsheet, identified by the combination of its column letter and row number.

Absolute Cell Reference

In spreadsheet applications, an absolute cell reference is a cell address that does not change when copied or moved to another cell location.

AutoFill Options Button

An interface button that, when activated, provides options to automatically complete filling data in fields based on patterns, preferences, or previously entered information.