Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please use excel to solve this problem (a) Formulate an algebraic model for the problem. Submit this in Word or pdf. (b) Use LINGO or

please use excel to solve this problem
image text in transcribed
image text in transcribed
(a) Formulate an algebraic model for the problem. Submit this in Word or pdf. (b) Use LINGO or the Excel Solver to solve this model, including your name and student number on the model. If using LINGO, submit files for the model and the solution for each question. If using the Excel Solver, submit one file for all questions, using tabs for the model and the Answer Report (a total of ten tabs.) (c) State the solution in words. Submit this in Word or pdf. A lumber store stocks dowels in one standard length of 200 cm. Each dowel costs $26.50. A customer wants the store to cut her at minimal cost thirty dowels of length 95 cm, fourteen dowels of length 63 cm, thirty-five dowels of length 37 cm, and fifty dowels of length 20 cm. She will receive a recycling credit of 5 cents per cm for any wood declared to be "waste". You might wish to use Excel to help create the list of patterns needed in part (a)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Cost Accounting

Authors: Edward J. Vanderbeck

15th Edition

978-0840037039, 0840037031

More Books

Students also viewed these Accounting questions

Question

Did Elizabeth use visual aids effectively?

Answered: 1 week ago

Question

What is the mean world syndrome?

Answered: 1 week ago

Question

Is Elizabeths speech persuasive or informative or both?

Answered: 1 week ago