Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Prepare cost projections for the salary/wages based on the analysis of the financial statements. ESTIMATED* 2010 COST IN S 96,000 100,000 156,000 3 WALLY'S JANITORIAL

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

Prepare cost projections for the salary/wages based on the analysis of the financial statements.

ESTIMATED* 2010 COST IN S 96,000 100,000 156,000 3 WALLY'S JANITORIAL SERVICES, SALARY SCHEDULE FOR JANITORS CURRENT SALARY ANNUAL INCOME 2009 NUMBER 2009 JANITOR NUMBER OF SCALE IN $ OF JANITORS SALARY COST IN $ JANITORS 0 24,000 4 96,000 4 1 25,000 6 150,000 4 2 26,000 4 104,000 6 3 28,000 8 224,000 3 4 30,000 0 0 7 5 32,000 6 192,000 0 6 36,500 5 182,500 6 7 40,000 3 120,000 5 8 44,000 4 176,000 3 9 50,000 5 250,000 4 10 56,000 35 1,960,000 38 Totals 80 3,454,500 80 84,000 210,000 0 6 219,000 200,000 132,000 200,000 2,128,000 3,525,000 "The estimated 2010 cost multiplies the 2009 incomes by the current number of janitors. $21,222,320 WALLY'S JANITORIAL SERVICES BUDGET INFORMATION CURRENT YEAR (NOVEMBER 2010-NOVEMBER 2011) PROJECTED BUDGET Total Revenue (net of taxes) EXPENDITURES Administration: Professional salaries $1,137,500 Clerical/secretarial salaries $ 281,250 Other $ 250,000 Subtotal Capital and Other Business Functions: Equipment and vehicles $ 6,558,100 Marketing and sales $ 1,420,000 $1,668,750 $10,109,450 $4,278,750 WALLY'S JANITORIAL SERVICES BUDGET INFORMATION CURRENT YEAR (NOVEMBER 2010 NOVEMBER 2011) PROJECTED BUDGET Aides $1,187,600 Materials/supplies $ 943,750 Subtotal Janitorial staff: Salaries $3,525,000 Training and certification $ 975,000 Insurance and safety $ 258,750 Subtotal Fixed charges: Retirement $1,176,450 Other $ 425,700 Subtotal Debt servicing Transportation: Salaries $ 400,000 Other $ 395,000 Subtotal Total expenditures Budget surplus (shortfall) $1,602,150 $1,026,000 $795,000 $19,960,100 $1.262.220 $22,099,897 WALLY'S JANITORIAL SERVICES BUDGET INFORMATION PREVIOUS YEAR (NOVEMBER 2009-NOVEMBER 2010) Total Revenue (net of taxes) EXPENDITURES Administration: Professional salaries $1,137,248 WALLY'S JANITORIAL SERVICES BUDGET INFORMATION PREVIOUS YEAR (NOVEMBER 2009 NOVEMBER 2010) Clerical/secretarial salaries Other $ 281,067 $ 261,129 Subtotal $1,679,444 $7,748,000 $ 1,394,643 $1,183,275 S 842,633 $11,168,551 $3,454,500 $ 812,268 Capital and Other Business Functions: Equipment and vehicles Marketing and sales Aides Materials/supplies Subtotal Janitorial Staff Salaries Training and certification Insurance and safety Subtotal Fixed charges: Retirement Other Subtotal Debt servicing Transportation: Salaries $ 225,198 $4,011,966 $ 1,120,428 $ 324,774 $1,445,201 $900,260 $ 399,698 Other S 301,527 Subtotal Total expenditures Budget surplus (shortfall) $701,225 $20,386,647 $1,713,250 ESTIMATED* 2010 COST IN S 96,000 100,000 156,000 3 WALLY'S JANITORIAL SERVICES, SALARY SCHEDULE FOR JANITORS CURRENT SALARY ANNUAL INCOME 2009 NUMBER 2009 JANITOR NUMBER OF SCALE IN $ OF JANITORS SALARY COST IN $ JANITORS 0 24,000 4 96,000 4 1 25,000 6 150,000 4 2 26,000 4 104,000 6 3 28,000 8 224,000 3 4 30,000 0 0 7 5 32,000 6 192,000 0 6 36,500 5 182,500 6 7 40,000 3 120,000 5 8 44,000 4 176,000 3 9 50,000 5 250,000 4 10 56,000 35 1,960,000 38 Totals 80 3,454,500 80 84,000 210,000 0 6 219,000 200,000 132,000 200,000 2,128,000 3,525,000 "The estimated 2010 cost multiplies the 2009 incomes by the current number of janitors. $21,222,320 WALLY'S JANITORIAL SERVICES BUDGET INFORMATION CURRENT YEAR (NOVEMBER 2010-NOVEMBER 2011) PROJECTED BUDGET Total Revenue (net of taxes) EXPENDITURES Administration: Professional salaries $1,137,500 Clerical/secretarial salaries $ 281,250 Other $ 250,000 Subtotal Capital and Other Business Functions: Equipment and vehicles $ 6,558,100 Marketing and sales $ 1,420,000 $1,668,750 $10,109,450 $4,278,750 WALLY'S JANITORIAL SERVICES BUDGET INFORMATION CURRENT YEAR (NOVEMBER 2010 NOVEMBER 2011) PROJECTED BUDGET Aides $1,187,600 Materials/supplies $ 943,750 Subtotal Janitorial staff: Salaries $3,525,000 Training and certification $ 975,000 Insurance and safety $ 258,750 Subtotal Fixed charges: Retirement $1,176,450 Other $ 425,700 Subtotal Debt servicing Transportation: Salaries $ 400,000 Other $ 395,000 Subtotal Total expenditures Budget surplus (shortfall) $1,602,150 $1,026,000 $795,000 $19,960,100 $1.262.220 $22,099,897 WALLY'S JANITORIAL SERVICES BUDGET INFORMATION PREVIOUS YEAR (NOVEMBER 2009-NOVEMBER 2010) Total Revenue (net of taxes) EXPENDITURES Administration: Professional salaries $1,137,248 WALLY'S JANITORIAL SERVICES BUDGET INFORMATION PREVIOUS YEAR (NOVEMBER 2009 NOVEMBER 2010) Clerical/secretarial salaries Other $ 281,067 $ 261,129 Subtotal $1,679,444 $7,748,000 $ 1,394,643 $1,183,275 S 842,633 $11,168,551 $3,454,500 $ 812,268 Capital and Other Business Functions: Equipment and vehicles Marketing and sales Aides Materials/supplies Subtotal Janitorial Staff Salaries Training and certification Insurance and safety Subtotal Fixed charges: Retirement Other Subtotal Debt servicing Transportation: Salaries $ 225,198 $4,011,966 $ 1,120,428 $ 324,774 $1,445,201 $900,260 $ 399,698 Other S 301,527 Subtotal Total expenditures Budget surplus (shortfall) $701,225 $20,386,647 $1,713,250

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_2

Step: 3

blur-text-image_3

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

ISE Fundamental Managerial Accounting Concepts

Authors: Thomas Edmonds, Christopher Edmonds, Mark Edmonds, Philip Olds

9th Edition

1260565483, 9781260565485

More Books

Students also viewed these Accounting questions

Question

What other publications/presentations does the person have?

Answered: 1 week ago

Question

What is a verb?

Answered: 1 week ago

Question

What is the purpose of the application form?

Answered: 1 week ago

Question

What is the general purpose of preliminary screening?

Answered: 1 week ago