Product Mix - The PQ Example - Starter File.xls - The PQ Product Mix Problem Profit = TR TC = TR FC VC = \$90P \$100Q \$6000 \$45P \$40Q Product ID P Q

# Product Mix - The PQ Example - Starter File.xls - The PQ...

• 2

This preview shows page 1 out of 2 pages.

#### You've reached the end of your free preview.

Unformatted text preview: The PQ Product Mix Problem Profit = TR - TC = TR - FC - VC = \$90P + \$100Q - \$6000 - \$45P - \$40Q Product ID P Q Product P Q P Q # Units Sold Selling per Week Price/Unit 158 \$90 1 \$100 Weekly Revenue \$14,220 \$100 Fixed Cost \$6,000 Profit = \$14,320 Profit = \$1,170 A 15 10 2370 10 Work Center B C 15 15 30 5 2370 2370 30 5 D 15 5 2370 5 <<-- Minutes for One Unit of Product P <<-- Minutes for One Unit of Product Q <<-- Minutes for All Units of Product P M <<-- Minutes for All Units of Product Q M 2400 2380 20 2400 2400 0 2400 2375 25 <<-- Minutes Available Per Week <<-- Minutes Used Per Week <<-- Minutes Remaining Per Week 2400 2375 25 - \$6,000 - Material Cost/Unit \$45 \$40 Variable Cost \$7,110 \$40 \$7,150 es for One Unit of Product P es for One Unit of Product Q es for All Units of Product P Made in a Week es for All Units of Product Q Made in a Week es Available Per Week es Used Per Week for both P and Q es Remaining Per Week Decision Variables Formulas Given Data (Input) ...
View Full Document

• Fall '18
• Sharma

### What students are saying

• As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

Kiran Temple University Fox School of Business ‘17, Course Hero Intern

• I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

Dana University of Pennsylvania ‘17, Course Hero Intern

• The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

Jill Tulane University ‘16, Course Hero Intern