Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Dolly Trolleys manufacture trolleys for a chain of supermarkets. Demand for trolleys is buoyant, so all production can be sold. Two models are produced by

Dolly Trolleys manufacture trolleys for a chain of supermarkets. Demand for trolleys is buoyant, so all production can be sold. Two models are produced by Dolly - the STREAMLINE (L) and the STANDARD (D). The streamline has three wheels and the standard has four. The daily availability of wheels (which are bought in) is limited to 240. Dolly works a single 8-hour shift per day.

There are two stages of manufacture for trolleys: fabrication and spraying. Spraying takes 24 minutes for each streamline trolley and 10 minutes for each standard. Fabrication takes 30 minutes for each streamline trolley and 20 minutes for each standard. Three identical machines are available for fabrication, which can be used for either type of trolley (or both). Spraying is carried out manually by one person per trolley, and there are two staff available for this process.

The profit from selling a streamline trolley is $20 and a standard trolley is $18. No more than 15 trolleys can be produced per hour because of storage limitations on work in progress. Develop a linear programming model for this problem. Develop an LP model for this problem and solve it using Excel. Then, upload your Excel file, which must contain the following:

3) The optimal solution in Excel? how to solve this one excel step by step

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

Step: 3

blur-text-image

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

Mathematics for Economics and Business

Authors: Ian Jacques

9th edition

129219166X, 9781292191706 , 978-1292191669

More Books

Students also viewed these Mathematics questions

Question

Define small data analytics.

Answered: 1 week ago

Question

34. Provide an example of value stream mapping.

Answered: 1 week ago

Question

37. What are the 5Ss of housekeeping? What is the sixth?

Answered: 1 week ago