Chapter 10

Download as doc, pdf, or txt
Download as doc, pdf, or txt
You are on page 1of 9

CHAPTER 10

PRODUCT PRICING AND GROSS PROFIT VARIATION ANALYSIS


[Problem 1]
1. Unit variable costs
Unit variable expense
Unit fixed overhead
Unit fixed expense
Unit costs and expenses
Mark-up (50%)
Unit sales price
2. USP
UVCE (P30 + P3)
UCM

P30
3
5
4
42
21
P63
P63
33
P30

Markup on CM = Non Cost Items + Profit


Non Cost Based
= P3 + P5 + P4 + P21 = 110%
P30
[Problem 2]
1. USP
2. USP
3. USP
4. USP
5. USP
6. USP

= P2.50 x 150% = P3.75


= P3.50 x 140% = P4.90
= P3.00 x 145% = P4.35
= P5.90 x 135% = P7.965
= P3.50 x 135% = P4.725
= P2.20 x 160% = P3.52

[Problem 3]
Unit variable production costs
Unit shipping costs
Incremental fixed costs (P40,000/10,000)
Minimum price/breakeven price

P3.00
0.75
4.00
P7.75

[Problem 4]
Markup ratios on:
1.
Absorption Costs = P3 + P2+ P30 = 102.94%
P34
Unit Profit Margin = P6,000,000 x 15% = P30
30,000 units

2.

Variable Costs and Expenses = P4 + P2 + P30


P33
=
109.09%

3.

Variable Production Costs = P4 + P3 + P2 + P30 = 130%


P30

4.

Full Costs = P30 = 76.92%


P39

5.

Materials Costs = P15 + P5 + P4 + P3 + P2 + P30


P20
=

[Problem 5]
1.

295%

Mark up ratio = P12 + P3 + P6 = 58.33%


P36
Unit fixed overhead (P600,000/50,000)
Unit fixed expenses (P150,000/50,000)
Unit profit margin [(P2,500,000 x 12%)/ 50,000]

2.
3.

P12
3
6

Target unit sales price = P36 x 158.33% = P57


Mark-up ratio = P20 + P5 + P10 = 97.22%
P36
UFxOH (P600,000/30,000)
P20
UFx exp (P150,000/30,000)
5
UPM [(P2,500,000 x 12%)/ 30,000]
10

[Problem 6]
1. Technicians wages (P600,000/20,000 hrs) P30.00/hr
Other repair costs (P200,000/20,000 hrs)
10.00/hr
Ordering, handling, etc.
15.56/hr
Standard time and material loading charge P 55.56/hr
Ordering, handling,etc rate =
100
140

P40
- 20%

= P15.56

140%
- P40

2. Standard time and materials cost (P55.56 x 4 hrs) P 222.24


Parts
1,200.00
Amount to be billed
P1,422.24
[Problem 7]
Sales
Var CGS (40% x costs)
Sales commissions
CM
CMR

Economy
P50,000
( 12,000)
( 5,000)
P33,000
66%

Standard
P80,000
( 16,000)
( 8,000)
P56,000
70%

Increase in CM Deluxe (P43,000 x 40%)


- Standard (P56,000 x 80%)
Decrease in CM- Economy (P33,000x20%)
Net Increase in CM
Old net income
Desired net income
Maximum advertising expense

Deluxe
P70,000
( 20,000)
( 7,000)
P43,000
61.43%

P17,200
44,800
(6,600)
55,400
5,500
(22,200)
P38,900

[Problem 8]
Recommended sales price = ?
Change in USP

(25%)

(10%)

10%

25%

Change in sales due to


Change in USP
( x 2003 Qty)

(750,000)

(285,000)

225,000

525,000

Change in quantity
( Qty x P 15)

450,000

300,000

(300,000)

(450,000)

(90,000)

(50,000)

(150,000)

(250,000)

Change in advertising and


promo expenditures
Change in operating
income

(390,000) P

(35,000)

(225,000)

(175,000)

The recommended unit sales price in 2003 is still P 15. All of the possible
changes in prices and volume result to reduction in operating income.

[Problem 9]
1.a. Difference in profit (P 18,000 P 15,000)
b. Direct materials
Direct labor
Minimum sales price

P 3,000
P 5,000
8,000
P 13,000

2. Advantages of contribution margin approach:


