1. Consider the applications for home mortgages data in the file of P12_04.xlsx.

1. Create a time series chart of the dat
2. Use simple exponential smoothing to forecast these data, using the default smoothing constant of 0.1
3. Calculate the three types of forecast errors, RMSE, MAE, and MAPE
4. Use the solver function in excel to optimize the smoothing constant in order to generate a minimum MAPE value.
5. Use multiple regression to develop an equation that can be used to predict future applications for home mortgages (hint: use dummy variables for the quarters and create a time variable for the quarter numbers)

Managing diversity in a Chinese-owned multinational IT firm

Company background

Established in 1988 in Beijing, Lenovo Group Limited (formerly known as ‘Legend Group Limited’) is the largest IT enterprise in China. Lenovo employs some 25,000 staff in all its operations in nearly 70 countries, but with the majority of employ- ees working in China. In 1984, with an initial capital of RMB 200,000 funded by the Chinese Academy of Sciences, a government-funded institution, 11 researchers formed the parent company of Lenovo. It was the first company to introduce the concept of the home computer in China. Lenovo’s main business activities are in the sale and manufacturing of desktop computers, notebook computers, mobile handsets, servers and printers. Lenovo is a stock-listed company, with the Chinese government holding over a quarter of its shares. In April 2003, the group adopted a new logo and the English brand name ‘Lenovo’, replacing the original English brand name ‘Legend’ in order to appeal to the international market. The English company name was also officially changed to ‘Lenovo Group Limited’ a year later. In December 2004, Lenovo spent US$1.25 billion to acquire IBM’s PC business. This was the largest cross-border acquisition in China’s IT industry (China Business, 13 December 2004). The acquisition process was completed in May 2005. The marriage of IBM and Lenovo created one of the world’s largest PC powerhouses. IBM possessed strong competitive advantage in the higher end of the customer market in its distribution channel, high quality customer resources, which complemented that of Lenovo. The two companies have main- tained a long-term cooperative strategy since the acquisition, with Lenovo having access to some of IBM’s key resources, such as technology, sales force, PartnerWorld, Global Finance and IBM Credit. The continuing expansion and globalization of Lenovo has brought a number of challenges to its HRM function, including the alignment of corporate HR strategy and DM after the acquisition of IBM’s PC business. Below are some of the issues that illustrate the challenges.

Managing foreign employees in China

Lenovo’s growing global presence in the IT sector has in recent years attracted an increasing number of non-Chinese citizens who wish to work in its operations in China. This is in part because they want to spend time in China to gain wider work experience and a deeper understanding of the country. These foreign citizens are employed by Lenovo under the same employment conditions as those offered to Chinese citizens. Free working meals and company-subsidized accommodation are some of the benefits that Lenovo offers its employees. These are traditional and typical workplace welfare provisions of Chinese firms. Under the housing scheme, newly recruited single employees are provided dormitory accommodation. Since housing is expensive in Beijing, this often takes the form of one bedroom shared by a few employees of the same gender. This arrangement is normal and acceptable to Chinese employees – Chinese students also share their dormitories in schools and universities, and in sweatshop manufacturing plants the situation is far worse where ten or more rural migrant workers are crowded in a room with poor facilities. However, foreign employees, though only very small in number compared with the Chinese employees, find it difficult to get used to this idea because of the lack of privacy. Lenovo (China) has no special policy to accommodate their needs. Different management style is another source of cultural shock to foreign employees. According to an HR manager, foreign employees all emphasize their cultural shock when they come to China. However, Lenovo (China) has not developed a formal policy to manage these cultural shocks. This has led to the turnover of a few of the foreign employees and the company has made no effort to retain them.

Managing Chinese graduate returnees from overseas

