Purchase Solution

Widget producer: Production Plan that minimizes cost using t

Not what you're looking for?

Ask Custom Question

Widget producer develops 4 month aggregate plan. Demand and capacity (in units) are forecast below

CAPACITY SOURCE Month 1 Month 2 Month 3 Month 4
Labor
Regular time 235 255 290 300
Overtime 20 24 26 24
Subcontract 12 15 15 17
Demand 255 294 321 301

The cost of producing each widget is $985 on regular time, $1310 on overtime, and $1500 subcontract. Carrying cost is $100 per unit per month. There is no beginning or ending inventory in stock and backorders are not permitted. Set up production plan that minimizes cost using transportation method.

Purchase this Solution
Solution Preview

Please see the attached file - you can see the set up in tools > solver

Capacity Labour Source Month 1 Month 2 Month 3 Month 4 Cost
Regular Time 235 255 290 300 $985.00
Over Time 20 24 26 24 $1,310.00
Subcontract 12 15 15 17 $1,500.00
Demand 255 294 321 301
Carrying Cost per unit per month $100.00

Decision Variables Month 1 Month 2 Month 3 Month 4
Regular Time 235.00 255.00 290.00 300.00
Over ...

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
MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Learning Lean

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

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Balance Sheet

The Fundamental Classified Balance Sheet. What to know to make it easy.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

View More Free Quizzes
Related BrainMass Solutions

  • Unconstrained Optimization: level of production that maximizes profits

    Assume that the marginal cost of producing each widget increases with the number of widgets that are produced. The formula is MC(Y) = Y2. For example, the marginal cost of producing the second widget is 4.

  • markets and resources

    Marginal revenue product is defined as the change in total revenue that results from the employment of an additional unit of a resource. A widget producer wishes to determine how the addition of pounds of rubber will affect its MRP and profits.

  • Aggregate planning for widget maker: chase plan with steady

    Try a chase plan by hiring and layoffs to meet forecast as necessary. b. use a plan that holds employment steady c. which is the more economical plan. Need to develop aggregate schedule for widget maker.

  • 5 Problems

    with monopoly production of Econosil and indicate this area on your graph.

  • C-V-P analysis : key informaiton

    b) Assume instead that Broomfield uses an ABC system, with three cost drivers: machine hours, materials handling, and setups.

  • Finding economical lot size, carrying and annual costs

    The process of widget production has been automated over the years, and it now costs $1,000 to change over the widget production line to other products which are made on the same line. a.

  • Fixed and Variable Costs for specialty widgets

    Unit FC= Fixed cost/Monthly Production =250000/10000 =$25 per unit Unit VC= Variable cost/Monthly Production =138000/10000 =$13.8 per unit Breakeven point= Fixed cost/(SP-VC) =250000/(79.95-13.8) =3780 units.

  • Solving Probability Theory Questions

    The production cost is 10,000 fixed cost plus 150 per unit Production cost = $10,000 +$150(100) = $25,900.00 Cost per unit when 100 units are sold = Charge per widget to make 10% profit = $2590.00(1.1) = $2849.00 The expert solves probability theory

  • Transshippment problem: LINDO 10

    The firm has to determine an optimal transshipment plan that minimizes total transportation cost while meeting the demands in each retail outlet and not exceeding the capacity at each production facility.

View More Related Solutions