Question: EXCEL solver. WP Machine shop makes deluxe and regular skis on a weekly schedule for the area skiing enthusiasts. They also supply both regular and

EXCEL solver.

WP Machine shop makes deluxe and regular skis on a weekly schedule for the area skiing enthusiasts. They also supply both regular and deluxe skis to local sporting goods stores. A deluxe pair of skis requires 40 minutes for roughing and 20 minutes for finishing, whereas a regular pair of skis requires 20 minutes for roughing and 27 minutes for finishing. With only 1,000 minutes for roughing and 800 minutes of finishing time available per week and a profit realization of $4 and $3 for the deluxe and regular, respectively, what weekly mix of the two types of skis should be produced to meet the contracts requirement and maximize profits? (Hint: solve graphically as a linear program

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!