Budgeting help!!
jd09
Registered Posts: 5 New contributor 🐸
Can someone help please...
Don't know why but i'm stuggling to make sense of the Variable production overhead part in this question, everything else is easy enough but not sure how to work that bit out?
Calculate these sales and cost budgets for April.
Budget for the year Budget for April
Units sold 24,000 2,000
Units produced 25,000 2,500
£ £
Sales 480,000
Materials used 80,000
Labour 64,800
Variable production overhead 30,000
Fixed overhead 1,800
Each unit is made from 2 kg of material costing £1.60 per kg.
It takes 12 minutes to make each item.
350 hours of basic time is available in the month. Any extra hours must be worked in overtime.
The basic rate is £12 per hour. Overtime is paid at time and a half (50% more than basic rate).
Variable overhead relates to labour hours, including overtime.
Fixed overhead costs are incurred evenly through the year.
Don't know why but i'm stuggling to make sense of the Variable production overhead part in this question, everything else is easy enough but not sure how to work that bit out?
Calculate these sales and cost budgets for April.
Budget for the year Budget for April
Units sold 24,000 2,000
Units produced 25,000 2,500
£ £
Sales 480,000
Materials used 80,000
Labour 64,800
Variable production overhead 30,000
Fixed overhead 1,800
Each unit is made from 2 kg of material costing £1.60 per kg.
It takes 12 minutes to make each item.
350 hours of basic time is available in the month. Any extra hours must be worked in overtime.
The basic rate is £12 per hour. Overtime is paid at time and a half (50% more than basic rate).
Variable overhead relates to labour hours, including overtime.
Fixed overhead costs are incurred evenly through the year.
0
Comments
-
are you sure that 24000 or 2400 for me 2400 make more sense because of labour hours available of 350 hours there for 2400*12/60=480 so overtime just 130 if 24000*12/60=4800 that is too much overtime to pay0
-
Apologies, 1st column is per year and the second column is for the month0
-
Hi, I'm sure you would treat the "variable production overhead" the same as you would a normal variable cost. So divide the variable production overhead cost for the year by the number of units produced in the year, then you times this by the number of units produced in the month. Hope that helps.0
-
To answer your question about the variable production overhead; I think this would be the approach
12 minutes per unit = 0.2 hrs/unit
25,000 units x 0.2 = 5,000 hours
5000 hrs x £6.00/hr absorption rate = £30,000
I hope that helps.
I have made an attempt to understand the labour cost of £64,800
Is it made up of 350 hrs per month x 12 months per year x £12 per hour
plus 800 hours of overtime over the year x £18 per hour ?Sandy
sandy@sandyhood.com
www.sandyhood.com0 -
Re: Budgeting
This is how I calculated my labour hour:
Hour worked 350 * 12 = 4200
unit produced 2500 *12/60 = (500)
Overtime 150* 18 = 2700
Total Labour hour 6900
hope this helps0 -
Thanks guys - you've been really helpful. I knew there was a simple calculation0
-
To answer your question about the variable production overhead; I think this would be the approach
12 minutes per unit = 0.2 hrs/unit
25,000 units x 0.2 = 5,000 hours
5000 hrs x £6.00/hr absorption rate = £30,000
I hope that helps.
I have made an attempt to understand the labour cost of £64,800
Is it made up of 350 hrs per month x 12 months per year x £12 per hour
plus 800 hours of overtime over the year x £18 per hour ?
I was given the 1st column and just had to work out the 2nd. Unfortunately the format of copy and paste didn't quite work out in a table as i'd hoped so looks a bit confusing! That's how I would have worked out the labour cost too!0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 318 NEW! Qualifications 2022
- 161 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 87 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 273 Tax
- 135 Bookkeeping
- 7.2K General accounting discussion
- 200 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership