Questions from Spreadsheet Modeling


Q: The PENTEL Corporation manufactures three different types of computer chips. Each

The PENTEL Corporation manufactures three different types of computer chips. Each type of chip requires different amounts of processing time in three different departments as summarized in the followi...

See Answer

Q: A car dealership needs to determine how to allocate its $20

A car dealership needs to determine how to allocate its $20,000 advertising budget. They have estimated the expected profit from each dollar (X) spent in four different advertising media as follows:...

See Answer

Q: The XYZ Company produces two products. The total profit achieved

The XYZ Company produces two products. The total profit achieved from these products is described by the following equation Every 1,000 units of X1 require 1 hour of time in the shipping department,...

See Answer

Q: Members of the Roanoke Health and Fitness Club pay an annual membership

Members of the Roanoke Health and Fitness Club pay an annual membership fee of $250 plus $3 each time they use the facility. Let X denote the number of times a person visits the club during the year....

See Answer

Q: A recruiter for Big Box stores has collected the data in the

A recruiter for Big Box stores has collected the data in the file BigBox.xlsx summarizing the amount of money the company spent on print, web, and TV advertising in California over the past 22 months...

See Answer

Q: Golden Years Easy Retirement Homes owns several adult care facilities throughout the

Golden Years Easy Retirement Homes owns several adult care facilities throughout the southeast United States. A budget analyst for Golden Years has collected the data found in the file GoldenYears.xls...

See Answer

Q: The O-rings in the booster rockets on the space shuttle

The O-rings in the booster rockets on the space shuttle are designed to expand when heated to seal different chambers of the rocket so that solid rocket fuel is not ignited prematurely. According to e...

See Answer

Q: Advertising is the primary source of revenue for newspaper companies. Over

Advertising is the primary source of revenue for newspaper companies. Over the past 10 to15 years, the newspaper industry has been adjusting to changes in the mix of services that produce this revenue...

See Answer

Q: An analyst for Phidelity Investments wants to develop a regression model to

An analyst for Phidelity Investments wants to develop a regression model to predict the annual rate of return for a stock based on the price-earnings (PE) ratio of the stock and a measure of the stock...

See Answer

Q: Oriented Strand Board (OSB) is manufactured by gluing woodchips together

Oriented Strand Board (OSB) is manufactured by gluing woodchips together to form panels. Several panels are then bonded together to form a board. One of the factors influencing the strength of the fin...

See Answer