ANLY500 Problems Solving from Evans Business analytics Paper.
Chapter 1- Problems 1, 3, 6, 9, 12, 13, 15, 16
1) Discuss how you might use business analytics in your personal life, such as managing your
grocery purchasing, automobile maintenance, budgeting, sports, and so on. Be creative in identifying opportunities!
3) Suggest some metrics that a hotel might want to collect about their guests. How might these
metrics be used with business analytics to support decisions at the hotel?
ORDER A CUSTOM-WRITTEN, PLAGIARISM-FREE PAPER HERE
6) Identify each of the variables in the Excel file Credit Approval Decisions as categorical,ordinal, interval, or ratio and explain why. ANLY500 Problems Solving from Evans Business analytics Paper.
9) A bank developed a model for predicting the average checking and savings account balance as
balance=−17,732+367×age+1,300×years education+0.116×household wealth.
a) Explain how to interpret the numbers in this model. b) Suppose that a customer is 32 years old, is a college graduate (so that years education =
16), and has a household wealth of $150,000. What is the predicted bank balance?
12) Return on investment (ROI) is computed in the following manner: ROI is equal to turnover
multiplied by earnings as a percent of sales. Turnover is sales divided by total investment. Total
investment is current assets (inventories, accounts receivable, and cash) plus fixed assets. Earnings
equal sales minus the cost of sales. The cost of sales consists of variable production costs, selling
expenses, freight and delivery, and administrative costs.
a) Construct an influence diagram that relates these variables. b) Define symbols and develop a mathematical model.
13) Total marketing effort is a term used to describe the critical decision factors that affect
demand: price, advertising, distribution, and product quality. Let the variable x represent total
marketing effort. A typical model that is used to predict demand as a function of total marketing
effort is
D=axb
Suppose that a is a positive number. Different model forms result from varying the constant b.
ORDER A CUSTOM-WRITTEN, PLAGIARISM-FREE PAPER HERE
Sketch the graphs of this model for b = 0, b = 1, 0 b 1, b 0, and b 1. What does each
model tell you about the relationship between demand and marketing effort? What assumptions
are implied? Are they reasonable? How would you go about selecting the appropriate model?
15) A manufacturer of mp3 players is preparing to set the price on a new model. Demand is
thought to depend on the price and is represented by the model
D=2,500−3P
The accounting department estimates that the total costs can be represented by
C=5,000+5D
Develop a model for the total profit in terms of the price, P. ANLY500 Problems Solving from Evans Business analytics Paper.
16) The demand for airline travel is quite sensitive to price. Typically, there is an inverse
relationship between demand and price; when price decreases, demand increases and vice versa.
One major airline has found that when the price (P) for a round trip between Chicago and Los
Angeles is $600, the demand (D) is 500 passengers per day. When the price is reduced to $400,
demand is 1,200 passengers per day.
a) Plot these points on a coordinate system and develop a linear model that relates demand to price.
b) Develop a prescriptive model that will determine what price to charge to maximize the total revenue.
c) By trial and error, can you find the optimal solution that maximizes total revenue? ANLY500 Problems Solving from Evans Business analytics Paper.