Nottingham Forest Products reports the following information concerning operations for the most recent month: Master Budget (based on budgeted sales of 4,075 units) $191,525 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. Actual (based on actual sales of 4,890 units) $233,200 50,332 31,550 16,638 7,835 7,245 $ 113,600 $ 119,600 38,975 14,890 9,555 $ 63,420 $ 56,180 39,030 27,230 13,130 6,230 6,530 $ 92,150 $ 99,375 37,430 12,230 10,430 $ 60,090 $ 39,28 Required: Prepare a sales activity variance analysis for Nottingham Forest Products. Note: Do not round intermediate calculations Indic

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
100%
Nottingham Forest Products reports the following information concerning operations for the most recent month: Master Budget Actual (based (based on on actual sales budgeted sales of 4,890 units) of 4,075 units) Sales revenue $ 233,200 $ 191,525 Less Manufacturing costs Direct labor Materials Variable overhead Marketing Administrative Total variable costs Contribution margin 50,332 31,550 16,638 7,835 7,245 $ 113,600 $ 119,600 39,030 27,230 13,130 6,230 6,530 $ 92,150 $ 99,375 Fixed costs Manufacturing Marketing Administrative Total fixed costs Operating profits 38,975 14,890 9,555 $ 63,420 $ 56,180 37,430 12,230 10,430 $ 60,090 $ 39,285 There are no inventories. 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.
**Nottingham Forest Products Operational Report**

Nottingham Forest Products reports the following information concerning operations for the most recent month:

| Description                  | Actual (based on actual sales of 4,890 units) | Master Budget (based on budgeted sales of 4,075 units) |
|------------------------------|-----------------------------------------------|--------------------------------------------------------|
| **Sales Revenue**            | $233,200                                      | $191,525                                               |
| Less:                       |                                               |                                                        |
| - Manufacturing Costs       |                                               |                                                        |
|   - Direct Labor             | 50,332                                        | 39,030                                                 |
|   - Materials                | 31,550                                        | 27,230                                                 |
|   - Variable Overhead       | 16,638                                        | 13,130                                                 |
|   - Marketing               | 7,835                                         | 6,230                                                  |
|   - Administrative          | 7,245                                         | 6,530                                                  |
| **Total Variable Costs**     | $113,600                                      | $92,150                                                |
| **Contribution Margin**      | $119,600                                      | $99,375                                                |
| - Fixed Costs               |                                               |                                                        |
|   - Manufacturing            | 38,975                                        | 37,430                                                 |
|   - Marketing               | 14,890                                        | 12,230                                                 |
|   - Administrative          | 9,555                                         | 10,430                                                 |
| **Total Fixed Costs**        | $63,420                                       | $60,090                                                |
| **Operating Profits**        | $56,180                                       | $39,285                                                |

**Note:** There are no inventories.

**Required:**

Prepare a sales activity variance analysis for Nottingham Forest Products.

**Instructions:**  
- 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.

**Graphs/Diagrams:**

There are no graphs or diagrams in this report. Each section is presented in a table format for clarity and comparison.
Transcribed Image Text:**Nottingham Forest Products Operational Report** Nottingham Forest Products reports the following information concerning operations for the most recent month: | Description | Actual (based on actual sales of 4,890 units) | Master Budget (based on budgeted sales of 4,075 units) | |------------------------------|-----------------------------------------------|--------------------------------------------------------| | **Sales Revenue** | $233,200 | $191,525 | | Less: | | | | - Manufacturing Costs | | | | - Direct Labor | 50,332 | 39,030 | | - Materials | 31,550 | 27,230 | | - Variable Overhead | 16,638 | 13,130 | | - Marketing | 7,835 | 6,230 | | - Administrative | 7,245 | 6,530 | | **Total Variable Costs** | $113,600 | $92,150 | | **Contribution Margin** | $119,600 | $99,375 | | - Fixed Costs | | | | - Manufacturing | 38,975 | 37,430 | | - Marketing | 14,890 | 12,230 | | - Administrative | 9,555 | 10,430 | | **Total Fixed Costs** | $63,420 | $60,090 | | **Operating Profits** | $56,180 | $39,285 | **Note:** There are no inventories. **Required:** Prepare a sales activity variance analysis for Nottingham Forest Products. **Instructions:** - 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. **Graphs/Diagrams:** There are no graphs or diagrams in this report. Each section is presented in a table format for clarity and comparison.
**Sales Activity Variance Analysis for Nottingham Forest Products**

**Objective:**
To prepare a sales activity variance analysis for Nottingham Forest Products by comparing the flexible budget with the master budget.

---

**Table Overview:**

This table consists of several columns including:

- **Flexible Budget (based on actual of 4,890 units)**
- **Sales Activity Variance**
- **Master Budget (based on a budgeted 4,075 units)**

---

**Sales Revenue:**
- Master Budget: $191,525

**Variable Costs:**

1. **Manufacturing Costs:**
   - Direct Labor
   - Materials
   - Variable Overhead
   - Marketing
   - Administrative
   - Total variable costs: $92,150

**Contribution Margin:**
- $99,375

**Fixed Costs:**

1. **Manufacturing:**
   - **Manufacturing:** $37,430
   - **Marketing:** $12,230
   - **Administrative:** $10,430
   - **Total Fixed Costs:** $60,090

**Operating Profits:**
- $39,285

---

**Instructions:**

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

This analysis helps identify the difference in performance due to actual sales activity deviating from planned activity levels.
Transcribed Image Text:**Sales Activity Variance Analysis for Nottingham Forest Products** **Objective:** To prepare a sales activity variance analysis for Nottingham Forest Products by comparing the flexible budget with the master budget. --- **Table Overview:** This table consists of several columns including: - **Flexible Budget (based on actual of 4,890 units)** - **Sales Activity Variance** - **Master Budget (based on a budgeted 4,075 units)** --- **Sales Revenue:** - Master Budget: $191,525 **Variable Costs:** 1. **Manufacturing Costs:** - Direct Labor - Materials - Variable Overhead - Marketing - Administrative - Total variable costs: $92,150 **Contribution Margin:** - $99,375 **Fixed Costs:** 1. **Manufacturing:** - **Manufacturing:** $37,430 - **Marketing:** $12,230 - **Administrative:** $10,430 - **Total Fixed Costs:** $60,090 **Operating Profits:** - $39,285 --- **Instructions:** - 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. This analysis helps identify the difference in performance due to actual sales activity deviating from planned activity levels.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

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.
Similar questions
  • SEE MORE QUESTIONS
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