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.
-
Distinguish among the date of dividend declaration, the date of record, and the date of payment.
-
In Exercises 39 through 42, find the largest and smallest values of the given function over the prescribed closed, bounded interval. g(t) = In(Vt) 2 for 1 t 2
-
Juliette Shulof Furs (JSF) was a New York corporation that had been in the fur-dealing business for 15 years. George Shulof, an officer of JSF, attended two auctions conducted by Finnish Fur Sales...
-
Plush Textiles Inc. shows a retained earnings balance on January 1, 2011, of $580,000. For 2011, the income from continuing operations was $225,000 before income tax. Following is a list of special...
-
How can we add Database connection script to search product item form input into MySQL Database Tables?
-
On January 1, 2021, DC Ltd. issued bonds with a maturity value of $8 million when the market rate of interest was 4%. The bonds have a coupon (contractual) interest rate of 5% and mature on January...
-
S Required information Use the following information for the Exercises below. (Algo) [The following information applies to the questions displayed below.] Simon Company's year-end balance sheets...
-
During the year, Fiona, a 19-year-old full-time student, earned $4,500 during the year and was not eligible to participate in an employer-sponsored retirement plan. The general limit for deductible...
-
What type of data can be found in "Relative Valuation" module in the Company Overview App?
-
Give 2 common reasons why scope creep occurs? Give 2 examples of what project managers can do to control Scope Creep. Reporting performance keeps stakeholders informed about how resources are being...
-
A real estate agency is considering whether to hire additional agents or to lay off workers. It currently has 4 agents and sells 52 homes. Its internal research suggests the following home sales...
-
How do you open the full inventory of Portfolios, Lists, and Screens in the Watchlist Pulse app?
-
Given the summation: - 2 n = 2 N 1 Change the summarion index from n = 2 to n = 0.
-
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...
-
From the following account balances of Josland at 31 December 20X2 prepare a balance sheet in both T-format and narrative classified format. Cash at bank $113 500 Accounts receivable (net) 52 400...
-
Flightboat Ltd borrowed $60 000, issued $20 000 worth of ordinary shares, paid a dividend of $50 000 and the owner withdrew $10 000 in cash. What was Flightboats net cash provided (used) by financing...
-
Obtain the Woolworths 2018 annual report and answer the following questions. Required: 1 How does Woolworths report on its corporate responsibility? 2 List three important points the CEO makes...
Study smarter with the SolutionInn App