Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
7th Edition
ISBN: 9781285418681
Author: Cliff Ragsdale
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3, Problem 20QP
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 identify: If it is advisable to make assembly workers work overtime.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Radiant wants to hire Cargo planes for transporting their goods. They contacted VIP Transportation Company to hire Cargo planes. VIP informed that they can provide two types of Cargo Planes. In addition, they provided the following cost related information about the two types Cargo planes- WT88 and BH54:
Personnel Cost
Fuel Cost
Maintenance Cost
WT88
2000
1000
2000
BH54
2500
1500
1000
Radiant has $200,000 to spend in personnel cost, $160,000 in fuel cost, and $80,000 in maintenance cost. Moreover, they have to hire at least two of each type of planes. If WT88 can carry 55 tons of goods and BH54 can carry 85 tons of goods, then find out the following using Linear Programming:
What is the maximum amount Radiant can carry given their budget constraint?
Can you solve using solver ? (I did this but I got a wrong answer)
Data
Personnel Cost
Fuel Cost
Maintenance Cost
Tons
WT88
2000
1000
2000
55…
Analyse eMMC ' s price and storage capacity with its benefits
Arts N Crafts Industries manufacturers high-end light fixtures, which it sells internationally. The company is responsible for paying for shipping its product to a distributor located in Atlanta, Georgia. Due to the high cost of shipping, the company is considering shipping its products unassembled, but will include detailed assembly instructions in each package. By shipping unassembled products, Arts N Crafts will be able to shrink the size of its cartons and thereby increase the number of products per pallet from 16 (4 rows of 4) to 25 (5 rows of 5). Note that this change will not appreciably increase each product’s 8-pound shipping weight. Furthermore, since individual fixtures will be packed more tightly, they will be less susceptible to damage and easier to handle. Thus, the company expects the freight class to decrease from 85 to 70. Currently the company ships 400 units per week.a. Using Table, assess the impact of the proposed change in packaging on weekly shipping cost.b. How…
Chapter 3 Solutions
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
Ch. 3 - Prob. 1QPCh. 3 - Prob. 2QPCh. 3 - Prob. 3QPCh. 3 - Prob. 4QPCh. 3 - Prob. 5QPCh. 3 - Prob. 6QPCh. 3 - Prob. 7QPCh. 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 - Tuckered Outfitters plans to market a custom brand...Ch. 3 - Prob. 18QPCh. 3 - Prob. 19QPCh. 3 - Prob. 20QPCh. 3 - Prob. 21QPCh. 3 - Prob. 22QPCh. 3 - Prob. 23QPCh. 3 - Prob. 24QPCh. 3 - Prob. 25QPCh. 3 - A manufacturer of prefabricated homes has decided...Ch. 3 - Prob. 27QPCh. 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 - A natural gas trading company wants to develop an...Ch. 3 - Prob. 45QPCh. 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
- UPD Manufacturing produces a range of health care appliances for hospital as well as for home use. The company has experienced a steady demand for its products, which are highly regarded in the health care field. Recently the company has undertaken a review of its inventory ordering procedures as part of a larger effort to reduce costs. One of the company's products is a blood pressure testing kit. UPD manufactures all of the components for the kit in-house except for the digital display unit. The display units are ordered at six-week intervals from the supplier. This ordering system began about five years ago, because the supplier insisted on it. However, that supplier was bought out by another supplier about a year ago, and the six-week ordering requirement is no longer in place. Nonetheless, UPD has continued to use the six-week ordering policy. According to purchasing manager Tom Chambers, “Unless somebody can give me a reason for changing, I'm going to stick with what we've been…arrow_forwardCryolab Inc makes and sells a lawn fertilizer called Hypergro. The company has developed standard costs for one bag of Hypergro as follows: Standard Quantity/Hours Standard Price/Rate Standard Cost per Bag Direct Material 25 pounds ₱ 0.75 ₱18.75 Direct Labor 0.25 hours ₱69.00 ₱17.30 Variable overhead 0.25 hours ₱24.00 ₱ 6.00 Total ₱42.05 The company had no beginning inventories of any kind on January 1. Variable overhead is applied to production on the basis of standard direct labor hours. During January, the following activity was recorded by the company: Production of Fastgro: 23,000 bags Direct materials purchased: 585,000 pounds at a cost of ₱436,250 Direct labor worked: 5,800 hours at a cost of ₱397,300 Variable overhead incurred: ₱140,650 Inventory of direct materials on January 31: 8,000 pounds Compute the variances and indicate whether it is FAVORABLE (F) or UNFAVORABLE (U) in your solution sheet. The raw…arrow_forwardFuego Limited is a table-glass retailer located in Vancouver. The company purchases glasses from Anderson PLC. The details of the table glasses are as follows: The purchase price per glass – $3,000 Cost of an order - $500 The annual cost of carrying a glass - 2% of the purchase price Monthly Demand - 1,250 Units The company has been offered a discount of 1% on the price of a table glass if the lot size is 3,000 table glasses at a time. Required: i. Calculate the Economic Order Quantity. ii. Calculate the total inventory cost. iii. Draw a graph and discuss the behavior of the total inventory holding cost, total ordering cost, and total cost for the given scenario. iv. Advise whether the quantity discount offer can be accepted (Assume that the inventory carrying cost does not vary according to the discount policy)arrow_forward
- Mpho is an avid seamstress and want to sew and sell high quality, reusable designer face masks during the current Covid-19 pandemic. She will design and sew the masks herself and use her automatic embroidery machine to put her logo on each mask sold. With the help of her son, deliveries will be made all over Gauteng within 3 days of placing the order. Every mask will have a unique three-layer design with adjustable straps to ensure comfort and it. Mpho’s only expenseis the material needed to sew the masks and delivery costs. At this stage, Mpho’starget market is limited to Gauteng. Draw a diagram to illustrate the transformation process of Mpho’s new business. Be sure to include all relevant elements, headings and arrows to indicate the flow of products/ services. Question: 1. Draw a diagram to illustrate the transformation process of Mpho’s new business. Be sure to include all relevant elements, headings and arrows to indicate the flow of products/ services.arrow_forwardCopper Kettle Catering (CKC) is a full-service catering company that provides services ranging from box lunches for picnics or luncheon meetings to large wedding, dinner, or office parties. Established as a lunch delivery service for offices in 1972 by Wayne and Janet Williams, CKC has grown to be one of the largest catering businesses in Raleigh, North Carolina. The Williams’s divide customer demand into two categories: deliver only and deliver and serve. The deliver-only side of the business delivers boxed meals consisting of a sandwich, salad, dessert, and fruit. The menu for this service is limited to six sandwich selections, three salads or potato chips, and a brownie or fruit bar. Grapes and an orange slice are included with every meal, and iced tea can be ordered to accompany the meals. The overall level of demand for this service throughout the year is fairly constant, although the mix of menu items delivered varies. The planning horizon for this segment of the business is…arrow_forwardPls helparrow_forward
- Costco also employs a just-in-time inventory management system, which includes sharing data directly with many of its largest suppliers. Companies like Kimberly-Clark calculate re-order points in real time and send new inventory, as needed, to replenish store shelves. Costco also works to redesign product packaging to squeeze more bulky goods onto trucks and shelves, reducing the number of orders Costco needs to place with suppliers.Occasionally, the company leverages its 75 million square feet of warehouse space to reduce purchasing costs. For example, when Procter & Gamble recently announced a 6% price increase for its paper goods, Costco bought 258 truckloads of paper towels at the old rate and stored them using available capacity in its distribution centers and warehouses.These inventory management techniques have allowed Costco to succeed in tough times while others have failed. Costco turns its inventory nearly 12 times a year, far more often than other retailers. With many…arrow_forwardCostco also employs a just-in-time inventory management system, which includes sharing data directly with many of its largest suppliers. Companies like Kimberly-Clark calculate re-order points in real time and send new inventory, as needed, to replenish store shelves. Costco also works to redesign product packaging to squeeze more bulky goods onto trucks and shelves, reducing the number of orders Costco needs to place with suppliers.Occasionally, the company leverages its 75 million square feet of warehouse space to reduce purchasing costs. For example, when Procter & Gamble recently announced a 6% price increase for its paper goods, Costco bought 258 truckloads of paper towels at the old rate and stored them using available capacity in its distribution centers and warehouses.These inventory management techniques have allowed Costco to succeed in tough times while others have failed. Costco turns its inventory nearly 12 times a year, far more often than other retailers. With many…arrow_forwardCostco also employs a just-in-time inventory management system, which includes sharing data directly with many of its largest suppliers. Companies like Kimberly-Clark calculate re-order points in real time and send new inventory, as needed, to replenish store shelves. Costco also works to redesign product packaging to squeeze more bulky goods onto trucks and shelves, reducing the number of orders Costco needs to place with suppliers.Occasionally, the company leverages its 75 million square feet of warehouse space to reduce purchasing costs. For example, when Procter & Gamble recently announced a 6% price increase for its paper goods, Costco bought 258 truckloads of paper towels at the old rate and stored them using available capacity in its distribution centers and warehouses.These inventory management techniques have allowed Costco to succeed in tough times while others have failed. Costco turns its inventory nearly 12 times a year, far more often than other retailers. With many…arrow_forward
- Costco also employs a just-in-time inventory management system, which includes sharing data directly with many of its largest suppliers. Companies like Kimberly-Clark calculate re-order points in real time and send new inventory, as needed, to replenish store shelves. Costco also works to redesign product packaging to squeeze more bulky goods onto trucks and shelves, reducing the number of orders Costco needs to place with suppliers.Occasionally, the company leverages its 75 million square feet of warehouse space to reduce purchasing costs. For example, when Procter & Gamble recently announced a 6% price increase for its paper goods, Costco bought 258 truckloads of paper towels at the old rate and stored them using available capacity in its distribution centers and warehouses.These inventory management techniques have allowed Costco to succeed in tough times while others have failed. Costco turns its inventory nearly 12 times a year, far more often than other retailers. With many…arrow_forwardMpho is an avid seamstress and want to sew and sell high quality, reusable, designer face masks during the current Covid-19 pandemic. She will design and sew the masks herself and use her automatic embroidery machine to put her logo on each mask sold. With the help of her son, deliveries will be made all over Gauteng within 3 days of placing the order. Every mask will have a unique three-layer design with adjustable straps to ensure comfort and fit. Mpho’s only expense is the material needed to sew the masks and delivery costs. At this stage, Mpho’s target market is limited to Gauteng. Question: Create a diagram to illustrate the transformation process of Mpho’s new business. Be sure to include all relevant elements, headings and arrows to indicate the flowof products/ services. What should be in the diagram: outputs, inputs, feedback, transformation process and flow of product and service ect.arrow_forwardDemand for stereo headphones and music players for joggers has caused Nina Industries to grow almost 50 percent over the past year. The number of joggers continues to expand, so Nina expects demand for headsets to also expand, because, as yet, no safety laws have been passed to prevent joggers from wearing them. Demand for the players for this year was as follows: MONTH DEMAND (UNITS) January 4,150 February 4,250 March 3,950 April 4,350 May 4,950 June 4,650 July 5,250 August 4,850 September 5,350 October 5,650 November 6,250 December 5,950 a. Using linear regression analysis, what would you estimate demand to be for each month next year? Using a spreadsheet, follow the general format in Exhibit 3.8. (Do not round intermediate calculations. Round your answers to 2 decimal places.) b. To be reasonably confident of meeting demand, Nina decides to use 3 standard errors of estimate for safety. How many additional units should be held to meet this…arrow_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