• 100% Satisfaction Guarantee

Ryan, Engineer
Category: Math Homework
Satisfied Customers: 8613
Experience:  B.S. in Civil Engineering
40260889
Type Your Math Homework Question Here...
Ryan is online now

# Production Planning. The Bogard Corporation produces three

### Resolved Question:

Production Planning. The Bogard Corporation produces three types of bookcases, which it sells to large office supply companies. The production of each bookcase requires two machine operations, trimming and shaping, followed by assembly, which includes inspection and packaging. All three types require 0.4 hours of assembly time, but the machining operations have different processing times, as shown below, in hours per unit:

Standard        Narrow      Wide

Trimmer              0.2                    0.4            0.6

Shaper                0.6                    0.2            0.5

Each machine is available 150 hours per month, and the current size of the assembly department provides capacity of 600 hours. Each bookcase produced yields a unit profit contribution as follows:                                       Standard            Narrow        Wide

Profit                     \$8                      \$6              \$10 .

What are the optimal production quantities for the company? What is the pattern in the optimal allocation?

Question #2:

1. Fertilizing the Lawn. The facilities manager at Oxbridge University is planning to apply fertilizer to the grass in the quadrangle area in the spring. The grass needs nitrogen, phosphorus, and potash in at least the amounts given in the following table.

MineralMinimum Weight (lb)
Nitrogen12
Phosphorus14
Potash18

Three kinds of commercial fertilizer are available, with mineral content and prices per 1,000 pounds as given in the following table. There is virtually unlimited supply of each kind of fertilizer.

FertilizerNitrogen Content (lb)Phosphorus Content (lb)Potash Content (lb)Price (\$)
A2010510
B105158
C151057

How much of each fertilizer should be purchased to satisfy the requirements at minimum cost?

If this can be completed by Thursday morning that is great......I seems a bit lengthy, but maybe easier than it looks as well.  If the price is too low we can work out a deal on the bonus, please let me know...

Thanks,

Misty :)

Submitted: 2 years ago.
Category: Math Homework
Expert:  Ryan replied 2 years ago.
Hi,

Thank you for the new request, and thank you for the high rating and bonus on the previous question.

I can help you with this problem, but I need a little bit of information from you. There are a few different ways of approaching this problem. Since I'm not in your class, I don't know what has been covered, which makes it difficult to select a method that is appropriate for your course.

What have you covered in your course regarding these types of problems?

Thanks,

Ryan
Customer: replied 2 years ago.

HI Ryan,

We are just now covering this chapter....so far we have covered Linear and non-linear optimization the basics from the previous chapter....this begins chapter 11 with allocation models, covering models and blending models. Really the basics for Excel modeling. The following is a link to the online chapter......http://my.safaribooksonline.com/book/management/9780470530672/linear-optimization/linear_optimization

Thanks,

Misty :)

Expert:  Ryan replied 2 years ago.
Hi Misty,

Ok, then. It would seem that your course feels that using Excel's Solver is appropriate. That spares us the tedious, gritty details of a matrix solution.

I'll write up an explanation of how the constraints and objective functions are obtained, and include a screenshot of the Excel Solver solution. If you want it, I can also post the Excel file itself.

I expect to have this posted for you later today, or tomorrow morning. Well before your Thursday deadline in any case.

Thanks,

Ryan
Customer: replied 2 years ago.

Thanks Ryan...and the Excel file is greatly appreciated!

Have a wonderful day:)

Misty

Expert:  Ryan replied 2 years ago.
Hi Misty,

Ok, I'll include that too.

Hope you have a great day too!

Regards,

Ryan
Expert:  Ryan replied 2 years ago.
Hi Misty,

Here are the solutions:

OptimizationProblems(Word)

OptimizationProblems(Excel)

Note: There are two sheets in the Excel file. Each problem is on its own worksheet. I wanted to combine them on one sheet, but doing so would have caused problems with the Solver application.

Thanks,

Ryan
Ryan, Engineer
Category: Math Homework
Satisfied Customers: 8613
Experience: B.S. in Civil Engineering

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

### What Customers are Saying:

• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
< Previous | Next >
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
• Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland
• He answered my question promptly and gave me accurate, detailed information. If all of your experts are half as good, you have a great thing going here. Diane Dallas, TX

• ### Mr. Gregory White

#### Satisfied Customers:

91
M.A., M.S. Education / Educational Administration
< Last | Next >

### Mr. Gregory White

#### Satisfied Customers:

91
M.A., M.S. Education / Educational Administration

### JACUSTOMER-yrynbdjl-

#### Satisfied Customers:

49
I have taught college Mathematics for the past 10 years.

### SusanAthena

#### Satisfied Customers:

41
Tutor for Algebra, Geometry, Statistics. Explaining math in plain English.

### Dr Arthur Rubin

#### Satisfied Customers:

37
Ph.D. in Mathematics, California Institute of Technology

### mhasan420

#### Satisfied Customers:

29
BA Maths, Oxford

### Don

#### Satisfied Customers:

17
M.S. Astronautical Engineering. Math/Science/Comp Tutor