Questions from Spreadsheet Modeling


Q: Large Lots is planning a seven-day promotion on a discontinued

Large Lots is planning a seven-day promotion on a discontinued model of 310 color television sets. At a price of $575 per set, the daily demand for this type of TV has been estimated as follows: Larg...

See Answer

Q: The monthly demand for the latest computer at Newland Computers follows a

The monthly demand for the latest computer at Newland Computers follows a normal distribution with a mean of 350 and standard deviation of 75. Newland purchases these computers for $1,200 and sells th...

See Answer

Q: The manager of Moore’s Catalog Showroom is trying to predict how much

The manager of Moore’s Catalog Showroom is trying to predict how much revenue will be generated by each major department in the store during the next year. The manager has estimated...

See Answer

Q: The Harriet Hotel in downtown Boston has 100 rooms that rent for

The Harriet Hotel in downtown Boston has 100 rooms that rent for $150 per night. It costs the hotel $30 per room in variable costs (cleaning, bathroom items, etc.) each night a room is occupied. For e...

See Answer

Q: Lynn Price recently completed her MBA and accepted a job with an

Lynn Price recently completed her MBA and accepted a job with an electronics manufacturing company. Although she likes her job, she is also looking forward to retiring one day. To ensure that her reti...

See Answer

Q: The graph of the probability distribution of a normally distributed random variable

The graph of the probability distribution of a normally distributed random variable with a mean of 20 and standard deviation of 1.5 is shown in Figure 12.5. The Excel function: also returns randomly...

See Answer

Q: Employees of Georgia-Atlantic are permitted to contribute a portion of

Employees of Georgia-Atlantic are permitted to contribute a portion of their earnings (in increments of $500) to a flexible spending account from which they can pay medical expenses not covered by the...

See Answer

Q: Acme Equipment Company is considering the development of a new machine that

Acme Equipment Company is considering the development of a new machine that would be marketed to tire manufacturers. Research and development costs for the project are expected to be about $4 million...

See Answer

Q: Representatives from the American Heart Association are planning to go door-

Representatives from the American Heart Association are planning to go door-to-door throughout a community, soliciting contributions. From past experience, they know that when someone answers the door...

See Answer

Q: Fiasco Foods, Inc. is one of the largest suppliers of

Fiasco Foods, Inc. is one of the largest suppliers of institutional and commercial food products in the United States. Fortunately for Fiasco, the demand for “food away from home&aci...

See Answer