I need a solution for this please
Problem 2 Cost behaviour analysis (a) Colour Zone makes and sells industrial paints in Hinchinbrook, NSW. Eduardo Garcia, the owner is considering two alternative plans for paying his four salespersons next year (2020). Plan A is a straight commission of the equivalent of $0.40 per gallon sold. Plan B is a salary equivalent of $20 000 each plus a commission of $0.20 per gallon. Required: Using cost equation, determine the number of gallons all four sales persons together would have to sell for Colour Zone to pay the same total compensation under the two plans. (b) In 2019, Colour Zone operated at full capacity of 400 000 gallons. Each sales person was paid according to Plan A. The average sale price was $10 per gallon, and the average variable cost (excluding commission) was $6 per gallon. Fixed expenses totalled $1 000 000. Garcia believes that his sales force can sell 500 000 gallons in 2020 and every year thereafter if his company can produce them. He estimates that an additional committed fixed cost of $200 000 would be required to provide another 100 000 gallons of capacity. Required: (i) Compute 2020 operating income on a contribution margin income statement if Colour Zone acquires the additional capacity and produces and sells 500 000 gallons. Assume that Colour Zone switches to plan B (a salary of $20 000 each and commission of $0.20 per gallon) to pay sales person. (ii) Repeat the above requirement (i), assuming that Colour Zone continues to pay compensation according to plan A (a straight commission of $0.40 per gallon). (iii) At production and sales volume of 500 000 gallons per year, which employee compensation plan should the company use. Why? (b) To meet the production needs, Elizabeth Grey, the purchasing manager of Colour Zone, needs a cost function to predict purchasing department costs. She believes that the primary cost driver is the number of purchase order placed. Grey collect the following observations for the most recent six quarters of activity. Quarter Number of Purchase orders Total Costs (thousands) 1 1 875 $312 2 1 500 225 3 3 800 380 4 2 300 37: 5 3 500 312 6 2 700 325Required: (i) Plot the data observations, with total purchasing department cost as the dependent variable (y) and number of purchase orders as the independent variable (x). (ii) Use the high-low method to estimate the cost function showing fixed cost and variable cost per purchase order. (iii) Regression analysis reveals that the equation of the best-fitting straight line through the sample point is: Total cost = $183 160 + $46.57 per purchase order. Draw the regression-analysis line on the graph from requirement (i). (iv) Use both the high-low method and regression-analysis cost functions to predict purchasing department cost for a quarter in which Grey places 3 000 purchase orders with suppliers. In which prediction do you have more confidence? Give your reason