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 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
Want to see the full answer?
Check out a sample textbook solutionStudents 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
Spreadsheet Modeling & Decision Analysis: A Practical Introduction to Business Analytics (MindTap Course List)
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 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_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_forward
- attle 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_forwardThe 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_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
- PRODUCT 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_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_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_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_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
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,