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 3, Problem 32QP
a)
Summary Introduction
To formulate: A 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 calculate: The maximum amount of steam that can be produced per hour.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
There are two companies manufacturing drones. Company A manufactures mass market drones, while company B manufactures customised drones according to customers’ requirements. In 2020, company A produces 3,200 drones, 3% of which were found to be defective and cannot pass the quality check. Company A employs 5 workers working an average of 8 hours a day in the drone production, and they worked 200 working days in 2020.In contrast, company B produces 900 drones, 10% of which were found to be defective and cannot pass the quality check. Company B employs 3 workers working an average of 6 hours a day in the drone production, and they worked 170 days in 2020.
(a) If the drone manufacturing is seen as a process, what is considered as the output of the production processes of companies A and B and why?
(b) Measure the single-factor manpower productivity for the two companies.
(c) Is it reasonable to compare the manpower productivity of the two companies and reach a conclusion that one company…
Digital Controis, Inc. (DCI), manufactures two models of a radar gun used by police to monitor the speed of automobiles. Model A has an accuracy of plus or minus 1 mile per hour, whereas the
smaller model B has an accuracy of plus or minus 3 miles per hour.
For the next week, the company has orders for 100 units of model A and 150 units of model B. Although DCI purchases all the electronic components used in both models, the plastic cases for both
models are manufactured at a DCI plant in Newark, New Jersey. Each model A case requires 4 minutes of injection-molding time and 6 minutes of assembly time. Each model B case requires 3
minutes of injection-molding time and 8 minutes of assembly time. For next week, the Newark plant has 600 minutes of injection-molding time avallable and 1,080 minutes of assembly time availab
The manufacturing cost is $10 per case for model A and $6 per case for model B. Depending upon demand and the time avalable at the Newark plant, DCI occasionally…
As part of a quality improvement initiative, Consolidated Electronics employees complete a three-day training program on teaming and a two-day training program on problem-solving. The manager of quality improvement has requested that at least 8 training programs on teaming and at least 10 training programs on problem-solving be offered during the next six months. In addition, senior-level management has specified that at least 25 training programs must be offered during this period. Consolidated Electronics uses a consultant to teach the training programs. During the next quarter, the consultant has 84 days of training time available. Each training program on teaming costs $10,000 and each training program on problem-solving costs $8,000.
a. Formulate a linear programming model that can be used to determine the number of training programs on teaming and the number of training programs on problem-solving that should be offered in order to minimize total cost.b. Graph the feasible…
Chapter 3 Solutions
Spreadsheet Modeling & Decision Analysis: A Practical Introduction To Business Analytics, Loose-leaf Version
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 Northwoods General Store in Vermont sells a variety of outdoor clothing items and equipment and several food products at its modern but rustic-looking retail store. Its food products include salmon and maple syrup. The store also runs a lucrative catalog operation. One of its most popular products is maple syrup, which is sold in metal half-gallon cans with a picture of the store on the front. Maple syrup was one of the first products the store produced and sold, and it continues to do so. Setting up the syrup-making equipment to produce a batch of syrup costs $450. Storing the syrup for sales throughout the year is a tricky process because the syrup must be kept in a temperature-controlled facility. The annual cost of carrying a gallon of the syrup is $15. Based on past sales data, the store has forecasted a demand of 7,500 gallons of maple syrup for the coming year. The store can produce approximately 100 gallons of syrup per day during the maple syrup season, which runs from…arrow_forwardMansfield Energy Corp has recently taken over a fuel supply plant that is in close proximity to one of its competitors. The collection point for both fuel companies is located at the same seaport. The general manager of Mansfield Energy Corp intends to hire a consultant to train Mansfield Energy Corp’s employees regarding the new procedures for affixing the fuel lines at the collection point to the high-capacity storage tanks and is debating whether the competitor should be invited to attend given that they use the same seaport. The general manager is mindful of the high cost of hiring the consultant and sourcing the equipment to train Mansfield Energy Corp’s employees and is therefore hesitant to invite his competitors. The manager is also aware that there have been no accidents at the port since operations started 10 years ago and might not invite the competitors to participate in the training. The General Manager decides, based on the high price for the consultant (facilitation fee,…arrow_forwardGolf World, Incorporated (GWI) sells products and services for the sport of golf. One of its key business units specializes in the repair and reconditioning of golf carts. GWI enters into contracts with a number of golf clubs throughout the U.S. in which the clubs send their carts to GWI for a complete reconditioning: motor, frame repair where necessary, and replacement of seat covers and canvas tops. The clubs usually will cycle 10–15% of their carts through this process each year. Because GWI's business has been growing steadily, it is very important to complete the reconditioning of the carts within a budgeted time and cost. The firm uses weighted-average process costing to keep track of the costs incurred in the reconditioning process. GWI's golf cart repair and reconditioning unit has the following information for the month of November, in which 1,200 carts were started for reconditioning: Beginning WIP: 150 units, 50% complete for materials ($16,600) and 30% complete for…arrow_forward
- The Fish House (TFH) in Norfolk, Virginia, sells fresh fish and seafood. TFH receives daily shipments of farm-raised trout from a nearby supplier. Each trout costs $2.45 and is sold for $3.95. To maintain its reputation for freshness, at the end of the day TFH sells any leftover trout to a local pet food manufacturer for $1.25 each. The owner of TFH wants to determine how many trout to order each day. Historically, the daily demand for trout is: Demand 10 11 12 13 14 15 16 17 18 19 20 Probability 0.02 0.06 0.09 0.11 0.13 0.15 0.18 0.11 0.07 0.05 0.03 a. Construct a payoff matrix for this problem. b. How much should the owner of TFH be willing to pay to obtain a demand forecast that is 100% accurate? give a clear explanation for (b)arrow_forwardDonna Canova is the environmental compliance manager for a small plastics manufacturing company Platicallity Inc. She is currently faced with the decision of whether or not to spend on a new technology that will reduce the level of a particular toxin in the wastewater that flows out the back of the factory and into a lake. The factory's emission levels are already within legal limits. However, Donna knows that enviromental regulatiosn for this particular toxin re laggin behind scientific evidence. In fact, a scientist from the university was quoted in the newspaper recently, saying that if emmission levels stayed at this level, the fish in the lakes and rivers in the area might soon have to be declared unfit for human consumption. Further, if companies in the region don't engage in some self-regulation on this issue, there is reason to fear that the government--backed by public opinion--may force companies to begin using the new technology and require monthly emmission level reports…arrow_forwardEmily works for a small software company and oversees software quality assurance. The company recently developed an inventory control system for a national clothing manufacturer. The system gathers sales information on an hourly basis from clothing retailers nationwide. This information is then used by all departments (including the accounting, shipping, and ordering departments) to control the functions of the clothing manufacturer. Emily suspects that the inventory functions of the system are not sufficiently tested, although they have passed all their contracted (legal) tests. However, she is pressured by her employers to sign off on the software. Whilst she is only required to perform tests which have been agreed to in the original contract, her considerable experience in software testing has led her to be concerned over the quality of the system. Her employers say that they will go out of business if they do not deliver the software on time. Emily knows that if any section of…arrow_forward
- Port Ormond Carpet Company manufactures carpets. Fiber is placed in process in the Spinning Department, where it is spun into yarn. The output of the Spinning Department is transferred to the Tufting Department, where carpet backing is added at the beginning of the process and the process is completed. On January 1, Port Ormond Carpet Company had the following inventories: Finished Goods $8,200 Work in Process-Spinning Department 1,800 Work in Process-Tufting Department 2,900 Materials 4,800 Departmental accounts are maintained for factory overhead, and both have zero balances on January 1. Manufacturing operations for January are summarized as follows: Jan. 1 Materials purchased on account, $82,700 2 Materials requisitioned for use: Fiber-Spinning Department, $43,800 Carpet backing-Tufting Department, $34,900 Indirect materials-Spinning Department, $3,200 Indirect materials-Tufting Department, $2,800 31 Labor used: Direct…arrow_forwardMenzGold is a small mine located in a mining town of Mim in the discharged into natural water bodies and not those discharged through years and the effluent from the mine has been used for some years as The city has enacted byelaws that in order to monitor heavy metal discharges, plants in Mim are responsible for supplying test data to the the discharge of heavy metals into the effluent, so it would be safe for use by farmers as fertilizer. mine, but the plant’s mercury processing process creates substantial quantities of toxic materials and heavy metals, which is discharged as from the sale of Mulch-1 enables the city to supplement its tax revenues and carry out massive developmental projects. In order to MenzGold mine has a plant which processes the mercury used in the effluents is flawed, however because it only regulates effluent directly city. The data must be signed by a licenced and registered professional law and ethics, who attests to its accuracy. The Mim law…arrow_forwardLindsey Brentwood is the manager of a fine dining restaurant chain that serves its guests a variety of traditional Southern dishes prepared with the very finest of ingredients. It is most famous for its upscale version of Chicken Fried Steak. At Lindsey's restaurant, this dish (beef steak, seasoned, breaded, and then pan fried) is prepared using USDA Prime rib-eye steak. As the price of rib-eye has increased, Lindsey’s food cost percentage on this item has risen dramatically. Currently, Lindsey is considering whether the selling price of this dish should be increased significantly or if she should take other steps to help reduce her overall product cost percentage. 1. What issues should Lindsey consider prior to making this decision? 2. What alternatives to raising prices do you think are available to Lindsey?arrow_forward
- Trips Logistics, a third-party logistics firm that provides warehousing and other logistics services, is facing a decision regarding the amount of space to lease for the upcoming three-year period. The general manager has forecast that Trips Logistics will need to handle a demand of 100,000 units for each of the next three years. Historically, Trips Logistics has required 1,000 square feet of warehouse space for every 1,000 units of demand. For the purposes of this discussion, the only cost Trips Logistics faces is the cost for the warehouse. Trips Logistics receives revenue of $1.22 for each unit of demand. The general manager must decide whether to sign a three-year lease or obtain warehousing space on the spot market each year. The three-year lease will cost $1 per square foot per year, and the spot market rate is expected to be $1.20 per square foot per year for each of the three years. Trips Logistics has a discount rate of k = 0.1.arrow_forwardList the assumptions of the gravity model and how to overcome its limitationsarrow_forwardThe Pert Mustangarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning