# 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

### Step 1 – Read the Information Below Organizational behavior is the

Step 1 – Read the Information Below Organizational behavior is the combination of four areas of study—psychology, social psychology, sociology, and anthropology. While each of

### Lewis Discuss how telehealth can assist to address equality of

Lewis Discuss how telehealth can assist to address equality of health care resource distribution. What barriers must be removed to achieve well-being, sufficiency, and health

### The presentation should introduce the main arguments of the text and briefly explain the historical background. The length of the

The presentation should introduce the main arguments of the text and briefly explain the historical background. The length of the presentation should be approx. 1

### The contemporary relevance of the US Constitution.

The US Constitution was written in 1787, well over 200 years ago. Despite its age, it is clear that the Constitution has a profound impact

### TOPIC: Benchmark – Marketing Plan Analysis and Presentation: Part 1-

TOPIC: Benchmark – Marketing Plan Analysis and Presentation: Part 1- Research Assessment Description Please use the attached Research Template to complete this assignment. The purpose

### Dress Code Laws in education

Part I: Providing Context Compose 1-2 paragraphs in which you do the following: • Identify and explain the problem or issue that drives your inquiry;

### Type 2 Diabetes Mellitus       Diabetes mellitus (DM) is

Type 2 Diabetes Mellitus       Diabetes mellitus (DM) is a common chronic disease that brings burden on health care systems worldwide and

### you should have at least five paragraphs for each question.

you should have at least five paragraphs for each question. The first five questions refer to the following scenario regarding Ken Allen at Bally Gears.

### Refer to the “Population-Focused Nurse Practitioner Competencies” found in the

Refer to the “Population-Focused Nurse Practitioner Competencies” found in the Week 1 Learning Resources and consider the quality measures or indicators advanced nursing practice

### critically analyze the benefits and limitations of ratio analysis, explaining

critically analyze the benefits and limitations of ratio analysis, explaining what factors impact the meaningfulness of such measures and what new practices or theories

### choose a health care statistic that health care managers would

choose a health care statistic that health care managers would use, such as one of the following: Hospital-acquired condition (HAC) Emergency department visits Labor and

### We know that the quantitative analysis approach includes a high

We know that the quantitative analysis approach includes a high level overview of the importance of identifying the problem, developing a model, acquiring input

New questions