Radford Castings can produce brake shoes on six different machines. The following table summarizes the manufacturing costs

Question:

Radford Castings can produce brake shoes on six different machines. The following table summarizes the manufacturing costs associated with producing the brake shoes on each machine along with the available capacity on each machine. If the company has received an order for 1,800 brake shoes, how should it schedule these machines?

a. Formulate an ILP model for this problem.
b. Create a spreadsheet model for this problem and solve it.
c. What is the optimalsolution?

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For book-img-for-question

Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics

ISBN: 1233

8th Edition

Authors: Cliff T. Ragsdale

See More Books

Question Posted: Oct 06, 2012 06:36 AM

See More Questions

A sports apparel company has received an order for a college basketball teams national championship T-shirt. The company can purchase the T-shirts from textile factories in Mexico, Puerto Rico, and...
A sports apparel company has received an order for a college basketball teams national championship T-shirt. The company can purchase the T-shirts from textile factories in Mexico, Puerto Rico, and...
A furniture maker has received an order for 100 units of its kitchen table to be delivered at the beginning of Friday, March 20. The table consists of 1 top and 4 legs, made from purchased lumber (2"...
is manager should spend time in understanding the market before taking decisions? If yes, why?
(a) Show that a line t 0 through the origin of R3 is a subspace of R3. (b) Show that a line t in R3 not passing through the origin is not a subspace of R3.
What are the differences between the back of the house and the front of the house? LO.1
Explain why rational subgrouping should be used in constructing control charts.
The manager of a chain of electronics stores is considering running a sale on a Lexmark printer model that contains many popular features. The store buys these printers for $60 apiece and, at the...
You are promised one off bonus 81099 in two years time. If the discount rate is 6% what is the present value of this payment
1. What micro-environmental factors have affected Fitbit since it opened for business? 2. How should Fitbit overcome the threats and obstacles it faces? 3. What factors in the marketing environment...
Kentwood Electronics manufactures three components for stereo systems: CD players, tape decks, and stereo tuners. The wholesale price and manufacturing cost of each item are: Each CD player produced...
The teenage daughter of a recently deceased movie star inherited a number of items from her famous fathers estate. Rather than convert these assets to cash immediately, her financial advisor has...
The molar mass of caffeine is 194.19 g. Is the molecular formula of caffeine C4H5N2O or C8H10N4O2?
Sample grade point averages for ten male students and ten female students are listed. Males 2.4 3.7 3.8 3.9 Females 2.8 3.7 2.1 3.9 2.8 2.6 3.6 3.3 4.0 1.9 3.6 4.0 2.0 3.9 3.7 2.3
Fill in the columns in the following table. What quantity should a profit-maximizing firm produce? Verify your answer with marginal reasoning. 9 0 1 2 3 st 4 5 6 TFC $5 5 5 5 5 5 5 TVC $0 3 5 9 16 25...
Perform the experiments in Problems 48-51, tally your results, and calculate the probabilities (to the nearest hundredth). Flip three coins simultaneously 100 times, and note the results. The...
The following information is available for Spring Inc. and Winter Inc. at December 31, 2011: Required a. What is the accounts receivable turnover for each of the companies for 2011? b. What is the...
Margin of error = 0.5 g, standard deviation = 8.7 g
How do we evaluate inventories?LO1.
Could a set of three vectors in span all of? Explain. What about n vectors in when n is less than m? R4
A day after sending an email to all 1,800 employees in your company regarding income tax implications of the companys retirement plan, you discover that one of the sources you relied on for your...
Refer to question 17 at the end of Chapter 2. Implement a spreadsheet model for this problem and solve it using Solver.
Refer to question 18 at the end of Chapter 2. Implement a spreadsheet model for this problem and solve it using Solver.
Refer to question 19 at the end of Chapter 2. Implement a spreadsheet model for this problem and solve it using Solver.
Which of the following statements regarding traditional cost accounting systems is false? a. Products are often over or under cost in traditional cost accounting systems. b. Most traditional cost...
Bart is a college student. Since his plan is to get a job immediately after graduation, he determines that he will need about $250,000 in life insurance to provide for his future wife and children...
Reporting Financial Statement Effects of Bond Transactions (please show me how you got the answers) Lundholm, Inc., which reports financial statements each December 31, is authorized to issue...

Radford Castings can produce brake shoes on six different machines. The following table summarizes the manufacturing costs

Question:

Machine Fixed Cost Variable Cost Capacity $21 $23 $25 $24 $20 $26 500 600 750 400 600 800 $1000 5 800

Step by Step Answer:

a MIN 21X1 23X2 25X3 24X4 20X5 26X6 1000Y1 950Y2 875Y3 85...View the full answer

Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics

Students also viewed these Management Leadership questions