Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I can't understand how the reply is picture not readable. As the same can be read in my mobile Sheet1 Sheet2 Sheet3 Y B E

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

image text in transcribed

I can't understand how the reply is picture not readable. As the same can be read in my mobile

Sheet1 Sheet2 Sheet3 Y B E F G H 1 . K L M N P c Hawa 4 1 . 4100 4 20 41 5313 1550 YA 44 2 DT TI 1. 3 33 33 481 CP - 4 : 12 CM RE BE SEE LE STE HIE BELLE 953 1 17 118 3 10 TU . SOS 30 NE 02 UN DO 79 T T 31 99 19 94 9 96 32 2 30 001 LAS 91 32 14 11:53 AM 090 ", e jabpng Sheet1 Sheet2 Sheet3 ... A B C E F G H 1 3 X L M N O P D R S 17 1 28 20 an 42 An 47 THE WEST AR 20 an 1 12 FA IN CV TV nd LV 10 21 22 2 Sheet1 heet2 Sheet3 D E TI G B Parameters-budget Quarters 3 1 2 4 Year 4,160 2,950 1,260 5,110 3,050 1,530 4,560 3,250 1,400 5,375 3,550 1,635 19,205 13,380 5,825 $ $ 38 $ 48 $ 38 $ 48 $ 38 $ 48 $ 38 $ 4B $ 38 48 22 22 22 22 1 2 3 4 (hours) 5 geted total sales in hours 6 geted commercial sales in hours 7 geted residential sales in hours 8 ing price (S/hr): 9 ing price per hour (commercial 10 ing price per hour (residential) 11 12 ct labour expense (S/hr): 13 14 ning Supply usage (litre/labour hour) 15 mercial 16 dential 17 18 ning Supply experne (S/litre) 19 on doverhead 21 ptionist 22 recation 23 24 De Supplies 25 26 27 28 29 0.24 0.15 0.24 0.15 0.25 0.15 0.25 0.15 $ 5.50 $ 5.50 $ 5.50 $ 5.50 6750 9250 8250 1500 6750 9250 8250 1500 6750 9250 8250 1500 6750 9250 8250 1500 27000 37000 33000 Sheet1 heet2 Sheet3 D E TI G B Parameters-budget Quarters 3 1 2 4 Year 4,160 2,950 1,260 5,110 3,050 1,530 4,560 3,250 1,400 5,375 3,550 1,635 19,205 13,380 5,825 $ $ 38 $ 48 $ 38 $ 48 $ 38 $ 48 $ 38 $ 4B $ 38 48 22 22 22 22 1 2 3 4 (hours) 5 geted total sales in hours 6 geted commercial sales in hours 7 geted residential sales in hours 8 ing price (S/hr): 9 ing price per hour (commercial 10 ing price per hour (residential) 11 12 ct labour expense (S/hr): 13 14 ning Supply usage (litre/labour hour) 15 mercial 16 dential 17 18 ning Supply experne (S/litre) 19 on doverhead 21 ptionist 22 recation 23 24 De Supplies 25 26 27 28 29 0.24 0.15 0.24 0.15 0.25 0.15 0.25 0.15 $ 5.50 $ 5.50 $ 5.50 $ 5.50 6750 9250 8250 1500 6750 9250 8250 1500 6750 9250 8250 1500 6750 9250 8250 1500 27000 37000 33000 A 3 C E F - 1 J K M N P Q 37 The SA 41 A2 24 45 Parameters - actual Quarters 3 1 2 4 Year Sales ( hours): Actual total sales Actual sales - commercial Actual sales - residential Selling price ( $/hr): Actual selling price-commercial Actual sellling price - residential 4,020 2,950 1,210 5,220 3,650 1,570 4,440 3,150 1,240 4,400 2,800 1,600 18,080 12,460 5,620 40 40 40 40 40 49 49 49 49 49 Direct labour expense ( $/hr): 23 23 23 23 Actual Cleaning Supply usage ( litre / labour hour): Commercial Residential 0.22 0.22 0.22 0.22 0.12 0.12 0.11 0.11 Actual Cleaning Supply expense ( $/litre)): 5 5 5 Actual Fixed overhead: Receptionist Depreciation Gas Office Supplies 6,010 9,250 7,300 990 5,770 9,250 7,940 950 5,915 9,250 7,450 975 6,325 9,250 7,275 1,215 24,020 37,000 29,965 4,130 20,896 Total no. of hours actually paid to employees Breakdown: Commercial Residential Actual hours worked Direct labour cost 3,393 1,392 4,784 1,10,032 4,198 1,806 6,003 1,38,069 3,623 1,426 5,049 1,16,116 3,220 1,840 5,060 1,16,380 14,433 6,463 20,896 4,80,597 Unproductive (unbilled) factor 15% 15% 15% 15% 15% Parameters - budget Quarters 1 2 3 4 Year 4,160 2,950 1,260 5,110 3,050 1,530 4,560 3,250 1,400 5,375 3,550 1,635 19,205 13,380 5,825 $ 38 38 $ 48 S 38 $ 48 $ 38 $ 48 $ 38 $ 48 $ S 48 22 22 22 22 Sales ( hours): - Budgeted total sales in hours 5 Budgeted commercial sales in hours Budgeted residential sales in hours Selling price ( $/hr): Selling price per hour (commercial) O Selling price per hour (residential) 1 2 Direct labour expense ($/hr): 3 4 Cleaning Supply usage ( litre / labour hour): 15 Commercial 16 Residential 17 18 Cleaning Supply expense ( $/litre)): 19 20 Fixed overhead: 21 Receptionist 22 Depreciation 23 Gas 24 Office Supplies 25 0.24 0.25 0.25 0.24 0.15 0.15 0.15 0.15 $ 5.50 $ 5.50 $ 5.50 $ 5.50 6750 6750 9250 27000 9250 6750 9250 8250 1500 6750 9250 8250 1500 8250 8250 37000 33000 6000 1500 1500 26 27 Sheet1 Sheet2 Sheet3 Y B E F G H 1 . K L M N P c Hawa 4 1 . 4100 4 20 41 5313 1550 YA 44 2 DT TI 1. 3 33 33 481 CP - 4 : 12 CM RE BE SEE LE STE HIE BELLE 953 1 17 118 3 10 TU . SOS 30 NE 02 UN DO 79 T T 31 99 19 94 9 96 32 2 30 001 LAS 91 32 14 11:53 AM 090 ", e jabpng Sheet1 Sheet2 Sheet3 ... A B C E F G H 1 3 X L M N O P D R S 17 1 28 20 an 42 An 47 THE WEST AR 20 an 1 12 FA IN CV TV nd LV 10 21 22 2 Sheet1 heet2 Sheet3 D E TI G B Parameters-budget Quarters 3 1 2 4 Year 4,160 2,950 1,260 5,110 3,050 1,530 4,560 3,250 1,400 5,375 3,550 1,635 19,205 13,380 5,825 $ $ 38 $ 48 $ 38 $ 48 $ 38 $ 48 $ 38 $ 4B $ 38 48 22 22 22 22 1 2 3 4 (hours) 5 geted total sales in hours 6 geted commercial sales in hours 7 geted residential sales in hours 8 ing price (S/hr): 9 ing price per hour (commercial 10 ing price per hour (residential) 11 12 ct labour expense (S/hr): 13 14 ning Supply usage (litre/labour hour) 15 mercial 16 dential 17 18 ning Supply experne (S/litre) 19 on doverhead 21 ptionist 22 recation 23 24 De Supplies 25 26 27 28 29 0.24 0.15 0.24 0.15 0.25 0.15 0.25 0.15 $ 5.50 $ 5.50 $ 5.50 $ 5.50 6750 9250 8250 1500 6750 9250 8250 1500 6750 9250 8250 1500 6750 9250 8250 1500 27000 37000 33000 Sheet1 heet2 Sheet3 D E TI G B Parameters-budget Quarters 3 1 2 4 Year 4,160 2,950 1,260 5,110 3,050 1,530 4,560 3,250 1,400 5,375 3,550 1,635 19,205 13,380 5,825 $ $ 38 $ 48 $ 38 $ 48 $ 38 $ 48 $ 38 $ 4B $ 38 48 22 22 22 22 1 2 3 4 (hours) 5 geted total sales in hours 6 geted commercial sales in hours 7 geted residential sales in hours 8 ing price (S/hr): 9 ing price per hour (commercial 10 ing price per hour (residential) 11 12 ct labour expense (S/hr): 13 14 ning Supply usage (litre/labour hour) 15 mercial 16 dential 17 18 ning Supply experne (S/litre) 19 on doverhead 21 ptionist 22 recation 23 24 De Supplies 25 26 27 28 29 0.24 0.15 0.24 0.15 0.25 0.15 0.25 0.15 $ 5.50 $ 5.50 $ 5.50 $ 5.50 6750 9250 8250 1500 6750 9250 8250 1500 6750 9250 8250 1500 6750 9250 8250 1500 27000 37000 33000 A 3 C E F - 1 J K M N P Q 37 The SA 41 A2 24 45 Parameters - actual Quarters 3 1 2 4 Year Sales ( hours): Actual total sales Actual sales - commercial Actual sales - residential Selling price ( $/hr): Actual selling price-commercial Actual sellling price - residential 4,020 2,950 1,210 5,220 3,650 1,570 4,440 3,150 1,240 4,400 2,800 1,600 18,080 12,460 5,620 40 40 40 40 40 49 49 49 49 49 Direct labour expense ( $/hr): 23 23 23 23 Actual Cleaning Supply usage ( litre / labour hour): Commercial Residential 0.22 0.22 0.22 0.22 0.12 0.12 0.11 0.11 Actual Cleaning Supply expense ( $/litre)): 5 5 5 Actual Fixed overhead: Receptionist Depreciation Gas Office Supplies 6,010 9,250 7,300 990 5,770 9,250 7,940 950 5,915 9,250 7,450 975 6,325 9,250 7,275 1,215 24,020 37,000 29,965 4,130 20,896 Total no. of hours actually paid to employees Breakdown: Commercial Residential Actual hours worked Direct labour cost 3,393 1,392 4,784 1,10,032 4,198 1,806 6,003 1,38,069 3,623 1,426 5,049 1,16,116 3,220 1,840 5,060 1,16,380 14,433 6,463 20,896 4,80,597 Unproductive (unbilled) factor 15% 15% 15% 15% 15% Parameters - budget Quarters 1 2 3 4 Year 4,160 2,950 1,260 5,110 3,050 1,530 4,560 3,250 1,400 5,375 3,550 1,635 19,205 13,380 5,825 $ 38 38 $ 48 S 38 $ 48 $ 38 $ 48 $ 38 $ 48 $ S 48 22 22 22 22 Sales ( hours): - Budgeted total sales in hours 5 Budgeted commercial sales in hours Budgeted residential sales in hours Selling price ( $/hr): Selling price per hour (commercial) O Selling price per hour (residential) 1 2 Direct labour expense ($/hr): 3 4 Cleaning Supply usage ( litre / labour hour): 15 Commercial 16 Residential 17 18 Cleaning Supply expense ( $/litre)): 19 20 Fixed overhead: 21 Receptionist 22 Depreciation 23 Gas 24 Office Supplies 25 0.24 0.25 0.25 0.24 0.15 0.15 0.15 0.15 $ 5.50 $ 5.50 $ 5.50 $ 5.50 6750 6750 9250 27000 9250 6750 9250 8250 1500 6750 9250 8250 1500 8250 8250 37000 33000 6000 1500 1500 26 27

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

Advances In Quantitative Analysis Of Finance And Accounting (Vol. 5)

Authors: Lee Cheng Few

1st Edition

9812706283, 9789812706287

More Books

Students also viewed these Accounting questions

Question

3.4 Define HRIS and describe its main components.

Answered: 1 week ago