6. Chapter 6, Problem 11.Radford Castings can produce brake shoes on sixdifferent machines. The following table summarizes themanufacturing costs associated with producing the brakeshoes on each machine along with the available capacityon each machine. If the company has received an orderfor 1,800 brake shoes, how should it schedule thesemachines?Machine12345Fixed Cost Variable Cost$1000$21$950$23$25$24$ 875$ 850$ 800$ 700$20$26Capacity500600750400600800a. Formulate an ILP model for this problem.b. Create a spreadsheet model for this problem andsolve it.What is the optimal solution?

Find the Given details: Given details:MachineFixed costVariable costCapacity1 $ 1,000 $…

Answered: Radford Castings can produce brake…

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

22.May I know the correct option?
Problem 11-11 (Algo) Famous Albert prldes himself on being the Cookle King of the West. Small, freshly baked cookles are the specialty of his shop. Famous Albert has asked for help to determine the number of cookles he should make each day. From an analysis of past demand, he estimates demand for cookles as VROBARTLITY OF DENAND 0.04 DEEAND 1,800 dosen 2,000 2,200 0.10 0.20 2,400 2,600 2,000 3,000 0.26 0.15 0.03 0.14 ces Each dozen sells for $0.65 and costs $0.49, which includes handling and transportation. Cookles that are not sold at the end of the day are reduced to $0.30 and sold the following day as day-old merchandise. a. Compute the expected profit or loss for each cookie making decislon quantity. (Round your answer to the nearest whole number. Enter expected losses with a negative sign.) Cookles Baked (Dozen) Probability of Demand Expected Profit/Loss 1,800 0.04 2,000 0.10 2,200 0.28 2,400 0.26 2,600 0.15
Chairs Tables Selling price per unit ＄80 ＄400 Variable cost per unit ＄30 ＄200 Board feet per unit 　　　　　　2 10 Monthly demand 600 100 The company's supplier of hardwood will only be able to supply 2,000 board feet this month. What plan would maximize profits? a. 500 chairs and 100 tables b. 600 chairs and 80 tables c. 500 chairs and 80 tables d. 600 chairs and 100 tables Note:- Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. Answer completely. You will get up vote for sure.
1. Inventory management for a tyre company? 2. Process management for a tyre company?
Problem 3-14 (Algo) Demand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) 4,150 4,25e 3,950 4, 350 4,95e 4,650 5,25e 4,850 5,35e 5,65e 6,25e 5,95e January February March Аpril Мay June July August September October November December a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round Intermedlate calculatlons. Round your answers to 2 decimal places.) Month Forecast January February March April May June July August September October November December b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors…
2. May I know the correct option?
29 00:24 1 令.l 50 B/s Question no. 02: A Leading manufacturer of Action Figures is about to introduce four new Action Figures. The accompanying table summarizes price and cost data, combined fixed costs equal $650,000. A marketing research study predicts that for each unit sold of Noyan, 2 units of Dogan, 3 units of Bamsi and 4 units of Turgut will be sold. Action Figures Turgut Bamsi Dogan Novan Selling Price (in dollars) 35 26 24 16 Variable Cost/unit (in dollars) 17 12 12 11 Table 1 a) How many product mix units must be sold to break even? b) How does it translate into sales of individual games?
Model A B C Labor Hours Used Hours Available Tubing Pumps A B C Blue Ridge Hot Tubs Total Profit Pumps Tubing Number to Assembl Require Require Make y hours d Resources Used Demand Min 15 12 10 322 Max 130 Available 650 88 30 40 45 d 112 A B C 11 10 12 Profit/Unit $ 96.00 $ 75.00 $ 116.00 Blue Ridge Hot Tubs is a local company that just received a donation of tubes and pumps used for hot tubs. The company wants to know how many of each model they should make in order to maximize their profits. They need to stay within the amount of available hours, can't make more than what they have the resources for, and want to stay within the minimum and maximum demand.
Q4) A manufacturer provides specialized microchips. During the next 3 months its sales, costs, and available time are shown in the table. Month 1 Month 2 Month 3 There are no chips in stock at the beginning of the first month. It takes 1.5 hr of production time to produce a chip and costs $5 to store a chip from one month to the next. Determine a production schedule that meets the demand requirements, does not exceed the monthly production time limitations, and minimizes cost. Note that no chips should be in stock at the end of the 3 months. Use fmincon. Chips required Cost regular time ($/chip) Cost overtime ($/chip) Regular operation time (hr) Overtime (hr) 1000 100 110 2500 100 120 2200 120 130 2400 2400 720 2400 720 720
|Product D is stocked only at the AMC Chemical Company's Dallas warehouse and at the company's plant warehouse in Akron. The sales director has forecast product sales from the Dallas warehouse to be 40 units per week for the next 8 weeks. Product D is manufactured at the firm's Akron plant using 2 units of ingredient X per unit of product D. Information: Ingredient X Projected available balance: 4 Units Schedule receipt in week 1: 320 units Safety stock quantity: 2 Product D in Dallas Product D in Plant Warehouse Warehouse Projected available balance: 85 Units Safety stock quantity: 5 units Lead time: 2 weeks Lot for lot size quantity Projected available balance: 2 Units Schedule receipt in week 1: 46 units Safety stock quantity: 8 units units Lead time: 1 week Lead time: 4 weeks Lot for lot size quantity Lot size quantity: 320 units Prepare the DRP records for product D at the Dallas warehouse and the plant warehouse as well as the MRP record for ingredient X (Assume ingredient X is…
33. During a move to a new location, the inventory records of 98 Degrees were misplaced. The bookkeeper has been able to gather some data for the July purchases: Units Unit cost Total cost July 5 10,000 65 650,000 10 12,000 70 840,000 15 15,000 60 900,000 25 14,000 55 770,000 On July 31, 17,000 units were on hand. The sales for July amounted to P6,000,000 or 60,000 units at P100 per unit. The entity always used a perpetual FIFO inventory costing system. Gross profit on sales for July was P2,400,000. What was the cost of the inventory on July 1?34. Thug Life Company provided the following information at year-end: Cost Retail Inventory, January 1 700,000 1,100,000 Purchases 4,200,000 5,700,000 Additional markup 200,000 Markdown 100,000 Sales 5,400,000 Under the approximate lower of average cost or NRV…

Recommended textbooks for you

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Practical Management Science

Operations Management

ISBN:

9781337406659

Author:

WINSTON, Wayne L.

Publisher:

Cengage,

Operations Management

ISBN:

9781259667473

Author:

William J Stevenson

Publisher:

McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi…

Operations Management

ISBN:

9781259666100

Author:

F. Robert Jacobs, Richard B Chase

Publisher:

McGraw-Hill Education

Business in Action

Operations Management

ISBN:

9780135198100

Author:

BOVEE

Publisher:

PEARSON CO

Purchasing and Supply Chain Management

Operations Management

ISBN:

9781285869681

Author:

Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson

Publisher:

Cengage Learning

Production and Operations Analysis, Seventh Editi…

Operations Management

ISBN:

9781478623069

Author:

Steven Nahmias, Tava Lennon Olsen

Publisher:

Waveland Press, Inc.

SEE MORE TEXTBOOKS