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.
Use SolverTable to run a sensitivity analysis on the cost per assembling labor hour, letting it vary from $5 to $20 in increments of $1. Keep track of the computers produced in row 21, the hours used in the range B26:B28, and the total profit. Discuss your findings. Are they intuitively what you expected?
Purchasing and Supply Chain Management
Principles of Economics (MindTap Course List)
Corporate Financial Accounting
Cornerstones of Cost Management (Cornerstones Series)
Management, Loose-Leaf Version
Corporate Financial Accounting
Exploring Economics
Foundations of Business (MindTap Course List)
College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)
Fundamentals of Financial Management (MindTap Course List)
Accounting (Text Only)
PAYROLL ACCT.,2019 ED.(LL)-TEXT
Brief Principles of Macroeconomics (MindTap Course List)
College Accounting (Book Only): A Career Approach
Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)
Financial Accounting
Survey of Accounting (Accounting I)
MKTG 12:STUDENT ED.-TEXT
Principles of Microeconomics (MindTap Course List)
Pkg Acc Infor Systems MS VISIO CD
Essentials of Economics (MindTap Course List)
Principles of Macroeconomics (MindTap Course List)
Essentials of Business Communication (MindTap Course List)
Contemporary Marketing
Macroeconomics
Principles of Macroeconomics (MindTap Course List)
Economics (MindTap Course List)
ECON: MICRO4 (New, Engaging Titles from 4LTR Press)
Financial And Managerial Accounting
Managerial Accounting: The Cornerstone of Business Decision-Making
Accounting Information Systems
Fundamentals of Financial Management (MindTap Course List)
College Accounting (Book Only): A Career Approach
Intermediate Accounting: Reporting And Analysis
Financial & Managerial Accounting
Accounting Information Systems
Financial Accounting
STATISTICS F/BUSINESS+ECONOMICS-TEXT
Economics For Today
Fundamentals of Financial Management, Concise Edition (MindTap Course List)
Statistics for Business & Economics, Revised (MindTap Course List)
College Accounting, Chapters 1-27
Financial & Managerial Accounting
Economics: Private and Public Choice (MindTap Course List)
Macroeconomics: Private and Public Choice (MindTap Course List)
Micro Economics For Today
Microeconomics: Private and Public Choice (MindTap Course List)
Cornerstones of Financial Accounting
Managerial Accounting
Understanding Management (MindTap Course List)