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

### Click here to request for this assignment help

#Raffel #jeans #management #decides #units

#### Table of Contents

Calculate your order
Pages (275 words)
Standard price: \$0.00

### Latest Reviews

Impressed with the sample above? Wait there is more

Related Questions

### Firms have a finite amount of funds for expansion and growth. Entering foreign markets by definition means a firm is

Firms have a finite amount of funds for expansion and growth. Entering foreign markets, by definition, means a firm is investing money in another country

### Qualitative Research Project – SOC234 2021 Due: 3/9/21 Weighting: 40%

Qualitative Research Project – SOC234 2021 Due: 3/9/21 Weighting: 40% Length: 2,000 words For this project, students will be required to complete two components: Analysis

### Write a 1,000-1,250 word analysis in which you discuss retaining

Write a 1,000-1,250 word analysis in which you discuss retaining quality technical staff in organizations. Conduct research to discover some reasons why technical staff

### Abnormal Psychology Film Analysis

Guidelines for Film Analysis Paper: In addition to entertaining us, movies offer detailed portrayals of individual differences in human behavior. Your task in this assignment

### 1. Which strategy, First and Late-Mover, is better to use

1.  Which strategy, First and Late-Mover, is better to use for entering a new market? What is the difference between Vertical vs Horizontal Diversification Strategies

### TWO Part Assignment Part 1- Write 150-200 words, Use APA

TWO Part Assignment Part 1- Write 150-200 words, Use APA 6 formatting- I have attached two post from previous assignments that can be used to

### For this assignment, the following items will need to be

For this assignment, the following items will need to be prepared: A short summary of the organization you have selected for the project. Write a

### Rejection of blood transfusions by Jehovah’s witnesses.

Reli335: Essay 1: Public debates about religion Essay: write 1500 words Presentation: After finishing writing the essay please make sure to write up to 600

### Read the Strategic Management Project Background document attached  Review the resources

Read the Strategic Management Project Background document attached  Review the resources listed at the end of this assignment along with the terms and concepts

### Developing Employees through Performance Management

A development plan is a key component of a performance management plan because it guides performance improvement. Create a short-term development plan (1-2 years) and

### Offering three options for medical insurance went over so well

Offering three options for medical insurance went over so well with employees at Open Enrollment that you are considering offering more options next year through

### The article summary is a 250 words in length double-spaced

The article summary is a 250 words in length double-spaced (1 pages), summary of the 2 main viewpoints addressed in chapter 6 of the Wolff

New questions