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 21QP
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
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…
Cryolab 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…
Fuego 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)
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
- 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_forwardDuring the Inept Management Day festivities, the citizens of X country elect through online polls the most clueless, psychologically unstable, incompetent, and damaging leader, and then hang the pictures of that leader on their balcony clotheslines. Company Y sells copies of the picture and needs to order them from a print shop. The cost per picture copy bought from print shop is 71.50 local currency units (LCU), and during the festivities they are sold for 119.50 LCU per copy. It is expected that any stock of the pictures remaining unsold after the festivities can be given for recycling to a toilet paper manufacturer at the sale price of 59.50 LCU per copy. Assume that a uniform probability distribution ranging from 6830 to 7680 copies describes the demand, with average expected demand of 7255. What is the optimal order size of picture copies for the Inept Management Day under these conditions? Select one: a. equal to or less than 6920 copies b. between 6920 and 7220 copies…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 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_forward
- Copper 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_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_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_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
- 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 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_forwardPaul Williams recently joined XYZ2 Limited as the head of accounting department. Williams spent the first few weeks to analyse the account information system. Based on this analysis, Williams is concerned about the purchase system of XYZ2 Limited. Here is the details of purchase system. The purchasing agent of XYZ2 Limited periodically checks inventory levels from a computer terminal, which is connected to a central accounting system. The agent searches the inventory file for items that need to be ordered. He then selects a supplier, prints a hard copy of the purchase order, and mails it to the vendor. The clerk files one copy of the PO in the department and sends a second copy to the AP Clerk. When the inventories arrive at the receiving department, a receiving clerk reconciles the items with the packing slip, inspects them for condition, and manually prepares a three-part receiving report. The clerk sends one copy to the purchasing department to close out the open PO, files one…arrow_forwardSpark Ltd has two divisions, assembly and electrical. The assembly division transfers partially completed components to the electrical division at a predetermined transfer price. The assembly division's standard variable production cost per unit is $550. This division has spare capacity, and it could sell all its components to outside buyers at $680 per unit in a perfectly competitive market. Required: a) Determine a transfer price using the general rule b) How would the transfer price change if the assembly division had no spare capacity? c) What transfer price would you recommend if there was no outside market for the transferred component and the assembly division had spare capacity? d) Explain how negotiation between the supplying and buying units may be used to set transfer prices. How does this relate to the general transfer pricing rule?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