F. A SUPER CLEAN 1 Operating Budget for the period Jan - Dec '18 Quarters 1 2 4 Year Sales budget Sales Commercial Sales residential O 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 Office Supplies Total

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question

static budget

Parameters - budget
Quarters
4
Year
Quarters
3
3
4
Year
Sales ( hours):
Actual total sales
Actual sales - commercial
Actual sales - residential
Selling price ( $/hr):
Actual selling price - commercial
Actual selling price - residential
4,020
2,810
4,120
2,880
1,240
5,320
3,720
1,600
18,680
13,060
5,620
5,220
Sales (hours):
Budgeted total sales in hours
Budgeted commercial sales in hours
Budgeted residential sales in hours
Selling price ( $thr):
Selling price per hour (commercial)
- Selling price per hour (residential)
4,160
2,900
1,260
5,060
3,530
4,460
3,110
1,350
5,360
3,740
1,620
19,040
13,280
5,760
3,650
1,570
1,210
1,530
$40
$40
$40
$40
$40
$4
37 $
37 $
37 $
37 $
37
$50
$50
$50
$50
$50
48
24
48 $
48 $
48
$4
48
22
22
22
22
22 $
Direct labour expense ( $lhr):
22 $
22 $
22
2 Direct labour expense ( $thr):
13
14 Cleaning Supply usage ( litre / labour hour):
Commercial
16 Residential
Actual Cleaning Supply usage ( litre / labour hour):
Commerçial
Residential
0.22
0.22
0.22
0.22
0.25
0.15
15
0.25
0.25
0.25
0.1
0.11
0.1
0.11
0.15
0.15
0.15
17
$ 5.50 $ 5.50
Actual Cleaning Supply expense ( 1
5
18
Cleaning Supply expense ( $litre)}: $ 5.50 $ 5.50
19
Actual Fixed overhead:
20 Fixed overhead:
21 Receptiornist
22 Depreciation
Gas
24 Office Supplies
6,325 24,020
36,900
7,275 29,965
1,215
5,770
5,915
Receptionist
Depreciation
Gas
6,010
9,225
7,300
6,363
25,450
36,900
6,363
9,225
7,650
1,075
6,363
9,225
7,650
1075
6,363
9,225
7,940
9,225
9,225
9,225
7,650
1,075
9,225
7,650
1,075
7,450
975
30,600
23
4,300
Office Supplies
990
950
4,130
25
20,361
Total no. of hours actually paid to e
Breakdown:
26
27
4,055
1,744
14,235
6,126
3,139
1.352
4.491
98.798
3,063
1,319
3,979
1,711
5,690
Commercial
28
Residential
29
Actual hours worked
Direct labour cost
4,382
5,799
20,361
30
96,400
1,25,176
1,27,574
#####
31
32
Unproductive ( unbilled ) factor
9%
9%
9%
9%
9%
33
34
35
NE 5
Transcribed Image Text:Parameters - budget Quarters 4 Year Quarters 3 3 4 Year Sales ( hours): Actual total sales Actual sales - commercial Actual sales - residential Selling price ( $/hr): Actual selling price - commercial Actual selling price - residential 4,020 2,810 4,120 2,880 1,240 5,320 3,720 1,600 18,680 13,060 5,620 5,220 Sales (hours): Budgeted total sales in hours Budgeted commercial sales in hours Budgeted residential sales in hours Selling price ( $thr): Selling price per hour (commercial) - Selling price per hour (residential) 4,160 2,900 1,260 5,060 3,530 4,460 3,110 1,350 5,360 3,740 1,620 19,040 13,280 5,760 3,650 1,570 1,210 1,530 $40 $40 $40 $40 $40 $4 37 $ 37 $ 37 $ 37 $ 37 $50 $50 $50 $50 $50 48 24 48 $ 48 $ 48 $4 48 22 22 22 22 22 $ Direct labour expense ( $lhr): 22 $ 22 $ 22 2 Direct labour expense ( $thr): 13 14 Cleaning Supply usage ( litre / labour hour): Commercial 16 Residential Actual Cleaning Supply usage ( litre / labour hour): Commerçial Residential 0.22 0.22 0.22 0.22 0.25 0.15 15 0.25 0.25 0.25 0.1 0.11 0.1 0.11 0.15 0.15 0.15 17 $ 5.50 $ 5.50 Actual Cleaning Supply expense ( 1 5 18 Cleaning Supply expense ( $litre)}: $ 5.50 $ 5.50 19 Actual Fixed overhead: 20 Fixed overhead: 21 Receptiornist 22 Depreciation Gas 24 Office Supplies 6,325 24,020 36,900 7,275 29,965 1,215 5,770 5,915 Receptionist Depreciation Gas 6,010 9,225 7,300 6,363 25,450 36,900 6,363 9,225 7,650 1,075 6,363 9,225 7,650 1075 6,363 9,225 7,940 9,225 9,225 9,225 7,650 1,075 9,225 7,650 1,075 7,450 975 30,600 23 4,300 Office Supplies 990 950 4,130 25 20,361 Total no. of hours actually paid to e Breakdown: 26 27 4,055 1,744 14,235 6,126 3,139 1.352 4.491 98.798 3,063 1,319 3,979 1,711 5,690 Commercial 28 Residential 29 Actual hours worked Direct labour cost 4,382 5,799 20,361 30 96,400 1,25,176 1,27,574 ##### 31 32 Unproductive ( unbilled ) factor 9% 9% 9% 9% 9% 33 34 35 NE 5
D.
A
SUPER CLEAN
1
Operating Budget for the period Jan - Dec '18
3
4
Quarters
4
Year
- Sales budget
B Sales Commercial
eSales residential
O Total sales
B Direct material budget
Variable costs commercial
Variable costs residential
Total variable costs
Labour budget
Commercial
Residential
Total labour
Fixed Overhead:
Receptionist
Depreciation
Gas
Office Supplies
Total
Transcribed Image Text:D. A SUPER CLEAN 1 Operating Budget for the period Jan - Dec '18 3 4 Quarters 4 Year - Sales budget B Sales Commercial eSales residential O Total sales B Direct material budget Variable costs commercial Variable costs residential Total variable costs Labour budget Commercial Residential Total labour Fixed Overhead: Receptionist Depreciation Gas Office Supplies Total
Expert Solution
steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education