Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 6.4, Problem 17P
Summary Introduction
To determine: The optimal solution using the solver.
Introduction: The variation between the present value of the
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Box Electric makes electronic components and has estimated the following for a new design of one of its products.
Fixed cost = $24,975
Material cost per unit = $0.17
Labor cost per unit = $0.12
Revenue per unit = $0.66
Note that fixed cost is incurred regardless of the amount produced. Per-unit material and labor cost together make up the variable cost per unit. Assuming that Box Electric sells all that it produces, profit is calculated by subtracting the fixed cost and total variable cost from total revenue.
Construct an appropriate spreadsheet model to find the profit based on a given production level and use the spreadsheet model to answer these questions.
(a)
Construct a one-way data table with production volume as the column input and profit as the output. Breakeven occurs when profit goes from a negative to a positive value; that is, breakeven is when total revenue = the total cost, yielding a profit of zero. Vary production volume from 0 to 100,000 in increments of 10,000.…
Note: please do NOT use EXCEL
Use the following information for the next 3 problems:
ABC Company plans to construct a 60,000 sq. ft private warehouse and rent public warehouse as needed. Warehouse inventory turns at the rate of 2 times per month. One pound of merchandise occupies 0.2 cubic feet of warehouse space and can be stacked 10 feet high. Given aisles, and normal operating efficiency, only 50 percent of the total warehouse space is actually used for storage. Assume the facility is being built to size so no additional space is allowed for future product growth.
A private warehouse can be constructed for $36 per sq. ft. and can be amortized over 20 years. Annual fixed costs amount to $20 per sq. ft. of total space. The cost of operation is $0.03 per pound of throughput.
Space may also be rented for a storage charge on inventory of $0.06 per pound per month and a handling charge of $0.05 per pound of throughput. Monthly demands for a typical year are as follows:
Month
Demand (lb)
Jan
2,000,000…
Chapter 6 Solutions
Practical Management Science
Ch. 6.3 - Prob. 1PCh. 6.3 - Prob. 2PCh. 6.3 - Solve Problem 1 with the extra assumption that the...Ch. 6.3 - Prob. 4PCh. 6.3 - Prob. 5PCh. 6.3 - Prob. 6PCh. 6.3 - Prob. 7PCh. 6.3 - Prob. 8PCh. 6.3 - Prob. 9PCh. 6.3 - Prob. 10P
Ch. 6.4 - Prob. 11PCh. 6.4 - Prob. 12PCh. 6.4 - Prob. 13PCh. 6.4 - Prob. 14PCh. 6.4 - Prob. 15PCh. 6.4 - Prob. 16PCh. 6.4 - Prob. 17PCh. 6.4 - Prob. 18PCh. 6.4 - Prob. 19PCh. 6.4 - Prob. 20PCh. 6.4 - Prob. 21PCh. 6.4 - Prob. 22PCh. 6.4 - Prob. 23PCh. 6.5 - Prob. 24PCh. 6.5 - Prob. 25PCh. 6.5 - Prob. 26PCh. 6.5 - Prob. 28PCh. 6.5 - Prob. 29PCh. 6.5 - Prob. 30PCh. 6.5 - In the optimal solution to the Green Grass...Ch. 6.5 - Prob. 32PCh. 6.5 - Prob. 33PCh. 6.5 - Prob. 34PCh. 6.5 - Prob. 35PCh. 6.6 - Prob. 36PCh. 6.6 - Prob. 37PCh. 6.6 - Prob. 38PCh. 6 - Prob. 39PCh. 6 - Prob. 40PCh. 6 - Prob. 41PCh. 6 - Prob. 42PCh. 6 - Prob. 43PCh. 6 - Prob. 44PCh. 6 - Prob. 45PCh. 6 - Prob. 46PCh. 6 - Prob. 47PCh. 6 - Prob. 48PCh. 6 - Prob. 49PCh. 6 - Prob. 50PCh. 6 - Prob. 51PCh. 6 - Prob. 52PCh. 6 - Prob. 53PCh. 6 - Prob. 54PCh. 6 - Prob. 55PCh. 6 - Prob. 56PCh. 6 - Prob. 57PCh. 6 - Prob. 58PCh. 6 - Prob. 59PCh. 6 - Prob. 60PCh. 6 - Prob. 61PCh. 6 - Prob. 62PCh. 6 - Prob. 63PCh. 6 - Prob. 64PCh. 6 - Prob. 65PCh. 6 - Prob. 66PCh. 6 - Prob. 67PCh. 6 - Prob. 68PCh. 6 - Prob. 69PCh. 6 - Prob. 70PCh. 6 - Prob. 71PCh. 6 - Prob. 72PCh. 6 - Prob. 73PCh. 6 - Prob. 74PCh. 6 - Prob. 75PCh. 6 - Prob. 76PCh. 6 - Prob. 77PCh. 6 - Prob. 78PCh. 6 - Prob. 79PCh. 6 - Prob. 80PCh. 6 - Prob. 81PCh. 6 - Prob. 82PCh. 6 - Prob. 83PCh. 6 - Prob. 84PCh. 6 - Prob. 85PCh. 6 - Prob. 86PCh. 6 - Prob. 87PCh. 6 - Prob. 88PCh. 6 - Prob. 89PCh. 6 - Prob. 90PCh. 6 - Prob. 91PCh. 6 - Prob. 92PCh. 6 - This problem is based on Motorolas online method...Ch. 6 - Prob. 94PCh. 6 - Prob. 95PCh. 6 - Prob. 96PCh. 6 - Prob. 97PCh. 6 - Prob. 98PCh. 6 - Prob. 99PCh. 6 - Prob. 100PCh. 6 - Prob. 1CCh. 6 - Prob. 2CCh. 6 - Prob. 3.1CCh. 6 - Prob. 3.2CCh. 6 - Prob. 3.3CCh. 6 - Prob. 3.4CCh. 6 - Prob. 3.5CCh. 6 - Prob. 3.6C
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.Similar questions
- A linear programming computer package is needed. The Westchester Chamber of Commerce periodically sponsors public service seminars and programs. Currently, promotional plans are under way for this year's program. Advertising alternatives include television, radio, and online. Audience estimates, costs, and maximum media usage limitations are as shown. Constraint Audience per advertisement Radio Online Cost per advertisement Maximum media usage 5 15 10 Radio Budget Online Budget Total Audience Television Radio Online Need Help? 300,000 54,000 120,000 X $2,000 To ensure a balanced use of advertising media, radio advertisements must not exceed 50% of the total number of advertisements authorized. In addition, television should account for at least 10% of the total number of advertisements authorized. Read It 10 (a) If the promotional budget is limited to $27,400, how many commercial messages should be run on each medium to maximize total audience contact? Television $300 20 $600 10 What…arrow_forwardDigital Imaging has hired your Analytics Consulting Firm (SJU Analytics) to help determine how many units of each printer they should produce to maximize profit. Construct a Simple Linear Programing Analysis using Excel SOLVER Prepare a presentation to DI’s president presenting your findings and recommendations. Digital Imaging’s Leadership team has providing the following information: Digital Imaging (DI) produces color printers for both the professional and consumer markets. The DI consumer division recently introduced two new color printers. The DI-910 model can produce a borderless color print in approximately 37 seconds. The more sophisticated and faster DI-950 can even produce a borderless color print. Financial projections show profit contributions of $42 for each DI-910 and $87 for each DI-950. The printers are assembled, tested, and packaged at DI’s plant located in New Bern, North Carolina. This plant is highly automated and uses two manufacturing lines to produce the…arrow_forwardFedori Corporation has a Parts Division that does work for other Divisions in the company as well as for outside customers. The company's Machinery Division has asked the Parts Division to provide it with 4,000 special parts each year. The special parts would require P23.00 per unit in variable production costs. The Machinery Division has a bid from an outside supplier for the special parts at P37.00 per unit. In order to have time and space to produce the special part, the Parts Division would have to cut back production of another part-the YR24 that it presently is producing. The YR24 sells for P40.00 per unit, and requires P28.00 per unit in variable production costs. Packaging and shipping costs of the YR24 are P3.00 per unit. Packaging and shipping costs for the new special part would be only P1.50 per unit. The Parts Division is now producing and selling 15,000 units of the YR24 each year. Production and sales of the YR24 would drop by 20% if the new special part is produced for…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_forwardTwo machines A and B produce items at the rate of 50 units per hour and 40 units per hour respectively. Under certain production plans, the total number of items needed is at least 1000 items, the total number of hours available for running the machines is atmost 24 hours. If the hourly cost is P300 for machine A and P250 for machine B, how many hours should each machine be used in order to minimize the cost? What is the minimum cost? Use either graphical method or simplex methodarrow_forwardAndy Mendoza makes handcrafted dolls, which he sells at craft fairs. He is considering mass-producing the dolls to sell in stores. He estimates that the initial investment for plant and equipment will be $25,000, whereas labor, material, packaging, and shipping will be about $10 per doll. If the dolls are sold for $30 each, what sales volume is necessary for Andy to break even?arrow_forward
- 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…arrow_forwardJuliette loves to eat ice cream and spends a fortune each week buying it. In an effort to save money, she is considering making her own ice cream at home. The cost of an ice cream maker is $150 and the cost of ingredients is $6 for each 1.5 L batch. The cost of the same 1.5 L is $10 at the store. If she eats three litres of ice cream per month, will she save money by making her favourite treat at home? Assume the ice cream maker has a one-year warrant and breaks immediatelv after.arrow_forwardDana’s Ribbon World makes award rosettes. Following is information about the company: Variable cost per rosette $ 2.00 Sales price per rosette $ 6.00 Total fixed costs per month $ 6000.00 Required: 1. Suppose Dana’s would like to generate a profit of $1,120. Determine how many rosettes it must sell to achieve this target profit. 2. If Dana’s sells 2,140 rosettes, compute its margin of safety in units, in sales dollars, and as a percentage of sales. 3. Calculate Dana’s degree of operating leverage if it sells 2,140 rosettes. 4a. Using the degree of operating leverage, calculate the change in Dana’s profit if unit sales drop to 1,819 units. 4b. Prepare a new contribution margin income statement to verify change in dana's profit.arrow_forward
- Juliette loves to eat ice cream and spends a fortune each week buying it. In an effort to save money, she is considering making her own ice cream at home. The cost of an ice cream maker is $155 and the cost of ingredients is $4 for each 1.5 L batch. The cost of the same 1.5 L is $12 at the store. If she eats three litres of ice cream per month, will she save money by making her favourite treat at home? Assume the ice cream maker has a one-year warranty and breaks immediately after.Cost of making the ice creamCost of buying the ice creamBest optionarrow_forwardA9)arrow_forwardA company has limited machine hours available per week, in result the company is able to produce only 3 of 4 products. The company needs to increase the number of hours worked using the existing machinery by working overtime. Such overtime would be paid at a premium of 50% above normal labour rates, and variable overhead costs would be expected to increase in proportion to labour costs. Critically discuss any expected increase in contribution and any issues (in particular in regard to overtime working) that could arise and would need to be resolved. What would be advantages and disadvantages of that and how this will affect the quanitity and the quality of the production and the whole process.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,
Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage Learning
Production and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education
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
Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.