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...
-
Gabby's Bakery Company reported sales revenue of $148,000 and cost of goods sold of $93,000. Requirements 1. Compute Gabby's Bakery Company's correct gross profit assuming the company's ending...
-
Given the Boolean function F = xyz + x'y'z + xyz a. List the truth table of the function. b. Draw the logic diagram using the original Boolean expression. c. Simplify the algebraic expression using...
-
Why are systems for collaboration and social business so important and what technologies do they use? Define collaboration and social business, and explain why they have become so important in...
-
Job costing, accounting for manufacturing overhead, budgeted rates. The Fasano Company uses a job-costing system at its Dover, Delaware, plant. The plant has a machining department and a finishing...
-
Question 1. (elaborate on your answers with an example) Explain what is meant by operating and ?nancial risk. Suppose that ?rm A has a greater operating risk than ?rm B. Is it true that ?rm A ...
-
10. Classifying Processed Images into Multiple Classes Introduction We have processed images to represent as a vector of 300 attributes. The first 294 are decimal values in the range 0 to 1...
-
1. The Lone Star Company has $1,000 par value bonds outstanding at 9 percent interest. The bonds will mature in 25 years. Use Appendix B and Appendix D for an approximate answer but calculate your...
-
Listed below are several transactions that took place during the second and third years of operations for the RPG Company. Amounts billed to customers for services rendered Cash collected from credit...
-
Consider a security that pays annual dividends. It just paid $2.50 dividends per share and the next dividend will be paid in 1 year. The dividend is expected to grow at the rate of 6% per annum for...
-
Given the following information, what is the desired profit margin? D/E = 2 current profit margin = 10% R = 0.6 capital intensity ratio = 2 desired sustainable growth rate = 15%
-
Bless Inc. manufactures a single product in which variable manufacturing overhead is assigned on the basis of direct labor hours. The company uses a standard cost system and has established the...
-
A horizontal spring with a spring constant k = (7.17x10^4) N/m is uncompressed from an extension Ax = (6.1870x10^0) cm back to its unstretched length. Calculate the change in potential energy in...
-
What is the value to the company and the supplier in developing and implementing a supplier relationship management (SRM) system?
-
Inexhaustible collections of ONPOs are not required to be capitalized or depreciated, if certain criteria are met. Why is this so, and what accounting and reporting recognition, if any, is required...
-
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...
-
7. Fred Schipul taught English at the Thomaston (Connecticut) High School for 18 years. When the position of English Department chairperson became vacant, Schipul applied, but the Board of Education...
-
10. ROLE REVERSAL Write an essay question involving a union organizing campaign and a management response that includes both permissible advocacy and illegal conduct.
-
Find a website that is campaigning against sweatshops. What are sweatshops? Do they exist in the United States? Describe a current campaign about this issue. Do you agree or disagree with what is...
Study smarter with the SolutionInn App