Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
7th Edition
ISBN: 9781285418681
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
thumb_up100%
Chapter 2, Problem 24QP
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 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.
bama 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?
Formtech 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)
Chapter 2 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
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 - Prob. 19QPCh. 2 - Prob. 20QPCh. 2 - Prob. 21QPCh. 2 - Prob. 22QPCh. 2 - Prob. 23QPCh. 2 - Prob. 24QPCh. 2 - Prob. 25QPCh. 2 - American Auto is evaluating their marketing plan...Ch. 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 - For the Lines They Are a-Changin (with apologies...
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
- 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_forwardJoan has a small design and tailoring shop making custom outfits for women. She has two employees. Each employee only begins working on a dress when a customer order has been received and then she makes the dress from beginning to end. The average production time of a dress is 1.8 days, with a standard deviation of 2.1 days. Historically, Joan has been receiving orders with interarrival times of one day on average. The interarrival times of orders have a coefficient of variation of one. (Carry at least 4 decimal places in all intermediate calculations. Round your final answer to 2 decimal places.) What is the expected waiting time, in days, between when an order is received and when production begins on the dress? A. 9.12 days B. 6.50 days C. 1.23 days D.3.41 daysarrow_forward
- A 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_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_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_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/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_forward
- A machine used for cutting materials in a factory has the following outputs per hour at various speeds and required periodic tool regrinding at intervals cited. Speed Hour Output per Tool RegrindingA 200 pieces every 8 hours B 280 pieces every 5 hours A set of tools costs 560 and can be ground twenty times. Each regrinding costs 54.00 and the time needed to regrind and change tools is 1 hour. The machine operator is paid 35.00 per hour including the time the tool is changed. The tool grinder who also sets the tools to the machine is paid 40.00 per hour. The hourly rate chargeable against the machine is 38.00, regardless of machine speed. Which speed is more ecomical? A. Speed B, 0.096/pc B Speed B, 0.087/pc C. Speed A, .054/pc D. Speed A >037/pcarrow_forwardMr. Elf owns a show store. Currently, he has 10 pairs of shoes that require resoling and polishing. He has a machine that can resole one pair of shoes at a time, and the time required for the operation varies with the type and condition of the shoe and the type of sole that is used. Shoes are polished on a machine dedicated to this purpose as well, and polishing is always done after resoling. His assistant generally does the polishing while Mr. Elf does the resoling. The resoling and polishing times (in minutes) are: Shoes 1 Resoling Time 14 Polishing Time 3 2 28 1 3 12 2 4 6 5 5 10 10 6 14 6 7 4 12 8 25 8 9 10 15 10 5 5 Determine the sequence in which these shoes should be repaired to minimize the total makespan for these 10 jobs, and answer the following questions. Based on the optimal sequence: (Enter integer only) 1. The first job to be processed is Job 2. The third job to be processed is Job 3. The fourth job to be processed is Job 4. The fifth job to be processed is Job 5. The…arrow_forwardJOHNSON’S RULE Five specialty jobs at a La Crosse, Wisconsin, tool and die shop must be processed through two workcenters (drill press and lathe). The time for processing each job follows:Work (processing) Time for Jobs (hours)JOBWORK CENTER 1(DRILL PRESS) WORK CENTER 2(LATHE)A5 2B3 6C8 4D 10 7E 7 12arrow_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,