Need help? We are here

# 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

### Case Report: Application of Theory

Case Report: Application of Theory In this assignment, learners are required to write a case report addressing the personal knowledge and skills gained in this

### Purpose The purpose of this assignment is to provide an analysis

Purpose The purpose of this assignment is to provide an analysis and synthesis-level evaluation of the factors that influence both contemporary advanced practice nursing

### Reflection post 500 words APA 7th edition 3 references within

Reflection post  500 words APA 7th edition 3 references within 5 years Discuss the application of Middle Range Theories and Nursing Practice and Reflect on

### My website is closed to the launch date, but I

My website is closed to the launch date, but I am not a native American so I need a proofreading service(I will pay more if

### Pinch Egyptian Mythology

G. Pinch, Egyptian Mythology Please bring to class a one-page, TYPED abullet-point list of the main points of every reading. The list does not need

### Health provider in your local community.

The benchmark assesses the following competency: 4.2 Communicate therapeutically with patients. The RN to BSN program at Grand Canyon University meets the requirements for clinical

### Police Brutality In New York City

Police brutaly Research paper! it must be based in New York City History, Suggested sources- New York times and New York City Council and independent

### Prior to beginning the assignment, review Chapters 4 and 5

Prior to beginning the assignment, review Chapters 4 and 5 in your textbook, where risk factors for criminal behavior are covered from a biological, developmental,

### The assignment is to answer the question provided above in

The assignment is to answer the question provided above in essay form. This is to be in narrative form. Bullet points should not to be

### I have a three hundred proposal that is due for The Mouth Diaries this Friday. I need to present the

I have a three hundred proposal that is due for The Mouth Diaries this Friday. I need to present the basic ideas and why this

### Elements of a Contract Suppose that the Fabulous Hotel hires

Elements of a Contract Suppose that the Fabulous Hotel hires you as head chef under a two-year employment contract. After two years, another hotel wants