Questions from Business Analytics

Q: Box Tile Company makes ceramic and porcelain tile for residential and commercial

Box Tile Company makes ceramic and porcelain tile for residential and commercial use. They produce three different grades of tile (for walls, residential flooring, and commercial flooring), each of wh...

Q: Valencia Products makes automobile radar detectors and assembles two models: LaserStop

Valencia Products makes automobile radar detectors and assembles two models: LaserStop and SpeedBuster. The firm can sell all it produces. Both models use the same electronic components. Two of these...

Q: The Hansel Corporation, located in Bangalore, India, makes plastics

The Hansel Corporation, located in Bangalore, India, makes plastics materials that are mixed with various additives and reinforcing materials before being melted, extruded, and cut into small pellets...

Q: The background for this case was introduced in Chapter 2. For

The background for this case was introduced in Chapter 2. For this part of the case, summarize the numerical data using frequency distributions and histograms, cross-tabulations, PivotTables, and desc...

Q: The Excel file Retail Survey provides data about customers’ preferences for denim

The Excel file Retail Survey provides data about customers’ preferences for denim jeans. Use PivotTables and slicers to draw conclusions about how preferences differ by gender and age group and summar...

Q: FujiFarm produces four types of vegetables with variable costs of $2

FujiFarm produces four types of vegetables with variable costs of $2.80, $3.54, $1.07, and $2.23 per acre. Due to an increment in the cost of fertilizers, the variable cost of each of the vegetables w...

Q: Reddy & Rao (R&R) is a small company

Reddy & Rao (R&R) is a small company in India that makes handmade, artistic chairs for commercial businesses. The company makes four models. The time required to make each of the models and co...

Q: Joan Weasley receives a reward bonus semi-annually from her company

Joan Weasley receives a reward bonus semi-annually from her company: $3,000 on 1st June and $3,500 on 1st December. She must pay $1,500 as an insurance installment for each of the January, April, July...

Q: Suppose that David Samuel wants to invest in three company shares:

Suppose that David Samuel wants to invest in three company shares: APPL, FB, and IBM. He decides to do some market research before he invests his money in these shares. The following table provides in...

Q: Starbucks coffee company uses three types of cup sizes for selling its

Starbucks coffee company uses three types of cup sizes for selling its bestseller drink Mocha Frappuccino: Tall, (8 ounces), Grande (12 ounces), Venti (16 ounces), which have unit profits of $0.60, $0...