a. It gives flexibility as to pricing strategy by considering only
relevant incremental costs and expenses.
b. It evaluates segment performance by the amount it contributes to
profit.
c. It facilitates in the implementation of effective planning and
controlling system.
d. It zeroes-in to items to be controlled.
3. Pitfalls of contribution margin approach:
a. It does not consider the immediate recovery of fixed costs and
expenses which are integral to business operations.
b. It focuses to short-term decisions and not to long-term stability
and growth.
c. It is not in conformity with GAAP.
[Problem 8]
Recommended sales price = ?
Unit sales price

(11.25) P

(13.50) P

15.00 P

16.50 P

18.75

30,000

20,000

20,000

30,000

(337,500)

(270,000)

270,000

337,500

(90,000)

(50,000)

50,000

250,000

P (247,500)

P(220,000)

0 P270,000

P87,500

Increase (decrease)
In unit sales
Increase (decrease)
in sales
Increase (decrease)
In advertising and
promo expenditures
Increase (decrease)
In profit

USP =

[TC + (ROS x FxCapital)]

Units produced and sold____


[1 ROS x CA/Sales]
P 168,000 + (480/4,800) x P180,000)
12,000
P 168,000 + P 18,000 (1 0.05)
12,000
P 186,000 .95
12,000
P 15.5
= P 16.32
.95

USP =
=
=
=

1 (10% x 2.4/4.8)

[Problem 10]
1. a. Unit sales price using return-on-capital employed pricing:
Total cost = 12,000 units x P 14
= P 168,000
Ret. on sales = P 480,000/4,800,000 = 10%
CA/Sales ratio = P 2.4M/P4.8M
= 50%
USP =
=
=
=

Total cost + (ROS x Fixed Capital)


____Units produced and sold_________
(1 ROS x CA/Sales ratio)
P 168,000 + (10% x P180,000) [1 (10% x 50%)]
12,000
P 15.50
95%
P 16.32

b. Unit sales price using gross profit margin pricing:


GP rate = P 1,920 P 4,800 = 40%
USP
= P 12 60%
= P 20
2. No. The sales price for electric pencil sharpener cannot be calculated
using the return-on-capital employed pricing model because other data
needed in the model are not available.
3. The return-on-asset employed is a more strategic pricing model in
meeting the long-term strategy of a business. The gross profit pricing
basically focuses on short-term return. Hence, the return-on-assetemployed is more appropriate for decision analysis.

4. Additional steps to be taken to set an actual sales price:


a. Industry sales price.
b. Market positioning in relation to pricing strategy.
c. Flexibility of competitors in responding to price settings.
d. Market orientation as to price settings.
e. Possible regulatory bottlenecks as to pricing.
[Problem 11]
1. Sales variances:
Sales price variance:
Tamis
= P 2 F x 12,000 units
Anghang = P 2 F x 20,000 units
Sales quantity variances:
Tamis
= 4000 F x P 8
Anghang = 12,000 F x P 4
Cost variances:
Cost price variances:
Tamis
= P 3 UF x 12,000
Anghang = P 2 UF x 20,000
Cost quantity variance:
Tamis
= P 4,000 UF x P 6
Anghang = P 12,000 UF x P3
Net increase in gross profit
2.

= P 24,000 F
= 40,000 F P 64,000 F
= 32,000 F
= 48,000 F

80,000 F P144,000 F

=
=

36,000 UF
40,000 UF 76,000UF

=
=

24,000 UF
36,000 UF 60,000UF 136,000UF
P 8,000 F

Sales mix variance:


GP this year at UGP last year
Tamis = 12,000 x P 2 = P 24,000
Anghang = 20,000 x P1 = 20,000
P 44,000
Less: GP this year at ave. UGP last year
(30,000 units x P 1.50)
48,000
Sales yield variance (final sales volume variance):
GP this year at ave. UGP last year
48,000
Less: GP last year
24,000
Net quantity variance

P (4,000) UF
24,000 F
P 20,000 F

[Problem 12]
1. Handy Home Products Company
Gross Profit Variation Analysis
For the year ended December 31, 2003
Sales price variances:
Hand drill [(P 59 P 60) x 86,000 units]
Table saw [(P 115 P 120) x 74,000 units]

P (86,000) UF
(370,000) UF P (456,000) UF

Cost price variances:


Hand drill [(P 50 P 50) x 86,000 units]
Table saw [(P 82 P 80) x 74,000 units]

0
148,000 UF

148,000 UF

Sales mix variance:


