Question

In: Accounting

Jackson.Inc, manufactures two products that it sells to the same market. Excepted below are its budgeted...

Jackson.Inc, manufactures two products that it sells to the same market. Excepted below are its budgeted and actual operating results for the year just completed:

Budget

Actual

Units sale

Product X

22500

42000

Product Y

90000

80000

Unit contribution margin

Product X

$4.80

$3.90

Product Y

$13.00

$14.00

Unit selling price

Product X

$13.00

$14.00

Product Y

$30.00

$29.00

Industry volume was estimated to be 1875000 units at the time the budget was prepared. Actual industry volume for the periods was 2440000 units. Jackson measure variances using contribution margin

The market size variances is

Total sales quality variances is

The total contribution margin sales volume variances of the period

The total selling price variance the period is

Solutions

Expert Solution

A) market size variances is
X Y
13 30
13(42000-22500)*.06 30(80,000-90,000)*.06
15210 -18000
1875000 22500
90000
112500
6%
MSZV = P x (MSZA-MSZB) x MSHB
P = the weighted price average of each product
MSZA = actual market size
MSZB = budgeted market size
MSHB = budgeted market share
B) Sales Quantity Variance
=(Budgeted sales - Unit Sales at Standard Mix)xStandard Contribution*
Where marginal costing is used
X Y
Calculate the standard mix ratio standard mix ratio
22,500.00 90,000.00 1,12,500.00
20% 80%
sales qty in proporton to standard mix
total sales
X Y
42000 80000 122000
24400 97600 122000
calcuate diff between actual sales and sales qty in std mix
X Y
22,500.00 90,000.00
24,400.00 97,600.00
-1,900.00 -7,600.00
std contribuiion per unti
X Y
4.8 13
calcuate varaince for each produt
X Y
4.8 13
-1,900.00 -7,600.00
-9120 -98800 favourable
add indivudual vairance
-107920
C) Sales Volume Variance =
(AU) (BCM) - (BU)(BCM) or (AU-BU)(BCM)
X Y
budget 22,500.00 90,000.00
acutl 42000 80000
budget 4.8 13
(42000-22500)*4.8 (80000-90000)*13
93600 -130000
D) Sales Price Variance = Actual sales revenue - Flexible budget sales revenue for actual units sold
(AP)(AU) - (BP)(AU) or (AP-BP)(AU)
X Y
AP 14 29
BP 13 30
AU 42000 80000
(14-13)*42000 (29-30)*80000
42000 -80000

Related Solutions

Product Pricing: Two Products Quality Data manufactures two products, CDs and DVDs, both on the same...
Product Pricing: Two Products Quality Data manufactures two products, CDs and DVDs, both on the same assembly lines and packaged 10 disks per pack. The predicted sales are 400,000 packs of CDs and 500,000 packs of DVDs. The predicted costs for the year 2009 are as follows: Variable Costs Fixed Costs Materials $100,000 $600,000 Other 250,000 600,000 Each product uses 50 percent of the materials costs. Based on manufacturing time, 40 percent of the other costs are assigned to the...
Product Pricing: Two Products Quality Data manufactures two products, CDs and DVDs, both on the same...
Product Pricing: Two Products Quality Data manufactures two products, CDs and DVDs, both on the same assembly lines and packaged 10 disks per pack. The predicted sales are 400,000 packs of CDs and 500,000 packs of DVDs. The predicted costs for the year 2009 are as follows: Variable Costs Fixed Costs Materials $200,000 $600,000 Other 350,000 600,000 Each product uses 50 percent of the materials costs. Based on manufacturing time, 40 percent of the other costs are assigned to the...
Product Pricing: Two Products Quality Data manufactures two products, CDs and DVDs, both on the same...
Product Pricing: Two Products Quality Data manufactures two products, CDs and DVDs, both on the same assembly lines and packaged 10 disks per pack. The predicted sales are 400,000 packs of CDs and 500,000 packs of DVDs. The predicted costs for the year 2009 are as follows: Variable Costs Fixed Costs Materials $200,000 $500,000 Other 150,000 600,000 Each product uses 50 percent of the materials costs. Based on manufacturing time, 40 percent of the other costs are assigned to the...
Halbert plc manufactures and sells three products that use the same production facilities. In the plan...
Halbert plc manufactures and sells three products that use the same production facilities. In the plan for 2011, the details of each product were:- Product                                                                      K                     L                      M                                                                                     £                     £                     £ Selling price per unit                                               70                    45                    30 Variable costs per unit                                            35                    25                    12 Apportioned fixed costs per unit                            20                    10                   10 Profit per unit                                                            15                    10                     8 Estimated sales – units                                   15 000           20 000           20 000 Estimated...
A & B manufactures and sells two types of products to a number of customers. The...
A & B manufactures and sells two types of products to a number of customers. The resources are as follows: Material Type Product X Product Y Available Material P 8 10 31,250 Material Q 10 5 20,000 Direct Labour 4 5 17,500 Maximum sales(demand) for X is 1000 units and Y 3000 units.Contribution margin X $96 and Y $110 Formulate a linear programme Solve in excel Write a brief report to explain the analysis
company manufactures two products, A and B. Both products utilise the same material and require skilled...
company manufactures two products, A and B. Both products utilise the same material and require skilled labour. Materials and skilled labour are the only variable costs. Product details are as follows:                                                               A    B                                                                              £                             £ Selling price                                                          24                          30 Material costs                                                     5                          10 Skilled labour costs                                             16                          16        Materials cost £5 per kg. Skilled labour costs £8 per hour. For the month of May 2020 maximum expected demand is for 1,000 units of A and 1,500 units of B. In May 2020...
Firm Z manufactures 3 products using the same machine. At the weekly market demand for the...
Firm Z manufactures 3 products using the same machine. At the weekly market demand for the product (see below), the firm is limited in terms of machine capacity - 450 hours per week. Product Machine hours required per unit of product Maximum demand in units Contribution margin per unit A 3 hours machinery hours, maximum demand in units 100, Contribution margin £9 B 2 hours machinery hours, maximum demand in units 100, contribution margin £7 C 1 hour machinery hours,...
Henna Co. produces and sells two products, T and O. It manufactures these products in separate...
Henna Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company sold 43,000 units of each product. Sales and costs for each product follow. Product T Product O Sales $ 761,100 $ 761,100 Variable costs 608,880 76,110 Contribution margin 152,220 684,990 Fixed costs 33,220 565,990 Income before taxes 119,000 119,000 Income taxes (30% rate) 35,700 35,700 Net income $...
Letter Co. produces and sells two products, T and O. It manufactures these products in separate...
Letter Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company sold 48,000 units of each product. Sales and costs for each product follow. Product T Product O   Sales $ 825,600 $ 825,600   Variable costs 577,920 165,120   Contribution margin 247,680 660,480   Fixed costs 113,680 526,480   Profit before taxes 134,000 134,000   Income taxes (32% rate) 42,880 42,880   Net profit $...
Letter Co. produces and sells two products, T and O. It manufactures these products in separate...
Letter Co. produces and sells two products, T and O. It manufactures these products in separate factories and markets them through different channels. They have no shared costs. This year, the company sold 53,000 units of each product. Sales and costs for each product follow. Product T Product O   Sales $ 863,900 $ 863,900   Variable costs 604,730 86,390   Contribution margin 259,170 777,510   Fixed costs 116,170 634,510   Profit before taxes 143,000 143,000   Income taxes (40% rate) 57,200 57,200   Net profit $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT