Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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,

I need a solution for this please

image text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Terminology

Authors: Michael P Griffin

1st Edition

1423229371, 9781423229377

More Books

Students also viewed these Accounting questions