Formulate Linear Programming Model (Excel Solver) Model To Calculate Optimal Quantity Of The Products To Maximize Profit?
Fantastic news! We've Found the answer you've been seeking!
Question:
Formulate Linear Programming Model (Excel Solver) Model To Calculate Optimal Quantity Of The Products To Maximize Profit?
Transcribed Image Text:
The Production manager of a paper manufacturing company must determine the daily product mix for a new paper and board plant. This plant produces four products: foot-board, container-board, book paper and coarse paper, The sales department had established the following maximum daily demand and sales prices: Foot board 60 tons/day Rs. 2,050/- per ton Container board 120 tons/day Rs. 1,100/- per ton Book paper 25 tons/day 30 tons/day Rs. 1,700/- per ton Coarse paper Rs. 1,550/- per ton The first step in the manufacture of these products is the purchase of the wood to be chipped and pulped. Hardwood can be purchased for Rs. 234/- per cord; Soft-wood costs Rs. 260/- per cord (There is approximately 1.3 tons in a cord of either type of wood). The available local supply is limited to 200 tons per day of hardwood and 350 tons a day of softwood. Hardwood and softwood are chipped and pulped separately. The equipment has a total output capacity of 235 tons per day of pulp, regardless of the type of wood being processed. The yield on hardwood is 47% (that is, the total tonnage of hardwood pulp is 47% of the hardwood tonnage fed into the process). The yield for softwood is 45%. The chipping and pulping process incurs a variable cost of Rs. 600/- per ton of pulp produced. A portion of the pulp is used directly in producing the final products and the remaining portion is bleached first. The stream of unbleached pulp going directly into the paper and board machines is composed (by weight) of 60% hardwood pulp and 40% softwood pulp. The stream of pulp going into the Bleacher consists of 50% hardwood and 50% softwood pulp. Bleaching adds a variable cost of Rs. 100/- per ton of bleached pulp produced. The bleacher yield is 98% and has a daily output capacity of 80 tons. The bleached and unbleached pulps are mixed in fixed proportions for each of the final products. Information regarding quantities of bleached and unbleached pulp required to produce one ton of each of the final products is given below. Tons of pulp required to produce one ton of final product Foot Board Container board Вook paper Сoarse paper Unbleached pulp Bleached pulp 0.10 0.70 0.90 1.10 0.95 0.40 0.15 A board machine is used to produce container board and foot board. A variable cost of Rs. 50/- is incurred from production of a ton of either product; the board machine has an output capacity of 190 tons per day. A paper machine is used to produce book paper and coarse paper. A variable cost of Rs. 50/- is incurred from production of a ton of either product, and the machine has an output capacity of 60 tons per day. P.T.O., The Production manager of a paper manufacturing company must determine the daily product mix for a new paper and board plant. This plant produces four products: foot-board, container-board, book paper and coarse paper, The sales department had established the following maximum daily demand and sales prices: Foot board 60 tons/day Rs. 2,050/- per ton Container board 120 tons/day Rs. 1,100/- per ton Book paper 25 tons/day 30 tons/day Rs. 1,700/- per ton Coarse paper Rs. 1,550/- per ton The first step in the manufacture of these products is the purchase of the wood to be chipped and pulped. Hardwood can be purchased for Rs. 234/- per cord; Soft-wood costs Rs. 260/- per cord (There is approximately 1.3 tons in a cord of either type of wood). The available local supply is limited to 200 tons per day of hardwood and 350 tons a day of softwood. Hardwood and softwood are chipped and pulped separately. The equipment has a total output capacity of 235 tons per day of pulp, regardless of the type of wood being processed. The yield on hardwood is 47% (that is, the total tonnage of hardwood pulp is 47% of the hardwood tonnage fed into the process). The yield for softwood is 45%. The chipping and pulping process incurs a variable cost of Rs. 600/- per ton of pulp produced. A portion of the pulp is used directly in producing the final products and the remaining portion is bleached first. The stream of unbleached pulp going directly into the paper and board machines is composed (by weight) of 60% hardwood pulp and 40% softwood pulp. The stream of pulp going into the Bleacher consists of 50% hardwood and 50% softwood pulp. Bleaching adds a variable cost of Rs. 100/- per ton of bleached pulp produced. The bleacher yield is 98% and has a daily output capacity of 80 tons. The bleached and unbleached pulps are mixed in fixed proportions for each of the final products. Information regarding quantities of bleached and unbleached pulp required to produce one ton of each of the final products is given below. Tons of pulp required to produce one ton of final product Foot Board Container board Вook paper Сoarse paper Unbleached pulp Bleached pulp 0.10 0.70 0.90 1.10 0.95 0.40 0.15 A board machine is used to produce container board and foot board. A variable cost of Rs. 50/- is incurred from production of a ton of either product; the board machine has an output capacity of 190 tons per day. A paper machine is used to produce book paper and coarse paper. A variable cost of Rs. 50/- is incurred from production of a ton of either product, and the machine has an output capacity of 60 tons per day. P.T.O.,
Expert Answer:
Answer rating: 100% (QA)
Before attempting to solve a linear programming problem with Excel make sure that the Solver addin has been activated See the Excel Addins web page for details 2 Enter all data from the problem into c... View the full answer
Related Book For
Management Accounting Information for Decision-Making and Strategy Execution
ISBN: 978-0137024971
6th Edition
Authors: Anthony A. Atkinson, Robert S. Kaplan, Ella Mae Matsumura, S. Mark Young
Posted Date:
Students also viewed these corporate finance questions
-
The production manager of a plant that manufactures syringes records the marginal cost at various levels of output for 14 randomly selected months. The data are shown here: a. On the accompanying...
-
The production manager of a large Cincinnati manufacturing firm once made the statement, "I would like to use LP, but it's a technique that operates under conditions of certainty. My plant doesn't...
-
The production manager of a large casting firm is studying different methods to increase productivity in the workforce of the company. The process engineer and personnel in the human resources...
-
The president has become discouraged with his current economic advisory team. He has searched the colleges and your name keeps coming up as one of the very best macroeconomic analysts in the country....
-
Identify analytical tools useful in evaluating depreciation expense. Explain why they are useful.
-
Waterway Inc. wishes to accumulate $1,144,000 by December 31, 2035, to retire bonds outstanding. The company deposits $176,000 on December 31, 2025, which will earn interest at 12% compounded...
-
Which of the following disaster recovery techniques may be least optimal in the case of a widespread natural disaster? a. empty shell b. ROC c. internally provided backup d. they are all equally...
-
The following items were taken from the 2009 financial statements of Texas Instruments, Inc. (All dollars are in millions.) InstructionsPrepare a classified balance sheet in good form as of December...
-
BUS 208-Principles of Accounting II Homework Assignment 4 Chapter 15 McDaniel Corporation manufactures surveying equipment. Journalize the entries to record the following selected equity investment...
-
The following unadjusted trial balance is for the year ended 30 June 2019: BILLY GOAT LTD Unadjusted Trial Balance as at 30 June 2019 Debit Credit Bank overdraft Vehicle rental expenses Cash at bank...
-
a. Using plantwide allocation b. Using department's allocation rate Baseball Profit Bats Tennis Rackets
-
What are the four basic business transactions and what are their corresponding debit and credit accounting entries under the convention of double-entry bookkeeping?
-
The International Accounting Standards Board (IASB) decreed the adoption of the International Financial Reporting Standards (IFRSs) by all listed companies within the European Union are mandatory...
-
Conceptual frameworks of accounting have been developed over many years and in many countries. Explain how these culminated in the publication of the UK Statement of Principles (SOP) in 1999, and...
-
How may the cash position of a company be ascertained from its trial balance?
-
(i) At a specific point in time, what does a companys trial balance show? (ii) What may the trial balance not show?
-
The board of directors commits the corporation to a binding legal obligation that cannot be rescinded on December 31 of each year the declaration date the date of payment the date of record None of...
-
Find the radius of convergence in two ways: (a) Directly by the CauchyHadamard formula in Sec. 15.2. (b) From a series of simpler terms by using Theorem 3 or Theorem 4.
-
Multiple breakeven points Last month, Capetini Capacitor Company sold capacitors to its distributors for $250 per capacitor. The sales level of 3,000 capacitors per month was less than the...
-
Operating budgets: materials purchasing plan Masefield Dairy is preparing a third-quarter budget (July, August, and September) for its ice cream products. It produces five brands of ice cream, and...
-
Pierre LeBlanc, manager of Centaur Corporation, is thinking about implementing a target costing system in his organization. Several managers have taken him aside and have expressed concerns about...
-
Wildcat Oil Company leased undeveloped acreage from David Jones for \($30,000\), with Jones receiving a 1/8 royalty interest. Financially unable to develop the lease, Wildcat enters into a...
-
Bingo Oil Company owns 100% of the working interest in a fully developed lease on which there is a 1/8 royalty interest. The lease has the following capitalized costs and reserve data as of January...
-
Philco Company owns a proved property with the following costs: Philco Company sells 100% of the working interest in the property to Company Q for $600,000. a. Give the entry for Philco Company to...
Study smarter with the SolutionInn App