Concur Technologies, Inc., is a large expense-management company located in Redmond, Washington. The Wall Street Journal asked Concur to examine the data from 8.3 million expense reports to provide insights regarding business travel expenses. Their analysis of the data showed that New York was the most expensive city, with an average daily hotel room rate of $198 and an average amount spent on entertainment, including group meals and tickets for shows, sports, and other events, of $172. In comparison, the U.S. averages for these two categories were $89 for the room rate and $99 for entertainment. The table in the Excel Online file below shows the average daily hotel room rate and the amount spent on entertainment for a random sample of 9 of the 25 most visited U.S. cities (The Wall Street Journal, August 18, 2011). Construct a spreadsheet to answer the following questions.
| City | Hotel Room Rate ($) | Entertainment ($) |
| Boston | 144 | 163 |
| Denver | 100 | 104 |
| Nashville | 93 | 102 |
| New Orleans | 111 | 140 |
| Phoenix | 89 | 100 |
| San Diego | 105 | 121 |
| San Francisco | 134 | 165 |
| San Jose | 87 | 140 |
| Tampa | 82 | 97 |
What does the scatter diagram developed in part (a) indicate about the relationship between the two variables?
The scatter diagram indicates a _________negativepositive linear relationship between the hotel room rate and the amount spent on entertainment.
Develop the least squares estimated regression equation.
(to 4 decimals)
Provide an interpretation for the slope of the estimated regression equation (to 3 decimals).
The slope of the estimated regression line is approximately . So, for every dollar _________increasedecrease in the hotel room rate the amount spent on entertainment increases by $.
The average room rate in Chicago is $128, considerably higher than the U.S. average. Predict the entertainment expense per day for Chicago (to whole number).
In: Economics
In: Accounting
In 2020, Raoul & Ayesha , married filing joint taxpayers, have adjusted gross income of $430,000. Their AGI includes $10,000 of interest income. They have no dependents and have $50,000 of itemize deductions. What is their 2020 federal income tax? (PLEASE SHOW ALL WORK)
A) $83,631
B) $83,829
C) $89,212
D) $89,404
In: Accounting
ACQUISITION PROGRAM
Acquisition of Varta AG (Germany)
In 2002, Rayovac acquired the consumer battery business of Varta AG
of Germany. Varta was the leading European-based manufacturer of
general batteries and 86% of its revenues were generated in Europe.
Some overlap in Latin America permitted combined operations which
solidified Rayovac’s market lead outside of Brazil. Too, the
complementary geographic distribution of the firms’ production
facilities and distribution channels was expected to yield greater
access to global sourcing and generate cost savings of $30-40
million per year.
Acquisition of Microlite (Latin America)
In 2004 Rayovac acquired Microlite SA, the largest producer of
consumer batteries in Brazil and owner of the Rayovac brand name in
Brazil. It immediately realized a 50% market share in Latin
America’s largest consumer market. Rayovac replaced Microlite’s
management team with Rayovac veterans who reduced costs, increased
efficiency, improved product packaging, and raised prices 16%. The
Microlite business was also undercapitalized and losing money. It
was considered by lenders to be a high risk and, consequently, paid
very high interest rates. Rayovac immediately recapitalized the
business, replacing high interest-rate loans with lower interest
rate Rayovac-backed debentures. As a result of the acquisition,
Rayovac expected to increase total Latin America revenues by
approximately 50% in 2005.
Acquisition of 85% of Ningbo Baowang (China)
Located inNinghai, China, Ningbo Baowang was a major exporter of private label branded batteries. The company also sold its Baowang brand throughout China. Rayovac acquired the Chinese firm in 2004, hoping both to increase its presence in the rapidly growing Asian market and to add a low cost manufacturing subsidiary from which it could export Rayovac and Varta brand batteries to global markets. Rayovac replaced Ningbo’s management with its own to implement Rayovac process controls and management policies more efficiently. It also installed new manufacturing equipment that would allow it to produce over one billion Rayovac branded batteries a year beginning in 2005.
Explain how this acquisition program helps Rayovac to capitalize upon its strengths and opportunities and neutralize its weaknesses and threats.
In: Finance
Cities, States, and Businesses Lead the Way to Reduce Greenhouse Gases
Although the United States signed the original Kyoto Protocol, the U.S. Congress never ratified the agreement so the protocol has never been legally binding on the United States. The administration of President George W. Bush argued that there was no scientific consensus on global warming and that the costs of reducing greenhouse gases were simply too high. However, many state and local governments felt they had waited long enough for change at the federal level. In 2005, mayors from 141 cities and both major political parties gathered in San Francisco to organize their own efforts to reduce the causes and consequences of global warming. Their goal was to reduce greenhouse emissions in their own cities by the same 7 percent that the United States had agreed to in the Kyoto Protocol.
As of 2014, a total of 1,060 out of 1,139 mayors of U.S. cities had signed the U.S. Conference of Mayors Climate Protection Agreement. Among the reasons the mayors cited for supporting this agreement were concerns in their communities over increasing droughts, reduced supplies of fresh water due to melting glaciers, and rising sea levels in coastal cities. “The United States inevitably will have to join this effort,” Seattle mayor Greg Nickels said. “Ultimately we will make it impossible for the federal government to say no. They will see that it can be done without huge economic disruption and that there’s support throughout the country to do this.”
Similar actions are being taken at the state level. In 2005, then-governor of California Arnold Schwarzenegger stated at a press conference, “The debate is over . . . and we know the time for action is now.” In 2006, Governor Schwarzenegger signed the California Global Warming Solutions Act. The goal of the act was to bring California into compliance with the Kyoto Protocol by 2020, an effort that would require a 25 percent reduction in greenhouse gases for a state that, if a country, would be the tenth largest producer of greenhouse gases in the world. At the signing ceremony, the governor stated, “I say unquestionably it is good for businesses.” Indeed, a cost analysis by the California Air Resources Board in 2008 indicated that the law would add $27 billion to the economy of the state and add 100,000 jobs.
The California effort is gaining popularity around the country. In the northeastern United States, for example, nine states have joined together collectively to form the Regional Greenhouse Gas Initiative to control regional production of greenhouse gases. A similar group emerged in western North America when seven western states and four Canadian provinces joined together in 2007 to form the Western Climate Initiative. For both groups, the goal was to to regulate greenhouse emissions. By 2014, northeastern group continued to work together while the western group had a reduced membership that included only California and the four Canadian provinces.
A number of large businesses are also joining in efforts to reduce greenhouse gases. General Electric, for example, announced in 2014 that it had reduced its greenhouse emissions by 34 percent since 2004. In addition, the company has invested $12 billion for research and development of technologies that can reduce greenhouse gases and is planning to invest a total of $25 billion by 2020. In 2011, General Electric announced that its technology generated more than $100 billion in revenues, which confirmed that creating technology that would reduce greenhouse emissions was a profitable thing to do.
In 2013, the New York Times reported that a growing number of companies including Microsoft, ExxonMobil, and Google have developed long-term financial plans that include the cost of producing greenhouse gases. These companies recognize that the scientific evidence of human-caused global climate change continues to grow and that they will increasingly need to factor the costs of emissions into their budgets. Those companies that include plans to accommodate and reduce these costs are likely to profit from such planning.
From these stories, it is clear that progress on reducing greenhouse gases that cause global warming does not have to wait for national and international agreements to take effect. The public overwhelmingly understands that Earth is warming, states and cities are pushing forward with solutions that save money, and large corporations understand that reducing emissions can reduce costs and improve profits over the long term. In short, curbing greenhouse gases and global warming is not only good for humans and the environment, it can be good for business as well.
Critical Thinking Questions
1.What data might city mayors use to support their assertion that humans are causing global warming?
2.Why is it more effective for states and provinces to create regional partnerships to combat global warming rather than doing so alone?
In: Other
ZIPE Co. which is the market leader in the sector in which it
operates, wants to continue its
success in the international arena. First of all, firm plans to
open a store in the city center of
Berlin, Germany. The CEO of the company traveled with the senior
managers and asked the
finance manager to submit a feasibility report. The finance manager
has reached the
following figures in coordination with other departments.
The rentals of the shops in the area where investment is planned
are quite expensive.
Nevertheless, it is not a situation that cannot be tolerated both
in terms of the target
customer volume and the prestige of the company. The rental cost a
shop in this area of the
firm will be € 240,000 per year. Also, in Germany, wages are
expected to be higher than in
Turkey. The number of personnel required is determined and the
total cost is expected to be
€ 300,000. In addition to these costs, the company is expected to
incur operating costs of €
120,000 annually. By the way, it is necessary to advertise with a
huge commercial campaign.
The € 200,000 ad budget for the first year will be reduced to €
50,000 in the following years.
In spite of these costs, the company is expected to reach a sales
figure of € 6,500,000 for the
first year. In a project with a 10-year economic life expectancy,
sales will rise to € 7,000,000
for the second year, € 7,500,000 for the third year, and €
8,000,000 for the third year and
will remain stable at this level. Firms earn up(increase) to 20% of
gross profits and 80% of cost of goods sold.
In order for the firm to open such a shop in Germany, it has to
invest a fixed asset of €
5,000,000. It is expected that the scrap value of the investment
made at the end of 10 years
will be zero. The tax rate for the firm is 20%, the cost of capital
is 8% and the depreciation is
straight line method.
So, what would be your decision as a finance manager?
In: Finance
ZIPE Co. which is the market leader in the sector in which it
operates, wants to continue its
success in the international arena. First of all, firm plans to
open a store in the city center of
Berlin, Germany. The CEO of the company traveled with the senior
managers and asked the
finance manager to submit a feasibility report. The finance manager
has reached the
following figures in coordination with other departments.
The rentals of the shops in the area where investment is planned
are quite expensive.
Nevertheless, it is not a situation that cannot be tolerated both
in terms of the target
customer volume and the prestige of the company. The rental cost a
shop in this area of the
firm will be € 240,000 per year. Also, in Germany, wages are
expected to be higher than in
Turkey. The number of personnel required is determined and the
total cost is expected to be
€ 300,000. In addition to these costs, the company is expected to
incur operating costs of €
120,000 annually. By the way, it is necessary to advertise with a
huge commercial campaign.
The € 200,000 ad budget for the first year will be reduced to €
50,000 in the following years.
In spite of these costs, the company is expected to reach a sales
figure of € 6,500,000 for the
first year. In a project with a 10-year economic life expectancy,
sales will rise to € 7,000,000
for the second year, € 7,500,000 for the third year, and €
8,000,000 for the third year and
will remain stable at this level. Firms earn up(increase) to 20% of
gross profits and 80% of sales.
In order for the firm to open such a shop in Germany, it has to
invest a fixed asset of €
5,000,000. It is expected that the scrap value of the investment
made at the end of 10 years
will be zero. The tax rate for the firm is 20%, the cost of capital
is 8% and the depreciation is
straight line method.
So, what would be your decision as a finance manager?
In: Finance
In: Economics
Background :
You are Sarah, CFO at PT Kembang Gula, a FMCG company which
manufactures and sells products necessities of the day which
consist of:
1. Foods like: Chili sauce, soy sauce, tea etc.
2. Personal Care such as: shampoo, soap, moisturizer, toothpaste,
etc.
3. Home Care such as: detergent, fabric softener, washing kitchen
soap, floor cleaners, etc.
Putri is the CEO of PT Kembang Gula.
Task :
One day Sarah received an email from Putri, and asked for a reply
to the email.
Email content:
Dear Sarah,
Seeing more and more not sure the business situation, national and
global economy, and also still the length of travel Pandemi
COVID19, then please give reviews and recommendations on the
subject matter as follows:
1. With many variables that continue to change rapidly and
significantly, how do we regulate the profitability and fundamental
financial conditions of the company (the balance of loss/profit,
balance sheet, cash flow) so that we remain healthy in the company
and at the same time can still take any opportunities that arise in
the market?
2. Please provide what is the example of business action that can
be done by each section: Consumer & Market Insight, Marketing,
Sales, Supply Chain and R&D, which is a unity with the
corporate action above?
Later this issue will be discussed in the management meeting next
week, but I want both of us to be able to discuss this first so
that it can get the prefix proposals to be brought to the wider
forum in the management meeting.
In: Accounting
Case Analysis 1: You work for a small, local telecommunications company. In five years, the company plans to undertake a major upgrade to its servers and other IT infrastructure. Management estimates that it will need up to $450,000 to cover all related costs; however, as a fairly young company, the goal is to pay for the upgrade with cash and not to take out loans. Right now, you have $300,000 in a bank account established for Capital Investments. This account pays 4% interest, compounded annually. A member of the finance department has approached you with an investment opportunity for the $300,000 that covers a five-year period and has the following projected after-tax cash flows:
Year Projected Cash Flow
1 $90,000
2 $115,000
3 $135,000
4 $110,000
5 $90,000
Based on this information, in an MS Word document, answer the following questions:
1) How much money will be in the bank account if you leave the $300,000 alone (earning 4% compounded interest) until you need it in five years?
2) If you undertake the investment opportunity, what is the Nominal Payback Period?
3) Using the Present Value factors for 7% (which can be found on any PV Factor table), what is the discounted Payback Period of the investment opportunity?
4) What is the Net Present Value at 7% of the investment opportunity?
5) Which option (make the investment or leave the money in a savings account) would you recommend to your CEO? Why? What additional factors/information might make you change your point of view?
In: Finance