Business Analyst Aptitude Online Test

A retail company is exploring new customer segments to increase sales. You are provided with the following data on three potential customer segments:

Segment A:

- Average annual revenue per customer: $500
- Average customer retention rate: 80%
- Average customer acquisition cost: $200
- Expected segment size: 2,000 customers

Segment B:

- Average annual revenue per customer: $750
- Average customer retention rate: 70%
- Average customer acquisition cost: $300
- Expected segment size: 1,500 customers

Segment C:

- Average annual revenue per customer: $1,000
- Average customer retention rate: 60%
- Average customer acquisition cost: $400
- Expected segment size: 1,000 customers

Assuming a 10% discount rate, which customer segment should the company target to maximize the return on investment? A target customer segment would have higher customer lifetime value (CLV). Note that CLV is calculated by using the following formula:

CLV = (Average Annual Revenue per Customer * Gross Margin %) * (Retention Rate / (1 + Discount Rate - Retention Rate)) - Customer Acquisition Cost

A company is considering two options to optimize its supply chain and reduce costs. The following data has been provided for each option:

Option Alpha:

- Annual transportation cost reduction: $300,000
- Annual inventory carrying cost increase: $250,000
- One-time implementation cost: $100,000

Option Beta:

- Annual transportation cost reduction: $200,000
- Annual inventory carrying cost increase: $150,000
- One-time implementation cost: $50,000

As a business analyst, determine which option provides a higher net cost reduction over a 3-year period.

A: Option Alpha provides a higher net cost reduction.
B: Option Beta provides a higher net cost reduction.
C: Both options provide the same net cost reduction.
D: Neither option provides a net cost reduction.
E: The net cost reduction cannot be determined with the given data.

Consider the following line chart which shows the money invested by a company in production each year and the sales made by the company each year. If the pie chart shows the shareholding pattern of the company and the company gives 10% of the profit as dividends to its share holders then what is the average dividend received by retail investors from 2000 to 2004?

Given below is the list of laptop brands and their details in which some data is missing. If the cost price of Dell is 3/5 of the cost price of Lenovo, then what will be the %profit of Dell?

 Consider the following line chart which shows the sales of five different companies from 2000 to 2009. Which of the following companies has the maximum percentage increase in the median from 2000 to 2004 and 2005 to 2009.

Emma's cafe has been operating successfully for the last 6 years. Profits have been growing every year, with this year (2020) being their best year so far. As a thank you, Emma treated her staff to a meal at a Michelin star restaurant. 

Below are 3 statements about Emma, her staff and her cafe. Can you help us decide whether the 3 statements are "True", "Probably True", "Insufficient Data to Say True or False", "Probably False", or "False".

1. Emma's staff members are happy.
2. Emma's cafe did well in 2016.
3. Emma is rich.

A: True
B: False
C: Probably True
D: Probably False
E: Insufficient Data

Statement: Ivory started a new startup. We know for a fact that almost all startups fail within the first 2 years. 
Conclusion: Ivory's startup will fail.
Does the conclusion follow from the statement?

Four airline operators A, B, C and D operate on a popular route between 2 cities, Rome and Venice in Italy. Airline A wanted to increase the number of seats sold, so they reduced their fares for this route. Airlines B, C, D imitated this move immediately. The general belief is that the volume of air travel between Rome and Venice would increase as a result of this. Which of the following statements, if true, would add trust to the general belief?

A: All 4 airlines see increased profits.
B: Airlines start slashing rates for other routes as well.
C: A study shows that around 80% of air travel in Italy is company sponsored.
D: A study shows that air travellers in Italy are price sensitive.

Folks should call Gurj Clooners if they want to:

Cigarettes account for only 23% of tobacco consumption, and only 16% of 250 million tobacco consumers use cigarettes. However these 16% contribute 85% of the tax revenues to the Exchequer from the tobacco sector. The punitive cigarette taxation regime has kept the tax base narrow, and lowering taxes will expand this base. Which of these best bolsters the conclusion that lowering duties will expand the tax base?

A: The cigarette manufacturers’ association has decided to indulge in aggressive promotion.

B:  Cigarette manufacturers are lobbying for a reduction on duties.

C: There is a likelihood that tobacco consumers will shift to cigarette smoking if cigarette prices reduce.

D: An increase in duties on non-cigarette tobacco may lead to a shift in favor of cigarette smoking.

E: There is a likelihood that tobacco consumers will shift to cigarettes if cigarette prices reduce.

F: A decrease in duties on non-cigarette tobacco may lead to more tobacco consumers shifting to cigarettes. 

G: Cigarette smokers are becoming increasing aware of associated health risks.

H: Increased health warnings could reduce the tax base.

This note informs Savannah that:

A: she can purchase new toys at a discounted rate.
B: the toy store has a new collection that she can purchase from now.
C: she can sell her used toys to the store.
D: she can get used and new toys in the ongoing sale at the store.

Your company recently opened a second office overseas. Some of the people from the original office will be relocating. All the people hired in the last six months will continue working in the original location where they were hired. Which of the following statements can be true regarding employees relocating?

The cost of manufacturing phones in China is twenty percent lesser than the cost of manufacturing phones in Vietnam. Even after adding shipping fees and import taxes, it is cheaper to import phones from China to Vietnam than to manufacture phones in Vietnam. Which of the following statements is best supported by the given information. 

A: The shipping fee from China to Vietnam is more than 20% of the cost of manufacturing a phone in China.
B: The import taxes on a phone imported from China to Vietnam is less than 20% of the cost of manufacturing the phone in China. 
C: Importing phones in Vietnam will cut 20% of the manufacturing jobs in Vietnam.
D: It takes 20% more time to manufacture a phone in Vietnam than it does in China.
E: Labour costs in Vietnam are 20% higher than in China.

A large real estate company conducted a recent study of their customers. The study was designed to uncover insights regarding the main criteria for choosing to invest in a residential property. A majority of the customers surveyed stated the 'returns profile' was their main priority, followed by 'development potential' and 'stability of income'. 'Portfolio legacy' ranked at the bottom in the list of factors. It was interesting to note that respondents were less likely to have residential holdings that formed part of mixed-use assets i.e. as an add on to commercial investment. One might assume that more investors are proactively investing in residential real estate rather than having incidental exposure via business investments. 

Based on the given passage, what can we say about the following statement?

Business owners having commercial premises often have a residential property as part of their portfolio.