Gross profit this year @ budgeted UGP:
Hand drill (86,000 x P 10) P 860,000
Table saw (74,000 x P 40) 2,960,000
3,820,000
Less: Gross profit this year at budgeted UGP
(160,000 units x P 4,400/200)
3,500,000
300,000 F
Final sales volume variance:
Gross profit this year at budgeted UGP
3,520,000
Less: Budgeted gross profit
4,400,000
(880,000) UF
Net change in gross profit
P 1,184,000 UF

2. Apparent effect (s) of the special marketing programs:


a. The predicted 10% drop in sales may result to a 10% drop in
gross profit amounting to P 224,200 (i.e., 10% x P 2,442,000),
assuming that overhead follows the trend of sales. This means
that the firm is constrained to develop its marketing programs
within the P 244,200 budget to compensate the decline in sales.
b. Granting of dealer discounts would encourage dealers to push
through table saw to customers.
c. Increased direct advertising would heighten awareness and better
market positioning that are expected to retain or increase market
share.
[Problem 13]
1. Price variances:
Sales price variances
Product 1 =
Product 2 =
Product 3 =
Product 4 =

(P 0.375 P 0.975) x 2,845 = P (682.80) UF


(P 1.023 P 0.762) x 3,280 =
856.08 F
(P 0.195 P 0.20) x 7,340 =
( 36.70) UF
(P 1.650 P 1.50) x 4,320 =
648.00 F P 784.58 F

Cost price variances


Product 1 =
Product 2 =
Product 3 =
Product 4 =

(P 0.59 P 0.60) x 2,845


(P0.99 P 0.65) x 3,280
(P0.14 P 0.20) x 7,340
(P 1.25 P1.14) x 4,320

=
=
=
=

( 28.45) F
1,115.20 UF
( 440.40) F
475.20 UF

1,121.55 UF

=
=
=
=

823.88 UF
(1310.64) F
68.00 UF
480.00 UF

( 61.24)UF

Sales quantity variances:


Product 1 =
Product 2 =
Product 3 =
Product 4 =

(2,845 2,000) x P0.975


(3,280 5,000) x 0.762
(7,340 7,000) x 0.20
(4,320 4,000) x 1.50

Cost quantity variances:


Product 1 = (2,845 2,000) x P 0.60
Product 2 = (3,280 5,000) x 0.65
Product 3 = (7,340 7,000) x 0.20
Product 4 = (4,320 4,000) x 1.14
Net gross profit variance

=
=
=
=

507.00 UF
(1,118.00) F
68.00 UF
364.84 UF

(178.20) F
P 220.01 UF

2. Sales mix variance:


GP this year UGP last year
Product 1 = 2,845 z P 0.375 = P 1,066.88
Product 2 = 3,280 x 0.112 =
367.36
Product 3 = 7,340 x
0=
0.00
Product 4 = 4,320 x 0.36 = 1,555.20
Less: GP this year at average UGP last year
(17,785 x P 2,750/18,000)
Final sales volume variance:
GP this year at average UGP last year
Less: GP last year
Net sales quantity variance

[Problem 14]
1. Sales this year at USP last year
(P 5 million x 120%)
Less: Sales last year
Sales quantity variance

P 2,989.44
2,717.15
2,717.15
2,750.00

P 272.29 F

(32.85) UF
P 239.44 F

P6,000,000
5,000,000
P1,000,000 F

2.

Sales this year


Less: STY @ USP last year
Sales price variance

3.

Sales price variance ratio = P 1,500,000 = 25% decrease


6,000,000

[Problem 15]
1. Cost this year
Less: Cost this year at UC last year
(P 6,600,000 110%)
Cost price variance
2.

P 4,500,000
6,000,000
P1,500,000) UF

P6,600,000
6,000,000
P 600,000 F

Cost this year at UC last year


P6,000,000
Less: Cost last year (P 6,600,000 120%) 5,500,000
Cost quantity variance
P 500,000 UF

3.

Cost quantity variance ratio = P 500,000 UF


P 5,500,000

[Problem 16]
1. Sales this year
Less: STY at USP last year (P8,000,000 x 105%)
Sales price variance
SPV rate = P3,600,00 F = 4.29% F
8,400,000

9.09% increase

P12,000,000
8,400,000
P 3,600,000 F

2. STY @ USP last year (P 8M x 105%)


Less: Sales last year
Sales quantity variance

P8,400,000
8,000,000
P 400,000 F

3. Cost this year


Less: CTY @ UC last year
(P 6 million x 105%)
Variable cost price variance

P8,000,000

4.

P6,300,000
6,000,000
P 300,000 UF

CTY @ UC last year


Less: Cost last year
Cost last year

6,300,000
P1,700,000 UF

You might also like