menu
bartleby
search
close search
Hit Return to see all results
close solutoin list

The PC Tech company assembles and then tests two models of computers, Basic and XP. For the coming month, the company wants to decide how many of each model to assemble and then test. No computers are in inventory from the previous month, and because these models are going to be changed after this month, the company doesn’t want to hold any inventory after this month. It believes the most it can sell this month are 600 Basics and 1200 XPs. Each Basic sells for $300 and each XP sells for $450. The cost of component parts for a Basic is $150; for an XP it is $225. Labor is required for assembly and testing. There are at most 10,000 assembly hours and 3000 testing hours available. Each labor hour for assembling costs $11 and each labor hour for testing costs $15. Each Basic requires five hours for assembling and one hour for testing, and each XP requires six hours for assembling and two hours for testing. PC Tech wants to know how many of each model it should produce (assemble and test) to maximize its net profit, but it cannot use more labor hours than are available, and it does not want to produce more than it can sell. As in the previous example, PC Tech must decide how many of each of its computer models to assemble and test, but there are now eight available models, not just two. Each computer must be assembled and then tested, but there are now two lines for testing. The first line tends to test faster, but its labor costs are slightly higher, and each line has a certain number of hours available for testing. Any computer can be tested on either line. The inputs for the model are same as before: (1) the hourly labor costs for assembling and testing, (2) the required labor hours for assembling and testing any computer model, (3) the cost of component parts for each model, (4) the selling prices for each model, (5) the maximum sales for each model, and (6) labor availabilities. These input values are listed in the file Product Mix 2.xlsx. As before, the company wants to determine the product mix that maximizes its total net profit. Some analysts complain that spreadsheet models are difficult to resize. You can be the judge of this. Suppose the current product mix problem is changed so that there is an extra resource, packaging labor hours, and two additional PC models, 9 and 10. What additional input data are required? What modifications are necessary in the spreadsheet model (including range name changes)? Make up values for any extra required input data and incorporate these into a modified spreadsheet model. Then optimize with Solver. Do you conclude that it is easy to resize a spreadsheet model? (By the way, it turns out that algebraic models are typically much easier to resize.)

BuyFindarrow_forward

Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659

Solutions

Chapter
Section
BuyFindarrow_forward

Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659
Chapter 3.7, Problem 16P
Textbook Problem
1 views

The PC Tech company assembles and then tests two models of computers, Basic and XP. For the coming month, the company wants to decide how many of each model to assemble and then test. No computers are in inventory from the previous month, and because these models are going to be changed after this month, the company doesn’t want to hold any inventory after this month. It believes the most it can sell this month are 600 Basics and 1200 XPs. Each Basic sells for $300 and each XP sells for $450. The cost of component parts for a Basic is $150; for an XP it is $225. Labor is required for assembly and testing. There are at most 10,000 assembly hours and 3000 testing hours available. Each labor hour for assembling costs $11 and each labor hour for testing costs $15. Each Basic requires five hours for assembling and one hour for testing, and each XP requires six hours for assembling and two hours for testing. PC Tech wants to know how many of each model it should produce (assemble and test) to maximize its net profit, but it cannot use more labor hours than are available, and it does not want to produce more than it can sell.

As in the previous example, PC Tech must decide how many of each of its computer models to assemble and test, but there are now eight available models, not just two. Each computer must be assembled and then tested, but there are now two lines for testing. The first line tends to test faster, but its labor costs are slightly higher, and each line has a certain number of hours available for testing. Any computer can be tested on either line. The inputs for the model are same as before: (1) the hourly labor costs for assembling and testing, (2) the required labor hours for assembling and testing any computer model, (3) the cost of component parts for each model, (4) the selling prices for each model, (5) the maximum sales for each model, and (6) labor availabilities. These input values are listed in the file Product Mix 2.xlsx. As before, the company wants to determine the product mix that maximizes its total net profit.

