Lockheed Martin has been approached by the Department of Defense to prepare a bid for
Starlight rocket launchers.
The prototype took 2,000 hours to produce and has the following cost information. The prototype can be sold as a part of the contract.
Direct materials $600,000
Direct labor (2,000 hours @ $200 per hour) $400,000 Variable direct manufacturing overhead (2,000 hours @ $100) $200,000 Other manufacturing overhead (20% of direct cost) $240,000
$1,440,000(i.e., 20% of direct materials, direct labor, and variable overhead)
In preparing each bid, integrate the learning curve into the bid by relying on the following historical data for the production of 16 Sky rocket launchers, which was the previous generation of the Starlight launchers.
|Unit Number||Labor Hours|
Continue to Q2….
Question 2 (Please use Excel Dataset labeled “Marks and Spencer International (MSI)_Final Exam Data” for this question)
MSI, a department store chain, is trying to upgrade its customer service in order to compete with a rival chain which has recently moved into its territory and has a very strong customer-service reputation. MSI management knows that customer service is currently high in some of its stores but low in others. On average, its current reputation for service is less than outstanding. In order to build support for better customer service throughout the chain, MSI management decides to analyze existing data to show how much more profitable its own high-service stores are than its low-service stores.
MSI has created a customer-service indicator which is composed of a combination of ratings from “mystery shoppers” and surveys of customers by an independent organization. The scale for this indicator ranges from 1 to 60, which is a continuous variable with higher numbers indicating higher quality. MSI also has data on a number of factors that are likely to influence store profits. These include store size, rural versus urban location, manager performance rating (1 to 5 scale, where 5 is high), per capita income in the surrounding region (low to high ranges, summarized on a 1 to 5 scale, where 5 is high), non-managerial employee skill index (a measurement the Human Resources department has created, which ranges from 1 to 20; high numbers are better) and age of the store (which implies how long it has been in operation).
Based on regression analysis, what can you tell MSI about customer service? For example:
Continue to Q3….
The RBC case describes two methods for computing the lifetime value of a customer. One method (Markov Chain and Transition matrices) takes into account the expected likelihood that a customer holding a particular product portfolio will migrate to another portfolio or leave the bank in the future.
Assume that RBC has only two products: Car Loan (CL) and Credit Card (CC). The annual profitability for each of the two products is (-$100) (i.e., $100 loss) for CL and +$1000 for CC.
RBC has made the following observation for customers in the 25-30 year segment:
Similar observations can be made for individuals who begin the year with only a credit card, both products, or neither product. These observations are summarized in the following matrix of probabilities.
Probabilities for year t+1 product mix for all possible combinations of product mixes for year t.
|Product mix in year t+1|
|Product mix in year t||CL||CC||CL+CC||None|
Answer the following questions using a 8% discount rate:
You are the manager of a bank. You need to decide whether to approve a 10-year loan application from a 25 year old student to finance her MBA. The loan will yield a loss of $250 per year to the bank for the duration of the loan. After 10 years, the student will likely buy other products and therefore she will yield a profit of $500 per year until she is 65. After age 65, she will yield a profit of $1,000 per year until she is 85, when she will stop being a customer. The likelihood that she stops being a customer after she repays her MBA loan is 2% each year. The discount rate that the bank uses is 7% per year.
Would you approve the loan? Please explain with numerical support.
Continue to Q4….
We have discussed many cases in this course where we classify the type of data analytics problem as either descriptive, predictive, or prescriptive. For each type of data analytics (descriptive, predictive, prescriptive) select one case from the course and discuss why it belongs to the particular analytics category (thus, you will have three cases to select). Your discussion should (a) provide relevant case details from the cases chosen, (b) make use of the associated readings for the case, and (c) justification for the classification.
Do you need a customized paper? Place an order with us!