Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
8th Edition
ISBN: 9781305947412
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
thumb_up100%
Chapter 2, Problem 25QP
a)
Summary Introduction
To formulate: An LP model for the problem.
b)
Summary Introduction
To sketch: The feasible region for the problem.
c)
Summary Introduction
To calculate: The optimal solution using corner points.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
A diabetic patient needs at least 40 units of Vit. A, at least 30 units of Vit. C, and atleast 30 units of Vit. E each day. Each brand X multivitamin capsule contains 4 units of
Vit. A, 6 units of Vit. C, and 2 units of Vit. E; each brand Y capsule contains 5 units of Vit.A, 3 units of Vit.C, and 5 units of Vit. E. If each brand X capsule costs P6.00 and eachbrand Y capsule costs P9.00, how many capsules should the patient take each day tominimize the costs? Solve using graphical method. Show complete solution.
The ABC Company is planning a new product line and a new plant to produce the parts for the line. The product line will include 8 different models. Annual production of each model is expected to be 900 units. Each product will be assembled of 180 components. All processing of parts will be accomplished in the new plant. On average, 6 processing operations are required to produce each component, and each operation takes an average of 1 min (including an allowance for setup time and part handling). All processing opera-tions are performed at workstations, each of which includes a production machine and a human worker. The plant operates one shift. Determine the number of (a) components, (b) processing operations, and (c) workers that will be needed to accomplish the processing operations if each worker works 2,000 hr/yr.
A manufacturing plant produces a product 'A' that requires one unit of 'B' and ½ unit of 'C'. Each unit of 'B' is comprised of one unit of 'D', two units of 'E', and one unit of 'F'. Each unit of 'C' requires ½ unit of 'G' and three units of 'H'. The manufacturing lead times for the components are as follows: 'A' - two weeks, 'B' - one week, 'C' - two weeks, 'D' - two weeks, 'E' - three weeks, 'F' - one week, 'G' - two weeks, 'H' - one week. There are 20 units in stock for each of these components. 100 units of 'A' are needed for delivery in seven weeks: a) Develop the product structure and indexed bill of materials for the product. b) Create a gross and net requirements plan for the manufacturer of the product.
Chapter 2 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
Ch. 2 - Prob. 1QPCh. 2 - Prob. 2QPCh. 2 - Prob. 3QPCh. 2 - Prob. 4QPCh. 2 - Prob. 5QPCh. 2 - Prob. 6QPCh. 2 - Prob. 7QPCh. 2 - Prob. 8QPCh. 2 - Prob. 9QPCh. 2 - Prob. 10QP
Ch. 2 - Prob. 11QPCh. 2 - Prob. 12QPCh. 2 - Prob. 13QPCh. 2 - Prob. 14QPCh. 2 - Prob. 15QPCh. 2 - Prob. 16QPCh. 2 - Prob. 17QPCh. 2 - Prob. 18QPCh. 2 - American Auto is evaluating their marketing plan...Ch. 2 - Prob. 20QPCh. 2 - Prob. 21QPCh. 2 - Prob. 22QPCh. 2 - Prob. 23QPCh. 2 - Prob. 24QPCh. 2 - Prob. 25QPCh. 2 - Prob. 26QPCh. 2 - Prob. 1.1CCh. 2 - Prob. 1.2CCh. 2 - Prob. 1.3CCh. 2 - Prob. 1.4CCh. 2 - Prob. 1.5CCh. 2 - Prob. 1.6CCh. 2 - Prob. 1.7CCh. 2 - Prob. 1.8CCh. 2 - Prob. 1.9CCh. 2 - Prob. 1.10C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.Similar questions
- A diabetic patient needs at least 40 units of Vit. A, at least 30 units of Vit. C, and at least 40 units 30 units of Vit. E each day. Each brand X multivitamin capsule contains 4 units of Vit. A, 6 units of Vit. C, and 2 units of Vit. E; each brand Y capsule contains 5 units of Vit. A, 3 units of Vit.C, and 5 units of Vit. E. If each brand X capsule costs P6.00 and each brand Y capsule costs P9.00, how many capsules should the patient take each day to minimize the costs?arrow_forwardbama pie company's assembly line operations (the assembly line operates for six hundred minutes per day) comprise of eleven tasks, with the longest task time being 2.4 minutes and the shortest task time being 0.4 minutes; the sum of the task times is eighteen minutes. the firm is working on balancing its assembly line operations. the firm needs to produce 200 pies per day; to achieve this, the firm calculates the required cycle time as ---- minutes?arrow_forwardFormtech Inc. produces transformers. Each order is custom designed and manufactured for the customer. Each order goes through 3 phases: Transformer Design, which takes 4 weeks. Procurement, which has a lead time of 8 weeks. Assembly and Testing, which takes 4 weeks The design group can handle only 4 projects at any given time. The other groups are not capacity constrained. How much total work-in-process (number of projects started but not yet completed) does the company typically have? (Hint: Little's Law)arrow_forward
- Company ZWZ manufactures three products in a serial system; Product XA is manufactured in Stage 1, Product XB in Stage 2, and XC in Stage 3. Product XB has a sales potential in the market; hence, some of it can be sold at the end of Stage 2, and the remaining can be moved to Stage 3. The third stage produces Product XC, and then delivers it to customers. Two units of Product XA produced in Stage 1 are required for each unit of Product XB in Stage 2. In addition, four units of Product XB produced in Stage 2 are required for each unit of Product XC in Stage 3. Stage 1 can only use regular time; however, Stage 2 has the options of using regular time and overtime in manufacturing. On the other hand, Stage 3 has only one alternative, which is subcontracting. The pertinent data are provided below: Stage 2 Stage 1 11 No overtime No subcontracting No sales 0.07 Unit regular time cost (TL) Unit overtime cost (TL) Unit subcontracting cost (TL) Unit selling price (TL) Unit processing time (hrs)…arrow_forwardGreen Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/40 of a day and 1/75 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/45 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $275 and $225, respectively, per vehicle sold. The aim of the objective function for Green Vehicle Inc. should be to Maximize the objective value. The optimum solution is: Number of trucks to be produced per day = nothing (round your response to two decimal places).arrow_forwardA Support Labor Staff lifts bricks from 30, 53-ft long trailers in their 8-hr shift using forklifts. The typical 53-ft trailer holds 26 pallets of bricks. The warehouse receives in the first half of the shift and ships in the second half of the shift. The work standard for forklift operations is listed below: Load/unload pallet from trailer 45 sec Move from dock to warehouse or warehouse to dock 120 sec Load/unload pallet from Truck 30 sec Move within warehouse 60 sec Calculate the number of forklifts needed to process all the pallets is most nearly: А. 7 В. 9 С. 10 D. 11arrow_forward
- Green Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/25 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/45 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicle sold. The optimum solution is: Number of trucks to be produced per day = ? (round your response to two decimal places).arrow_forwardGreen Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/25 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/45 of a day to assemble either type of vehicle in the assembly shop. A T1 truck and a C1 car yield profits of $300 and $220, respectively, per vehicle sold. The aim of the objective function for Green Vehicle Inc. should be to Maximize the objective value. Part 2 The optimum solution is: Number of trucks to be produced per day = ? enter your response herearrow_forwardGreen Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/40 of a day and 1/60 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/50 of a day to assemble either type of vehicle in the assembly shop. AT1 truck and a C1 car yield profits of $325 and $220, respectively, per vehicle sold. The aim of the objective function for Green Vehicle Inc. should be to Maximize the objective value. The optimum solution is: Number of trucks to be produced per day = 240 (round your response to two decimal places).arrow_forward
- Green Vehicle Inc., manufactures electric cars and small delivery trucks. It has just opened a new factory where the C1 car and the T1 truck can both be manufactured. To make either vehicle, processing in the assembly shop and in the paint shop are required. It takes 1/25 of a day and 1/75 of a day to paint a truck of type T1 and a car of type C1 in the paint shop, respectively. It takes 1/50 of a day to assemble either type of vehicle in the assembly shop. AT1 truck and a C1 car yield profits of $325 and $250, respectively, per vehicle sold. The aim of the objective function for Green Vehicle Inc. should be to Maximize the objective value. The optimum solution is: Number of trucks to be produced per day = 12.50 (round your response to two decimal places). Number of cars to be produced per day = 37.50 (round your response to two decimal places). Optimal solution value =(round your response to two decimal places).arrow_forwardThere is an upstream Picking department that feeds two downstream Packing departments: Pack Singles and Pack Multis. Those Packing departments feed to a Shipping department that loads the outgoing trucks. 40% of your Pick volume goes to Pack Singles and has a packing rate of 104 units per labor hour (uph). 60% of the Pick volume goes to Pack Multis and has a pack rate of 215 units per labor hour. Your pickers pick both Single and Multi items throughout the day at an overall average rate of 114 units per labor hour. All units that are packed in both processes go through the Ship process at a rate of 570 units per hour. You have 102 people today for all 4 departments and you absolutely must pack 47,880 units in Pack Multis Items to meet a customer promise metric. How do you allocate labor to balance the flow in your department if you work a 10 hour shift? Do not assume breaks or lunches in your answer. Redirect 1: You now need to process all of the Pack Singles Volume in the first 5…arrow_forwardTwo vital stages in a production process are assembly I and assembly II. The unit load for the assembly I stage is 7.0 ( 50% higher for high skill) minutes, while it is 10.0 (30 % higher for high skill) minutes for assembly II. There are 7 employees working in assembly I and 8 employees working in assembly II. 65% of low skill labor and 35% of high skill labor are required at both stages. . On average 18% of the operating time is wasted, what's the theoretical unit load for Assembly II? answer is 9.06 please explainarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,