Prepare a sales activity variance analysis for Osage, Inc. (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.) OSAGE, INC. Sales Activity Variance Flexible Budget Sales Activity Variance Master Budget Sales revenue Variable costs: Materials Direct labor Variable overhead Variable marketing and administrative Total variable costs Contribution margin Fixed costs: Manufacturing overhead Marketing Administrative Total fixed costs Operating profits

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

Hello question is attached, thanks. 

**Sales Activity Variance Analysis for Osage, Inc.**

**Objective:**
Prepare a sales activity variance analysis for Osage, Inc., indicating the effect of each variance by selecting "F" for favorable, or "U" for unfavorable. If there is no effect, do not select either option.

---

**OSAGE, INC.**

**Sales Activity Variance**

| Line Item                               | Flexible Budget | Sales Activity Variance | Master Budget |
|-----------------------------------------|-----------------|-------------------------|---------------|
| **Sales revenue**                        |                 |                         |               |
| **Variable costs:**                      |                 |                         |               |
| - Materials                             |                 |                         |               |
| - Direct labor                          |                 |                         |               |
| - Variable overhead                     |                 |                         |               |
| - Variable marketing and administrative |                 |                         |               |
| **Total variable costs**                 |                 |                         |               |
| **Contribution margin**                  |                 |                         |               |
| **Fixed costs:**                         |                 |                         |               |
| - Manufacturing overhead                |                 |                         |               |
| - Marketing                             |                 |                         |               |
| - Administrative                        |                 |                         |               |
| **Total fixed costs**                    |                 |                         |               |
| **Operating profits**                    |                 |                         |               |

---

**Note:**
- Complete the table by calculating each category's variance between the flexible budget and the master budget.
- Evaluate whether each variance is favorable (F) or unfavorable (U). Leave the column blank if there is no variance.
- This analysis helps assess performance by comparing planned versus actual sales activities.
Transcribed Image Text:**Sales Activity Variance Analysis for Osage, Inc.** **Objective:** Prepare a sales activity variance analysis for Osage, Inc., indicating the effect of each variance by selecting "F" for favorable, or "U" for unfavorable. If there is no effect, do not select either option. --- **OSAGE, INC.** **Sales Activity Variance** | Line Item | Flexible Budget | Sales Activity Variance | Master Budget | |-----------------------------------------|-----------------|-------------------------|---------------| | **Sales revenue** | | | | | **Variable costs:** | | | | | - Materials | | | | | - Direct labor | | | | | - Variable overhead | | | | | - Variable marketing and administrative | | | | | **Total variable costs** | | | | | **Contribution margin** | | | | | **Fixed costs:** | | | | | - Manufacturing overhead | | | | | - Marketing | | | | | - Administrative | | | | | **Total fixed costs** | | | | | **Operating profits** | | | | --- **Note:** - Complete the table by calculating each category's variance between the flexible budget and the master budget. - Evaluate whether each variance is favorable (F) or unfavorable (U). Leave the column blank if there is no variance. - This analysis helps assess performance by comparing planned versus actual sales activities.
**Osage, Inc. Manufacturing and Sales Budget Analysis**

Osage, Inc. manufactures and sells lamps. The company operates on a made-to-order basis and does not hold inventory. Below is the detailed financial performance for the current month, comparing actual figures against the master budget.

---

### Financial Overview

**Actual (450,000 units) vs. Master Budget (480,000 units)**

- **Sales Revenue**
  - Actual: $4,968,000
  - Budget: $4,800,000

**Expenses**

- **Variable Costs**
  - **Materials**
    - Actual: $1,440,000
    - Budget: $1,440,000
  - **Direct Labor**
    - Actual: $276,000
    - Budget: $336,000
  - **Variable Overhead**
    - Actual: $674,400
    - Budget: $624,000
  - **Variable Marketing and Administrative**
    - Actual: $468,000
    - Budget: $480,000
  - **Total Variable Costs**
    - Actual: $2,858,400
    - Budget: $2,880,000

- **Contribution Margin**
  - Actual: $2,109,600
  - Budget: $1,920,000

- **Fixed Costs**
  - **Manufacturing Overhead**
    - Actual: $988,800
    - Budget: $960,000
  - **Marketing**
    - Actual: $288,000
    - Budget: $288,000
  - **Administrative**
    - Actual: $204,000
    - Budget: $180,000
  - **Total Fixed Costs**
    - Actual: $1,480,800
    - Budget: $1,428,000

- **Operating Profits**
  - Actual: $628,800
  - Budget: $492,000

**Analysis:**
The actual sales revenue exceeded the budget despite fewer units being sold. While fixed costs were higher than projected, the operating profits were better than anticipated due to efficient management of variable costs and a higher contribution margin.
Transcribed Image Text:**Osage, Inc. Manufacturing and Sales Budget Analysis** Osage, Inc. manufactures and sells lamps. The company operates on a made-to-order basis and does not hold inventory. Below is the detailed financial performance for the current month, comparing actual figures against the master budget. --- ### Financial Overview **Actual (450,000 units) vs. Master Budget (480,000 units)** - **Sales Revenue** - Actual: $4,968,000 - Budget: $4,800,000 **Expenses** - **Variable Costs** - **Materials** - Actual: $1,440,000 - Budget: $1,440,000 - **Direct Labor** - Actual: $276,000 - Budget: $336,000 - **Variable Overhead** - Actual: $674,400 - Budget: $624,000 - **Variable Marketing and Administrative** - Actual: $468,000 - Budget: $480,000 - **Total Variable Costs** - Actual: $2,858,400 - Budget: $2,880,000 - **Contribution Margin** - Actual: $2,109,600 - Budget: $1,920,000 - **Fixed Costs** - **Manufacturing Overhead** - Actual: $988,800 - Budget: $960,000 - **Marketing** - Actual: $288,000 - Budget: $288,000 - **Administrative** - Actual: $204,000 - Budget: $180,000 - **Total Fixed Costs** - Actual: $1,480,800 - Budget: $1,428,000 - **Operating Profits** - Actual: $628,800 - Budget: $492,000 **Analysis:** The actual sales revenue exceeded the budget despite fewer units being sold. While fixed costs were higher than projected, the operating profits were better than anticipated due to efficient management of variable costs and a higher contribution margin.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Initial Public Offering (IPO)
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