Answer Questions A & B using a excel spreadsheet that uses the Solver function.Answer the questions in written format on another sheet in excel after the excel spreadsheet proves the modelShipping Carpets: A manufacturer of nylon carpets produces rolls of carpeting atfour factories and ships them to distributors in five locations. The table below showsthe capacities at the factories and the demands at the distributors for the nextquarter, all given in thousands of rolls. Also shown are the unit transportation costsbetween each factory and each distributor, stated in cost per roll. D1 D2 D3 D4 D5 CopocigrF1 42F2 F1F3 53F4 52Demand 4-1 56 29 31 59 [a] 10 points: If the manufacturer wishes to meet the demand at the minimumtotal transportation cost, what is the optimal distribution plan and its cost? [b] 10 points: Suppose that the manufacturer’s policy is that each distributormust be supplied from a single factory. What is the optimal distributionplan under this policy?
Plagiarism-free and delivered on time!
We are passionate about delivering quality essays.
Our writers know how to write on any topic and subject area while meeting all of your specific requirements.
Unlike most other services, we will do a free revision if you need us to make corrections even after delivery.
How it Works
Place an order
Fill out the order form.
Attach any custom instructions that is required to complete your order.
Pay online safely.
The order form will redirect you to a payment page.
Receive Order via Email
Once the order is complete, we’ll send it via the email provided on the order form.