16. Bearland Manufacturing produces 4 different types of wood paneling. Each type of paneling is made by gluing and pressing together a different mixture of pine and oak chips. The following table summarizes the required amount of gluing, pressing, and mixture of wood chips required to produce a pallet of 50 units of each type of paneling: Paneling Type Glue (quarts) Pressing (hours) Pine chips (pounds) Oak chips (pounds) Resources Required per Pallet of Paneling Type Pacific Savannah Aspen Tahoe 50 50 500 500 50 150 400 750 100 100 300 250 50 50 200 500 b. Create a spreadsheet mode for this problem, and solve it using Solver. c. What is the optimal solution? Assume the company has 6,000 quarts of glue; 7,500 hours of pressing capacity; 30,000 pounds of pine chips; and 62,500 pounds of oak chips available in the next production cycle. Further assume that each pallet of Tahoe, Pacific, Savannah, and Aspen panels can be sold for profits of $450, $1,150, $800, and $400, respectively. Finally, for marketing purposes, the company wants to produce at least 4 pallets of each type of paneling. a. Formulate an LP model for this problem.

16. Bearland Manufacturing produces 4 different types of wood paneling. Each type of paneling is made by gluing and pressing together a different mixture of pine and oak chips. The following table summarizes the required amount of gluing, pressing, and mixture of wood chips required to produce a pallet of 50 units of each type of paneling: Paneling Type Glue (quarts) Pressing (hours) Pine chips (pounds) Oak chips (pounds) Resources Required per Pallet of Paneling Type Pacific Savannah Aspen Tahoe 50 50 500 500 50 150 400 750 100 100 300 250 50 50 200 500 b. Create a spreadsheet mode for this problem, and solve it using Solver. c. What is the optimal solution? Assume the company has 6,000 quarts of glue; 7,500 hours of pressing capacity; 30,000 pounds of pine chips; and 62,500 pounds of oak chips available in the next production cycle. Further assume that each pallet of Tahoe, Pacific, Savannah, and Aspen panels can be sold for profits of $450, $1,150, $800, and $400, respectively. Finally, for marketing purposes, the company wants to produce at least 4 pallets of each type of paneling. a. Formulate an LP model for this problem.

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

