NorthwestCaseStudy_Writeup_JingJingWu_YusiSang_XuXin

The quantity produced in duchesne and shipped to los

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: t can produce TO 301 Section 005: Northwest Newsprint, Inc Case Study Group 137: Jing Jing Wu, Xin Xu, Yusi Sang 125,500,605.10 Northwest realizes additional 3962,737.95 of profit. (Reference to Excel Sheet Question 2) Question 3 If the trucking company that handles Northwest’s Duchesne- San Francisco production increases rates from $124.83 to $129.00 per ton, the profit margin will change from 210.17 to 206. Using the sensitivity report, as the allowable decrease for this coefficient is negative infinity, the optimal solution won’t change because of this change in transportation pricing. (Reference to Excel Sheet Question 3& Sensitivity report) Question 4 If the shipping rate on the Duchesne- Los Angeles route decreases from $150.14 to $140.00 per ton, the optimal solution may change. Usin...
View Full Document

Ask a homework question - tutors are online