Question

Today, your paint line must produce 6250 gallons of beige paint. Your four step manufacturing process...

Today, your paint line must produce 6250 gallons of beige paint. Your four step manufacturing process has the following scrap rates for the corresponding step:

Step 1: 0.4%

Step 2: 1.4%

Step 3: 2.3%

Step 4: 1.3%

How many gallons of paint must you start with to have 6250 gallons of point that can be sold?

(Keep one decimal point in your answer)

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Answer: we need to input 6599.8 gallons

Explanation:

44 B C D E F G
45 Scrap rates 0.40% 1.40% 2.30% 1.30%
46 Input step-1 step-2 step-3 step-4 Output
47 6599.8 6599.8 6573.4 6481.4 6332.3 6250

Excel formula

44 B C D E F G
45 Scrap rates 0.004 0.014 0.023 0.013
46 Input step-1 step-2 step-3 step-4 Output
47 =C47 =D47/(1-C45) =E47/(1-D45) =F47/(1-E45) =G47/(1-F45) 6250
Add a comment
Know the answer?
Add Answer to:
Today, your paint line must produce 6250 gallons of beige paint. Your four step manufacturing process...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Your daughter's high school Introduction to Engineering class includes a week-long exposure to an oil refractory....

    Your daughter's high school Introduction to Engineering class includes a week-long exposure to an oil refractory. The model facility built by the teacher involves 6 steps, and it's obvious that most of the steps have significant leakage. If the teacher wants to have 100 ounces of product when the process is complete, how many ounces of ingredients must they begin with? The process has the following scrap rates for the corresponding step: Step 1: 2.8% Step 2: 0.8% Step 3:...

  • One-Variable Data Table Your maximum weekly production capability is 200 gallons. You would like to create...

    One-Variable Data Table Your maximum weekly production capability is 200 gallons. You would like to create a one-variable data table to measure the impact of Production Cost, Gross Profit, and Net Profit based on selling between 10 and 200 gallons of paint within a week. a. Start in cell E3. Complete the series of substitution values ranging from 10 to 200 at increments of 10 gallons vertically down column E. b. Enter references to the Total Production Cost, Gross Profit,...

  • One year ago, your company purchased a machine used in manufacturing for $110,000. You have learned...

    One year ago, your company purchased a machine used in manufacturing for $110,000. You have learned that a new machine is available that offers many advantages, you can purchase it for $150,000 today. It will be depreciated on a straight line basis over ten years, after which it has no salvage value. You expect that the new machine will contribute EBITDA (earnings before interest, taxes depreciation, and amortization) of $40,000 per year for the next ten years. The current machine...

  • The ACME Manufacturing Company has hired you to help automate their production assembly line. Cameras have...

    The ACME Manufacturing Company has hired you to help automate their production assembly line. Cameras have been placed above a conveyer belt to enables parts on the belt to be photographed and analyzed. You are to augment the system that has been put in place by writing C code to detect the number of parts on the belt, and the positions of each object. The process by which you will do this is called Connected Component Labeling (CCL). These positions...

  • Your Assignment ·     You are an outside consulting organization who has been retained by the CEO to...

    Your Assignment ·     You are an outside consulting organization who has been retained by the CEO to fix the problems and make sure the mandate is driven throughout the organization. identify what strategic initiatives and changes you will recommend and the tactics to implement those strategies and changes based on this case study New Product Development Process Improvement Case Study Background:          Horizon Giftables, Inc. is a 35-year-old consumer products company that manufactures and distributes home accessory products and décor items through...

  • Zara Organizational Structure Structure relates to a skeletal framework of activities and process...

    Zara Organizational Structure Structure relates to a skeletal framework of activities and processes in an organisation and specifies the roles of these in achieving goals and objectives of the organisation. According to (Mullins, 2009), a good structure is highly important due to the fact that decisions on structure are primary strategic decisions which can make or break an organisation. One important aspect of a good structure is the human element. Organisation structure should be designed so as to encourage employees...

  • Activity-Based Costing, Distorted Product Costs Sharp Paper Inc. has three paper mills, one of which is...

    Activity-Based Costing, Distorted Product Costs Sharp Paper Inc. has three paper mills, one of which is located in Memphis, Tennessee. The Memphis mill produces 300 different types of coated and uncoated specialty printing papers. Management was convinced that the value of the large variety of products more than offset the extra costs of the increased complexity. During 20X1, the Memphis mill produced 120,000 tons of coated paper and 80,000 tons of uncoated paper. Of the 200,000 tons produced, 180,000 were...

  • Code is in C# Your instructor would like to thank to Marty Stepp and Hélène Martin...

    Code is in C# Your instructor would like to thank to Marty Stepp and Hélène Martin at the University of Washington, Seattle, who originally wrote this assignment (for their CSE 142, in Java) This program focuses on classes and objects. Turn in two files named Birthday.cs and Date.cs. You will also need the support file Date.dll; it is contained in the starter project for this assignment. The assignment has two parts: a client program that uses Date objects, and a...

  • Please read the article and answer about questions. You and the Law Business and law are...

    Please read the article and answer about questions. You and the Law Business and law are inseparable. For B-Money, the two predictably merged when he was negotiat- ing a deal for his tracks. At other times, the merger is unpredictable, like when your business faces an unexpected auto accident, product recall, or government regulation change. In either type of situation, when business owners know the law, they can better protect themselves and sometimes even avoid the problems completely. This chapter...

  • SYNOPSIS The product manager for coffee development at Kraft Canada must decide whether to introduce the...

    SYNOPSIS The product manager for coffee development at Kraft Canada must decide whether to introduce the company's new line of single-serve coffee pods or to await results from the product's launch in the United States. Key strategic decisions include choosing the target market to focus on and determining the value proposition to emphasize. Important questions are also raised in regard to how the new product should be branded, the flavors to offer, whether Kraft should use traditional distribution channels or...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT