Employee ID First name Last name Job classification Jan Sales 1001 Mary Stevens Senior Sales Rep $
Fantastic news! We've Found the answer you've been seeking!
Question:
Employee ID | First name | Last name | Job classification | Jan Sales |
1001 | Mary | Stevens | Senior Sales Rep | $ 85,000 |
1002 | Larry | Anderson | Senior Sales Rep | $ 72,000 |
1003 | Sunil | Gupta | Junior Sales Rep | $ 35,000 |
1004 | Sarah | Ellis | Junior Sales Rep | $ 61,500 |
1005 | Timothy | Chau | Junior Sales Rep | $ 48,000 |
Transcribed Image Text:
Charisa Williams is the sales manager of an online financial data service company that specializes in providing brokerage firms and independent financial analysts with up-to-date financial market data and analysis. She keeps track of the commissions of her salespeople to make sure that their earnings are competitive with those of other firms. The Commissions spreadsheet has the sales of her team in January. She expects the sales amount to increase by 5% each month for the senior sales representatives and 3% for the junior sales representatives. The base monthly salaries are $3,000 and $2,000 for senior and junior sales representatives, respectively. The sales commission rate is 8% and 6% for senior and junior sales representatives, respectively. If the monthly sales of a sales representative exceeds $100,000, he or she receives a 5% bonus on the commission of that month. The personal marginal income tax rates are 15% for up to $1,999, 22% for up to $4,999, 27% for up to $9,999, and 30% for anything beyond $9,999. a. Modify the partially-completed spreadsheet model to help Charisa Williams compute the monthly incomes (both before- and after- tax) of her sales team members for the entire year. What is the team's total sales for the entire year? Note: Round your answer to 2 decimal places. Total sales b. What is the total of before-tax annual compensations of the entire sales team? What is the total for after-tax annual compensations of the entire sales team? Note: Round your answers to 2 decimal places. Total before tax compensations Total after tax compensations c. The firm is forecasting an economic recession this year; therefore, instead of a monthly increase in sales, the firm is projecting a monthly decrease in sales by 3% and 5% for the senior and junior sales representatives, respectively. What will be the total sales, total before-tax compensations, and total after-tax compensations for the entire sales team? Note: Round your answers to 2 decimal places. Total sales Total before tax compensations Total after tax compensations Charisa Williams is the sales manager of an online financial data service company that specializes in providing brokerage firms and independent financial analysts with up-to-date financial market data and analysis. She keeps track of the commissions of her salespeople to make sure that their earnings are competitive with those of other firms. The Commissions spreadsheet has the sales of her team in January. She expects the sales amount to increase by 5% each month for the senior sales representatives and 3% for the junior sales representatives. The base monthly salaries are $3,000 and $2,000 for senior and junior sales representatives, respectively. The sales commission rate is 8% and 6% for senior and junior sales representatives, respectively. If the monthly sales of a sales representative exceeds $100,000, he or she receives a 5% bonus on the commission of that month. The personal marginal income tax rates are 15% for up to $1,999, 22% for up to $4,999, 27% for up to $9,999, and 30% for anything beyond $9,999. a. Modify the partially-completed spreadsheet model to help Charisa Williams compute the monthly incomes (both before- and after- tax) of her sales team members for the entire year. What is the team's total sales for the entire year? Note: Round your answer to 2 decimal places. Total sales b. What is the total of before-tax annual compensations of the entire sales team? What is the total for after-tax annual compensations of the entire sales team? Note: Round your answers to 2 decimal places. Total before tax compensations Total after tax compensations c. The firm is forecasting an economic recession this year; therefore, instead of a monthly increase in sales, the firm is projecting a monthly decrease in sales by 3% and 5% for the senior and junior sales representatives, respectively. What will be the total sales, total before-tax compensations, and total after-tax compensations for the entire sales team? Note: Round your answers to 2 decimal places. Total sales Total before tax compensations Total after tax compensations
Expert Answer:
Answer rating: 100% (QA)
SOLUTION a To compute the monthly incomes both before and aftertax of the sales team members for the entire year we need to first compute the monthly ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Accounting Draw Insert Design Layout Tell me ne X Aav A A v Apr Times New... v 12 v Paragraph Styles Dictate aste Av. Av BI U ab X Vi
-
Lucile Bluth has been asked by the Board of Directors to provide a brief presentation at the upcoming meeting to identify the root cause of project G.O.B's challenges as well as identify a feasible...
-
Dream Limited is engaged in the production of olive oil. Subtotals of the budgeted overheads for the first six months of the 20X6 financial year (January to June 20X6) revealed the following General...
-
Explain fully the role played by unplanned investment in inventories in determining equilibrium in the Keynesian model. Use the examples of AD > GDP and AD < GDP to illustrate your answer.
-
Consider the data in Table P-3 where X = weekly advertising expenditures and Y = weekly sales. a. Does a significant relationship exist between advertising expenditures and sales? b. State the...
-
Ray Panneton, president of Okus Designs, met with his CFO and vice president of marketing to discuss the profitability of the companys top 10 customers. These customers account for 80% of the...
-
Amazon.com, Inc. is the world's leading online retailer selling books, music, DVDs, videos, toys, electronics, software, video games, and home improvement products. The following foot- note appeared...
-
Quillen Company is performing a post-audit of a project completed one year ago. The initial estimates were that the project would cost $250,000, would have a useful life of 9 years, zero salvage...
-
ACCT 621 Individual Case #1 You are a junior financial analyst for the CPA firm, ACCT621 LLP. Your firm specializes in providing a wide variety of internal financial solutions for local small...
-
A researcher studied the number of anxiety attacks recounted over a two-week period by 30 people in psychotherapy for an anxiety disorder. In an article describing the results of the study, the...
-
13. is the influence of a moral person who moves others to do the right thing in the right way for the right reasons. * 2 points Autocratic leadership Democratic leadership Ethical leadership...
-
custody and miscommunication between first and second shift meant that the print was lost! A drop of blood on the back of Nicole Brown Simpson appeared to have been dropped from someone standing over...
-
Freedom of Speech essay questions 3.10 What policy for Internet access and use of filter software do you think is appropriate for elementary, schools? For high schools? Give your reasons. 3.15...
-
Dalya just finished the MCAT and it was NOTHING like the Princeton Review books that she studied 16 hours a day, EVERY DAY, all Summer! Dalya decides to go to the Princeton Review offices across the...
-
The Rule of 70: Suppose you have a variable, called Y, that grows at a constant rate g. The value of the variable at time t + h in relation to its value at time t is then: Yt+h = (1 + g)^h * Yt This...
-
Find and simplify f (x + h). f(x)=-2x-4x-7
-
Required information Exercise 5-4A (Algo) Effect of inventory cost flow (FIFO, LIFO, and weighted average) on gross margin LO 5-1 [The following information applies to the questions displayed below.]...
-
1. Firms may hold financial assets to earn returns. How the firm would classify financial assets? What treatment will such financial assets get in the financial statements in accordance with US GAAP...
-
According to FedSmith. com, the average salary for a federal employee in 2012 was $ 74,804. Assume the population standard deviation is $ 15,300. A random sample of 34 federal employees is selected....
-
Suppose the Department of Energy would like to compare residential utility bills for different cities in the United States. A random sample of households was selected, and their utility bills for the...
-
City Hospital would like to develop a regression model to predict the total hospital bill for a patient based on his or her length of stay, the number of days in the hospitals intensive care unit...
-
Use the partition function \(Z\) for the quantum harmonic oscillator to find the average energy, \(\langle Eangle\).
-
Find the Taylor series centered at \(x=a\) and its corresponding radius of convergence for the given function. In most cases, you need not employ the direct method of computation of the Taylor...
-
Consider Gregory's expansion \[\tan ^{-1} x=x-\frac{x^{3}}{3}+\frac{x^{5}}{5}-\cdots=\sum_{k=0}^{\infty} \frac{(-1)^{k}}{2 k+1} x^{2 k+1}\] a. Derive Gregory's expansion using the definition \[\tan...
Study smarter with the SolutionInn App