MindTap Business Statistics for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th Edition, [Instant Access], 2 terms (12 months)
8th Edition
ISBN: 9781337274876
Author: Cliff Ragsdale
Publisher: Cengage Learning US
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3, Problem 15QP
a)
Summary Introduction
To formulate: An linear programming model for the problem.
b)
Summary Introduction
To develop: A spreadsheet model and solve using solver.
c)
Summary Introduction
To identify: The optimal solution.
Expert Solution & Answer
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
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)…
Karen owns a roof repair service and drives a van to local client sites. During the week she drives the following distances:
· From her home to her business headquarters: 8 miles
· From her headquarters to a client site: 15 miles
· From client site back to her headquarters: 15 miles
· Trip from her headquarters back home: 8 miles
How many miles does she count for business purposes?
Group of answer choices
8 miles.
15 miles.
30 miles.
46 miles.
The Ace Manufacturing Company has orders for three similar products.
Product
A
Min
B
C
1
2
Machine
3
Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each
machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are shown below.
A
A
B
B
Ic
C
Product
1
12
3
Orders
(units)
1,900
500
1,100
Capacity
(units)
1,300
1,600
800
1
Machine
2
3
$1.00 $1.30 $1.10
$1.20 $1.40 $1.00
$0.90 $1.20 $1.20
(a) Develop the linear programming formulation of this problem. (Let XA1 be the number of units of product A produced by machine 1, X;; be the number of units of product i produced by machine j, etc.)
Chapter 3 Solutions
MindTap Business Statistics for Ragsdale's Spreadsheet Modeling & Decision Analysis, 8th Edition, [Instant Access], 2 terms (12 months)
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Refer to question 19 at the end of Chapter 2....Ch. 3 - Prob. 8QPCh. 3 - Prob. 9QPCh. 3 - Prob. 10QP
Ch. 3 - Prob. 11QPCh. 3 - Prob. 12QPCh. 3 - Prob. 13QPCh. 3 - Prob. 14QPCh. 3 - Prob. 15QPCh. 3 - Prob. 16QPCh. 3 - Prob. 17QPCh. 3 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - Prob. 26QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 28QPCh. 3 - Prob. 29QPCh. 3 - Prob. 30QPCh. 3 - Prob. 31QPCh. 3 - Prob. 32QPCh. 3 - Prob. 33QPCh. 3 - Prob. 34QPCh. 3 - Prob. 35QPCh. 3 - Prob. 36QPCh. 3 - Prob. 37QPCh. 3 - Prob. 38QPCh. 3 - Prob. 39QPCh. 3 - Prob. 40QPCh. 3 - Prob. 41QPCh. 3 - Prob. 42QPCh. 3 - Prob. 43QPCh. 3 - Prob. 44QPCh. 3 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 46QPCh. 3 - The CFO for Eagle Beach Wear and Gift Shop is in...Ch. 3 - Prob. 48QPCh. 3 - Prob. 1.1CCh. 3 - Prob. 1.2CCh. 3 - Prob. 1.3CCh. 3 - Prob. 1.4CCh. 3 - Prob. 2.1CCh. 3 - Prob. 2.2CCh. 3 - Prob. 2.3CCh. 3 - Prob. 2.4CCh. 3 - Prob. 2.5CCh. 3 - Kelly Jones is a financial analyst for Wolverine...
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_forward) The following data have been prepared for master production scheduling purposes in IKEA Australia: End product A: Beginning inventory of 60, Period forecast of 10, Lot size of 30, and 30 hours in lot size. End product B: Beginning inventory of 20, Period forecast of 5, Lot size of 20, and 20 hours in lot size. End product C: Beginning inventory of 30, Period forecast of 15, Lot size of 50, and 50 hours in lot size. Capacity: 38 hours/ week (i) Prepare the master production schedule for these items during the next four periods using the Ethan Allen master production scheduling method. (ii) Suppose that the master production schedule is frozen for the next three periods. What specific impact would the policy have on the IKEA's performance?arrow_forwardMaterial Handling Systems Case Mfa Company operates a centrally located storeroom in their manufacturing complex. Every afternoon, each craft foreman (Tin Shop, Electric Shop, Iron Workers, etc.) writes a requisition for common use items include nuts, bolts, screws, washers, flashlight batteries, and gloves. All specialty items are ordered separately. During the night shift, the storeroom personnel fill the orders items requested by the craft foreman. Each morning, one or two workers from each department to go the storeroom with a four –wheel platform truck to pick up the filled order. Question: Although studies have been performed to determine the amount of time craftsmen spend waiting the supplies, it is the thoughts of the management that idle craft manpower is a problem resulting from this procedure. How can time spent traveling and from the described storeroom be reduced, thus, eliminating or decreasing crafts’ personnel travel time?arrow_forward
- 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.arrow_forwardattle Tots makes a fiberglass tricycle for kids that is composed of three major components: a handlebar-front wheel-pedal assembly, a seat, and frame unit, and rear wheels. The company has orders for 12,000 of these tricycles. The company does not have the resources available to manufacture everything needed for the completion of 12,000 tricycles so it has gathered purchase information for each component. The following table shows relevant information: Requirements Cost to Manufacture Cost to Purchase Component Plastic Time Space Front 3 10 2 8 12 Seat/Frame 4 6 2 6 9 Rear-wheel (each) .5 2 .1 1 3 Available 50,000 160,000 30,000 Develop a linear programming model to advise the operations manager of Tattle Tots how many of each component should be manufactured and how many should be purchased in order to provide 12,000 fully completed tricycles at the minimum cost. What is your best…arrow_forwardA machine shop is tasked with processing five different products in four workstations, and operates 40 hours per week. Part-mix ratios, batch quantities, part routings, machines, servers, and production times are given in the table below for the five part styles produced in the shop. Part production times include an allowance for setup time that is based on the batch quantity for each part style. Production records indicate that the average nonproductive time associated with each operation is 10 hrs. Operation sequence for each part style is in the order of station number. Part styles are identified by letter and stations are identified by number. Determine the average lead time for all four part styles (hours, 2 decimal points). Part style (j) A B D Part mix ( p;) 0.25 0.20 0.10 0.20 0.25 Batch quantity ( Qb) 25 19 19 20 27 Stations (i) Servers ( s;) ТрА (hr) Трв (hr) Трс (hr) Tро (hr) ТРЕ (hr) 1 1 0.27 0.36 0.14 0.17 2 1 0.46 0.45 0.26 0.11 3 1 0.44 0.17 0.17 0.25 4 1 0.28 0.13 0.26…arrow_forward
- The Ace Manufacturing Company has orders for three similar products. Product Min A s.t. B C 1 2 Machine 3 Three machines are available for the manufacturing operations. All three machines can produce all the products at the same production rate. However, due to varying defect percentages of each product on each machine, the unit costs of the products vary depending on the machine used. Machine capacities for the next week and the unit costs are shown below. A A LB B Ic C Product 4 2 3 Orders (units) Machine 1 Capacity Product A Orders Machine 2 Capacity Product B Orders Machine 3 Capacity Product C Orders 1,800 X20 for all i, j. 700 1,100 Capacity (units) 1,400 (a) Develop the linear programming formulation of this problem. (Let x₁ be the number of units of product A produced by XA1 machine 1, x,, be the number of units of product i produced by machine j, etc.) 1,500 1,000 1 Machine $1.00 $1.30 $1.10 2 $1.20 $1.40 $1.00 $0.90 $1.20 $1.20 3 (b) Solve the transportation model for the…arrow_forwardPRODUCT MIX: The JP Manufacturing Company produces two products. Resource requirements for production are given in the table. There are 1500 hours of assembly worker hours available per week, 600 hours of paint time, and 200 hours of the inspection time. Regular customers will demand at least 150 units of the regular line and 90 of the super. Formulate an LP model that will determine the optimal product mix on a weekly basis. Product Profit contribution Assembly time (hr) Paint time (hr) Inspection time (hr) Product A 50 1 1/2 1/5 Product B 75 1.5 3/4 1/5arrow_forward33 White & Becker Tools (W&B) requires 2,000 elec- tric motors next month for its product line of weed trimmers. Each motor is composed of three com- ponents: a coil, a shaft, and housing. W&B has the capability to produce these components or purchase them from an outside vendor. The costs of produc- ing them and purchasing them are shown in the following table. COMPONENT Coil Shaft Housing DEPART- MENT PRODUCTION COST PER UNIT Fabrication 0.5 Molding 0.4 Inspection 0.2 $2.60 $1.80 $1.40 The components that are produced by W&B must pass through three departments: fabrication, molding, and inspection. The number of hours each component requires in each department and the total number of hours available next month in each department are shown in the following table: 0.2 0.7 0.3 PURCHASE COST PER UNIT COIL SHAFT HOUSING AVAILABILITY (HR.) (HR.) (HR.) (HR.) $3.12 $2.16 $1.68 0.6 0.3 0.4 3,000 3,000 1,800 In order to determine the number of components that will be produced and the number…arrow_forward
- A producer has three products, A, B, and C, which are composed from many of the same raw materials and subassemblies by the same skilled workforce. Each unit of product A uses 15 units of Raw Material X, one Purge System Subassembly, one Case, one Power Cord, three Labour Hours in the Assembly Department, and one Labour Hour in the Finishing Department. Each unit of product B uses 10 units of Raw Material X, five units of Raw Material Y, two Purge System Subassemblies, one Case, one Power cord, five Labour Hours in the Assembly Department, and 90 minutes in the Finishing Department. Each unit of product C uses five units of Raw Material X, 25 units of Raw Material Y, two Purge System Subassemblies, one Case, a Power Cord, seven Labour Hours in the Assembly Department, and Three Labour Hours in the Finishing Department. Labour between the Assembly and Finishing departments is not transferable, but workers within each department work on any of the three products. There are three…arrow_forwardA producer has three products, A, B, and C, which are composed from many of the same raw materials and subassemblies by the same skilled workforce. Each unit of product A uses 15 units of Raw Material X, one Purge System Subassembly, one Case, one Power Cord, three Labour Hours in the Assembly Department, and one Labour Hour in the Finishing Department. Each unit of product B uses 10 units of Raw Material X, five units of Raw Material Y, two Purge System Subassemblies, one Case, one Power cord, five Labour Hours in the Assembly Department, and 90 minutes in the Finishing Department. Each unit of product C uses five units of Raw Material X, 25 units of Raw Material Y, two Purge System Subassemblies, one Case, a Power Cord, seven Labour Hours in the Assembly Department, and Three Labour Hours in the Finishing Department. Labour between the Assembly and Finishing departments is not transferable, but workers within each department work on any of the three products. There are three…arrow_forwardMaterials Management $12.00 per purchase order Chemical Processing $7.50 per metric ton Molding $24.00 per direct labor hour Packaging $0.10 per unit Engineering designs show that the order will require direct materials that cost $540; direct labor cost will be $90. The order will require four purchas orders to be placed, use two metric tons of chemical base, and need eight direct labor hours. The size of the order is to produce 3,000 units of product. How to calculate the total production of the order?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,
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,