2) BAQARAH Milk is fresh cow’s milk from Bangladesh’s first industrial hi-tech dairy farm which is equipped with the most advanced technology for milking cows and processing milk. All the cows are purebred Holstein Friesian from Australia. The farm ensures that milk is hygienically produced without human touch from milking to packing. It is instantly pasteurized to preserve the milk quality. The key features of BAQARAH milk is pure, fresh, low fat, free of antibiotic, free of toxin and of global standard. a) Which pricing strategy will be applicable for this product- price skimming or pricing penetration? Justify your position with three proper logics. b) In the given situation, which stage of buying decision process of consumers the company is trying to influence and how?
Atlanta Manufacturing Company produces products W, X, Y, and Z through a joint process. The joint costs amount to $250,000. Product Units Produced Sales Value at Split-Off Additional Costs of Processing Sales Value After Processing W 750 $10,000 $2,500 $15,000 X 1,500 $30,000 $3,000 $35,000 Y 1,000 $20,000 $4,000 $25,000 Z 1,500 $40,000 $6,000 $45,000 If W is processed further, profits of W will: 1) Increase by $2,500 2) Increase by $12,500 3) Decrease by $23,000 4) Increase by $5,000
The Chineke Group of Company manufactures two products, namely product B and product P, and provides you with the following information: Prod. B Prod. P Selling price per unit 80.00 50.00 Less cost of sales: Direct material A @ R5.00 per kg 15.00 10.00 Direct material B @ R4.00 per kg 8.00 12.00 Direct labour @ R6.00 per hour 12.00 6.00 Variable manufacturing overhead @ R5.00 per labour hour 10.00 5.00 Fixed manufacturing overhead per unit 5.00 5.00 Gross profit 30.00 12.00 Less sales & administrative costs: Variable 6.00 4.00 Fixed 10.00 5.00 Net profit per unit 14.00 3.00 Take note of the following constraints: Material A available 360 kg Material B available 360 kg Labour hours available…
8. Cebrero Company makes 6,000 bottles of avocado shake every day. Each bottle size up to 50 gramsand contains 50% content mixture of avocados. How many kilos of avocado does the company needsevery day to suffice the production?
economics of using mechaniz The following are the different phases in the analytical approach and process. Ind k. Establishment of budgetary c h Evaluation of the applicability Preparation of accounting syt d. The primary purpose of MAS is to improve the client firm's use of its capabal Exercise 2: Classification of Services and finance funetions: a Job evaluation and administration Industrial engineering e. Development of management-oriented accounting reporting system d Operations research e Investment management E Development of compensation programs g. Management or operations audit equipment i. and procedures manual i Revision of pension plans of 1. Marketing Cost reduction studies m. Exercise 3: Phases in the Analytical Approach and Process the sequence in which they are performed by writing the corresponding number of If it is not included, write NA. Advising and providing technical assistance in implementing recommendations Seeking and identifying objectives Evaluating and…
What is one important advantage of a Make-To-Stock process? Group of answer choices Can respond quickly to customer demand Creates greater flexibility Less likely to have obsolete inventory More environmentally sensitive
Please do not give solution in image format thanku In 2018, the government of Ghana launched operation one district one factory (IDIE). Based on IDIF, Ekumfi Pineapple Factory Co. Ltd (EPF) was launched. In 2019 the management of ERF started production with 100 workers per shift, each of the three shifts working 8 hours per day. Every working day the payroll cost was GHIC 20,000 and overhead expenses amounted to GHC 5000 and material cost GHC 4000. At the end of the first year, the company produced 1,000,000 boxes of pineapple juice. During the second year, EPF acquired a loan from Exim Bank to purchase a new plant. After the introduction of the new plant, the management reduced the size of its workers per shift to 80, each working 8 hours per day, with the payroll cost reducing to GHC 18,000 and overhead expenses also reducing to GHC 4000 and material cost rising to GHC 6000. Production rose to 1,200,000 boxes. Regard yourself as the Operations Manager of EPF: a) What are the…
Suppose we have a business of supplying fruits and vegetables to customers. So How to manage a order when there is lack of team members(more then 3-5 employes on leave on same time ) in the order management and order need to be fulfilled in short span of time in the following situations :-I) When Delivery team missing II) When Packaging Team missingIII) When Billing Team missing (Answer in points only ) upvote for quality answer
Jetaway, a small manufacturer of replacement parts forthe aircraft industry, had always maintained a simplelayout—all like machines were located together. That waythe firm could be as flexible as possible in producing small amounts of the variety of parts its customers re-quired. No one questioned the production arrangement until Chris Munnelly started to work for the company.Chris was actually hired to upgrade Jetaway’s computer system. In the process of creating a database of part rout-ings, Chris began to see similarities in the parts pro-duced. A part routing matrix for nine of the most popular parts is shown below, along with a schematic of thefactory layout.Chris, who was already tired of being a programmer,decided to reorder the matrix and see what he couldfind. If he could identify distinct part families, he couldreorganize the placement of machines into the cells hehad been reading about in his business magazines.Maybe then someone would notice his managementpotential.Help…
123456789unn3u5167 10 5 6 Variable Cells 18 19 20 21 22 23 24 25 26 27 28 29 30 31 7 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 8 9 10 11 2 11 13 12 14 12 Constraints Name Cell $B$15 demand for A LHS $B$16 total demand LHS 16 17 $B$17 procssing time LHS Cell $C$8 A $D$8 B 15 16 Name Final Reduced Objective Allowable Allowable Value Cost Coefficient Increase Decrease 1E+30 250 100 Final Value Price 250 350 600 0 0 Shadow Constraint R.H. Side 0 4 -1 2 3 Q1 what is the range for objective coefficient of A and B? 125 350 600 1 1E+30 Allowable Allowable Increase Decrease Q4) if the objective coefficient of A goes up to 5 dollars what will happen? Q2 assume that the final value of B is 0 and the reduced cost of B is 1; explain the situation ? Q5 If the objective coefficient of B goes up to 8 dollars what will happen? Q6) if the obj coeff of A goes down to -5 dollars what does that mean? 125 125 100 1 Q3 if the objective coefficient of A goes down to 1 dollar and objective coefficient of B…
12.4 A company has a warehouse with the dimensions shown in the following diagram. How many pallets measuring 48"x40" can be stored three high if there is to be a 2" space between the pallets? 50' Aisle Aisle 4' 4' 4' R 4'
1. Define and indicate the purpose of the following items: e. Refrigeration Temperature Monitoring f. Stockroom Temperature Monitoring g. Room Temperature Monitoring please provide reference ;>