Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

ou Doll & Doll has two facilities that source, procure raw material, manufacture, QAQC and initial Pack for delivery. The company distributes the toys from

ou Doll & Doll has two facilities that source, procure raw material, manufacture, QAQC and initial Pack for delivery. The company distributes the toys from these two plants through two distribution centers (DCs) located at Wah & Jhelum, to three different customer regions namely, Islamabad, Rawalpindi, Lahore where the toys are packaged as per demand and sold.

Each plant has a maximum capacity for its weekly supply of toys. Likewise, each region has a minimum weekly demand for toys. Furthermore, distributer has asked to sell toys at their facility calling it factory outlets, so they havedemands as well. The cost to distribute a pallet of toys (100 toys per pallet) between each plant and region depends on the distances between them. The transportation costs, maximum supplies in the plants, and minimum demands intheregionsaresummarizedinthefollowingtables:

Origin Plant

Destination DC

Transportation Cost (Rs/Pallet of toys )

Plant 1

Wah

5600

Jhelum

4100

Plant 2

Wah

5200

Jhelum

4200

Origin DC

Destination Region

Transportation Cost (Rs/pallets of toys)

Wah

Lahore

7900

Rawalpindi

5200

Islamabad

4200

Jehlum

Lahore

4700

Rawalpindi

6500

Islamabad

6700

Plant

Maximum Supply (pallets of toys)

Plant 1

1300

Plant 2

1050

Region

Minimum Demand (pallets of toys)

Lahore

500

Rawalpindi

1000

Islamabad

350

Wah

100

Jhelum

150

I want solution by Excel Solver .How To Write demand of DC in excel ?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Operations Management

Authors: William J Stevenson

12th edition

2900078024107, 78024102, 978-0078024108

More Books

Students also viewed these General Management questions

Question

=+14.4. 1 Let C be the set of continuity points of F.

Answered: 1 week ago