Please answer the question e), f), and g). Thank you ...

80.2K

Verified Solution

Question

Accounting

Please answer the question e), f), and g). Thank you

image

image

Company X produces office desks at two plants. Plant P1 has an annual capacity of 200,000 desks; plant P2 has an annual capacity of only 60,000 desks. There are three different market areas for desks. Each market requires at least the following shipments: market 1: 50,000 desks per year, market 2: 100,000 desks per year, and market 3: 50,000 desks per year. Desks can be shipped from the plants to the markets via two warehouses. The distribution cost per desk between plants and warehouses, and between warehouses and markets are shown in Table 1. (Note:in the Table means that this distribution route is not relevant or not possible at the moment.) Table 1: Distribution cost (E per desk) between plants and warehouses (W/H) and between warehouses and markets W/H 1 W/H 2 Market 1 Market 2 Market 3 From: P1 P2 W/H 1 W/H 2 2 4 The company's problem is to find out how many desks to produce at each plant, and how to ship the desks to the markets such that the total distribution cost is minimised. A linear programming model was formulated-the Excel layout (with optimal solution) and the Solver sensitivity report are shown in Figure 1 and Figure 2 From: Plant 1 Plant 2 Warehouse 1 Warehouse 1 Warehouse 2 Market 1 Marke ket 3 Total flow 140000 60000 140000 140000 60000 50000 90000 1000 10000 Total flow in 140000 50000 Unit cost: Warehouse 1 Warehouse 2 Market 1 Market 2 Market 3 Plant 1 Plant 2 Warehouse 1 Warehouse 2 Constraints Capacity Plant 1 140000 Demand Market 1 Demand Market 2 Demand Market3 Flow balance W/H 1 Flow balance W/H 2 50000 100000 100000 Total cost 40000

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students