Use the following information to answer the question(s) below.Cerebro Manufacturing produces four types of structural support fittings-plugs, rails, rivets, and clips-which are machined on two CNC machining centers. Themachining centers have a capacity of 250,000 minutes per year. The gross margin per unit and machining requirements are shown in the spreadsheet below.DEF1123ACerebro ManufacturingModel6178Product14 Gross margin/unitMinutes/unit15Gross margin/minuteMaximum productionProfitBO 125,000O 250,000O None of the aboveCMachineRivets Clips Capacity(mins./year)Plugs Rails$0.40 $ 1.20 $0.80 $1.10131.5250,000Assuming that one half of the machine capacity is used for the production of plugs. What is the maximum possible production of plugs based on this capacity?O 166,666.6783,333.33

Capacity management is the process of ensuring that an organization has the resources it needs to…

Answered: Use the following information to answer…

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

DBS is also expecting the demand for its top-of-the range devices to increase further from the next year. Given the increase in annual requirement, the production manager is contemplating to start manufacturing the special components in-house to save costs rather than sourcing them from outside. Given the current purchase price of $9000 per unit, what will the average annual requirement need to be in order to justify making the components in-house if the variable cost of making is $6750 per unit and an upfront fixed cost of $55,000,000 is needed to procure the necessary plant and equipment? However, in the event that the expected increase in demand does not materialize and the demand is actually forecast to drop to 20,000 units next year, then what will be the maximum price per unit that DBS would be willing to pay to the supplier in order to continue buying from them? Going forward, if it is found to be a better decision to make the components in-house, DBS will then need to…
As the production planner for Xiangling Hu Products, Inc., you have been given a bill of material for a bracket that is made up of a base, 2 springs, and 4 clamps. The base is assembled from 2 clamps and 1 housing. Each clamp has 1handle and 1 casting. Each housing has 2 bearings and 2 shafts. There is no inventory on hand. c) Compute the net quantities needed if there are 25 of the base and 100 of the clamp in stock. Base: units (enter your response as a whole number). Spring: units Clamp: units Housing: units Handle units Casting: units Bearing: units Shaft: units
The Big Black Bird Company (BBBC) has a large order for special plastic-lined military uniforms to be used in an urgent military operation. Working the normal two shifts of 40 hours each per week, the BBBC production process usually produces 2,500 uniforms per week at a standard cost of $120 each. 68 employees work the first shift and 30 the second. The contract price is $220 per uniform. Because of the urgent need, BBBC is authorized to use around-the-clock production six days per week. When each of the two shifts works 72 hours per week, production increases to 3,800 uniforms per week but at a cost of $144 each. a. The multifactor productivity level for two shifts working 72 hours when compared to the level of the normal two shifts.
Ripeka, the warehouse manager at Hine would like to update the company’s inventory locator system so that the picking operation can be streamlined. While conceptually simple to do, she knows that there will be several steps to the update process that will have to be carefully managed. She needs to complete upgrade and train her staff in operating the new system before the busy season, which is only 4 months away. She identifies the various activities, expected time duration, predecessors and costs, as shown in the table. Draw the AON Network, and then determine the critical path. [Show your workings, using the grid network.] Identify the project duration – is this project feasible within the required timeframe?
Based on customer benefit packages and value chain for the restaurant business determine the order qualifier and order winners for the restaurant business?
You are the operations manager for Louisiana Oysters, Inc. The company has designed new "Oyster shucking" knife that is expected to reduce risk of injury to the user. Your firm plans to begin production of these knives soon. Either of two machines, A or B could be used for in-house production. Machine A would have a fixed cost of $6000 and a variable cost of $5 per knife produced, and machine B would have a fixed cost of $9600 but a variable cost of $3 per knife. Each knife is expected to sell for $15. Determine the Range of annual “Volume of Business“[Q], for which each of the two alternative machines would be optimal i.e. best. Hint: Compute various break-even points for your evaluation
c7 need urgent in 15 minutes
2. Four products are processed sequentially on three machines in an aircraft maintenance workshop. The following Table 1 gives the operational data of the problem. Machine 1 2 3 Unit selling price ($) Table 1: Operational data for the problem Manufacturing time (hr) per unit Cost per hr Product Product Product Product $ 1 3 4 10 2 4 2 5 1 2 4 2 1 55 45 37 75 2323 70 Capacity (hr) 500 380 450 (a) Formulate the problem as a Linear Programming (LP) problem (b) Determine the optimal product-mix in the production schedule and the optimal profit
part b
Answer using the excel screenshot format to do the question. Secondly, please use the Net flow, sign and the RHS to work on Solver.
Production data show 35,920 units were transferred out of a stage of production and 6,150 units remained in ending WIP inventory that was 100% complete to material and 35% complete to conversion. The unit material cost is $5 for material and $8 for conversion. What is the amount of inventory transferred out and remaining in ending work in process inventory? Round to the whole unit and whole dollar, no decimals. Complete the tables below: Equivalent units data Units Materials Conversion Transferred out 35,920 Ending inventory 6,150 Units accounted for, equivalent units Cost data Transferred out $ Ending work in process: materials Ending work in process: conversion Ending work in process: total Costs to account for $ please fill in the information in the grid exactly as provided
Hand written solutions are strictly prohibited

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