Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
8th Edition
ISBN: 9781337274852
Author: Ragsdale, Cliff
Publisher: South-Western College Pub
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, Loose-leaf Version
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_forwardKala 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=…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 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_forwardThe sales forecast for a certain product being sold at P300/bundle is P25M/month. Each bundle has 100 packs with a weight of 30grams/pack. The product undergoes the following manufacturing processes: PROCESS CAPACITY/UNIT COST/UNIT EFFICIENCY Kneading 200kg/hr P800,000 85% Cutting 60kg/hr 600,000 90 Drying 500kg/hr 1,200,000 100 Seasoning 75kg/hr 100,000 100 Packaging 2,400packs/hr 250,000 95 If the company is operating at 25 days/month @ 24-hour operation, how much money is needed for the procurement of the machines? How many factory workers are needed in a 2-shift operation if kneading requires 2 operators, cutting - 2, drying - 1, seasoning - 1 and packaging - 3?arrow_forwardThe Finishing Department had 5,000 incomplete units in its beginning Work-in-Process Inventory which were 100% complete as to materials and 30% complete as to conversion costs. 15,000 units were received from the previous department. The ending Work-in-Process Inventory consisted of 2,000 units which were 50% complete as to materials and 30% complete as to conversion costs. The Finishing Department uses first-in, first-out (FIFO) process costing.What are the equivalent units of production for the conversion costs during the period? 17,100. 14,500. 15,100. 16,500.arrow_forward
- A 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_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_forwardThe MFA Co. Ltd. presently moves pallet loads of cans from production to the truck dock for loading. The loading dock foreman claims that due to increased production the company needs to purchase five new fork trucks and to hire five persons to operate these trucks. Using the present equipment (fork trucks) the maximum load of cans that can be transported is 1500 lb. at a 13.5” load center. The fork truck currently in use is manufacturer - rated for 3,000 lb. at the 24” load center. Question: Can the pallet load capacity be increased? What, if any, new equipment is required?arrow_forward
- The ore of a gold mine in the Mountain Province contains, on the average, 2 gram of gold perton. One method of processing cost ₱1,800.00 per ton and recovers 90% of the gold, whileanother method cost only ₱1,400.00 per ton and recovers 85% of the gold. If the gold can besold at ₱8,000.00 per gram, which method is better and by how much?arrow_forwardBecause of its labor contract, a company must hire enough labor for 100 units ofproduction per week on one shift or 200 units per week on two shifts. It cannot hire,lay off, or assign overtime. During the fourth week, workers will be available fromanother department to work part or all of an extra shift (up to 100 units). There is aplanned shutdown for maintenance in the second week, which will cut production tohalf. Develop a production plan. The opening inventory is 200 units, and the desiredending inventory is 300 unitsarrow_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_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,