Question: Please only answer my whole question parts a), b) & c) ON EXCEL AND POST SCREENSHOTS PLZZZ, thank you . Please only answer if you

Please only answer my whole question parts a), b) & c) ON EXCEL AND POST SCREENSHOTS PLZZZ, thank you . Please only answer if you have access to a personal computer. Plz provide equations and explanations. Please I will give a thumbs up for your efforts so plz don't copy and paste from any online sources.

When Vidalia onions are ready, the entire 13 county (plus parts of seven other counties) area in Georgia where they are grown is devoted to the harvest, packaging and shipping of this delicacy. The Onion Shack currently purchases 120,000 bags of onions each year at a price of $100 per bag (a bag is ten pounds). Onion Shack has historically purchased in lots of 3000 bags. Transit time and capacity vary as indicated in the table. The safety inventory that Onion Shack requires is 30% of lead time demand and the holding cost for a bag is 15% of the cost.

Carrier

Quantity Shipped (cwt)

Quantity shipped (bags)

Shipping cost ($/cwt)

Transit time (days)

Mashburn Rail

200+

2000+

$2.10

5

Sylvia Express

100+

1000+

$2.35

3

Anita Enterprises

250+

2500+

$1.35

3

Smith Trucking

250+

2500+

$1.00

3

  1. determine the least expensive transportation option if the Onion Shack continues to purchase 120,000 bags of Vidalia onions each year.
  2. determine the least expensive transportation option if the Onion Shack purchases 240,000 bags of Vidalia onions each year.
  3. determine the least expensive transportation option if the Onion Shack purchases 480,000 bags of Vidalia onions each year.

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!