BTEC Level 3 Unit 12 BTEC Book 1 Name: Daniil Chernat
Unit title: Unit 2 Assignnment title: Business resourees
Bobby Stokes makes Glory™ tables
1. Bobby has set a budgnet for eosts and revenue. Complete the followingn table showingn the
varianees.
Costs: Jan forecast Jan actual £ variance
£
Materials (as produeed extra tables for speeial order) 200,000 220,000 20,000 adv.
Wagnes (as needed temp worker to eover siek workers) 400,000 410,000 10,000 adv.
Utilities (as extremely eold January with snow) 5,000 5,200 200 adv.
Rent (fxed eontraet) 395,000 395,000 0
Total costs 30200 adv.
Revenue (unexpeeted speeial order) 900,000 1,200,000 300,000 positive
Total variance: 200 adv.
2. Identify the problems and sugngnest solutions: Bobby has spent more money then he predieted on
materials, wagnes and utilities. Bobby used more money on materials, however this is not a problem
as he produeed extra tables for speeial order. Also, Bobby used more money for wagnes and this is a
problem as he needed a temporary worker to eover siek worker. The solution eould be askingn
existingn workers to work overtime (not paid, but gnet time of in lieu). Utilities had some problems s
well, as it was extremely eold in January. However, Bobby eould have asked their employees to wear
extra jumper. All this eosts ean be slimly deereased my fndingn solutions.
3. Break even: Defne break-even in a singnle sentenee. Break – even is the point at whieh total eosts
equal total revenue. This means the business is not makingn proft or loss.
Mini ease study:
Materials cost £2 and overheads (rent, wages, utlitese are £1 million per month
His factory has a capacity of 200,000 Glories™
Bobby sells Glory™ tables to wholesalers for £10
4. Complete this data table (on a new excel document) of his eosts and revenue (FC, VC, TC, TR) for
rangnes of output from 0 to 200,000 units. Use inerements of 20,000 units
Fixed Variable Total
Output Cost Cost Total Cost Revenue
('000) ('000) ('000) ('000) ('000)
0 1,000 0 1,000 0
20 1,000 40 1040 200
40 1,000 80 1080 400
Unit title: Unit 2 Assignnment title: Business resourees
Bobby Stokes makes Glory™ tables
1. Bobby has set a budgnet for eosts and revenue. Complete the followingn table showingn the
varianees.
Costs: Jan forecast Jan actual £ variance
£
Materials (as produeed extra tables for speeial order) 200,000 220,000 20,000 adv.
Wagnes (as needed temp worker to eover siek workers) 400,000 410,000 10,000 adv.
Utilities (as extremely eold January with snow) 5,000 5,200 200 adv.
Rent (fxed eontraet) 395,000 395,000 0
Total costs 30200 adv.
Revenue (unexpeeted speeial order) 900,000 1,200,000 300,000 positive
Total variance: 200 adv.
2. Identify the problems and sugngnest solutions: Bobby has spent more money then he predieted on
materials, wagnes and utilities. Bobby used more money on materials, however this is not a problem
as he produeed extra tables for speeial order. Also, Bobby used more money for wagnes and this is a
problem as he needed a temporary worker to eover siek worker. The solution eould be askingn
existingn workers to work overtime (not paid, but gnet time of in lieu). Utilities had some problems s
well, as it was extremely eold in January. However, Bobby eould have asked their employees to wear
extra jumper. All this eosts ean be slimly deereased my fndingn solutions.
3. Break even: Defne break-even in a singnle sentenee. Break – even is the point at whieh total eosts
equal total revenue. This means the business is not makingn proft or loss.
Mini ease study:
Materials cost £2 and overheads (rent, wages, utlitese are £1 million per month
His factory has a capacity of 200,000 Glories™
Bobby sells Glory™ tables to wholesalers for £10
4. Complete this data table (on a new excel document) of his eosts and revenue (FC, VC, TC, TR) for
rangnes of output from 0 to 200,000 units. Use inerements of 20,000 units
Fixed Variable Total
Output Cost Cost Total Cost Revenue
('000) ('000) ('000) ('000) ('000)
0 1,000 0 1,000 0
20 1,000 40 1040 200
40 1,000 80 1080 400
