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

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Part I: A new client has come into the office

Part I: A new client has come into the office and is very upset. Alex Smith recently purchased a freezer from Star-Rent-to-Own. Alex thinks he may have been the recipient of a bad contract. Six months ago, Alex and Sandra Smith signed an agreement with Star Rent-to-Own to purchase a

Urbanization: Describe three pros and three cons for urbanization

This essay should be 2-4 pages double-spaced, Times New Roman 12 pt. Font Define urbanization. Describe three pros and three cons for urbanization and include examples. Pick one form of urbanization and describe how that form of urbanization can impact an individual’s health status. Pick a health issue of your

Flannery O’Connor was a deeply religious practicing Catholic. Discuss

 O’Connor was a deeply religious practicing Catholic. Discuss the religious nature of the themes in “The Life You Save May Be Your Own.” This post must contain a direct reference to the text and be supported by research that comes from a peer-reviewed source. Place the citation at the end

Search Yahoo Finance

Description Search Yahoo Finance or/and any other credible source(s) to find the most recent income statement and balance sheet of a major corporation located in your home country. – Provide these statements in the appropriate format (financial statement) – Perform a vertical analysis and comment on your finding. – Perform

Locate a website presenting any code of ethics, code of

  Locate a website presenting any code of ethics, code of professional conduct, or similarly documented guidance for an accounting, auditing, or professional oversight organization. Possibilities include the American Institute of Certified Public Accountants (AICPA), the National Association of State Boards of Accountancy (NASBA), the Association of Certified Fraud Examiners

1. The Constitution grants many different powers to the president.

1. The Constitution grants many different powers to the president. First, explain the difference between the expressed, implied, inherent, and delegated powers of the presidency.  Next, considering only the expressed powers, which two powers do you think are most essential to a successful presidency?  In other words, if you were

I am in search of someone that understands this type

I am in search of someone that understands this type of assignment,  (Wk 5 The Role of Poster Sessions in Scholarly Engagement ) Please be honest and professional, if there isn’t someone that could assist. I’m not up for paying for help and not receiving the correct response. Thank you

Write a 1,400- to 2,100-word Project Implementation Plan for the

  Write a 1,400- to 2,100-word Project Implementation Plan for the project your Learning Team selected in Wk 2. This will also be used for the final implementation plan for the Project Selection Paper assignment. Part 1 of the plan must include the following sections: Human Resources Plan: This plan should include

Topic: Agency Synopsis PowerPoint Presentation You will create a grid

  Topic:   Agency Synopsis PowerPoint Presentation You will create a grid listing 5 regulatory agencies that regulate health and the health care system within the United States. You will answer the following based on the 5 regulatory agencies:   Describe the agency, level of regulatory authority (local, state, federal,), scope of

The professional, ethical, legal and social considerations of

ask 4 Your final task is to advise the board of this case study on the professional, ethical, legal and social considerations of implementing and using MIS platforms, or indeed, of any IT system. To this end, conduct appropriate research – fully referenced using the Harvard system – and summarize

Alice Randall wrote an article for The New York Times

 Alice Randall wrote an article for The New York Times on the cultural factors that encouraged black women to maintain weight above what is considered healthy.  Randall’s statement sparked a great deal of controversy and debate; however, they emphasize an underlying reality in the healthcare field: different populations, cultures, and groups have

Introduction “Entrepreneurs must determine what to sell, to whom and

  Introduction  “Entrepreneurs must determine what to sell, to whom and how often, on what terms and at what price, and how to get the product or service to the customer. In short, a marketing plan identifies a company’s target customers and describes how it will attract and keep them.

Resources: Pastas R Us, Inc. Database & Microsoft Excel®, Wk

Last year, the marketing department rolled out a Loyalty Card strategy to increase sales. Under this program, customers present their Loyalty Card when paying for their orders and receive some free food after making 10 purchases. The company has collected data from its 74 restaurants to track important variables such

One of the areas of concern to Mr. Magone and

One of the areas of concern to Mr. Magone and the senior leadership of Healing Hands Hospital is the integration and adoption of information technology and systems that would be needed if the hospital consolidated with a large health system or added more outpatient services or expanded into telemedicine. As a member

Define public health nursing. Discuss the following three core functions

 Define public health nursing. Discuss the following three core functions of the public health nurse: assessment, policy development and assurance. Explain how population-focused nursing practice is different from clinical nursing care delivered in the community. Include a minimum of 250-300 words and two professional references, one of which, may be Stanhope.