Some analysts complain that spreadsheet models are difficult to resize. You can be the judge of this. Suppose the current product mix problem is changed so that there is an extra resource, packaging labor hours, and two additional PC models, 9 and 10. What additional input data are required? What modifications are necessary in the spreadsheet model (including range name changes)? Make up values for any extra required input data and incorporate these into a modified spreadsheet model. Then optimize with Solver. Do you conclude that it is easy to resize a spreadsheet model? (By the way, it turns out that algebraic models are typically much easier to resize.)

Summary Introduction

To determine: Whether Person X thinks that it is easy to resize a spreadsheet model.

Introduction: In linear programming, the unbounded solution would occur when the objective function is infinite. If no solution satisfied the constraints, then it is said to be an unfeasible solution.

Explanation of Solution

Compute net profit using the given information:

Figure (1)

Solving parameters are given as follows:

Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Chapter 3 Solutions

Practical Management Science
Show all chapter solutions
add
Ch. 3.7 - The PC Tech company assembles and then tests two...Ch. 3.7 - The PC Tech company assembles and then tests two...Ch. 3.7 - The PC Tech company assembles and then tests two...Ch. 3.7 - The PC Tech company assembles and then tests two...Ch. 3.7 - The PC Tech company assembles and then tests two...Ch. 3.7 - The PC Tech company assembles and then tests two...Ch. 3.7 - The PC Tech company assembles and then tests two...Ch. 3.8 - The Pigskin Company produces footballs. Pigskin...Ch. 3.8 - The Pigskin Company produces footballs. Pigskin...Ch. 3.8 - The Pigskin Company produces footballs. Pigskin...Ch. 3.8 - In one modification of the Pigskin problem, the...Ch. 3.8 - Modify the Pigskin spreadsheet model so that...Ch. 3.8 - Modify the Pigskin spreadsheet model so that...Ch. 3.8 - Modify the Pigskin spreadsheet model in the...Ch. 3 - A chemical company manufactures three chemicals:...Ch. 3 - A furniture company manufactures desks and chairs....Ch. 3 - A farmer owns 450 acres of land. He is going to...Ch. 3 - During the next four months, a customer requires,...Ch. 3 - A company faces the following demands during the...Ch. 3 - Maggie Stewart loves desserts, but due to weight...Ch. 3 - For a telephone survey, a marketing research group...Ch. 3 - A furniture company manufactures tables and...Ch. 3 - A manufacturing company makes two products. Each...Ch. 3 - There are three factories on the Momiss River....Ch. 3 - A company manufactures two types of trucks. Each...Ch. 3 - A company manufactures mechanical heart valves...Ch. 3 - A company that builds sailboats wants to determine...Ch. 3 - A company manufactures two products on two...Ch. 3 - A textile company produces shirts and pants. Each...Ch. 3 - Each year, a shoe manufacturing company faces...Ch. 3 - A small appliance manufacturer must meet (on time)...Ch. 3 - A pharmaceutical company manufactures two drugs at...Ch. 3 - In any optimization model such as those in this...Ch. 3 - Suppose you use Solver to find the optimal...Ch. 3 - Consider an optimization model with a number of...Ch. 3 - If you add a constraint to an optimization model,...Ch. 3 - Why is it generally necessary to add nonnegativity...Ch. 3 - Suppose you have a linear optimization model where...Ch. 3 - In a typical product mix model, where a company...Ch. 3 - In a typical product mix model, where a company...Ch. 3 - In a typical production scheduling model like...Ch. 3 - In a production scheduling problem like Pigskins,...Ch. 3 - Shelby Shelving is a small company that...

Additional Business Textbook Solutions

Find more solutions based on key concepts
Show solutions add
What is the OLAP operation of consolidation?

Accounting Information Systems

Explain how backflush costing works.

Cornerstones of Cost Management (Cornerstones Series)

DEPRECIATION METHODS Kristin is evaluating a capital budgeting project that should last for 4 years. The projec...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)

Distinguish buy-side and sell-side systems.

Pkg Acc Infor Systems MS VISIO CD