Compute the optimal production mix

Assignment Help Other Subject
Reference no: EM13716584

Compute the solution of the given problem

Problem- PC Tech's product mix problem, assume there is another PC model, the VXP, that the company can produce in addition to Basics and XPs. Each VXP requires eight hours for assembling, three hours for testing, $275 for component parts, and sells for $560. At most 50 VXPs can be sold.

Part 1- Modify the spreadsheet model to include this new product, and use Solver to find the optimal product mix.

Part 2- You should find that the optimal solution is not integer-valued. If you round the values in the changing cells to the nearest integers, is the resulting solution still feasible? If not, how might you obtain a feasible solution that is at least close to optimal?

I need help to compute the optimal production mix.

Reference no: EM13716584

Questions Cloud

Calculate the molarity of nh4+ the new solution : A 0.250 L volume of 0.128 M NH4PF6 is condensed to a volume of 0.100 L, calculate the molarity (M) of NH4+ in the new solution. Molar Mass (g/mol)
Explain chlorate ion under the same conditions : Chlorine dioxide reacts in basic water to form chlorite and chlorate according to the following chemical equation: 2CIO2(aq) + 2OH-(aq) --> (aq) + (aq) + H2O(l). If the initial rate of disappearance of chlorine dioxide is 0.230 M/s, what is the in..
Calculate the freezing point of a solution : Toluene freezes at -95.0 C. Its freezing point depression constant is 3.33 C/m. Calculate the freezing point of a solution formed by dissolving 6.4g of naphthalene (C10H8) in 100g of toluene.
Calculate the change in cell cortical tension : Calculate the cell cortical tension. After the cells are treated with a certain chemical, the liquid column height changes to 0.48 µm for the same cell. Calculate the change in cell cortical tension.
Compute the optimal production mix : Modify the spreadsheet model to include this new product, and use Solver to find the optimal product mix. You should find that the optimal solution is not integer-valued.
Describe how the deity horus became the king of egypt : Explain how the deity Horus became the king of Egypt and Osiris became king of the underworld.
Calculate the effective monthly interest rate : What is the effective monthly Interest Rate on a 15% annual nominal loan with continuous compounding. Assume 4.33 weeks per month.
Write an equation to show what other particle is emitted : When beryllium-9 is bombarded by alpha particles , carbon-12 is produced. Write an equation to show what other particle is emitted.
Determine the annual profit for each copier : For one to five copiers rented and daily demands of 500, 1000, 1500, and 2000 copies per day, find annual profit. That is, find annual profit for each of these combinations of copier's rented and daily demand.

Reviews

Write a Review

Other Subject Questions & Answers

  Campus diversity

During the last couple of decades, colleges and universities have tried to increase their number of minority students by various forms of affirmative action. At Campus X, this has led to no small amount of dissension.

  What is your new latitudinal-longitudinal location

You are at 100 N and 900E, you move to a new location which is 250 south and 400 west of your present location. What is your new latitudinal/longitudinal location?

  Good strategic sense-value chain activities

Does it make good strategic sense for Apple to be a competitor in the computer, personal media player, smartphone, and tablet computer industries? Are the value chain activities that Apple performs in computers, personal media players, tablet compute..

  Write the challenges facing leaders in todays environment

there are some who argue that leaders face unprecedented demands as we enter the 21st century. the pace of

  Relativistic nature of spacetime in the vicinity of black

Because of the relativistic nature of spacetime in the vicinity of a black hole, a satellite orbiting the hole in one direction would have a different orbital period from a satellite orbiting in the other direction.

  Protest of civil disobedience

What is your role as a police officer during a protest of Civil Disobedience and What are the possible ethical dilemmas that you could face during a protest?

  What is an identifier

What is an "identifier" (primary key)? What would be a good identifier for STUDENT table (=entity) for a university. What would be a good identifier for facebook USER entity?

  Management control system

If management decides to pursue an unwise goal, the management control system for that company should?

  Three healthcare market trends in your market

What are two or three healthcare market trends in your market. How might these trends affect a person's job or their ability to be hired. How would a person react to or preare for these trends.

  Who was milton friedman what are some of his theories and

who was milton friedman? what are some of his theories and how does he feel about government and its involvement in the

  Fundamentals of belief perseverance

Belief perseverance can be described as being the phenomenon in which individuals or groups believe in their theories despite the existence of contrary evidence (Bonabeau, 2009).

  Advantages of international diversification

Explain why, given the advantages of international diversification, some firms choose not to expand internationally. As firms attempt to internationalize, they may be tempted to locate their facilities where product liability laws are lax in testing ..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd