The Ace Manufacturing Company has orders for three similar products.OrdersProduct (units)MinAs.t.Bс12Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products vary depending on themachine used. Machine capacities for the next week and the unit costs are shown below.Machine3AABBcс1Product23Machine 2 Capacity2,000Machine 1 Capacity6001,300Machine 3 CapacityProduct A OrdersCapacity(units)Product B Orders1,7001,6001,0001$1.00 $1.30 $1.10Use the transportation model to develop the minimum cost production schedule for the products and machines.(a) Show the linear programming formulation. (Let XA₁ be the number of units of product A produced by machine 1, X;; be the number of units of product i produced by machine j, etc.)Machine$1.20 $1.40 $1.002$0.90 $1.20 $1.203

Answered: The Ace Manufacturing Company has…

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

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…
Pranuec Company mai Tactures, assembles, and rebunds material handing equipment used Tn war ses and uistr iters. One product, called a Liftmaster, is assembled from four components: a frame, a motor, two supports, and a metal strap. Frandec's production schedule calls for 6000 Liftmasters to be made next month. Frandec purchases the motors from an outside supplier, but the frames, supports, and straps may be either manufactured by the company or purchased from an outside supplier. Manufacturing and purchase costs per unit are shown. Component Manufacturing Cost Purchase Cost Frame $39.00 $52.00 Support $12.50 $16.00 Strap $7.50 $8.50 Three departments are involved in the production of these components. The time (in minutes per unit) required to process each component in each department and the available capacity (in hours) for the three departments are as follows: Department Component Cutting Milling Shaping Frame 3.6 2.3 3.2 Support 1.4 1.8 2.7 Strap 0.9 1.8 Capacity (hours) 370 430…
Franklin Tooling, Inc., manufactures specialty tooling for firms in the paper-making industry. All of their products are engineer-to-order and so the company never knows exactly what components to purchase for a tool until a customer places an order. However, the company believes that weekly demand for a few components is fairly stable. Component 135.AG is one such item. The last 26 weeks of historical use of component 135.AG is recorded below. Week Demand Week Demand 1 2 3 4 5 6 7 8 9 10 11 12 13 137 136 143 136 141 128 149 136 134 142 125 134 118 14 15 16 17 18 19 20 21 22 23 24 25 26 131 132 124 121 127 118 120 115 106 120 113 121 119 Use OM Explorer’s Time Series Forecasting Solver to evaluate the following forecasting methods. Start error measurement in the fifth week, so all methods are evaluated over the same time interval. Use the default settings for initial forecasts.i. Naïve (1-Period Moving Average)ii. 3-Period Moving Averageiii. Exponential Smoothing,…
(a) Give examples of independent and related dependent demand (b) APL company assembles and sales an electronics device (ED) on a contract basis. End item ED has composed of 3 units of subassembly BG and 5 units of component DD. BG is assembled using 3 DDs and 4 FCs. There are orders of 500 and 875 units of the device (ED) at the beginning of week 6 and week 8. In assembling BG, an extra 20 percent scrap allowance must be added. DD can only be ordered in whole cases of 400 units per case. One case of DD is received in each of week 1 and week 2. Also, there are 200 units of BG and 425 units of DD now on hand. The lead time for the item BG, DD, and FC is 2 weeks and that is for the item ED is 1 week.i. Calculate the required number of DD and FC for producing 100 units of ED. There is no stock of any item. ii. Prepare a material requirements plan for the component DD.
Consider the following information. PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 100 Q = 60, LT= 3 weeks, Safety Stock = 5 1 70 70 PART X Gross Requirements Scheduled Receipts Projected On-Hand Inventory 100 Planned Order Releases 1 70 70 100 2 0 > X WEEK 3 40 Compute the planned order releases and projected on-hand inventory for component part X. Round your answers to the nearest whole number. If your answer is zero, enter "0". 2 0 4 0 100 WEEK 3 40 5 160 60 4 0 40 0 X 5 160 Check My Work -60 0
spaces between figures) * Your answer There are 2 policies suggested by Procurement related to inventories. Policy A suggests: Order 150 units. ROP is 50 units and the time between placing and receiving an order is 10days. Policy B suggests: Order 200 units. ROP is 75 units and the time between placing and receiving an order is 15days.Order cost is P20.00 per order and the cost of keeping inventory is P 0.02 per day. Which policy do you think is the best for the company to adopt and what is the cost. Policy A Policy B How much is the cost of production planning A using chase demand? Write your
Product A Order Qty = 400 Order Lead Time = 2 Forecast Demand Scheduled Receipts Projected Available Inventory 400 Planned Order Receipts Planned Order Releases 1 300 OD 4, 6, 2 300 400 Sketch and fill in the grid on scrap paper to use on upcoming questions In what periods would you incur a planned order release? OA 1.3, and 4 2.4, and 5 OC 3,5, and 6 and 7 3 300 PERIODS 4 300 5 300 6 300 7 100 8 100
Bhatti Company produces plastic photo frames. Two departments, molding and finishing, are involved in the manufacturing. The molding department fills the molds with hot liquid plastic that is left to cool and then opens them. The finishing department removes the plastic frame from the mold and strips the edges of the frames of extra plastic. The following information is available for the month of January: January 1 Quantity (pounds) January 31 Quantity (pounds) Work-in-Process Inventory Cost Cost Molding department Finishing department None None 5,000 $ 15,000 2,000 The WIP Inventory in the finishing department is estimated to be 40% complete for conversion both at the beginning and end of January. Costs of production for January follow: Direct Costs of Production Materials Conversion Molding department Finishing department $ 450,000 $ 90,000 80,290 The molding department started 50,000 pounds of product in January. The firm uses the FIFO method of process costing. Required: 1. Prepare…
Figure shows a partially completed MPS record for 2 inch pneumatic control valves. Suppose that you receive the following orders at right for the valves (shown in the order of their arrival). As they arrive, you must decide whether to accept or reject them. Which orders would you accept for shipment?Order Amount (Units) Week Requested1 15 22 30 53 25 34 75 7
Semans is a manufacturer that produces bracket assemblies. Demand for bracket assemblies (X) is 128 units. The following is the BOM in indented form: DESCRIPTION Bracket assembly Wall board Hanger subassembly Hanger casting Ceramic knob Rivet head screw Metal tong Plastic cap USAGE 1 ITEM X A B D E 5 F G 3 1 Below is a table indicating current inventory levels: Item X 26 D 196 F G 95 Inventory 17 69 17 145 1,220 b. What are the net requirements for each item? (Leave no cells blank - be certain to enter "0" wherever required.) Item Net Requirements A B C D F G
Production Company Universal Controlsmanufactures control units. Their new models areeI Argon I and eI Argon II. To make each unit ofArgon I, use 6 meters and 3 controllers. For fa-craft each unit of Argon II, they use 10 meters and Scontrollers. The company receives a total of 760 me-managers and daily controllers of their suppliers.How many units of each model can you produce?seriously? Assume that all parts are used. Note: Solve freely # OF ARGON UNITS I # OF ARGON UNITS II
Demand for portable music players for joggers has caused Nancy Industries (Nancy) to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nancy expects demand for music player to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demands for the players for last year was as follows : Month Demand (units) Jan 4200 Feb 4300 Mar 4000 Apr 4400 May 5000 Jun 4700 Jul 5300 Aug 4900 Sep 5400 Oct 5700 Nov 6300 Dec 6000 Question : From the choice of simple moving average, weighted moving average, exponential smoothing, and linear regression analysis, which forecasting technique would you consider the most accurate to Nancy Industries? Why?

SEE MORE QUESTIONS

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