Essentials of Business Analytics (MindTap Course List)
2nd Edition
ISBN: 9781305627734
Author: Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 11, Problem 19P
The Calhoun Textile Mill is in the process of deciding on a production schedule. It wishes to know how to weave the various fabrics it will produce during the coming quarter. The sales department has continued orders for each of the 15 fabrics produced by Calhoun. These demands are given in the following table. Also given in this table is the variable cost for each fabric. The mill operates continuously during the quarter: 13 weeks, 7 days a week, and 24 hours a day.
There are two types of looms: dobbie and regular. Dobbie looms can be used to make all fabrics and are the only looms that can weave certain fabrics, such as plaids. The rate of production for each fabric on each type of loom is also given in the table. Note that if the production rate is zero, the fabric cannot be woven on that type of loom. Also, if a fabric can be woven on each type of loom, then the production rates are equal. Calhoun has 90 regular looms and 15 dobbie looms. For this problem, assume that the time requirement to change over a loom from one fabric to another is negligible.
Management would like to know how to allocate the looms to the fabrics and which fabrics to buy on the market so as to minimize the cost of meeting demand.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
The Lawson Fabric Mill Produces five different fabrics. Each fabric can be woven on one or more of the mill’s 36 looms. The sales department’s forecast of demand for the next month is shown in below Table 1, along with data on the selling price per yard, variable cost per yard, and purchase price per yard. The mill operates 24 hours a day and is scheduled for 30 days during the coming month. The mill has two types of looms: draw and regular. The draw looms are more versatile and can be used for all five fabrics. The regular looms can produce only three of the fabrics. The mill has a total of 36 looms: 8 are draw and 28 are regular. The rate of production for each fabric on each type of loom is given in below Table 2. The time required to change over from producing one fabric to another is negligible and does not have to be considered.
The Lawson Fabric Mill satisfies all demand with either its own fabric or fabric purchased from another mill. Fabrics that cannot be woven at the…
A furniture store expects to sell 120 coffee tables during the next year. It costs $1.50 to store one coffee table for one year. To reorder, there is a
fixed cost of $10, plus $2.80 for each coffee table ordered. In what lot size and how many times per year should an order be placed to minimize
inventory costs?
coffee tables per order
orders per year
A contractor, Susan Meyer, has to haul gravel to three building sites. She can purchase as much as 18 tons at a gravel pit in the north
of the city and 14 tons at one in the south. She needs 10, 5, and 10 tons at sites 1, 2, and 3, respectively. The purchase price per ton
at each gravel pit and the hauling cost per ton are given in the table below. Susan wishes to determine how much to haul from each pit
to each site to minimize the total cost for purchasing and hauling gravel.
Hauling Cost per Ton at Site
Pit
1
3
Price per Ton
North
$30
$60
$50
$100
South
$60
$30
$40
$120
Now suppose that trucks (and their drivers) need to be hired to do the hauling, where each truck can only be used to haul gravel from
a single pit to a single site. Each truck can haul 5 tons, and the cost per truck is five times the hauling cost per ton given above. Only
full trucks would be used to supply each site.
a. Formulate this problem as an assignment problem by constructing the appropriate cost table,…
Chapter 11 Solutions
Essentials of Business Analytics (MindTap Course List)
Ch. 11 - Kelson Sporting Equipment, Inc., makes two types...Ch. 11 - The Sea Wharf Restaurant would like to determine...Ch. 11 - Blair Rosen. Inc. (BR) is a brokerage firm that...Ch. 11 - Round Tree Manor is a hotel that provides two...Ch. 11 - Industrial Designs has been awarded a contract to...Ch. 11 - Vollmer Manufacturing makes three components for...Ch. 11 - Photon Technologies, Inc., a manufacturer of...Ch. 11 - The Westchester Chamber of Commerce periodically...Ch. 11 - The management of Hartman Company is trying to...Ch. 11 - The employee credit union at State University is...
Ch. 11 - The Atlantic Seafood Company (ASC) is a buyer and...Ch. 11 - The Silver Star Bicycle Company will manufacture...Ch. 11 - The Clark County Sheriff’s Department schedules...Ch. 11 - Bay Oil produces two types of fuel (regular and...Ch. 11 - Consider the following network representation of a...Ch. 11 - Refer to the transportation problem described in...Ch. 11 - Aggie Power Generation supplies electrical power...Ch. 11 - The Calhoun Textile Mill is in the process of...Ch. 11 - Refer to the Calhoun Textile Mill production...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, statistics and related others by exploring similar questions and additional content below.Similar questions
- If during the following year it is predicted that each comedy skit will generate 30 thousand and each musical number 20 thousand, find the maximum income for the year. A television program director must schedule comedy skits and musical numbers for prime-time variety shows. Each comedy skit requires 2 hours of rehearsal time, costs 3000, and brings in 20,000 from the shows sponsors. Each musical number requires 1 hour of rehearsal time, costs 6000, and generates 12,000. If 250 hours are available for rehearsal and 600,000 is budgeted for comedy and music, how many segments of each type should be produced to maximize income? Find the maximum income.arrow_forwardThe following table shows the expenses and income for a local college student. Assume that amounts shown for salaries and wages are after taxes and that 1 month = 4 weeks. Income Expenses Part-time Job: $1100/month Rent: $550/month Student Loans: $8400/year Groceries: $50/week Scholarship: $5700/year Tuition and Fees: $7500/year Health Insurance: $40/month Entertainment: $40/week Phone: $65/month a) What is the student's monthly income? b) What is the student's monthly expenses? c) What is the student's net monthly cash flow?arrow_forwardFlint lab produces 4 high tech product types. Each of the products must be wired, drilled, assembled and checked for quality standard before being delivered to consumers. The time requirement and profit for each product are as follows. Product A: 0.5 hr for wiring, 3 hrs for drilling, 1 hr for assembling, and 0.5 hr for inspection. One product A can be sold for $10 per unit. Product B: 1.5 hr for wiring, 1 hrs for drilling, 3 hrs for assembling, and 1 hr for inspection. One product B can be sold for $13 per unit. Product C: 1.5 hr for wiring, 2 hrs for drilling, 3 hrs for assembling, and 0.5 hr for inspection. One product C can be sold for $16 per unit. Product D: 1 hr for wiring, 3 hrs for drilling, 2 hrs for assembling, and 0.5 hr for inspection. One product D can be sold for $12 per unit. The maximum capacity for wiring, drilling, assembly, and inspection are 1500 hrs; 2350 hrs; 2600 hrs; and 1200 hrs respectively. Flint lab requires that there will be at least 150 units of A, 100…arrow_forward
- A publishing company sells 400,000 copies of a certain book each year. Ordering the entire amount printed at the beginning of the year ties up valuable storage space and capital. However, printing the copies in several partial runs throughout the year results in added costs for setting up each printing run, which costs $1000. The carrying costs, figured on the average number of books in storage, are $.50 per book. Find the most economical lot size, that is, the production run size that minimizes the total setting up andcarrying costs.arrow_forwardA local consulting firm currently has 5 jobs that have to be completed by its contract employees. After analyzing the time that it would take each specific employee to complete each specific job, and, the wages each specific employee is paid per hour, it determined how much it would cost if specific employees were assigned to specific jobs. These costs were calculated to be: Cost ($) Job Employee 1 2 3 4 5 A 1,200 1,850 1,375 3,500 1,900 B 1,175 1,920 1,540 3,375 2,050 C 1,080 1,885 1,475 3,400 2,010 D 1,190 1,905 1,400 3,600 2,100 E 1,250 1,900 1,390 3,520 1,975 F 1,200 1,950 1,465 3,400 1,950 G 1,075 1,820 1,480 3,250 1,920 a. If each employee can only be assigned at most one job and each job requires only one employee, which employees should be assigned to…arrow_forwardMarcia Baker is the new manager of the materials storeroom for Keller Manufacturing. Marcia has been asked to estimate future monthly purchase costs for part #696, used in two of Keller's products. Marciahas purchase cost and quantity data for the past 9 months as follows: Month Cost of Purchase Quantity Purchased January $12,410. 2,730 parts February. 12,880 2,880 March 17,505 4,148 April 15,869 3,761 May 13,170 2,912 June 13,867 3,332 July 15,237 3,644 August 10,061 2,287 September 14,960 3,582 Estimated monthly purchases for this part based on expected demand of the two products for the rest of the year are as follows: Month Purchase Quantity Expected October…arrow_forward
- A Company produces precision medical diagnostic equipment at two factories. Three medical centers have placed orders for this month’s production output. The table Below shows what the cost would be for shipping each unit from each factory to each of these customers. Also shown are the number of units that will be produced at each factory and the number of units ordered by each customer. A decision now needs to be made about the shipping plan for how many units to ship from each factory to each customer. Formulate a linear programming model for this problem. In the given probelm, company produces precision medical diagnostic equipment at two factories i.e.,Fatory 1 and Factory 2. Three medical centers i.e., Customer 1, Customer 2, Customer 3 have placed orders for this month’s production output. Consider variables xijxij that denotes the number of units that are shipped from factory ii to customer jj. Where i=1,2 and j=1,2,3Where i=1,2 and j=1,2,3 The objective function is given by…arrow_forwardA Company produces precision medical diagnostic equipment at two factories. Three medical centers have placed orders for this month's production output. The table Below shows what the cost would be for shipping each unit from each factory to each of these customers. Also shown are the number of units that will be produced at each factory and the number of units ordered by each customer. A decision now needs to be made about the shipping plan for how many units to ship from each factory to each customer. Formulate a linear programming model for this problem.Solve for the Constraints.arrow_forwardA Company produces precision medical diagnostic equipment at two factories. Three medical centers have placed orders for this month’s production output. The table Below shows what the cost would be for shipping each unit from each factory to each of these customers. Also shown are the number of units that will be produced at each factory and the number of units ordered by each customer.A decision now needs to be made about the shipping plan for how many units to ship from each factory to each customer. Formulate a linear programming model for this problem.arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
College Algebra (MindTap Course List)AlgebraISBN:9781305652231Author:R. David Gustafson, Jeff HughesPublisher:Cengage Learning
Algebra: Structure And Method, Book 1AlgebraISBN:9780395977224Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. ColePublisher:McDougal Littell
Holt Mcdougal Larson Pre-algebra: Student Edition...AlgebraISBN:9780547587776Author:HOLT MCDOUGALPublisher:HOLT MCDOUGAL
College Algebra (MindTap Course List)
Algebra
ISBN:9781305652231
Author:R. David Gustafson, Jeff Hughes
Publisher:Cengage Learning
Algebra: Structure And Method, Book 1
Algebra
ISBN:9780395977224
Author:Richard G. Brown, Mary P. Dolciani, Robert H. Sorgenfrey, William L. Cole
Publisher:McDougal Littell
Holt Mcdougal Larson Pre-algebra: Student Edition...
Algebra
ISBN:9780547587776
Author:HOLT MCDOUGAL
Publisher:HOLT MCDOUGAL
Solve ANY Optimization Problem in 5 Steps w/ Examples. What are they and How do you solve them?; Author: Ace Tutors;https://www.youtube.com/watch?v=BfOSKc_sncg;License: Standard YouTube License, CC-BY
Types of solution in LPP|Basic|Multiple solution|Unbounded|Infeasible|GTU|Special case of LP problem; Author: Mechanical Engineering Management;https://www.youtube.com/watch?v=F-D2WICq8Sk;License: Standard YouTube License, CC-BY
Optimization Problems in Calculus; Author: Professor Dave Explains;https://www.youtube.com/watch?v=q1U6AmIa_uQ;License: Standard YouTube License, CC-BY
Introduction to Optimization; Author: Math with Dr. Claire;https://www.youtube.com/watch?v=YLzgYm2tN8E;License: Standard YouTube License, CC-BY