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

  What insight does roi give into investment performance

What insight does ROI give into investment performance? Is it acceptable to lose profit on one product, if that product is vital to the sale.

  Job order costing or process costing decision

Your CFO, in her initial work, needs to decide whether to set up a job order costing system or a process type costing system. She has asked you to make a recommendation based on the following information.

  What is the contribution margin for the strip line

Which alternative (keep or drop the parquet product line) is now more cost effective and by how much? what is the contribution margin for the strip line

  What the budgeted production units for august are

Inventory equal to 30% of the next month's sales. Finished goods inventory on June 30 is 1,950 units. The budgeted production units for August are

  How much is the irrelevant cost in the problem

Perform the incremental costing analysis on the problem and provide recommendation to Aurora's management. How much is the irrelevant cost in the problem

  Recommend lenovo can take to lower the direct labor cost

Recommend (1) approach that Lenovo can take to lower the direct labor costs of technology products while remaining competitive with global markets

  Compare the overhead calculated in part a

Compare the overhead calculated in part a to that calculated in part b. Why are they different? Which allocation method (traditional or ARC) most likely results in a better estimate of product cost?

  What is the expected value of perfect information

Tversky and Kahneman describe three types of heuristics that people use in judgments under uncertainty. What do they mean by the term heuristics? Briefly describe the ones that they mention

  Prepare contribution format income statement for month

Prepare contribution format income statement for the month using variable costing. Prepare income statement for the month using absorption costing.

  Which error according to lewi change theory

HR reported a decline in productivity, job satisfaction, and morale. Company ZC committed which error according to Lewin's change theory

  What the profitability index for the investment is

What The profitability index for the investment is? The management of Tony Corporation is considering the purchase of a new machine costing $400,000

  Compute the equivalent units of material

Compute the equivalent units of material and of conversion that were required to complete the beginning inventory

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