Purchase Solution

Creating a schedule for orders

Not what you're looking for?

Ask Custom Question

Wooden pencils are made in 1 week out of four kinds of parts: two wooden halves, the graphite, the metal cap, and the rubber eraser. Construct an MRP explosion for orders of 10 dozen in week 2, 30 dozen in week 3, and 15 dozen in week 5. There are currently 500 wooden halves on hand, 300 graphic rods, and 1500 metal caps, but no rubber erasers. All items are purchased with a 1-week lead time except the graphite, which takes 2 weeks. Create a schedule of releases for the wooden halves and graphite. Use lot-for-lot sizing.

Purchase this Solution
Solution Summary

This solution creates a schedule of releases for the wooden halves and graphite using lot-for-lot sizing in an Excel file.

Solution provided by:
Gaurav Agarwal, MS
Education
  • BE, Bangalore University, India
  • MS, University of Wisconsin-Madison
Recent Feedback
  • "Your explanation to the answers were very helpful."
  • "What does 1 and 0 means in the repair column?"
  • "Went through all of the formulas, excellent work! This really helped me!"
  • "try others as well please"
  • "Thank you, this helped a lot. I was not sure how to plug in those numbers to a formula. This was a great help. Now I have to figure out how to explain cost of capital is used in net present value analysis, and how cost of capital is used in net present value analysis. This stuff gets confusing."
Purchase this Solution
Free BrainMass Quizzes
Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Writing Business Plans

This quiz will test your understanding of how to write good business plans, the usual components of a good plan, purposes, terms, and writing style tips.

Production and cost theory

Understanding production and cost phenomena will permit firms to make wise decisions concerning output volume.

Lean your Process

This quiz will help you understand the basic concepts of Lean.

View More Free Quizzes
Related BrainMass Solutions

  • Restructuring Channels of Distribution

    Immediately after the broadcast, orders came flooding in, overwhelming your small-batch production schedule and your limited distribution system. The company's shipping manager thinks she can handle it, but you disagree.

  • FCFS, SPT and EDD rules.

    inventory(in orders) and the average total inventory( in orders) for each schedule are also given .

  • Explain how traditional cost systems distort costs

    So, one cost driver will not do a good job representing the overhead resources consumed for either product line. ------------------------ Your tutorial is 107 words plus a schedule of overhead activity to show how disproportionate use of resources

  • Linear Programming Model for Optimal Production Schedule

    Production line 2 is activated only when demand is high and/or when large orders cannot be met by the capacity of line 1 alone in a timely manner.

  • Transportation problem

    One sheet is titled "info ahead of schedule" and the other is titled "info in September", if the information arrives half way through the schedule. This shows how to create a production schedule for a transportation problem with changing information.

  • Performance and Creating a Performance Rating System

    601400 Performance and Creating a Performance Rating System Laura Schulz has operated Laura's Sweet Stuff Bakery for the past 5 years.

  • Supply Chain/Value Stream Map

    The following are the process steps for the subassembly area: 1.Orders from main assembly area are received at 8:00 a.m. 2.Subassembly supervisors translate orders into a subassembly area schedule (2 hours). 3.After creating the schedule, components

  • Identify 3 potential Six Sigma projects relate dto a logistics company

    Total cost: $29,000.00 Projected Savings: An increase of 10 orders per week, and $1,250.00 in revenues, plus increasing re-order to 25% of weekly orders creating an additional $1562.50 in re-order revenues for a total of $2776.50 per week.

  • Banner: contribution margin per unit of constrained resource

    Which orders would you recommend that the company work on next week-the orders for product A, product B, or product C? Product A Product B Product C 3.

View More Related Solutions