Questions from Spreadsheet Modeling


Q: Techs burg, Inc. uses a stamping machine to manufacture aluminum

Techs burg, Inc. uses a stamping machine to manufacture aluminum bodies for lightweight, miniature aircraft used for military reconnaissance. Currently, forms in the stamping machine are changed after...

See Answer

Q: After spending 10 years as an assistant manager for a large restaurant

After spending 10 years as an assistant manager for a large restaurant chain, Ray Clark has decided to become his own boss. The owner of a local submarine sandwich store wants to sell the store to Ray...

See Answer

Q: Road Racer Sports, Inc. is a mail-order business

Road Racer Sports, Inc. is a mail-order business dedicated to the running enthusiast. The company sends out full-color catalogs several times a year to several hundred thousand people on its mailing l...

See Answer

Q: Sammy Slick works for a company that allows him to contribute up

Sammy Slick works for a company that allows him to contribute up to 10% of his earnings into a tax-deferred savings plan. The company matches a portion of the contributions its employees make based on...

See Answer

Q: Podcessories manufacture several accessories for a popular digital music player. The

Podcessories manufacture several accessories for a popular digital music player. The company is trying to decide whether to discontinue one of the items in this product line. Discontinuing the item wo...

See Answer

Q: Bob Davidson owns a newsstand outside the Waterston office building complex in

Bob Davidson owns a newsstand outside the Waterston office building complex in Atlanta, near Hartsfield International Airport. He buys his papers wholesale at $0.50 per paper and sells them for $0.75....

See Answer

Q: Vinton Auto Insurance is trying to decide how much money to keep

Vinton Auto Insurance is trying to decide how much money to keep in liquid assets to cover insurance claims. In the past, the company held some of the premiums it received ini interestbearing checking...

See Answer

Q: Refer to the Hungry Dawg Restaurant example presented in this chapter.

Refer to the Hungry Dawg Restaurant example presented in this chapter. Health claim costs actually tend to be seasonal, with higher levels of claims occurring during the summer months (when kids are o...

See Answer

Q: Executives at Meds-R-Us have decided to build a

Executives at Meds-R-Us have decided to build a new production facility for the company’s bestselling high blood pressure drug. The problem they now face is determining the size of the facility (in te...

See Answer

Q: The owner of a local car dealership has just received a call

The owner of a local car dealership has just received a call from a regional distributor stating that a $5,000 bonus will be awarded if the owner’s dealership sells at least 10 new cars next Saturday....

See Answer