total sales by salesperson in excel for mac

Total sales by salesperson in excel for mac plus#

Office Equipment ₤ 40,000 Utilities Expense ₤ 6,000 Cash 14,000 Accounts Receivable 27,000 Service Presented below is selected information related to O' Hara Company at December 31, 2011. O' Hara Company began operations on December 1, 2011. Later you discover that the company has a president, a sales manager, and 30 salespeople you also learn that each salesperson earns You apply for a job selling diet marshmallows because an ad says that the average company employee earns $50,000 a year. Find the value of S(45,000)ĭoughtry's Pet Shop reported a net loss of $1,500,000 and total expenses of $2,900,000. Let S(x) represent the commission on x dollars of sales. A salesperson gets a commission of $600 for the first $10,000 of sales, and then $300 for each additional $10,000 or partial of sales. write an equation that expresses t, her income for one month as a function of x, her total sales for the month.

Total sales by salesperson in excel for mac plus#

she earns $1,000 per month plus 15% commission on her sales. Martha works as a salesperson for momentum sales. Calculate the profit or loss on 12,000 bags and on 25,000 bags. What would the total yearly earnings of a sales assistant be who has $90,000 in sales? Commission & Salaries- Sales Assistant-Base Salary-$10,000 Sales Person-Baseī. This table is used to calculate annual commissions and salaries for car salespeople. Manuel, a sales agent,h has a basic salary of $18 000 and a commission of 20%on a sales above $80 000.if this total sales is $290 000. The following information is available from Payne’s records for the 10 Based on recent history, Payne has a gross profit of 25 percent of net sales. On October 31, a flood at Payne Company’s only warehouse caused severe damage to its entire inventory. The total sales made by a salesperson was $25,000 after 3 months and $68,000 after 23 months. Investing in the first venture will cost $3,000 more than investing in both the second and the third venture. The total cost of investing in all three ventures will be $15,000. Jake has decided upon three business ventures to invest in. How much would she earn if her total sales for the week wereīlane Company has the following data: Total Sales 800,000, Total Variable Costs 300,000, Fixed Costs 200,000, Units Sold 50,000, What will operating income be if units sold double to 100,000 units? She also earns a commission of 6% on all sales for the week and a bonus of 2% on all sales above $5,000 for the week. What would the total yearly earnings of a sales assistant be who has $90,000 in sales? Commission & Salaries Sales Assistant-Base Salary-$10,000 Sales Person-BaseĪ salesperson in a furniture store receives a weekly salary of $1,250. Estimate the probability that a randomly selected member earns at least $98,000. The data set represents the income levels of the members of a country club. If a firm has a break-even point of 20,000 units and the contribution margin on the sirm's single product is $3.00 per unit and fixed costs are $60,000, what will the firm's net income be at sales of 30,000 units? o.k. Jim Jones, an employee of Aley, has $130,000 in sales. ABC explosion ltd deals in informationĪley Company pays all its employees in a graduated commission scale: 3% on the first $30,000 sales, 5% on sales from $30,000 to $110,000, and 7% on sales more than $110,000. Write a piecewise function thatĭesign a flowchart and pseudo-code for a structured program that could be used to calculate a sales person’s gross salary and output of the sales person’s basic salary, additional pay, bonus, and gross salary. The commission is 2% of the sales up to and including $25,000 for the month and 5% of the sales over $25,000 for the month. Find the salesperson’s total pay for the year.Īn air conditioning salesperson receives a base salary of $2850 per month plus a commission.

Using an equation for the line whose graph depicts this data, predict theĪ computer salesperson earns a base salary of $32,000 per year plus a commission of 6% on total sales.