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
Chapter 2, Problem 15QP
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 level
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these 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)…
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.
Kala is one of the top manufacturer of ukuleles. The manufacturer produces three different
types of ukuleles. Its Concert produce $6 in profit per unit; its Soprano produce $4 in profit
per unit; and its Tenor produce $8 in profit per unit. Each type of ukulele passes through three
manufacturing stages as a part of the entire production process. The three process centers of
modelling, curing and assembly has an available production time per day of 12 hours, 14
hours and 16 hours, respectively. To produce one hundred units of Concert, the time required
for the process of modelling, curing and assembly is 2 hours, 3 hours and 2 hours,
respectively. To produce one hundred units of Soprano, 2 hours of modelling, 2 hours of
curing and 1 hour of assembly is required. Whereas 4 hours of modelling, 2 hours of curing
and 2 hours of assembly is required to produce one hundred units of Tenor. Sensitivity report
of the problem is given as below where C = unit of Concert to be produced each day, S=…
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
- The Tinkan Company produces one-pound cans for the Canadian salmon industry. Each year the salmon spawn during a 24-hour period and must be canned immediately. Tinkan has the following agreement with the salmon industry. The company can deliver as many cans as it chooses. Then the salmon are caught. For each can by which Tinkan falls short of the salmon industrys needs, the company pays the industry a 2 penalty. Cans cost Tinkan 1 to produce and are sold by Tinkan for 2 per can. If any cans are left over, they are returned to Tinkan and the company reimburses the industry 2 for each extra can. These extra cans are put in storage for next year. Each year a can is held in storage, a carrying cost equal to 20% of the cans production cost is incurred. It is well known that the number of salmon harvested during a year is strongly related to the number of salmon harvested the previous year. In fact, using past data, Tinkan estimates that the harvest size in year t, Ht (measured in the number of cans required), is related to the harvest size in the previous year, Ht1, by the equation Ht = Ht1et where et is normally distributed with mean 1.02 and standard deviation 0.10. Tinkan plans to use the following production strategy. For some value of x, it produces enough cans at the beginning of year t to bring its inventory up to x+Ht, where Ht is the predicted harvest size in year t. Then it delivers these cans to the salmon industry. For example, if it uses x = 100,000, the predicted harvest size is 500,000 cans, and 80,000 cans are already in inventory, then Tinkan produces and delivers 520,000 cans. Given that the harvest size for the previous year was 550,000 cans, use simulation to help Tinkan develop a production strategy that maximizes its expected profit over the next 20 years. Assume that the company begins year 1 with an initial inventory of 300,000 cans.arrow_forwardA 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.arrow_forwardIn order to produce 1000 units of X in a week units X is scheduled weekly for Operation B (due to 5% scrap ratio) units X is scheduled weekly for Operation A (due to 2% scrap ratio) Based on your answer in part a, find the number of machines required to produce 1000 units of X per week. The total time required to perform Operation B = minutes per week The total time required to perform Operation A = minutes per week H= Available Time in a week = minutes /week Thus FA = . FB = . Since both of the operations A and B are performed on the same machine machines are requiredarrow_forward
- 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_forwardA Company produces a component for use in the aerospace industry. The component consists of three parts (A, B and C), which are purchased externally and cost 50c, 60c and 70c per piece respectively. Parts A and B are assembled first on assembly line 1, which produces 150 components per hour. Part C undergoes a drilling operation before being finally assembled with the output from assembly line 1. There are six drilling machines in total, but only three are currently operational. Each drilling machine drills part C at a rate of 30 parts per hour. The final assembly line has a production capacity of 100 components per hour. At present, components are produced eight hours a day, five days a week. If the need arises, management can add a second shift of eight hours for the assembly lines only. The cost of assembly labour is 40c per assembly operation for each assembly line; the cost of drilling labour is 20c per part. For drilling, the cost of electricity is 10c per part. The overhead cost…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
- Kinga Doll Company manufactures eight versions of its popular girl doll, Shari. The company operates on a 40-hour workweek. The eight versions differ in doll skin, hair, and eye color, enabling most children to have a doll with a similar appearance to them. It currently sells an average of 4,000 dolls (spread equally among its eight versions) per week to boutique toy retailers. In simplified terms, doll making at Kinga involves three basic operations: molding the body and hair, painting the face, and dressing the doll. Changing over between versions requires setup time at the molding and painting stations due to the different colors of plastic pellets, hair, and eye color paint required. Table 7.5 lists the setup times for a batch and the activity times for each unit at each step. process setup molding painting dressing setup time (min) 12 29.00 no setup processing time (min) .24 0.17 0.27 a. What is the process capacity in dolls per hour with a batch size of 475 dolls? b.…arrow_forwardA custom motor cycle shop is experiencing high demand from its customers for its services. The owner performs all tasks relating to customization. Assume each customer brings one motor cycle for customization. The owner needs to determine if he needs to add more help to meet customer demand. A week has 40 hours ( maximum amount of time for the owner to work) The maximum number of customizations that can be done per week is 10 bikes ( if there is no wasted time). The following is the data collected from observations for a typical week : Every Friday the shop is cleaned by the owner. This takes 4 hours. - 15 % of the customizations needs rework which takes 50 % more time than regular customization - 10 % of the customers will be called by the owner. This takes 2 hours per customer. Determine OEE. How should the owner handle the business ? Show all formulas used, calculations and results. Do on Blk Bd For the toolbar, press ALT+F10 (PC) or ALT+FN+F10 (Mac).arrow_forwardQuitmeyer Elec-tronics Incorporated manufactures the following six microcomputer peripheral devices: internal mo-dems, external modems, graphics circuit boards, CD drives, hard disk drives, and memory expansionboards. Each of these technical products requirestime, in minutes, on three types of electronic testingdevices, as shown in the table on this page.The first two test devices are available 120hours per week. The third (device 3) requires morepreventive maintenance and may be used only 100 hours each week. The market for all six computer components is vast, and Quitmeyer Electronics be-lieves that it can sell as many units of each product as it can manufacture. The table that follows summa-rizes the revenue and material cost for each product: DEVICE REVENUE PERUNIT SOLD ($) MATERIAL COSTPER UNIT ($)Internal modem 200 35External modem 120 25Graphics circuit board 180 40CD drive 130 45Hard disk drive 430 170Memory expansionboard 260 60 In addition, variable labor costs are $15…arrow_forward
- JCL Inc. is a major chip manufacturing firm that sells its products to computer manufacturers like Dell, Gateway, and others. In simplified terms, chip making at JCL Inc. involves three basic operations: depositing, patterning, and etching. Depositing: Using chemical vapor deposition (CVD) technology, an insulating material is deposited on the wafer surface, forming a thin layer of solid material on the chip. Patterning: Photolithography projects a microscopic circuit pattern on the wafer surface, which has a light-sensitive chemical like the emulsion on photographic film. It is repeated many times as each layer of the chip is built. Etching: Etching removes selected material from the chip surface to create the device structures. The table below lists the required processing times and setup times at each of the steps. There is unlimited space for buffer inventory between these steps. Assume that the unit of production is a wafer, from which individual chips are cut at a later…arrow_forwardJCL Inc. is a major chip manufacturing firm that sells its products to computer manufacturers like Dell, HP, and others. In simplified terms, chip making at JCL Inc. involves three basic operations: depositing, patterning, and etching. Depositing: Using chemical vapor deposition (CVD) technology, an insulating material is deposited on the wafer surface, forming a thin layer of solid material on the chip. Patterning: Photolithography projects a microscopic circuit pattern on the wafer surface, which has a light-sensitive chemical like the emulsion on photographic film. It is repeated many times as each layer of the chip is built. Etching: Etching removes selected material from the chip surface to create the device structures. The following table lists the required processing times and setup times at each of the steps. Assume that the unit of production is a wafer, from which individual chips are cut at a later stage. Note: A setup can only begin once the batch has arrived at the…arrow_forwardDuring an eight-hour shift, 750 non-defective parts are desired as a result of a manufacturing operation. The default operation time is 15 minutes. As the operators of machine are inexperienced, the actual time they take to perform the operation is 20 minutes, and, on average, a fifth of the parts that start to be manufactured are lost. Assuming that each one of the machines used in this operation will not be available for one hour in each shift, determine the number of machines needed.arrow_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,