Using an excel spreadsheet to present your work, calculate the projected revenue collected from federal income taxes, state income taxes, and the local payroll tax for FY 2014 and prepare a revenue estimate for the City of Newark’s Public School System for FY 2015 based on the following information. Assume that no other deductions came from the employee’s salary other than what is listed here. Hint: New employees are not eligible for raises, which are based on performance from the previous fiscal year. (See Table below for format. You are to prepare two spreadsheets (projected revenue and revenue estimate))...Show formulas for calcualtions

FY 2014 Facts:

1 The school system currently has 34 full-time employees. There is one superintendent, two principals, three janitors, ten kitchen staff, and eighteen teachers (including coaches).

The superintendent has a salary of $95,000

Each principal has a salary of $70,000

Four of the teachers (Teacher A) had salaries of $55,000; six teachers (Teacher B) had salaries of $45,000 and six teachers (Teacher C) had salaries of $40,000

The remaining two teachers (A Level) are also coaches. The football coach receives and additional $5,000 in salary and the basketball coach receives and additional $7,000 in salary each year.

Mrs. Jones manages the kitchen. Her FY 2014 salary was $45,000

The remaining kitchen staff made $28,000 each in FY 2014

The three janitors made $25,000 each in FY 2014

Use these federal income tax rates: $0 - $8,700.99 = 10%; $8,701 - $35350.99 = 15%; $35,351 - $85,650.99 = 25%; $85,651 - $178,650.99 = 28%; $178,651 - $388,350.99 = 33%; >$388,351 = 35%. The tax rates were the same in FY 2014 and FY 2015.

The state income tax rate is 4% for the first $3,000 of employee salary and 5.5% on everything above that amount. The rate is the same in both years.

The local payroll tax is 1.75% in FY 2014 and 1.85% in FY 2015.

FY 2015 Facts:

In FY 2015, the school system hired two more teachers at the Teacher D level. They will begin work in FY 2015 at a salary of $35,000.

In FY 2015, each school employee received a 5% raise except the principals and superintendents. They received a 2% raise. Note, new employees, do not receive a raise.

Position Description # in Grade FY 2014 Salary Fed Inc. Tax State Inc. Tax Payroll Tax Total Taxes

Superintendent 1

Principal 2

Teacher (A) 4

Teacher (B) 6

Teacher (C) 6

Janitor 3

Kitchen Manager 1

Kitchen Staff 9

Football Coach 1

Basket Ball Coach 1

Total 34

Most motivation theories in use today were developed in the United States by Americans and about
Americans. Of those that were not, many have been strongly influenced by American theories. But
several motivation theories do not apply to all cultures. For example, Maslow’s theory does not often
hold outside the United States. In countries higher on uncertainty avoidance (such as Greece and Japan)
as compared with those lower on uncertainty avoidance (such as the United States), security motivates
employees more strongly than does self-actualization. Employees in high-uncertainty-avoidance
countries often consider job security and lifetime employment more important than holding a more
interesting or challenging job. Also contrasting with the American pattern, social needs often dominate
the motivation of workers in countries such as Denmark, Norway, and Sweden that stress the quality of
life over materialism and productivity.

When researchers tested Herzberg’s theory outside the United States, they encountered different
results. In New Zealand, for example, supervision and interpersonal relationships appear to contribute
significantly to satisfaction and not merely to reducing dissatisfaction. Similarly, researchers found that
citizens of Asia, Canada, Europe, Latin America, the Republic of Panama, and the West Indies cited certain
extrinsic factors as satisfiers with greater frequency than did their American counterparts. In other
words, the factors that motivate U.S. employees may not spark the same motivation in employees in
other cultures. Some of the major differences among the cultural groups include the following:

1. English-speaking countries such as England and the United States rank higher on individual
achievement and lower on the desire for security.
2. French-speaking countries and areas such as France and the province of Quebec in Canada,
although similar to the English-speaking countries, give greater importance to security and
somewhat less to challenging work.
3. Northern European countries such as Sweden have less interest in getting ahead and work towards
recognition goals and place more emphasis on job accomplishment. In addition, they have more
concern for people and less for the organization as a whole (it is important that their jobs not
interfere with their personal lives).
4. Latin American and Southern European countries find individual achievement somewhat less
important; Southern Europeans place the highest emphasis on job security, whereas both groups of
countries emphasize fringe benefits.
5. Germany ranks high on security and fringe benefits and among the highest on getting ahead.
6. Japan, although low on advancement, also ranks second-highest on challenge and lowest on
autonomy, with a strong emphasis on good working conditions and a friendly working environment.

Critical Thinking Questions
1. In today’s global business environment, with its diversity of perspectives, can a manager ever
successfully use equity theory? Why or why not?
2. What impact, if any, do these cultural differences have on managers managing an entirely American
workforce? Explain.

I need help with both questions

AugRealElectronics is a midsized electronics manufacturer. The company president is Shelly Couts, who inherited the company. The company originally repaired radios and other household appliances when it was founded over 70 years ago. Over the years, the company has expanded, and it is now a reputable manufacturer of various specialty electronic items.  You, a recent business school graduate, have been hired by the company in its finance department.

One of the major revenue-producing items manufactured by AugReal is a smart phone. AugReal currently has one smart phone model on the market and sales have been excellent. The smart phone is a unique item in that it comes in a variety of tropical colors and is preprogrammed to play Jimmy Buffett music. However, as with any electronic item, technology changes rapidly, and the current smart phone has limited features in comparison with newer models. AugReal spent $750,000 to develop a prototype for a new smart phone that has all the features of the existing one but adds new features such as Pokémonluring and capturing. The company has spent a further $200,000 for a marketing study to determine the expected sales figures for the new smart phone.

