Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Emplex is a payroll service. The firm takes over all record keeping, cheque writing, and remittances to the government of payroll taxes and withholding amounts.

Emplex is a payroll service. The firm takes over all record keeping, cheque writing, and remittances to the government of payroll taxes and withholding amounts. The firm also provides premium services which consist of analysis of efficiency, bonuses, sick days, market rates of pay etc. These services are intended to help client firms make sure their employees are working efficiently and effectively. Clients pay an initial fee that covers the costs of setting up the account. After that, each client pays a monthly fee that is based on number of employees. Premium services are billed out at a negotiated rate which varies depending on the service desired, the complexity of the analysis, research requirements and any other unique aspects of the project.

Emplex employs a team of salespeople who are charged with finding new customers and liaising with existing customers. The salespeople receive a commission for each new customer they bring on board. Each month, data from all covered employees is processed electronically, but a few data entry people are employed who make sure the data is clean and properly formatted before it is processed. This team makes sure that the nuts and bolts of the monthly service works properly. There is also a large team of analysts, who are responsible for conducting and reporting on the premium services.

The static budget for the month of November follows:

BudgetActualVariance
Clients (11/1)3,3933,393--
Clients (11/30)3,4503,200250
Employees Covered5,175,0005,286,000111,000
New Clients2041986
Premium Services1,3801,487107
Onboarding Fees$571,200$619,542$48,342
Monthly Charges11,643,75011,259,180384,570
Premium Charges6,210,0007,777,0101,567,010
Variable Costs
Commissions102,00099,0003,000
Data Care1,552,5001,691,520139,020
Customer Care1,035,0001,088,00053,000
Fixed Costs
Depreciaton4,300,0004,300,000--
Salaries5,400,0005,492,00092,000

Prepare a flexible budget for Emplex for the month of November. Be sure to include activity variances. Label each variance appropriately and indicate for each the degree of significance. Document your computations and label them.

Step by Step Solution

3.47 Rating (167 Votes )

There are 3 Steps involved in it

Step: 1

Flexible Budget for November Actual Activity Level 5286000 employee... 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

Introduction to Financial Accounting

Authors: Charles Horngren, Gary Sundem, John Elliott, Donna Philbrick

11th edition

978-0133251111, 013325111X, 0133251039, 978-0133251036

More Books

Students also viewed these Accounting questions