Warning: foreach() argument must be of type array|object, bool given in /var/www/html/web/app/themes/studypress-core-theme/template-parts/header/mobile-offcanvas.php on line 20

Murphy Company managers received the following incomplete performance report:

Units Actual Results Flexible Budget Variance Static Budget Flexible Budget Sales Volume Variance Sales Revenue Contribution Margin Fixed Expenses Operating Income 35,000 (a) (b) 5,000 F 29,000 14,000 105,000 0 219,000 27,000 F 85,000 13,000 MURPHY COMPANY Flexible Budget Performance Report For the Year Ended July 31, 2018 134,000 14,000 35,000 35,000100,000 219,000 84,000 135,000 (c) (d) (e) (f) (h) (g) (i) (j) (k) (l)

Complete the performance report. Identify the employee group that may deserve praise and the group that may be subject to criticism. Give your reasoning.

Short Answer

Expert verified

The flexible budget performance reports are prepared as per the data provided. The sales team is performing well but on the other hand, the performance of the production and administration team is not up to the mark.

Step by step solution

01

Preparation of flexible budget

Murphy Company

Flexible Budget Performance Report

For the year ended July 31, 2018

Actual ($)

Flexible Budget Variance ($)

Flexible Budget ($)

Sales Volume Variance

Static Budget

Units

35,000

0

35,000

5,000 F

30,000

Sales Revenue

219,000

0

219,000

27,000 F

192,000

Variable expenses

85,000

1,000 U

84,000

13,000 U

71,000

Contribution Margin

134,000

1,000 U

135,000

14,000 F

121,000

Fixed Expenses

105,000

5,000 U

100,000

0

100,000

Operating Income

29,000

6,000 U

35,000

14,000 F

21,000

02

Preparation of flexible budget

The sales team or group of the company deserves praise as they have achieved better sales volume than the budgeted sales volume, which is reflected by the volume variance.

The group responsible for production and administration deserves criticism as the actual variable expenses and fixed expenses have gone up in comparison to the amounts shown in the budgets, which are reflected by flexible budget variance for variable costs (1,000 U) and flexible budget variance for fixed expenses (5,000 U).

Unlock Step-by-Step Solutions & Ace Your Exams!

  • Full Textbook Solutions

    Get detailed explanations and key concepts

  • Unlimited Al creation

    Al flashcards, explanations, exams and more...

  • Ads-free access

    To over 500 millions flashcards

  • Money-back guarantee

    We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with Vaia!

One App. One Place for Learning.

All the tools & learning materials you need for study success - in one app.

Get started for free

Most popular questions from this chapter

Computing and journalizing standard cost variances

Moss manufactures coffee mugs that it sells to other companies for customizing with their own logos. Moss prepares flexible budgets and uses a standard cost system to control manufacturing costs. The standard unit cost of a coffee mug is based on static budget volume of 59,800 coffee mugs per month:

Direct material (0.2 lbs. @\(0.25 per lb)

\)0.05

Direct Labor (3 minutes @ \(0.11 per minute)

0.33

Manufacturing Overhead:

Variable (3 minutes @ \)0.06 per minute)

\(0.18

Fixed (3 minutes @ \)0.13 per minute)

0.39

0.57

Total Cost per Coffee Mug

\(0.95

Actual cost and production information for July 2018 follows:

a. There were no beginning or ending inventory balances. All expenditures were on account.

b. Actual production and sales were 62,500 coffee mugs.

c. Actual direct materials usage was 11,000 lbs. at an actual cost of \)0.17 per lb.

d. Actual direct labor usage was 197,000 minutes at a total cost of \(25,610.

e. Actual overhead cost was \)10,835 variable and \(29,765 fixed.

f. Selling and administrative costs were \)95,000.

Requirements

1. Compute the cost and efficiency variances for direct materials and direct labor.

2. Journalize the purchase and usage of direct materials and the assignment of direct labor, including the related variances.

3. For manufacturing overhead, compute the variable overhead cost and efficiency variances and the fixed overhead cost and volume variances.

4. Journalize the actual manufacturing overhead and the allocated manufacturing overhead. Journalize the movement of all production costs from Workยญ-inยญ-Process Inventory. Journalize the adjusting of the Manufacturing Overhead account.

5. Moss intentionally hired more highly skilled workers during July. How did this decision affect the cost variances? Overall, was the decision wise?

Question: What are the two components of the static budget variance? How are they calculated?

Question:How does the static budget affect the cost and efficiency variances?

The May 2018 revenue and cost information for McDonald Outfitters, Inc. follows:

Sales Revenue (at standard) $ 610,000

Cost of Goods Sold (at standard) 348,000

Direct Materials Cost Variance 1,500 F

Direct Materials Efficiency Variance 6,600 F

Direct Labor Cost Variance 4,200 U

Direct Labor Efficiency Variance 2,700 F

Variable Overhead Cost Variance 2,800 U

Variable Overhead Efficiency Variance 1,100

Fixed Overhead Cost Variance 2,300 U

Fixed Overhead Volume Variance 8,300 F

Prepare a standard cost income statement for management through gross profit. Report all standard cost variances for managementโ€™s use. Has management done a good or poor job of controlling costs? Explain.

Preparing a flexible budget performance report

Cell Plus Technologies manufactures capacitors for cellular base stations and other communication applications. The companyโ€™s July 2018 flexible budget shows output levels of 8,500, 10,000, and 12,000 units. The static budget was based on expected sales of 10,000 units.

Cell One Technologies

Flexible budget

For month ended July 31, 2018

Budgeted amount per unit

Units

8,500

10,000

12,000

Sales revenue

\(24

\)204,000

\(240,000

\)288,000

Variable expenses

13

110,500

130,000

156,000

Contribution margin

93,500

110,000

132,000

Fixed expenses

57,000

57,000

57,000

Operating income

\(36,500

\)53,000

\(75,000

The company sold 12,000 units during July, and its actual operating income was as follows:

Cell One Technologies

Income statement

For the Month Ended July 31, 2018

Sales revenue

\)295,000

Variable expenses

161,100

Contribution margin

133,900

Fixed expenses

58,000

Operating income

$75,900

Requirements

1. Prepare a flexible budget performance report for July 2018.

2. What was the effect on Cell Plusโ€™s operating income of selling 2,000 units more than the static budget level of sales?

3. What is Cell Plusโ€™s static budget variance for operating income?

4. Explain why the flexible budget performance report provides more useful information to Cell Plusโ€™s managers than the simple static budget variance. What insights can Cell Plusโ€™s managers draw from this performance report?

See all solutions

Recommended explanations on Business Studies Textbooks

View all explanations

What do you think about this solution?

We value your feedback to improve our textbook solutions.

Study anywhere. Anytime. Across all devices.

Sign-up for free