Reference no: EM13864094
Instructions
· Answer the following product mix problem in Excel using the Solver. Your final answer should show the number of Basic and XP computers to produce.
· As stated, your solution should be in an Excel document, which you will submit by the due date. I am giving you a week to complete the assignment.
· You can work on the assignment in groups of up to 4 people (and you can also work on it individually if you prefer). If you do work in a group, you can have just one member of the group submit the assignment, but be sure that the names of all members of the group are on the assignment.
Problem
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 3,000 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.
|
What is your dream job
: What is your dream job? Is the person that you interviewed currently working in your dream job? Or does he or she know enough about it to talk to you about it? Why did you choose the person that you interviewed?
|
|
Outline a marketing strategy for the health care
: Outline a marketing strategy for the health care
|
|
Describe the health care system and the role of marketing
: Describe the health care system and the role of marketing
|
|
Explain the basic principles of the civil service system
: "To the victor belong the spoils" was a phrase used to define the spoils system for filling vacancies of government jobs. Discuss the historical use of this system and its contemporary manifestations.
|
|
Tests two models of computers
: 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..
|
|
Determine how market commonality and resource
: "Apple, Inc: Keeping the "I" in Innovation" Please respond to the following: From the second e-Activity and the case study, determine how market commonality and resource similarity impact Apple's competitive standing in terms of its main rivals. Prov..
|
|
What will be united financial corp’s internal growth rate
: Asymmetric Frames Corp had a return on equity of 15%. The corporation’s earnings per share was $6.00, its dividend payout ratio was 40% and its profit-retention rate was 60%. If these relationships continue, what will be United Financial Corp’s inter..
|
|
Most necessary for learning to occur
: Describe the learning condition you think is most necessary for learning to occur. Use specific examples to support your answer. Your response should be at least 200 words in length
|
|
Exploring the perceptions and reality of white collar
: Background: Exploring the perceptions and reality of white collar criminal penalties. Summarize thoughts on penalties for white collar crimes including concepts, ideas and thoughts on value and importance of how ethics relate to criminal behavior and..
|