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 14QP
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.
d)
Summary Introduction
To explain: The way the spreadsheet model will differ.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
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.)
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…
Production and Materials Purchases Budgets White Corporation’s budget calls for the following sales for next year:Quarter 1 90,000 units Quarter 3 68,000 unitsQuarter 2 76,000 units Quarter 4 96,000 unitsEach unit of the product requires 3 pounds of direct materials. The company’s policy is to begineach quarter with an inventory of product equal to 5% of that quarter’s estimated sales requirementsand an inventory of direct materials equal to 20% of that quarter’s estimated direct materials requirements for production.Required Determine the production and materials purchases budgets for the second quarter.
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_forwardA manufacturing company makes two types of water skis, a trick ski and a slalom ski. The relevant manufacturing data are given in the table. Labor-Hours per Ski Maximum Labor-Hours Available per Day 384 36 Department Fabricating Finishing Trick Ski 12 1 Slalom Ski 8 1 If the profit on a trick ski is $50 and the profit on a slalom ski is $30, how many of each type of ski should be manufactured each day to realize maximum profit? What is the maximum profit? The maximum profit is $. The maximum occurs when trick skis and slalom skis are produced.arrow_forwardHudson Corporation is considering three options for managing its data warehouse: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of dollars) depends on demand as follows: DemandStaffing Options High Medium LowOwn staff 650 650 600Outside vendor 900 600 300Combination 800 650 500(a) If the demand probabilities are 0.2, 0.5, and 0.3, which decision alternative will minimize the expected cost of the data warehouse? Outside vendorWhat is the expected annual cost associated with that recommendation? Enter your answer in thousands dollars. For example, an answer of $200 thousands should be entered as 200,000. Expected annual cost = $570000(b) Construct a risk profile for the optimal decision in part (a). The input in the box below will…arrow_forward
- Materials 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_forwardMillie wants to install a new carpet in the living room of her house. She calculated the square footage of the room and then multiplied it by a set cost factor to estimate the cost. This is an example of_________ Group of answer choices Parametric estimating Three-point estimating Bottom-up estimating Analogous estimatingarrow_forwardWorkshape Manufacturing has two classes of distributors: JIT distributors and non-JIT distributors. The JIT distributor places small, frequent orders, and the non-JIT distributor tends to place larger, less frequent orders. Both types of distributors purchase the same product. The customer activities and costs for the previous quarter are as follows: Activity JIT distributors Non-JIT distributors Sales Orders 500 30 Sales Calls 30 30 Service Calls 200 90 Average Order Size 90 1,400 Manufacturing Cost/Unit $50 $50 Customer Costs: Processing Sales Orders $160,000 Selling Goods $155,000 Servicing Goods $195,000 Total $500,000 Calculate the activity rate for selling goods. (Note: Round answer to two decimal places.) a.$2,200.50 per sales call b.$9,400.60 per sales call c.$3,550.66 per sales call d.$2,583.33 per sales call e.$4,800.40 per sales callarrow_forward
- The manufacturing plant of Carilla Ltd. specializes in crafting specialized pieces for carnival. With a monthly production capacity of 15,000 pieces, the company currently manufactures and sells 11,000 pieces per month. Typically priced at $200 per piece, the company's cost breakdown for the ongoing production level is outlined below: Variable costs that vary with number of units producedDirect materials $ 440,000Direct manufacturing labor 495,000Variable costs (for setups, materials handling, quality control, etc.)that vary with number of batches, 220 batches * $500 per batch 110,000 Fixed CostsFixed manufacturing costs 300,000Fixed marketing costs 200,000Total costs $1,545,000Carilla has just received a special one-time-only order for 4,000 pieces at $150 per piece. Accepting the special order would not affect the company’s regular business. Carilla makes pieces for its existing customers in batch sizes of 50 pieces (220 batches 50 pieces per batch = 11,000 pieces). The special…arrow_forwardThe manufacturing plant of Carilla Ltd. specializes in crafting specialized pieces for carnival. With a monthly production capacity of 15,000 pieces, the company currently manufactures and sells 11,000 pieces per month. Typically priced at $200 per piece, the company's cost breakdown for the ongoing production level is outlined below: Variable costs that vary with number of units producedDirect materials $ 440,000Direct manufacturing labor 495,000Variable costs (for setups, materials handling, quality control, etc.)that vary with number of batches, 220 batches * $500 per batch 110,000 Fixed CostsFixed manufacturing costs 300,000Fixed marketing costs 200,000Total costs $1,545,000Carilla has just received a special one-time-only order for 4,000 pieces at $150 per piece. Accepting the special order would not affect the company’s regular business. Carilla makes pieces for its existing customers in batch sizes of 50 pieces (220 batches 50 pieces per batch = 11,000 pieces). The special…arrow_forwardHERO Corporation is considering three options for managing its data processing operation: continuing with its own staff, hiring an outside vendor to do the managing (referred to as outsourcing), or using a combination of its own staff and an outside vendor. The cost of the operation depends on future demand. The annual cost of each option (in thousands of pesos) depends on demand as follows: Demand Demand Demand Staffing Options High Medium Low Own staff 352 325 300 Outsider vendor 450 300 150 Combination 400 325 250 If the decision maker knows nothing about the probabilities of the four states of nature, what is the recommended decision using:i. the optimistic approach and the conservative approach iii. the minimax regret approach iv. the Laplace methodarrow_forward
- A company that operates 10 hrs a day manufactures three products on three processes The following table summarizes the data of the problem: Minutes per unit Product Process 1 Process 2 Process 3 Unit price $4.50 $5.00 10 8 10 6 9 12 $4.00 (a) Determine the optimal product mix. (b) Use the dual prices to prioritize the three processes for possible expansion. (c) If additional production hours can be allocated, what would be a fair cost per additional hour for each process? 609 123arrow_forwardMary is a sales person for Challenge Furniture. She receives an incremental commission based on the table below. If she sells $26,000 and has already received a draw of $766.15, how much commission is still owed to Mary? level 1 1-11,700 3.7% sales volume 2 11,701-21,200 4.3% commission rate 3 over 21,200 4.7%arrow_forwardUse the following information to answer the question(s) below. Cerebro Manufacturing produces four types of structural support fittings-plugs, rails, rivets, and clips-which are machined on two CNC machining centers. The machining centers have a capacity of 250,000 minutes per year. The gross margin per unit and machining requirements are shown in the spreadsheet below. D E F 11 2 3 A Cerebro Manufacturing Model 6 17 8 Product 14 Gross margin/unit Minutes/unit 15 Gross margin/minute Maximum production Profit B O 125,000 O 250,000 O None of the above C Machine Rivets Clips Capacity (mins./year) Plugs Rails $0.40 $ 1.20 $0.80 $1.10 13 1.5 250,000 Assuming that one half of the machine capacity is used for the production of plugs. What is the maximum possible production of plugs based on this capacity? O 166,666.67 83,333.33arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Understanding BusinessManagementISBN:9781259929434Author:William NickelsPublisher:McGraw-Hill Education
Management (14th Edition)ManagementISBN:9780134527604Author:Stephen P. Robbins, Mary A. CoulterPublisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...ManagementISBN:9781305947412Author:Cliff RagsdalePublisher:Cengage Learning
Management Information Systems: Managing The Digi...ManagementISBN:9780135191798Author:Kenneth C. Laudon, Jane P. LaudonPublisher:PEARSON
Business Essentials (12th Edition) (What's New in...ManagementISBN:9780134728391Author:Ronald J. Ebert, Ricky W. GriffinPublisher:PEARSON
Fundamentals of Management (10th Edition)ManagementISBN:9780134237473Author:Stephen P. Robbins, Mary A. Coulter, David A. De CenzoPublisher:PEARSON
Understanding Business
Management
ISBN:9781259929434
Author:William Nickels
Publisher:McGraw-Hill Education
Management (14th Edition)
Management
ISBN:9780134527604
Author:Stephen P. Robbins, Mary A. Coulter
Publisher:PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract...
Management
ISBN:9781305947412
Author:Cliff Ragsdale
Publisher:Cengage Learning
Management Information Systems: Managing The Digi...
Management
ISBN:9780135191798
Author:Kenneth C. Laudon, Jane P. Laudon
Publisher:PEARSON
Business Essentials (12th Edition) (What's New in...
Management
ISBN:9780134728391
Author:Ronald J. Ebert, Ricky W. Griffin
Publisher:PEARSON
Fundamentals of Management (10th Edition)
Management
ISBN:9780134237473
Author:Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:PEARSON