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....
-
Why is formal training of workers so important to most employers? Why dont employers simply let people learn about their jobs as they perform them?
-
Referring to the retirement example in Example 16.6, rerun the model for a planning horizon of 10 years; 15 years; 25 years. For each, which set of investment weights maximizes the VAR 5% (the 5th...
-
Five projects form the mutually exclusive, collectively exhaustive set under consideration. The cash flow profiles for the five projects are given in the table below. Information on each project was...
-
In a recent year Ives Township acquired six police cars at a total cost of $200,000. The vehicles are expected to have a useful life of four years. 1. Prepare the journal entries that the township...
-
Show that the two drawings represent the same graph by labeling the vertices and edges of the right-hand drawing to correspond to those of the left-hand drawing. 5 el 06 Veq 5 e2 V2 ez 3 U5 (a) es 1...
-
Go to the websites for project management tools (besides Microsoft Project), such as Apptivo (www.apptivo.com), GanttProject (www.ganttproject.biz), Gantter (www.gantter.com), and smartsheet...
-
Nighthawk Steel, a manufacturer of specialized tools, has $4,750,000 in assets. Temporary current assets i Permanent current assets Capital assets Total assets $1,050,000 1,600,000 2,100,000...
-
how to i record closing entries with the following accounts: Prepaid Insurance, Accum. Deprec. - Store Equip, C. Browning, Capital C. Browning, Drawing, Sales, Sales Returns & Allow, Purchases,...
-
10. Determine the output produced by the following program: int a 10, c = 2; float b 5.5, d = 9.9; bc/a; DDD ba+b; b b (int) d; printf("%f", b);
-
Forecasting with the Parsimonious Method and Estimating Share Value Using the DCF Model Following are the income statement and balance sheet for Cisco Sytems for the year ended July 30, 2016. Cisco...
-
Given the time frame of the case (i.e. 2009 - 2010) to what extent do you believe the mayor and the director of the zoo have correctly framed their assumptions regarding revenue and expense? 2) What...
-
Consider the following simplified financial statements for the Steveston Corporation (assuming no income taxes): Statement of Comprehensive Income Statement of Financial Position Sales $ 32,000...
-
Macroeconomic Analysis: In the context of the basic macroeconomic model developed in class, analyze the impact of each of the following economic changes (ceteribus paribus) on domestic real GDP,...
-
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...
-
A very simple version of the normative model described in the text involves a simple economic growth process converging to a steady-state, where values do not change over time. \({ }^{14}\) A simple...
-
Go to the library or the Internet and, for a particular year, put together a data set of profits in agriculture in different geographical units of your state or country (e.g., counties of a U.S....
-
For each of the following social choice methods, which of Arrow's axioms are violated, and why: a. the Pareto criterion b. plurality-rule voting (of several choices, the one with the most votes wins)...
Study smarter with the SolutionInn App