AugReal can manufacture the new smart phone for $205 each in variable costs. Fixed costs for the operation are estimated to run $5.1 million per year. The estimated sales volume is 64,000, 106,000, 87,000, 78,000, and 54,000 per year for the next five years, respectively, and no sales after the fifth year. The unit price of the new smart phone will be $485. The necessary equipment can be purchased for $34.5 million and will be depreciated on a seven-year MACRS schedule (see Table 6.3, p. 175).  It is believed the value of the equipment in five years will be $5.5 million.

Net working capital for the smart phones will be 20 percent of sales and will occur with the timing of the cash flows for the year (i.e., there is no initial outlay for NWC). Changes in NWC will thus first occur in Year 1 with the first year's sales. AugReal has a 35 percent corporate tax rate and a required return of 12 percent.

Shelly has asked you to prepare a report that answers the following questions:

QUESTIONS

1. What is the payback period of the project?
2. What is the profitability index of the project?
3. What is the IRR of the project?
4. What is the NPV of the project?
5. Should AugReal produce the new smart phone?

REPORT STYLE

            Remember that your boss is a smart business person, but she is not a financial analyst like you.  You should lead her through the logic of your analysis to your conclusions. Be sure your report is accurate and professional:  your job (grade) is on the line!

The report should be single-spaced within paragraphs and double spaced between paragraphs.  Use headings for major sections.  Include page numbers.  Use Times 12-point font.  Pay attention to grammar and writing style.  Write your report in third person, active voice.  Include Excel Worksheet Objects as tables in the body of your report that show the numbers involved in your analysis.  Include a memo to your boss as the cover/transmittal page.  The memo should present your primary conclusions in a bullet list.  

Your submission should be a single Word document (maximum of 6 pages) uploaded into Canvas.  I will use the attached rubric in the grading process.  “Paste object” to put your cash flows from Excel into your Word file. This allows me to simply click on your tables to see the match behind your calculations.  DO NOT USE EXCEL LIKE A TYPEWRITER.  That is, let Excel do the calculations.  Don’t do the calculations with pen and paper or a calculator and then simply type in the numbers into an Excel sheet.  I want to see that you can use Excel for this assignment and that you understand the concept of pasting an object rather than a picture from Excel to Word.  Failure to use Excel in the manner described will result in a significant grade penalty (50%?) even if your numbers are technically correct.

​(​EBIT-EPS analysis​) Bill and Kate Theil are not only husband and wife but entrepreneurs who have established three successful businesses. The proposed plan for their latest effort involves a series of international retail outlets to distribute and service a full line of ingenious home garden tools. The stores would be located in​ high-traffic cities in Latin America such as Panama​ City, Bogotá,​ São Paulo, and Buenos Aires. The entrepreneurs have proposed two financing plans. Plan A is an all​ common-equity structure. Five million dollars would be raised by selling 200,000 shares of common stock. Plan B would involve the use of​ long-term debt financing. Three million dollars would be raised by marketing bonds with an effective interest rate of 15 percent. Under plan​ B, another​ $2 million would be raised by selling 80,000shares of common stock. With both​ plans, $5 million is needed to launch the new​ firm's operations. The debt funds raised under plan B are considered to have no fixed maturity​ date, because this portion of financial leverage is thought to be a permanent part of the​ company's capital structure. The two promising entrepreneurs have decided to use a 22 percent tax rate in their​ analysis, and they have hired you on a consulting basis to do the​ following:

a. Find the EBIT indifference level associated with the two financing proposals.

b. Prepare income statements for the two plans that prove EPS will be the same regardless of the plan chosen at the EBIT level found in part a.

Assume you are a manufacturer of small kitchen electrics, and you want to determine if some innovative feature designs with unusual shapes and colors developed for town up –scale household dwellers could be successfully marketed even in the neighboring countries.

1. What qualitative research would you recommend and why?                [10 Marks]
2. Distinguish between structured, semi structured and unstructured interviews.                                                                                               

                                                                                                               [10 Marks]

The water works commission needs to know the mean household usage of water by the residents of a small town in gallons per day. Assume that the population standard deviation is 2.2 gallons. The mean water usage per family was found to be 15.8 gallons per day for a sample of 669 families. Construct the 90% confidence interval for the mean usage of water. Round your answers to one decimal place.

"The Role of the Room Rate" Analyze the hotel market in your state and determine if the room rates for the majority of hotels is elastic or inelastic. Explain your rationale and identify contributing factors (e.g., tax rates, competition, etc.). Imagine opening a small hotel in the town in which you attend class, Briefly describe the hotel and determine how you would determine the proper room rate.

Consider the following advertising game between two restaurants in a small town in Raub.

a) Find the Nash equilibrium if the restaurants need to make their decision
simultaneously.

b) If the game is played repeatedly for an infinite number of times, calculate the discount
factor that will make cooperation sustainable if the restaurants are using grim trigger
strategy.

The executives at your firm are discussing alternative pricing and cost strategies for one of your major product lines, but the finance manager is out of town at a conference. They have asked you to join the meeting to explain how cost-volume-profit (CVP) planning and sensitivity analysis might be useful in the decision making process. What would your finance manager say about the use of these financial tools?