# Raffel jeans management decides that the 16,000 units is most likely

Project 1 :

Following is a monthly given income statement for Raffel jeans, a small newly started fashion jeans manufacturer business. The pro forma analysis was prepared at the beginning of the month and considered three alternative sales levels. The company has no variable marketing costs.

 Income statement line item Budgeted amount per unit Pre-forma analysis for Alternative output levels 10,000 units 20,000 units 30,000 units Revenue \$35 \$350,000 \$700,000 \$1,050,000 Variable costs:   Material   Labor   Overhead   Total 13     8     5   26 130,000    80,000   50,000   260000 260,000   160,000   100,000   520,000 3,90,000   240,000   150,000   780,000 Contributing margin: \$10 100,000 200,000 300,000 Fixed costs:   Manufacturing   Overhead   Marketing cost   Total fixed cost   Operating income 100,000   50,000   150,000   (\$50,000) 100,000   50,000   150,000   \$50,000 100,000   50,000   150,000   \$150,000

Since by definition, fixed costs are not expected to change as volume of output changes within the relevant range, fixed costs remain the same at all three projected levels of output. Revenue and variable costs vary with output in a linear fashion. Hence, when output increases 100% from10,000 units to 20,000 units, revenue, each line-item for variable costs, and contribution marginal increase 100%

Raffel jeans management decides that the 16,000 units is most likely output volume, and sets the static budget based on this sale and production level

Using the above given data, prepare and compute in an Excel sheet using different tabs of the sheet for each one of the following calculations;

• Static budget for 10,000 units
• Actual result for 16,000 units
• Operating income
• Static budget variance
• Prepare flexible budget for end on the month
• Variation in operating income
• Actual results
• Flexible budget variance

You must attach the screen shot of the task performed and hand out a print out to the assessor.

#Raffel #jeans #management #decides #units

Pages (275 words)
Standard price: \$0.00

### Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

### -5 pages – writings main idea is Have we achieved

-5 pages – writings main idea is Have we achieved civil rights in America?  – need to summarize martin luther kings i have a dream

### For your assignment Identify the assigned topic as well as

For your assignment Identify the assigned topic as well as the title of the standard or process. State the description of the standard or

### Behavioural finance theory

Assessment Information   This assignment is designed to assess learning outcomes:  Apply behavioural finance theory in the provision of investment advice (ILO – 3)

### The Untethered Soul Paperback version: Read Chapters 12, 13, +

The Untethered Soul Paperback version: Read Chapters 12, 13, + 14 (pages 111-137) The Untethered Soul Online PDF/e-versions:  Read Chapters 12, 13, + 14

### 500-600 words, APA FORMAT 7TH EDITION Part I: Describe the

500-600 words, APA FORMAT 7TH EDITION Part I: Describe the Johari’s window and its importance in understanding communication. Support your reasoning with 2 scholarly references,

### Understanding the strategies that have been developed to address issues

Understanding the strategies that have been developed to address issues of trustworthiness is the first step. The second step is considering “how could I

### W7 Assignment Assignment “Key Performance Measures” Transportation Management W7 Assignment

W7 Assignment Assignment “Key Performance Measures” Transportation Management W7 Assignment In 4-5 pages, list and discuss: 1. What does the term private transportation mean?

### Safety Score Improvement Plan

Assessment #2 Preparation Refer to the Capella library and the Internet for supplemental resources to help you complete this assessment, a safety score improvement plan.

### Scenario You work as a director of leadership and learning

Scenario You work as a director of leadership and learning for an organization that makes prosthetics. This year’s employee engagement survey results for the organization

### Now that you have had the opportunity to complete the

Now that you have had the opportunity to complete the assigned readings for this module, relating to the Salem Witchcraft Trials, think about the four

### Before beginning this assignment, refer to read chapters 3 and

Before beginning this assignment, refer to read chapters 3 and 4 and go through the corresponding lectures in your Modules.   (This is the link

### This assignment is designed to develop information literacy skills through the research and analysis of relevant articles. Content Requirements Employer

This assignment is designed to develop information literacy skills through the research and analysis of relevant articles.Content RequirementsEmployer Branding, the Use of Social Media as

New questions