A building supply has two locations in town. The office receives orders from two customers, each...

 

Transcribed Image Text:

A building supply has two locations in town. The office receives orders from two customers, each requiring 3/4-inch plywood. Customer A needs fifty sheets and Customer B needs seventy sheets. The warehouse on the east side of town has 80 sheets in stock; the west-side warehouse has 45 sheets in stock. Delivery costs per sheet are as follows: $0.50 from the eastern warehouse to Customer A, $0.60 from the eastern warehouse to Customer B, $0.40 from the western warehouse to Customer A, and $0.55 from the western warehouse to Customer B. a. Find the shipping arrangement that minimizes costs. (Copy the Relevant part of the Excel worksheet below with the answer) b. If customer B needs 5 more sheets, what is the absolute minimum you should charge them? Explain. (If you have no solution to part a, assume you have the appropriate report and provide the answer to this question.) c. If you find out that the west warehouse has only 41 sheets of plywood, how will that effect the costs? Explain. (If you have no solution to part a, assume you have the appropriate report and provide the answer to this question.) d. If you find out that the East Side Warehouse has 84 sheets of plywood, how will that effect the costs? Explain. (If you have no solution to part a, assume you have the appropriate report to provide the answer to this question.) ( A building supply has two locations in town. The office receives orders from two customers, each requiring 3/4-inch plywood. Customer A needs fifty sheets and Customer B needs seventy sheets. The warehouse on the east side of town has 80 sheets in stock; the west-side warehouse has 45 sheets in stock. Delivery costs per sheet are as follows: $0.50 from the eastern warehouse to Customer A, $0.60 from the eastern warehouse to Customer B, $0.40 from the western warehouse to Customer A, and $0.55 from the western warehouse to Customer B. a. Find the shipping arrangement that minimizes costs. (Copy the Relevant part of the Excel worksheet below with the answer) b. If customer B needs 5 more sheets, what is the absolute minimum you should charge them? Explain. (If you have no solution to part a, assume you have the appropriate report and provide the answer to this question.) c. If you find out that the west warehouse has only 41 sheets of plywood, how will that effect the costs? Explain. (If you have no solution to part a, assume you have the appropriate report and provide the answer to this question.) d. If you find out that the East Side Warehouse has 84 sheets of plywood, how will that effect the costs? Explain. (If you have no solution to part a, assume you have the appropriate report to provide the answer to this question.) (

Answer rating: 100% (QA)

The shipping arrangement to minimize costs will be East to Customer A 5 units West to Customer A 45 ... View the full answer