Part 1
Carnival Handy Bag Limited (“Handy Bag”) manufactures and sells a single product. The following information is available for three years ending 30 September
Price per |
Unit volume |
||||
unit |
000s |
||||
Sales |
$ |
||||
Actual 2011 |
130 |
50 |
|||
Forecast 2012 |
129 |
52 |
|||
Forecast 2013 |
128.5 |
53 |
|||
Costs per unit |
Actual |
Forecast |
|||
Produced |
2011 |
2012 |
2013 |
||
$ |
$ |
$ |
|||
Direct materials |
50 |
55 |
55 |
||
Direct labour |
30 |
31.5 |
33 |
||
Variable production overhead |
10 |
11 |
12 |
||
Direct expenses |
5 |
5 |
6 |
||
Variable sales overhead |
15 |
16 |
16 |
||
Other costs for the year |
$ |
$ |
$ |
||
000 |
000 |
000 |
|||
Fixed production overhead |
50 |
55 |
55 |
||
Other fixed overhead |
200 |
220 |
220 |
||
Additional information: |
|||||
When the management of Handy Bag prepared its direct labour forecast unit cost for 2012 and 2013, direct wages were increased only by the forecast rate of inflation |
|||||
The trade union representatives of the production workers wished to press for a greater wage increase. They suggested that: |
|||||
Direct wages be increased at twice the rate of inflation. The effect of this would be to increase direct labour costs per unit as follows: |
|||||
2012 |
2013 |
||||
$ |
$ |
||||
Direct labour |
33.0 |
35.0 |
|||
Unit selling prices be increased in order to cover the increased labour costs. |
|||||
It is to be assumed that all expense and revenue relationships will be unchanged except where indicated |
|||||
Required: |
|||||
A schedule for 2011, 2012, 2013 for Handy Bag Ltd showing: |
|||||
the break-even points; |
|||||
the net profit for each year. |
|||||
Base your calculations on the original labour costs. |
|||||
A graph showing a break-even point for 2012.
|
|||||
Advise Handy Bag management as to their response to the trade union’s claim for higher wages. Include relevant financial analysis |
|||||
Explain the limitation of break-even analysis in the context of the question.
|
|||||
Part 2
Handy Bag also produces 1,000 bags for export per month for a fixed cost of $300,000 and variable cost of $500 per unit. Its current demand is 600 units which it sells at $1,000 per unit. It is approached by Man Purse Limited for an order of 200 units at $700 per unit.
Should Handy Bag accept the order and why?
I HOPE ITS HELPFUL TO YOU IF YOU HAVE ANY DOUBTS PLS COMMENTS BELOW..I WILL BE THERE TO HELP YOU...ALL THE BEST...!!
AS FOR GIVEN DATA...
A: | ||||||
2011 | 2012 | 2013 | ||||
Sold volume | 50000 | 52000 | 53000 | |||
SP | 130 | 129 | 128.5 | |||
Less: VC: | ||||||
DM | 50 | 55 | 55 | |||
DL | 30 | 33 | 35 | |||
VPO | 10 | 11 | 12 | |||
DE | 5 | 5 | 6 | |||
VSO | 15 | 16 | 16 | |||
total VC | 110 | 120 | 124 | |||
Contribution | 20 | 9 | 4.5 | |||
Total contribution | 1000000 | 468000 | 238500 | |||
Total Fixed cost | 250000 | 275000 | 275000 | |||
NI | 750000 | 193000 | -36500 | |||
BEP (fc/cont p.u.) | 12500 | 30555.56 | 61111.11 | |||
C. The trade union's claim should not claim for higher wages as the selling price | ||||||
do not increase with increase in wages leading to loss. | ||||||
D. The limitation fo BE analysis is that | ||||||
1) BE increases rapidly if the selling price decreases with cost increase. | ||||||
2) BE increases with the increase in fixed costs. | ||||||
3) BE must be obtained to be no profit no loss position. |
Part 1 Carnival Handy Bag Limited (“Handy Bag”) manufactures and sells a single product. The following...
e in the following table. Basic CVP relationships: manufacturer Vine Pty Ltd produces and sells bottles of wine. Price and cost data are in the following P18.33 LO18.1 18.3 18.4 18.5 Selling price per bottle Variable costs per bottle: Direct material Direct labour Manufacturing overhead Selling costs Total variable costs per bottle Annual fixed costs: Manufacturing overhead Selling and administrative Total fixed costs Forecast annual sales (140000 units) $ 29,70 $ 432000 621000 $1053000 $5250000 (In the following requirements, ignore...
QUESTION 4 Cemerlang Company manufactures and sells a product by the name PREMIUM. These products are sold at RM20 per unit. The company's sales amounted to RM8 million (normal capacity) for the year ended December 31, 2010. The following is the cost involved to produce these products Direct material Direct labor Variable overhead Manufacturing cost: fixed RM 4.00 per unit RM 3.00 per unit RM 2.60 per unit RM 240 000 RM 60 000 variable Selling and distribution expenses fixed...
Parkins Company produces and sells a single product. The company's income statement for the most recent month is given below: Sales (6,000 units at $40 per unit)............ $240,000 Less variable costs: Direct materials...................................... $48,000 Direct labor (variable)............................ 60,000 Variable manufacturing overhead.......... 12,000 Variable selling and other Expenses 24,000 144,000 Contribution margin.................................. 96,000 Less fixed costs: Fixed manufacturing overheat .............. 30,000 Fixed selling and other expenses........... 42,000 72,000 Net operating income................................ $ 24,000 There are no beginning or ending...
Basic CVP relationships: manufacturer Vine Pty Ltd produces and sells bottles of wine. Price and cost data are in the following table. $ 37.50 P18.33 LO18.1 18.3 S 12.30 Selling price per bottle 18.4 6.00 Variable costs per bottle: 18.5 Direct material 9.00 Direct labour 2.40 S 29.70 Manufacturing overhead Selling costs S 432000 Total variable costs per bottle Annual fixed costs Manufacturing overhead 621 000 $1053000 $5250000 Selling and administrative Total fixed costs Forecast annual sales (140000 units Refer...
Chec Blanchard Company manufactures a single product that sells for $220 per unit and whose total variable costs are $176 per unit. The company's annual fixed costs are $664,400. ) Prepare a contribution margin income statement for Blanchard Company at the break-even point BLANCHARD COMPANY Contribution Margin Income Statement (at Break-Even) Percentage of sales Amount ook Hint Print Relerences (2) Assume the company's fixed costs increase by $136,000. What amount of sales (in dollars) is needed to break even? Break-Even...
19. Gina Production Limited uses a standard costing system. The following information perta to 2011: Actual overhead costs ($16,500 is fixed) $ 40,125 Actual direct labour costs (11,250 hours) $131,625 Standard direct labour for 5,500 units: Standard hours allowed 11,000 hours Labour rate $12.00 The overhead rate is based on an activity level of 10,000 hours. Standard cost data for 5,000 units is as follows: Variable overhead Fixed overhead Total overhead $22,500 13,500 $36.000 What is the fixed overhead volume...
Handy Home sells windows and doors in the ratio of 7:3 (windows:doors). The selling price of each window is $105 and of each door is $255. The variable cost of a window is $65.00 and of a door is $177.50. Fixed costs are $640,625. (Enter your "per unit" values in two decimal places.) (1) Determine the selling price per composite unit. Quantity Selling Price per unit Total per composite unit Windows Doors (2) Determine the variable costs per composite unit....
Handy Home sells windows and doors in the ratio of 8:2 (windows:doors). The selling price of each window is $112 and of each door is $262. The variable cost of a window is $68.50 and of a door is $181.00. Fixed costs are $459,000. (Enter your "per unit" values in two decimal places.) Selling Price per unit Total per composite unit (1) Determine the selling price per composite unit. Quantity Windows 8s Doors 112.00 262.00 524.00 Variable costs per unit...
Flannigan Company manufactures and sells a single product that sells for $580 per unit, variable costs are $319. Annual fixed costs are $958,500. Current sales volume is $4,330,000. Compute the contribution margin per unit. Multiple Choice Ο Ο Ο Ο Ο A company's product sells at $12.22 per unit and has a $5.33 per unit variable cost. The company's total fixed costs are $96,900 The contribution margin per unit is: Multiple Choice Ο $8.06. Ο $5.33. Ο $6.89. Ο $12.22....
Exercise 5-22 CVP analysis using composite units LO P4 Handy Home sells windows and doors in the ratio of 8:2 (windows:doors). The selling price of each window is $120 and of each door is S270. The variable cost of a window is S72.50 and of a door is $185.00. Fixed costs are S275,000. (Enter your "per unit" values in two decimal places.) Answer is not complete. unit. Selling Price per u nit Total per composite unit Windows Doors Determine the...