L2 Tutorial Questions

AYB202 TUTORIAL 2: QUESTIONS Question 1: Matt operates a car wash. Incoming cars are put on an automatic conveyor belt which activates when a car is placed on it. Cars are washed as the conveyor belt carries them from the start station to the finish station. After a car moves off the conveyor belt, it is dried manually. Workers then clean and vacuum the inside of the car. Depreciation is computed on a straight-line basis. Matt serviced 80 000 cars in 2020. Matt reports the following costs for 2020. Account description Costs Car wash labour $260 000 Soap, cloth, and supplies 42 000 Water 38 000 Electricity to move conveyor belt 72 000 Depreciation 64 000 Salaries 46 000 Required 1. Classify each account as variable or fixed with respect to the number of cars washed. Fixed: Depreciation, salaries Variable: Car wash labour, Water, Electricity to move conveyor belt, Water, Soap, cloth and supplied 2. Create a cost function Total cost = Fixed + (Variable/unit * Quantity) TC = 110,000 + ((412,0000/80,000) * Q) TC = 110,000 + (5.15* Q) 3. Suppose Matt expects to wash 90 000 cars in 2021. Use the cost function you developed above to estimate Matt’s total costs in 2021. TC = 110,000 + (5.15 * 90,000) = $573,500

AYB202 TUTORIAL 2: QUESTIONS Question 2: Pat Wilson is the new manager of the materials storeroom for Perth Manufacturing. Pat has been asked to estimate future monthly purchase costs for part no. 4599, used in two of Perth Manufacturing’s products. Pat has cost of purchase and quantity data for the past nine months as follows: Month Cost of purchase Quantity purchased January $12 675 2 710 parts February 13 000 2 810 March 17 653 4 153 April 15 825 3 756 May 13 125 2 912 June 13 814 3 387 July 15 300 3 622 August 10 233 2 298 September 14 950 3 562 Estimated monthly purchases for this part, based on expected demand of the two products for the rest of the year, are: • October 3 340 parts • November 3 710 parts • December 3 040 parts Required a) Use the high-low method to estimate the expected purchase costs for each of the last three months of the year. See above highlighted for the high and low point Var Cost per unit = (17653 – 10233)/ (4153-2298) = $4/ unit Fixed cost = cost at high point – (Var cost per unit * activity at high point) = 17653 – (4 * 4153) = $1041 TC = 1041 + (4 * Q) Cost of Purchase Quantity Purchased October $14,401 3340 November $15,881 3710 December $13,201 3040 b) Pat has used the first nine months of data and regression analysis to estimate the relationship between the quantity purchased and the purchase costs of part no. 4599. The regression line Pat obtains is: Total cost = $2 582.57 + 3.54X Use the regression results to calculate the expected purchase costs for October, November and December. Cost of Purchase Quantity Purchased October $14,406.17 3340 November $15,715.97 3710 December $13,344.17 3040

AYB202 TUTORIAL 2: QUESTIONS

AYB202 TUTORIAL 2: QUESTIONS QUESTION 4 – We will work this together in class An excel workbook has been provided on BB to use in completing this question Belter Ltd has three product lines of belts—A, B and C—with contribution margins of $3, $2 and $1, respectively. The CEO expects to sell 200,000 units in the coming period based on the following sales mix: Product A: 20,000 Product B: 100,000 Product C: 80,000 Required A. Using the excel workbook provided, and the information above, complete the following: i. What is the company’s break-even point in units? ii. Calculate the total contribution margin and expected profit iii. Based on the projected sales, calculate the margin of safety for each product line, assuming selling price of $30 for A, $25 for B and $15 for C. B. The CEO has revised the sales mix to the following: Product A: 20,000 Product B: 80,000 Product C: 100,000 In the excel workbook provided, create a new worksheet , then recalculate i), ii) and iii) from above using the revised sales mix. Assume no change to each product’s contribution margin and selling price. C. Which sales mix [i.e. (A) or (B) based on your calculations above], provides the greatest profit: explain why. Product mix A provides the greatest profit as having more units of product B compared to product C is beneficial as Product B has a greater contribution margin per unit that product C.