There are 2 questions below. Question 9 got 4 parts and then question 10. I need help with both of the question with all their parts in it. The graph needs to have data of january, feb, march, april, june and july. Kindly follow all the instruction given in both of the questions
9 10 points Book Pittman Company is a small but growing manufacturer of telecommunications equipment. The company has no sales force of its own; rather, it relies completely on independent sales agents to market its products. These agents are paid & sales commission of 15% for all items sold Barbara Cheney, Pittman's controller, has just prepared the company's budgeted Income statement for next year as follows: Pittman Company Budgeted Income Statement For the Year Ended December 31 Sales $25,000,000 Manufacturing expenses: Variable $11.250.000 Fixed overhead 3.500.000 14.750.000 Gross margin 10,250.000 Selling and administrative expensest Commissions to agents 3,750,000 Fixed marketing expenses 175,000 Fixed administrative expenses 2.168.800 6,085,000 Net operating income 4,165,000 Fixed interest expenses 375,000 Incone before income taxes 3,290,000 Incone taxes (301) 987,000 Net Income $ 2,383,000 Primarily depreciation on storage facilities, As Barbara handed the statement to Karl Vecel, Pittman's president, she commented, "I went ahead and used the agents 15% commission rate in completing these statements, but we ve just learned that they refuse to handle our products next year unless we increase the commission rate to 20% "That's the last straw. Karl replied angrily. "Those agents have been demanding more and more, and this time they've gone too lat. How can they possibly defend a 20% commission rato?" "They claim that after paying for advertising, travel, and the other costs of promotion, there's nothing left over for profit," replied Barbara say it's just plain robbery" retorted Kart "And I also say it's time we dumped those guys and got our own sales force. Can you get your people to work up some cost figures for us to look at?" "We've already worked them up." sald Barbara, "Several companies we know about pay a 2.5% commission to their own salespeople, along with a small salary. Of course, we would have to handle all promotion costs, too. We figure our fixed expenses would increase by $3,750,000 per year, but that would be more than offset by the $5,000,000 (20% $25,000,000) that we would vold on agents commissions." The breakdown of the $3,750,000 cost follows Sataries: Sales manager Salespersons Travel and entertainment Advertising Total $ 156,250 937,500 625,000 2,031 250 53,750,000 "Super" replied Karl "And I noticed that the $3,750,000 equals what we're paying the agents under the old 15% commission rate even better than that," explained Barbara "We can actually save $115,000 a year because that's what we're paying our auditors to check out the agents reports. So our overall administrative expenses would be less." 9 Sales sanager Salespersons Travel and entertainment Advertising Total $ 156,250 937.500 625.000 2,031 259 $3,750,000 10 po "Supect replied kart. "And I noticed that the 53.750,000 equals what we're paying the agents under the old 15% commission rate." It's even better than that," explained Barbara "We can actually save $115.000 a year because that's what we're paying our auditors to check out the agents reports. So our overall administrative expenses would be less Puld all of these numbers together and we'll show them to the executive committee tomorrow." said Kart with the approval of the committee, we can move on the matter immediately Required: 1. Compute Pittman Company's break-even point in dollar sales for next year assuming a. The agents commission rate remains unchanged at 15% b. The agents commission rate is increased to 20% c. The company employs its own sales force 2. Assume that Pitman Company decides to continue selling through agents and pays the 20% commission rate. Determine the dollar sales that would be required to generate the same net income as contained in the budgeted income statement for next your 3. Determine the dollar sales at which net income would be equal regardless of whether Pitman Company sells through agents at a 20% commission rate or employs its own sales force. 4. Compute the degree of operating leverage that the company would expect to have at the end of next year assuming The agents commission rate remains unchanged at 15% b. The agents commission rate is increased to 20% c. The company employs its own sales force. Use income before income taxes in your operating leverage computation Complete this question by entering your answers in the tabs below. Required Required 2 Required Required Compute Pittman Company's break even point in dollar sales for next year assuming (Round CM radio to 3 decimal places and final anwers to the nearest dollar amount.) The agents commission rate remains unchanged at 15% D. The agents commission is increased to 20% The company employs own salesforce Required 2 > avert 9 "We've already worked them up," said Barbara. "Several companies we know about pay a 75% commission to their own salespeople, along with a small salary. Of course, we would have to handle all promotion costs, too. We figure our fixed expenses would increase by $3,750,000 per year, but that would be more than offset by the $5,000,000 (20% - $25,000,000) that we would avoid on agents commissions." 10 points The breakdown of the $3750,000 cost follows: clock Salaries Sales manager Salespersons Travel and entertainment Advertising Total $ 156,250 937.500 625,000 2001, 250 $3,750,000 "Super" replied Karl. "And I noticed that the $3,750,000 equals what we're paying the agents under the old 15% commission rate." "It's even better than that explained Barbara. "We can actually save $115,000 a year because that's what we're paying our auditors to check out the agents reports. So our overall administrative expenses would be less." "Put all of these numbers together and we'll show them to the executive committee tomorrow." said Kart with the approval of the committee, we can move on the matter immediately Required: 1. Compute Pittman Company's break-even point in dollar sales for next year assuming: a. The agents commission rate remains unchanged at 15% b. The agents' commission rate is increased to 20% c. The company employs its own sales force. 2. Assume that Pittman Company decides to continue selling through agents and pays the 20% commission rate. Determine the dollar sales that would be required to generate the same net income as contained in the budgeted Income statement for next year 3. Determine the dollar sales at which net income would be equal regardless of whether Pittman Company sells through agents fat a 20% commission rate) or employs its own sales force. 4. Compute the degree of operating leverage that the company would expect to have at the end of next year assuming a. The agents commission rate remains unchanged at 15% b. The agents' commission rate is increased to 20% c. The company employs its own sales force. Use income before income taxes in your operating leverage computation Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required 3 Required 4 Assume that Pittman Company decides to continue selling through agents and pays the 20% commission rate. Determine the dollar sales that would be required to generate the same net income as contained in the budgeted income statement for next year. (Round CM ratio to 3 decimal places and final answer to the nearest dollar amount.) Volume of sales in doar Required 1 Required 3 > 9 your people to work up some cost figures for us to look at 10 points "We've already worked them up." sald Barbara. Several companies we know about pay a 7.5% commission to their own salespeople along with a small salary. Of course, we would have to handle all promotion costs, too. We figure our faced expenses would increase by $3,750,000 per year, but that would be more than offset by the $5,000,000 (20% $25,000,000) that we would avold on agents commissions." The breakdown of the $3,750,000 cost follows: ebook Salaries: Sales manager Salespersons Travel and entertainment Advertising Total $ 156,250 337,500 625,000 2,031 250 $3,750,000 Referencer "Super" replied Karl. "And I noticed that the $3,750,000 equals what we're paying the agents under the old 15% commission rate." "It's even better than that explained Barbara. "We can actually save $115.000 a year because that's what we're paying our auditors to check out the agents' reports. So our overall administrative expenses would be less." "Pull all of these numbers together and we'l show them to the executive committee tomorrow." said Kart. With the approval of the committee, we can move on the matter immediately Required: 1. Compute Pittman Company's break-even point in dollar sales for next year assuming: a. The agents' commission rate remains unchanged at 15% b. The agents commission rate is increased to 20%. c. The company employs its own sales force. 2. Assume that Pittman Company decides to continue selling through agents and pays the 20% commission rate. Determine the dollar sales that would be required to generate the same net income as contained in the budgeted income statement for next year. 3. Determine the dollar sales at which net income would be equal regardless of whether Pittman Company sells through agents (et a 20% commission rate) or employs its own sales force. 4. Compute the degree of operating leverage that the company would expect to have at the end of next year assuming a. The agents commission rate remains unchanged at 15% b. The agents' commission rate is increased to 20% c. The company employs its own sales force Use income before income taxes in your operating leverage computation. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Required Required 4 Determine the dollar sales at which net income would be equal regardless of whether Pittman Company sells through agents (at a 20% commission rate) or employs its own sales force. (Do not round Intermediate calculations.) Mature alates on dollars) 9 your people to work up some costures to sto "We've already worked them up sad Barbara Several companies we now about pay a 154.com to the own people along with a small salary Of course, we would have to hande promotion costs too. We are out the expenses would increase by $3,750,000 per year, but that would be more than one by the $5.000.000 (203525.000.000 that we would song comida The breakdown of the $350.000 cost follows: 10 Salaries Sales Manager Salesperson Travel and entertainment Advertising Totat fo $ 150,20 97,500 625,000 2031250 58.750,000 "Super" replied Karl And I noticed that the 53.750,000 equals what we're paying the agents under the old come I even better than that explained Barbara "We can actually save $115.000 a year because that's what we're paying our auditors to check out the agents reports. So our overall administrative expenses would be less Pult of these numbers topether and we'll show them to the recutive committee tomorrow, sad Kart win the approval of the come, we can move on the matter immediately Required: 1 Compute Pittman Company's break-even point in dollar sales for next year assuming The agents commission rate remains unchanged at 15% D. The agents commission rate is increased to 20% c. The company employs its own sales force 2. Assume that Pittman Company decides to continue seling through agents and pays the 20% commission Determine the dollar sales that would be required to generate the same net incomes contained in the budgeted income statement for next your 3 Determine the dollar sales at which net income would be equal regardless of whether Pittman Company sets through agents ( 20% commission rates or employs its own sales force 4 Compute the degree of operating severage that the company would expect to have at the end of next year assuming The agents commission rate remains unchanged at 15% b. The agents commission rate is increased to 20% The company employs its own sales force Use income before income taxes in your operating leverage computation Complete this question by entering your answers in the tabs below. red Regard 2 Mequined Required Compute the degree of operating leverage that the company would expect to have at the end of next year assuming income before income taxes in your operating leverage computation.) (Round your answers to 2 decimal place) Do Operating The girl commission to reached M 10% The norte commission incred to 20% c The company employs the sales force PER cadirad 3 10 Part 1 of 2 10 points Required Information The following information applies to the questions displayed below) Archer Company is a wholesaler of custom built ar-conditioning units for commercial buildings gathered the following monthly data relating to units shipped and total shipping expenses Totat Units Shipping Month Shipped Expense January 3 $1,300 February 6 $1,800 March 4 $1,200 April 5 $1,500 May 7 $1,800 June 8 $2,800 July 1 $ 700 eBook Reference Required: 1-a. Prepare a scattergraph using the data given above. Pot cost on the verticals and activity on the horizontal Instructions: 1. On the graph below. use the point toot (January) to plot units shipped on the horizontal axis and the shipping 2. Repeat the same process for the plotter tools (February to July). 3. To enter exact coordinates, click on the point and enter the values of Xandy 4. To remove a point from the graph, click on the point and select delete option 509 Tools January February 1000 1500 1000 March April 200 Bude May June 2000 1500 TOOD 1 2 3 4 5 7 10 Shoped Ph. Is there an approximately linear relationship between shipping expense and the number of units shipped? Yes No