Compute the optimal production mix

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.

User Account

All Pages