Practical Management Science
5th Edition
ISBN: 9781305734845
Author: WINSTON
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.…
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…
Digital 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…
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
- Fedori 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_forwardMaterials 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_forward
- The Johnny Ho Manufact uring Company in Columbus, Ohio, is putting out four new electronic components. Each of Ho's four plants has the capacity to add one more productto its current line of electronic parts. The unit-manufacturing costs for producing the different parts at the four plants are shown in the accompanying table. How should Ho assign the new products to the plants to minimize manufacturing costs?arrow_forwardCompany DEF has a choice of two machines to purchase. They both make the same product which sells for P10. Machine A has FC of P5,000 and a per unit cost of P5. Machine B has FC of P15,000 and a per unit cost of P1. Under what conditions would you select Machine A?arrow_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
- Glascro Company manufactures skis. The management accountant wants to calculate the fixed and variable costs associated with the leasing of machinery. Data for the past four months were collected as follows: Month Lease cost Machine hours April $15,000 800 May 10,000 600 June 12,000 770 July 16,000 1,000 Using the Method of Least Squares, calculate the fixed cost of leasing. Round the fixed cost to the nearest cent.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_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 $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_forward
- A machine shop has an order for 12 000 pcs of a machine part that requires anti-corrosive properties. Chromium steel alloy that cost Php. 95.00/kg or Nickel steel alloy that cost Php. 65.00/kg may be used. The weight per piece, production rate per day and tool bit replacement cost for Cr-alloy are: 0.25 kg, 75 pcs and Php. 1 600.00 for every 400 pcs produced. The respective date for Ni-alloy are 0.3 kg, 50 pcs and Php. 1 800.00 for every 300 pcs produced. If the charge for the labor and other operating cost is Php. 450.00/day, with all other expenses being the same, determine which material should be used.arrow_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.