Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How do I find the Direct Material variable costs for the static budget and actual budget? Static Budget: Sales budget Sales Commercial Sales residential Total

How do I find the "Direct Material variable costs" for the static budget and actual budget?

Static Budget:

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
Sales budget Sales Commercial Sales residential Total sales Direct material budget Variable costs commercial Variable costs residential Total variable costs Labour budget Commercial Residential Total labour Fixed Overhead: Receptionist Depreciation Gas Maintenance Total [Company name} Operating Budget for the period Jan - Dec '21 Quarters Year Parameters - budget Quarters 1 2 3 4 total Sales ( hours): Budgeted total sales in hours 6,100 6,300 5,800 5,600 23,800 Budgeted commercial sales in hours 4,000 4,200 4,000 3,500 15,700 Budgeted residential sales in hours 2,100 2,100 1,800 2,100 8,100 Selling rate ( $/hr): Selling price per hour (commercial) $39 $39 $39 $39 $39 Selling price per hour (residential) $42 $42 $42 $42 $42 Direct labour expense ( $/hr): S 26 26 $ 26 26 $ 26 Cleaning Supply usage ( litre / labour hour): Commercial 0.28 0.28 0.28 0.28 0.28 Residential 0.17 0.17 0.17 0.17 0.17 Cleaning Supply expense ( $/litre)): 5.70 $ 5.70 $ 5.70 $ 5.70 $ 5.70 Fixed overhead: Receptionist 6,000 6,000 $ 6,000 $ 6,000 $ 24,000 Depreciation 8,700 $ 8,700 $ 8,700 8,700 $ 34,800 Gas 6,000 $ 6,000 $ 6,000 $ 6,000 $ 24,000 Maintenance 1,200 $ 1,200 $ 1,200 $ 1,200 4,800Parameters - actual Quarters 1 2 3 4 Year Quarter over quarter Sales ( hours): change> > > Actual total sales 5,950 6,650 5,700 5,900 24,200 Actual sales - commercial 3,700 4,300 3,900 3,900 15,800 Actual sales - residential 2,250 2,350 1,800 2,000 8,400 Selling rate ($/hr): Actual selling price - commercial $38 $38 $38 $38 $38 Actual sellling price - residential $46 $46 $46 $46 $46 Direct labour expense ($/hr): $ 28 $ $ 28 $ 28 $ 28 Actual Cleaning Supply usage ( litre / labour hour): Commercial 0.27 0.27 0.27 0.27 0.27 Residential 0.15 0.15 0.15 0.15 0.15 Actual Cleaning Supply expense ( $/litre)): $ 5.65 $ 5.65 $ 5.65 $ 5.65 $ 5.65 Actual Fixed overhead: Receptionist $ 6,200 $ 6,400 $ 5,900 $ 5,800 $ 24,300 Depreciation $ 8,500 $ 8,500 $ 8,500 8,500 $ 34,000 Gas 8,300 7,800 $ 8,100 $ 8,300 $ 32,500 Maintenance 1,300 1,000 1,200 1,000 $ 4,500 Total no. of hours actually paid to employees Breakdown: Commercial 4,218 4,902 4,446 4,446 $ 18,012 Residential 2,565 2,679 2,052 2,280 $ 9,576 Actual hours worked 6,783 7,581 6,498 6,726 27,588 Direct labour cost 189,924 212,268 181,944 188,328 772,464 Unproductive ( unbilled ) factor 14% 14% 14% 14% 14%Operating Budget for the period Jan - Dec 2 Quarters 1 2 3 4 Year Sales budget Sales Commercial $140,600 $163,400 $148,200 $148,200 $600,400 Sales residential $103,500 $108,100 $82,800 $92,000 $386,400 Total sales $244,100 $271,500 $231,000 $240,200 $986,800 Direct material budget Variable costs commercial Variable costs residential Total variable costs Labour budget Commercial $118,104 $137,256 $124,488 $124,488 $504,336 Residential $71,820 $75,012 $57,456 $63,840 $268,128 Total labour $189,924 $212,268 $181,944 $188,328 $772,464 Fixed Overhead: Receptionist $6,200 $6,400 $5,900 $5,800 $24,300 Depreciation $8,500 $8,500 $8,500 $8,500 $34,000 Gas $8,300 $7,800 $8,100 $8,300 $32,500 Maintenance $1,300 $1,000 $1,200 $1,000 $4,500 Total $24,300 $23,700 $23,700 $23,600 $95,300

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting, The Financial Chapters

Authors: Tracie Miller Nobles

12th Edition

013449041X, 9780134490410

More Books

Students also viewed these Accounting questions

Question

5. How quickly can we manage to collect the information?

Answered: 1 week ago

Question

3. Tactical/strategic information.

Answered: 1 week ago

Question

3. To retrieve information from memory.

Answered: 1 week ago