Since the early 2000s, an increasing number of Chinese who went abroad for their higher education have been returning to China to seek employment and career development. The majority of Chinese overseas graduate returnees (known as haigui in China) are keen to work for multinational firms, and are often the favourite candidates. Lenovo is among the top employers of choice for which haiguis want to work. These repatriated Western educated and trained graduates bring with them different life styles, perspectives and (often unrealistic) expectations that may depart from Chinese norms. Some of them are said to be complacent and consider themselves superior to other graduate employees who have not been abroad for education or training. They expect high salaries up front, fast promotion, flexibility and autonomy in their work. Turnover is common among haiguis when expectations are unmet or better offers are available elsewhere. How to recruit and manage overseas graduate returnees effectively is an important issue for MNCs operating in China. Companies are now reportedly more cautious in recruiting and managing these returnees because they are seen as ‘demanding’ employees who are difficult to retain. Lenovo shares some of these issues. Although turnover has not been a major problem, how to harmonize the relationship between haiguis and home- grown graduate employees is sometimes a challenge for line managers.

Gender equalities

Prior to Lenovo’s acquisition of the IBM PC business unit, Lenovo had more women at the senior management level. The proportion of women in senior management has actually declined since the acquisition because it is now part of a bigger inter- national operation. Two main reasons are attributed to this change. One is that there is a lower proportion of women at senior management level in the acquired business unit of IBM than in the Chinese operation. Another reason is that Lenovo has been through successive rounds of senior management restructuring after the acquisition, partly to do with the post-acquisition integration and partly to do with the poaching of senior managers among IT firms in China. Cultural clashes triggered by the post-acquisition integration have led to the departure of a number of senior managers. When new managers are recruited, they tend to bring their own people and HR initiatives with them, which will later be displaced by their successors when those managers depart. As an HR director observed, ‘It is organizational politics, rather than equal opportunities, that we consider in the recruitment of senior managers. You need to be competent as well as well connected to get the senior management’s job, and men tend to be better connected than women in the IT sector in general.’

Developing a global diversity management strategy

According to informants from Lenovo (China), diversity is not a key issue in the workforce in China. Therefore, it is not a priority of the company. The major task is post-acquisition integration to align the organizational cultures and become a truly international company. Nevertheless, Lenovo (China) does emphasize the need for employees to respect other employees’ rights and privacy. Aggressive or discriminaory behaviours are forbidden, even as jokes. These expectations are written in the business conduct guidelines for employees. However, Lenovo (China) does not have any specific equal opportunities or diversity management programmes to enforce these clauses. The acquired business unit of IBM has good HR practices, for example, WLB and DM. These have not yet been transferred to the Chinese operation due to staff shortages. There was a corporate initiative (stimulated from the US side) about grouping women at international level together to have a global forum to discuss diversity issues in 2006. Unfortunately, budget constraints meant that the plan was set to one side. The HR directors from Lenovo (US) are well aware of the challenge they face in transferring their US-developed diversity management programme to other branches across different countries and cultures. The US HR team are the people who are familiar with the concept and responsible for promoting its global diffusion, and they are approaching the task with extreme caution. This is in part, as they admit- ted, due to their unfamiliarity with the local environments in different parts of the world, although they are planning to visit Lenovo (China) for the first time. How to accommodate the diversity of the global workforce and leverage it to enhance the performance of the firm on the one hand, and how to develop a strong corporate culture that all employees will identify with on the other hand is their main HR con- cern, and a solution has yet to be found. According to all managerial informants, the corporate priority is talent management. A new scheme called ‘Mobility Plan’ has been implemented at the international level. The purpose of the plan is to give managers an opportunity to work overseas to gain international experience to be able to lead at a global level. It is not aimed at Chinese managers in principle, but in reality has mainly involved sending Chinese managers to the US for development.

Questions:

1: Identify and explain the main issues in this case study

2. What are the key issues of diversity management in this case study and how are they manifested?

The owner of a departmental store would like to estimate monthly gross revenues as a function of advertising
expenditures. Historical data for randomly selected 8 months is given below (₹ in crores)
Monthly revenue Television Advertising Newspaper advertising

a. Derive a regression equation with amount of expenditure on television advertising as independent
variable.
b. Derive a regression equation with both expenditure on television advertising and newspaper advertising
as independent variables.
c. Estimate the monthly gross revenue for a month when 4 crores is spent on TV , and 1.5 crores is spent
on newspaper advertising.

Problem 9.3 – Aging analysis, preparing journal entries and balance sheet presentation (LO 9-1)

At December 31, 20X0, Oettinger Corporation, a premium kitchen cabinetmaker for the home remodeling industry, reported the following accounts receivable information on its year-end balance sheet:

During 20X1, the company had credit sales of $8,200,000 of which it collected $7,975,000. Oettinger employs the sales revenue approach to estimate its bad debt provisions and, continuing to use the same 1% used in previous years, made the normal adjustment at the end of 20X1.

Although 20X1 started off well, the industry experienced a slowdown in the last four months of the year, and cash collections consequently dropped off substantially. Moreover, a major customer, which owed Oettinger $85,000, unexpectedly filed for bankruptcy and went out of business during November, at which time its account was written off. Oettinger’s controller is concerned that some customers are experiencing cash flow problems and that the company’s allowance for credit losses is too low. As a result, she prepared the following schedule:

Required:

1. 1-a. Determine Oettinger’s accounts receivable balance at December 31, 20X1.

1-b. Prepare a journal entry for each transaction affecting the accounts receivable balance for 20X1.

2. 2-a. Prepare an aging analysis.

2-b. Compute the required balance in the Allowance for credit losses at December 31, 20X1.

3. 3. Prepare any other required journal entries affecting the Allowance for credit losses for the year ended December 31, 20X1. (Do not duplicate any entries from requirement 1.)

4. Show Oettinger’s balance sheet presentation of accounts receivable at December 31, 20X1.

24a) The interior of thew building is renovated, extending the useful life of the building by 10 years. Is this a revenue expenditure or a capital expenditure? Type in 1 for revenue expenditure or type in 2 for a capital expenditure.

24b) A cleaning firm is paid $150 per week to clean the carpets in a building. Is this a revenue expenditure or a capital expenditure? Type in 1 for revenue expenditure or type in 2 for a capital expenditure.

24c) On which financial statement if Loss in Disposal of Plant assets recorded? Type in 1 for income statement; type in 2 for statement of retained earnings; type in 3 for balance sheet.

24d) When an exchange of similar plant assets is said to have "commercial substance", what does that mean?

1) For a monopoly, marginal revenue is less than price because
A) the demand for the firm's output is downward sloping.
B) the firm has no supply curve.
C) the firm can sell all of its output at any price.
D) the demand for the firm's output is perfectly elastic.

2) The monopoly maximizes profit by setting
A) price equal to marginal cost.
B) price equal to marginal revenue.
C) marginal revenue equal to marginal cost.
D) marginal revenue equal to zero.

3) The ability of a monopoly to charge a price that exceeds marginal cost depends on A) the price elasticity of supply.
B) price elasticity of demand.
C) slope of the demand curve.
D) shape of the marginal cost curve.

The following comparative income statement (in thousands of dollars) for the two recent fiscal years was adapted from the annual report of Speedway Motorsports, Inc., owner and operator of several major motor speedways, such as the Atlanta, Texas, and Las Vegas Motor Speedways.

Income Statement

Prepare a comparative income statement for these two years in vertical form, stating each item as a percent of revenues. Enter all amounts as positive numbers. Rounding instructions (Note: Due to rounding, amounts may not total 100%).

Final Question

Comment on the significant changes.

While overall revenue some between the two years, the overall mix of revenue sources did change somewhat. The NASCAR broadcasting revenue as a percent of total revenue by almost 2.6 percentage points, while the percent of admissions revenue to total revenue by 2 percentage points. Overall, it appears that income from continuing operations has significantly improved because of