Mont Noir makes three high-end items. A ballpoint pen, a mechanical pencil, and a fountain pen....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Mont Noir makes three high-end items. A ballpoint pen, a mechanical pencil, and a fountain pen. All are available in only one color, black, and are sold mostly through specialty stores and catalogs. The per-unit profit is $3 for the ballpoint pen, $3 for the mechanical pencil, and $5 for the fountain pen. These values take into account labor, the cost of materials, packaging, quality control, etc. The manufacture of these high-end items requires plastic, chrome, and stainless steel. These materials are not easily available. Mont Noir can get at most 1,000 ounces of plastic, 1,200 ounces of chrome, and 2,000 ounces of stainless steel each week. Each ballpoint pen requires 1.2 ounces of plastic, 0.8 ounces of chrome and 1.2 ounces of stainless steel. Each mechanical pencil requires 1.7 ounces of plastic, no chrome, and 3 ounces of stainless steel. Each fountain pen requires 1.2 ounces of plastic, 2.3 ounces of chrome and 4.5 ounces of stainless steel. You have been asked by Mont Noir to set up an LP model in a spreadsheet so that it can be used as a planning tool to explore any number of issues. NOTE: since the production continues week after week, any unfinished item is simply completed the next week-in other words, non-integer answers are OK. Mont Noir makes three high-end items. A ballpoint pen, a mechanical pencil, and a fountain pen. All are available in only one color, black, and are sold mostly through specialty stores and catalogs. The per-unit profit is $3 for the ballpoint pen, $3 for the mechanical pencil, and $5 for the fountain pen. These values take into account labor, the cost of materials, packaging, quality control, etc. The manufacture of these high-end items requires plastic, chrome, and stainless steel. These materials are not easily available. Mont Noir can get at most 1,000 ounces of plastic, 1,200 ounces of chrome, and 2,000 ounces of stainless steel each week. Each ballpoint pen requires 1.2 ounces of plastic, 0.8 ounces of chrome and 1.2 ounces of stainless steel. Each mechanical pencil requires 1.7 ounces of plastic, no chrome, and 3 ounces of stainless steel. Each fountain pen requires 1.2 ounces of plastic, 2.3 ounces of chrome and 4.5 ounces of stainless steel. You have been asked by Mont Noir to set up an LP model in a spreadsheet so that it can be used as a planning tool to explore any number of issues. NOTE: since the production continues week after week, any unfinished item is simply completed the next week-in other words, non-integer answers are OK.
Expert Answer:
Answer rating: 100% (QA)
SOLUTION To set up an LP linear programming model in a spreadsheet for Mont Noirs production planning we need to define the decision variables the obj... View the full answer
Related Book For
Spreadsheet Modeling & Decision Analysis A Practical Introduction to Management Science
ISBN: 978-0324656633
5th edition
Authors: Cliff T. Ragsdale
Posted Date:
Students also viewed these general management questions
-
a. What should the weekly product mix consist of, and what is the weekly net profit? b. Is the optimal solution to question 1 degenerate? Explain your response. c. Is the optimal solution from...
-
Computers and word processors not withstanding, the art of writing by hand recently entered a boom era. People are buying fountain pens again, and mechanical pencils are becoming more popular than...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Given the following set of slope staking notes: C Sta 51+00 50+00 49+00 L CX 33.4 F 9.1 33.6. F 10.3 35.4 C 5.5 0.0 F 3.5 R C 3.2 X C 4.1 30.2 0.0 20.0 Bases Base for cut=48 ft Base for fill= 40 ft s...
-
Prove [AB, CD] = AC {D, B} + A {C, B} D C {D, A} B + {C, A} DB. Discuss.
-
On an average day, an adult dissipates about 7000 kJ of free energy. Assuming that this occurs under standard conditions, (a) How many moles of ATP must be hydrolyzed to provide this quantity of free...
-
The magnitude of the magnetic field in Figure P29.40 changes with time, and the magnitude of the accompanying electric field inside the magnetic field is given by \(E(r, t)=3 C r t^{2}\), where \(C\)...
-
Stephen Thorne owns the Fredonia Barber Shop. He employs five barbers and pays each a base rate of $1,000 per month. One of the barbers serves as the manager and receives an extra $500 per month. In...
-
A multinational corporation is accused of environmental pollution and human rights violations in a foreign country where it operates. What legal challenges arise in holding the corporation...
-
On October 1, 2020, Mary Graham organized a computer service company called Echo Systems. Echo is organized as a sole proprietorship and will provide consulting services, computer system...
-
Facebook is not popular among the younger age groups as it is for the older generations. Do you believe this still holds true? Why or why not?
-
One of your nurses was involved in a car accident. The nurse has recovered and wants to return to work. The nurse informs you that because of the accident they are not able to lift more than 20...
-
You are the human resources director for IMF Plastics Manufacturing. Roan, the VPHR, has reached out asking for your help because the organization has experienced significant growth through an...
-
Traditionally, the activities of labor unions have supported the development of gains for the American worker. As labor unions negotiate with management, those gains set a standard for other...
-
Lisa is a supervisor working in Line CD-6 with 30 workers reporting to her. Her result-oriented and autocratic style has impressed her section ever since she joined the section. One Monday morning...
-
Why does change management matter? Why do most change efforts fail? For you alone, take a moment to reflect and then describe three (3) Leading and Managing Change Goals that you will strive to reach...
-
2. Write a Java class that extends ACM's GCompound class to draw the following symbol Note: Using Gimage is not valid Then write a separate Main class that instantiates the previously created class...
-
Given the table below, about how much force does the rocket engine exert on the 4.0 kg payload? Distance traveled with rocket engine firing (m) Payload final velocity (m/s) 500 320 490 310 1020 450...
-
Use regression to estimate the parameters of a 6th order polynomial model for this data. That is, estimate the least squares estimates for the parameters in the following estimated regression...
-
An investor wants to determine the safest way to structure a portfolio from several investments. Investment A produces an average annual return of 14% with a variance of 0.025. Investment B produces...
-
A manufacturing company uses a certain type of steel rod in one of its products. The design specifications for this rod indicate that it must be between 0.353 to 0.357 inches in diameter. The machine...
-
Can one have a picture in which operators don't evolve in time other than the Schrdinger picture?
-
Consider a Hamiltonian \(\hat{H}(p)\) only (no \(x\) dependence). What are the operators in the theory that evolve nontrivially in the Heisenberg picture? What about in a possible interaction...
-
Consider two harmonic oscillators, one with frequency \(\omega\) and one with frequency \(2 \omega\). Calculate the symmetric wave function (in \(x\) space) corresponding to the energy \(E=(15 / 2)...
Study smarter with the SolutionInn App