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?
“I’m trying to write my paper and I’m stuck. Can you help me?”
Yes, we can help you achieve academic success without the uncessary stress of deadlines.
Our reliable essay writing service is a great opportunity for you to save your time and receive the best paper ever.
Solver function
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.