Question

1 Approved Answer

Posted on Jun 29, 2024

MARKET SIZE, SHARE, PRICE AND VARIABLE COST FOR EACH PRODUCT AND IN TOTAL Key causal factors Plan Actual Total market Expected Actual Actual Actual Actual

MARKET SIZE, SHARE, PRICE AND VARIABLE COST FOR EACH PRODUCT AND IN TOTAL Key causal factors Plan Actual Total market Expected Actual Actual Actual Actual Market share Expected Expected Actual Actual Actual Selling price Expected Expected Expected Actual Actual Variable costs Expected Expected Expected Expected Actual Electric meters Sales $ 2,400,000 $ 1,950,000 1,950,000 $ 1,885,000 $ 1,885,000 Variable costs 1,280,000 1,040,000 1,040,000 1,040,000 1,105,000 Contribution $ 1,120,000 910,000 910,000 845,000 780,000 Market size Market share Sales price Variable costs - $ 210,000 $ -$ 65,000 -$ 65,000 Electric instruments Sales $ 3,750,000 $ 5,437,500 $ 4,350,000 $ 4,437,000 $ 4,437,000 Variable costs $ 1,375,000 $ 1,993,750 1,595,000 $ 1,595,000 1,653,000 Contribution 2,375,000 3,443,750 $ 2,755,000 2,842,000 $ 2,784,000 Market size Market share Sales price Variable costs $ 1,068,750 -$ 688,750 $ 87,000 -$ 58,000 Total Sales $ 6,150,000 7,387,500 6,300,000 $ 6,322,000 $ 6,322,000 Variable costs 2,655,000 $ 3,033,750 $ 2,635,000 $ 2,635,000 $ 2,758,000 Contribution $ 3,495,000 $ 4,353,750 $ 3,665,000 $ 3,687,000 3,564,000 Market size Market share Sales price Variable costs Check $ 858,750 -$ 688,750 $ 22,000 -$ 123,000 $ 69,000 Fixed costs Manufacturing 1,388,000 1,399,000 -$ 11,000 Selling 250,000 245,000 5,000 Administration 320,000 325,000 5,000 R&D 318,000 325,000 7,000 Profit 1,219,000 1,270,000 51,000 Electric Meters data Total market Share Volume Price Var. costs Budget 800,000 10% 80,000 EA EA 30.00 $ 16.00 Actual 650,000 10% 65,000 29.00 $ 17.00 Electric Instruments data Total market Share Volume Price Var. costs Budget 250,000 10% 25,000 150.00 $ 55.00 Actual 362,500 8% 29,000 153.00 $ 57.00MARKET SIZE, MARKET SHARE, SALES MIX, PRICE AND VARIABLE COST VARIANCES FOR EACH PRODUCT AND IN TOTAL Key causal factors Plan Actual Total marke Expected Actual Actual Actual Actual Actual Market share Expected Expected Actual Actual Actual Actual Sales mix Expected Expected Expected Actual Actual Actual Selling price Expected Expected Expected Expected Actual Actua Variable costs Expected Expected Expected Expected Expected Actua Electric meters Sales 4,685,714 $ 3,807,143 $ 3,807,143 1,950,000 1,885,000 1,885,000 Variable costs $ 2,022,857 1,643,571 1,643,571 1,040,000 1,040,000 1, 105,000 Contribution $ 2,662,857 2,163,571 $ 2,163,571 910,000 845,000 780,000 Market size Market share Sales mix Sales price Variable costs -$ 499,286 -$ 1,253,571 -$ 65,000 -$ $5,000 Electric instruments Sales 1,464,286 $ 2,123,214 1,698,571 $ 4,350,000 $ 4,437,000 $ 4,437,000 Variable costs 632, 143 916,607 733,286 1,595,000 $ 1,595,000 1,653,000 Contribution 832, 143 1,206,607 965,286 $ 2,755,000 $ 2,842,000 2,784,000 Market size Market share Sales mix Sales price Variable costs $ 374,464 -$ 241,321 1,789,714 $ 87,000 -$ 58,000 Total Sales $ 6,150,000 $ 5,930,357 $ 5,505,714 $ 6,300,000 $ 6,322,000 $ 6,322,000 Variable costs $ 2,655,000 2,560, 179 2,376,857 2,635,000 $ 2,635,000 2,758,000 Contribution 3,495,000 $ 3,370, 179 $ 3,128,857 3,665,000 $ 3,687,000 3,564,000 Market size Market share Sales mix Sales price Variable costs Check -$ 124,821 -$ 241,321 $ 536,143 $ 22,000 -$ 23,000 $ 69,000 Fixed costs Manufacturing 1,388,000 1,399,000 -$ 11,000 Selling 250,000 245,000 5,000 Administration 320,000 325,000 5,000 R&D 318,000 325,000 7,000 Profit $ 1,219,000 1,270,000 51,000 Budget data Total market Share Volume Price/unit Revenue Var. costs/unit Var. costs Contribunit Contribution Budget - EM 800,000 10% 80,000 30.00 $ 2,400,000 $ 16.00 $ 1,280,000 A EA 14.00 $ 1, 120,000 Budget - EI 250,000 10% 25,000 150.00 $ 3,750,000 55.00 $ 1,375,000 95.00 $ 2,375,000 Average 1,050,000 105,000 58.57 $ 6, 150,000 25.29 $ 2,655,000 33.29 $ 3,495,000 Actual data Total market Share Volume Price Revenue Var. costs/unit Var. costs Contribunit Contribution Actual - EM 650,000 10% 65,000 29.00 $ 1,885,000 12.00 $ 780,000 Actual - El 362,500 29,000 EA EA CA 17.00 $ 1, 105,000 8% 153.00 $ 4,437,000 $ 94,000 67.26 $ 6,322,000 At 57.00 $ 1,653,000 96.00 Average 29.34 $ 2,758,000 A EA EA $ 2,784,000 1,012,500 37.91 $ 3,564,000 NB While the figures in the first three columns above are based on average selling prices, average variable costs, and average contribution margin they have used the exact numbers found in the calculator (eg $6, 150,000 / 105,000 units = 58.57142857) rather than the figures rounded to 2 decimal places