Nottingham Forest Products reports the following information concerning operations for the most recent month: Master Budget (based on budgeted sales of 4,000 units) $ 188,000 Sales revenue Less Manufacturing costs Direct labor Materials Variable overhead Marketing Administrative Total variable costs Contribution margin Fixed costs Manufacturing Marketing Administrative Total fixed costs Actual (based on actual sales of 4,800 units) $ 228,700 50,302 31,520 16,608 7,805 7,215 $ 113,450 $ 115,250 38,930 14,860 9,510 $ 63,300 $ 51,950 39,000 27, 200 13,100 6,200 6,500 $ 92,000 $ 96,000 37,400 12,200 10,400 $ 60,000 $ 36,000 Operating profits There are no inventories. Required: Prepare a sales activity variance analysis for Nottingham Forest Products.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Topic Video
Question

Jay 

 

Nottingham Forest Products reports the following information concerning operations for the most recent month:
Master Budget
(based on
budgeted sales
of 4,000
units)
$ 188,000
Sales revenue
Less
Manufacturing costs
Direct labor
Materials
Variable overhead
Marketing
Administrative
Total variable costs
Contribution margin
Fixed costs
Manufacturing
Marketing
Administrative
Total fixed costs
Operating profits
There are no inventories.
Sales revenue
Variable costs:
Manufacturing costs:
Direct labor
Materials
Variable overhead
Marketing
Administrative
Total variable costs
Contribution margin
Fixed costs:
Manufacturing
Marketing
Administrative
Total fixed costs
Operating profits
Actual (based
on actual sales
of 4,800 units)
$ 228,700
50,302
31,520
$
$
16,608
7,805
7,215
$ 113,450
$ 115,250
Required:
Prepare a sales activity variance analysis for Nottingham Forest Products.
Note: Do not round intermediate calculations. Indicate the effect of each variance by selecting "F" for favorable, or "U" for
unfavorable. If there is no effect, do not select either option.
38,930
14,860
9,510
$ 63,300
$ 51,950
46,800✔
32,640 →
15,720 ✔
7,440
7,800✔
$ 110,400 $
$
> Answer is complete but not entirely correct.
NOTTINGHAM FOREST PRODUCTS
Sales Activity Variance
Flexible
Master
Budget
Budget
(based on
actual of
(based on
budgeted
4,000 units)
4,800 units)
$ 225,600 $ 225,600 F ✓ $ 188,000
39,000
27,200
13,100
110,400
6,200
6,500
$ 92,000
$ 96,000
115,200 $ 115,200
37,400✔
12.200
10,400✔
60,000
55,200 $ 55,200
37,400
12, 200
10,400
$ 60,000
$36,000
Sales Activity
Variance
46,800 X U
32,640 X U
15,720 X U
7,440 X U
7,800 X U
U
F
X
3333333
39,000
27,200
13,100
6,200
6,500
92,000
✓ $
✓$ 96,000
U X
U
X
U
X
U X $
F ✓ $
37,400
12,200
10,400
60,000
36,000
Transcribed Image Text:Nottingham Forest Products reports the following information concerning operations for the most recent month: Master Budget (based on budgeted sales of 4,000 units) $ 188,000 Sales revenue Less Manufacturing costs Direct labor Materials Variable overhead Marketing Administrative Total variable costs Contribution margin Fixed costs Manufacturing Marketing Administrative Total fixed costs Operating profits There are no inventories. Sales revenue Variable costs: Manufacturing costs: Direct labor Materials Variable overhead Marketing Administrative Total variable costs Contribution margin Fixed costs: Manufacturing Marketing Administrative Total fixed costs Operating profits Actual (based on actual sales of 4,800 units) $ 228,700 50,302 31,520 $ $ 16,608 7,805 7,215 $ 113,450 $ 115,250 Required: Prepare a sales activity variance analysis for Nottingham Forest Products. Note: Do not round intermediate calculations. Indicate the effect of each variance by selecting "F" for favorable, or "U" for unfavorable. If there is no effect, do not select either option. 38,930 14,860 9,510 $ 63,300 $ 51,950 46,800✔ 32,640 → 15,720 ✔ 7,440 7,800✔ $ 110,400 $ $ > Answer is complete but not entirely correct. NOTTINGHAM FOREST PRODUCTS Sales Activity Variance Flexible Master Budget Budget (based on actual of (based on budgeted 4,000 units) 4,800 units) $ 225,600 $ 225,600 F ✓ $ 188,000 39,000 27,200 13,100 110,400 6,200 6,500 $ 92,000 $ 96,000 115,200 $ 115,200 37,400✔ 12.200 10,400✔ 60,000 55,200 $ 55,200 37,400 12, 200 10,400 $ 60,000 $36,000 Sales Activity Variance 46,800 X U 32,640 X U 15,720 X U 7,440 X U 7,800 X U U F X 3333333 39,000 27,200 13,100 6,200 6,500 92,000 ✓ $ ✓$ 96,000 U X U X U X U X $ F ✓ $ 37,400 12,200 10,400 60,000 36,000
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps

Blurred answer
Knowledge Booster
Performance measurements
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education