# 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

Hello tutor, this question is very detailed, please read the attached file to understand. there are different parts/sections for this question. please read clearly. I

### House Bill Proposes National Nurse

House Bill Proposes national Nurse; Do we need one? As we explore Federal and State law and its relationship to Advanced Practice Nursing, we need

### FRAUD CASEBOOK Oil-for-Food Read the following articles or other related

FRAUD CASEBOOK Oil-for-Food Read the following articles or other related articles regarding the Oil-for-Food case and then answer the questions below: Sources: Windrem, Bob, “Korean

### Instructions For this assignment, you will search the CSU Online Library

Instructions For this assignment, you will search the CSU Online Library for an article that addresses how terminating the employer-employee relationship can be one

### 1. Compare the IoT with the regular Internet. 2. Discuss

1. Compare the IoT with the regular Internet. 2. Discuss the potential impact of autonomous vehicles on our lives. 3. Why must a truly smart

### Whether you are a new or veteran user of this

Whether you are a new or veteran user of this popular instant messaging app, you probably want to know how to download the latest version.

### Using the MLB steroids case as an example, explain how

Using the MLB steroids case as an example, explain how unethical choices by some players harms players who comply with the rules. Primary/Initial post to

### Scenario 4: You are a sales representative for a company

Scenario 4: You are a sales representative for a company that encourages staff to log time in the field and away from the office.

### Submit a meaningful reply of 400-450 words to the below

Submit a meaningful reply of 400-450 words to the below post.  Demonstrate analysis, and synthesis of all course materials, tact, and insight. For each reply,

### After reading the stories combine or select one of the

After reading the stories combine or select one of the items below to answer. Word count: 350-400 What similarities do you see among the stories?

### Instructions First, familiarize yourself with Doane Unviersity’s Student Rights and

Instructions First, familiarize yourself with Doane Unviersity’s Student Rights and Responsibilities Policy on Academic Integrity (Links to an external site.).  http://catalog.doane.edu/content.php?catoid=2&navoid=149 This policy can also

New questions