# Thread: graphing (excel 2003)

1. ## graphing (excel 2003)

Note to admins: At first glance, this probably seems like it belongs on the puzzle board. If after a second glance you still believe that, then I'm okay if it gets moved there.

The actual solution to each of the word problems below are simple enough to decipher with pen and paper. However, the required solution must be shown in a graphical format. In other words, the result must be derived from an x,y graph. If someone could provide a solution or steer me in the proper direction, I'd be most appreciative...

1. <LI>Production scheduling. A manufacturer of tennis rackets makes a profit of \$15 on each oversized racket and \$8 on each standard racket. To meet dealer demand, daily production of standard rackets should be between 30 and 80, and production of oversized rackets should be between 10 and 30. To maintain high quality, the total number of rackets produced should not exceed 80 per day. How many of each type should be manufactured daily to maximize the profit?

<LI> Minimizing cost. A coffee company purchases mixed lots of coffee beans and then grades them into premium, regular, and unusable beans. The company needs at least 280 tons of premium-grade and 200 tons of regular-grade coffee beans. The company can purchase ungraded coffee from two suppliers in any amount desired. Samples from the two suppliers contain the following percentages of premium, regular, and unusable beans. ...If supplier A charges \$125 per ton and B charges \$200 per ton, how much should the company purchase from each supplier to fulfill it's needs at minimum cost?

2. ## Re: graphing (excel 2003)

1) I created 2 charts for the Prod'n Sched of rackets. The first is a surface which shows all the possible combinations (even allowing <80 rackets to be made). The second presumes that making up to the max of 80 will yield the most profits and this chart is also given. The puzzle comes down to you make the max of the one yielding the most profit and the then you make the rest of the other.

2) for the coffee the chart is simpler, but the calcs are more complext. Calcs show if None from A, you need 1000 from B, if None from B, 1400 from A to meet min requirements. I varied A from 0 to 1400 and for each value, calculated the amount from B required. Once I had A and B, I calculated the amount spent. The cost per A is plotted. Once I had about where the midpoint was I varied the chart to have more "divisions" to fine tune it (though for this puzzle it was not required).

Steve

3. ## Re: graphing (excel 2003)

Hi Steve -

These were the final two questions from my daughters Alg II/Trig homework assignment. She presented them to me very late in the evening and asked if I could solve them. In less than 4-5 minutes, I presented her with the solution and she promptly said: "doh"!. Handed me a tablet of graph paper and said: "you've got to show your work using graph paper". So, I wrote the same numbers on the graph paper... <img src=/S/munch.gif border=0 alt=munch width=19 height=17> That's when she rolled her eyes into the back of her head so far that I thought she had passed out in disbelief. <img src=/S/doh.gif border=0 alt=doh width=15 height=15> <img src=/S/drop.gif border=0 alt=drop width=23 height=23>

I appreciate the work you've put into this "not-so-little" project. I have copied the file to a cdrom and printed each sheet of the workbook and will carry them to the school during her lunch period. Thankfully, she doesn't have math class until later in the day. If it's not exactly what she was after, I'm certain it will get her moving along in the right direction. Maybe my 'good daddy license' will be restored.

<img src=/S/thankyou.gif border=0 alt=thankyou width=40 height=15>

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•