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.
-
=> Prepare a 15-minute oral presentation on the history of charts of accounts, with particular reference to the French chart of accounts (dating from 1942). => Prepare a 15-minute oral presentation...
-
Many years ago, many politicians argued that because Microsoft Windows was installed on 90% of personal computers worldwide, it had a monopoly on the PC Operating Systems market. Does that argument...
-
What the paralegals role is in the litigation process?
-
The Foundation for Educational Excellence has decided to support the Tri-County School Districts series of teacher training workshops intended to improve instruction in mathematics. The foundation is...
-
Find Vacant 2022, and monthly supply MS using the following: Vacant2021 = 4m SF. Construction2022 = 6m SF. Net Absorption2022 = 1m SF. Gross Absorption2022 = 2.5m SF.
-
As your venture has moved from the development stage to the startup stage, a number of trade secrets have been developed along with an extensive client list. You are in the business of developing and...
-
What material was helpful and why for the Data Collection Strategies for Needs Assessment and Evaluations and Program Planning: The Big Picture and how did this material relate to your life and how...
-
Which statements about the following Twins class are true? (Choose three.) A. The class fails to compile because of the write() method. B. The class fails to compile because of the publish() method....
-
Given that Short and Integer extend Number directly, what type can be used to fill in the blank in the following class to allow it to compile? A. Object B. Integer C. Short D. Number E. None of the...
-
Which expressions about enums used in switch statements are correct? (Choose two.) A. The name of the enum type must not be used in each case statement. B. A switch statement that takes a enum value...
-
Given the following class, which method signature could be successfully added to the class as an overloaded version of the findAverage() method? A. public Long findAverage(int sum) B. public Long...
-
What is the result of compiling and executing the following class? A. red B. purple C. blue D. It does not compile. package sports; public class Bicycle { } String color="red"; private void...
-
In what ways would pipelining NOT potentially improve the execution of a program?
-
Write a function that reads a Float24_t value: Float24_t float24_read(void) A legitimate float24 value string is of the form: "mantissabexponent" where the mantissa (m) and the exponent (e) may have...
-
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...
-
A system of masses rotating in different parallel planes is in dynamic balance if the resultant. (a) force is equal to zero (b) couple is equal to zero (c) force and the resultant couple are both...
-
When the mass of a critically damped single degree of freedom system is deflected from its equilibrium position and released, it will (a) return to equilibrium position without oscillation (b)...
-
The equation of motion for a single degree of freedom system with viscous damping is \(4 \ddot{x}+9 \dot{x}+16 x=0\). The damping ratio of the system is (a) \(\frac{9}{128}\) (b) \(\frac{9}{16}\) (c)...
Study smarter with the SolutionInn App