Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A jeweler and her apprentice make silver pins and necklaces by hand. Each week they have 8 0 hours of labor and 3 6 ounces

A jeweler and her apprentice make silver pins and necklaces by hand. Each week they have 80 hours
of labor and 36 ounces of silver available. It requires 6 hours of labor and 3 ounces of silver to make a
pin and 10 hours of labor and 5 ounces of silver to make a necklace. Each pin also contains a small
gem of some kind. The demand for pins is no more than six per week. A pin earns the jeweler $200 in
profit, and a necklace earns $300. The jeweler wants to know how many of each item to make each
week to maximize profit.
a) Formulate an integer programming model for this problem.
b) Solve this model by using the Solver Tool in Microsoft Excel. Compare this solution with the
solution without integer restrictions and indicate the difference in the profit and units produced.
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project Management With CompTIA Project+

Authors: Joseph Phillips

4th Edition

9781259860300

More Books

Students also viewed these General Management questions