Make a flexible budget for Emplex for the month of November

Assignment Help Managerial Accounting
Reference no: EM132793339

Question - 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:

 

Budget

Actual

Variance

Clients (11/1)

3,393

3,393

-

Clients (11/30)

3,450

3,200

250

Employees Covered

5,175,000

5,286,000

111,000

New Clients

204

198

6

Premium Services

1,380

1,487

107

 

 

 

 

On-boarding Fees

$571,200

$619,542

$48,342

Monthly Charges

11,643,750

11,259,180

384,570

Premium Charges

6,210,000

7,777,010

1,567,010

 

 

 

 

Variable Costs

 

 

 

Commissions

102,000

99,000

3,000

Data Care

1,552,500

1,691,520

139,020

Customer Care

1,035,000

1,088,000

53,000

 

 

 

 

Fixed Costs

 

 

 

Depreciation

4,300,000

4,300,000

-

Salaries

5,400,000

5,492,000

92,000

Required - Make 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.

Reference no: EM132793339

Questions Cloud

Prepare the journal entries on the books of diona company : Prepare the journal entries on the books of Diona Company to record the settlement of note payable.if the fair value of the equity instrument is used.
Prepare journal entries for each of the foregoing events : Residents of Mountain Park Ranch, Prepare journal entries for each of the foregoing events by the city. and use Excel formulas for all calculated numbers.
Define mechanisms to help amend the state constitutions : If changes need to be made, what mechanisms should be in place to help amend the state constitutions? If there is a conflict between a state's constitution.
Describe what was happening before and after the civil war : Describe what was happening before, during, and after the Civil War, according to this week's lecture. How does the article on "The Forgotten Rebellion.
Make a flexible budget for Emplex for the month of November : This team makes sure that the nuts and bolts of the monthly service works properly. Make a flexible budget for Emplex for the month of November
Explain the purpose of the documentary : Please formally critique the movie and answer the following questions. Also please explain the purpose of the documentary and if you think the documentary works
Project management principles to it security planning : Identify personnel security, training and security education needs, and associated legal and ethical awareness and propose strategies for corporations taking
What role treaty of versailles play in causes of world war : What role did the Treaty of Versailles play in the causes of World War II? Who were the major players (countries) in the war? What was Roosevelt's stance.
Compare classic greek tragedy and elizabethan tragedy : Compare and contrast classic Greek tragedy and Elizabethan tragedy. Differentiate among various forms of comedy, including satire, comedy of character, farce.

Reviews

Write a Review

Managerial Accounting Questions & Answers

  Manage budgets and financial plans

Explain the budgeting process and its importance to a business, identifying the components of different budgets, forecast estimates for inclusion in the budgets.

  Prepare a retained earnings statement

Prepare a retained earnings statement for the year and Prepare a stockholders' equity section of given case.

  Prepare a master budget for the three-month period

Prepare a master budget for the three-month period.

  Construct the companys direct labor budget

Construct the company's direct labor budget for the upcoming fiscal year, assuming that the direct labor workforce is adjusted each quarter to match the number of hours required to produce the forecasted number of units produced.

  Evaluate the predetermined overhead rate

Evaluate the Predetermined Overhead Rate

  Determine the company''s bid

Determine the company's bid if activity-based costing is used and the bid is based upon full manufacturing cost plus 30 percent.

  Compute the pool rates for the different activities

Complete the schedule to compute the pool rates for the different activities.

  Prepare Company financial statements

Prepare Company financial statements

  Prepare an analysis of terracycles

This individual assignment is based on the TerraCycle Inc.

  Discuss the ethical issues

Discuss the ethical issues

  Political resources in emerging markets

Calculate the GDP in Income Approach  and Expenditure Approach

  Management accounting - ehsan electronics company

A new plant accountant suggested that the company may be able to assign support costs to products more accurately by using an activity based costing system that relies on a separate rate for each manufacturing activity that causes support costs.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd