Question

5)X Company uses an activity-based costing overhead allocation system. It has identified three activities - Material handling, Product testing, Packaging - and their respective cost drivers - pounds of material, tests, packages. Budgeted activity costs in 2018 were as follows:

Activity	Budgeted Cost
Material handling	$104,700
Product testing	58,700
Packaging	53,000

The following 2018 cost driver information is available for one of its products, Product A, and for all of its products (including Product A):

	Product A	All Products
pounds of material	32,000	747,857
tests	53,500	1,174,000
packages	63,600	662,500

How much overhead was allocated to Product A in 2018 [round overhead rate(s) to two decimal places]?

6) The cafeteria at X Company incurred the following costs in September:

Cost Item	Cost
Supervisor salary	$6,310
Hourly workers wages	22,312
Food	11,849
Equipment	7,900
Supplies	3,246
Total	$51,617

The hourly workers wages, food costs, and supplies costs were variable; the supervisor salary and equipment costs were fixed. The cafeteria served 11,100 meals during September. In October, the cafeteria is expected to serve 10,600 meals. Using account analysis with this data, estimate the total cafeteria cost in October [round variable costs per unit to two decimal places]?

7) The cafeteria at X Company has the following cost and activity information for the first five months of 2019:

Month	Cost	Meals
January	$27,319	7,100
February	29,961	7,787
March	29,301	7,615
April	32,379	9,300
May	29,171	7,581

Using the high-low method with this data, estimate the total cafeteria cost in December, when 10,400 meals are expected to be served [round variable costs per unit to two decimal places].

8) Sales and costs for X Company in 2018 were as follows:

		Total	Per Unit
Sales		$150,500	$17.20
Variable manufacturing costs		65,888	7.53
Variable selling costs		19,950	2.28
Fixed manufacturing costs		8,925	1.02
Fixed selling costs		2,975	0.34

X Company expects sales to increase from 8,750 units in 2018 to 9,550 units in 2019. It also expects direct labor costs per unit to decrease by $1.20 and fixed selling costs to increase by $3,300. What is expected profit in 2019?

Answer 1

5)

Activity	Activity rate	Overhead assigned to Product A
		Activity usage	Overhead assigned (activity usage *activity rate)
Material Handling	104700/747857 = $ .14 per pound	32000	4480
Product testing	58700/1174000 = $ .05 per test	53500	2675
Packaging	53000 / 662500 = $ .08 per packages	63600	5088
Overhead assigned			12243

6)

	Variable cost	Fixed cost
Supervisor salary		6310
Hourly workers wages	22312
Food cost	11849
Equipment		7900
supplies	3246
Total cost	37407	14210
Number of meals served	11100
Variable cost per meal	37407/11100 =$ 3.37 per meal

In October If 10600 meals to be served ,Total cost = [X*3.37 ]+ 14210

Where X =number of meals to be served

                                                  =[ 10600 *3.37] +14210

                                                  = 35722+ 14210

                                                 = 49932

7)

	Cost	Activity
Highest activity	32379	9300
Lowest activity	27319	7100
Change in cost /activity	5060	2200

Variable cost per meal = change in cost /change in activity

                              = 5060 /2200

                              = $ 2.3 per meal

Fixed cost at highest activity -=Total cost -variable cost

                                    = 32379 - (9300 *2.3)

                                   = 32379 - 21390

                                     = 10989

If 10400 meals are served ,Total cost =[X*2.3]+ 10989

                                             = [2.3*10400 ] + 10989

                                           = 23920+10989

                                           = 34909

8)

Sales (9550*17.2)		164260
less:variable cost
Variable manufacturing costs (7.53-1.20= 6.33*9550)	60451.5
variable selling costs   (2.28*9550)	21774	(82225.5)
contribution margin		82034.5
fixed cost
Fixed manufacturing costs	8925
Fixed selling costs (2975 +3300)	6275	(15200)
net profit		66834.5