Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The United States Postal Service (USPS) is responsible for screening packages at mail distribution centers around the country. The USPS is considering the purchase

 

The United States Postal Service (USPS) is responsible for screening packages at mail distribution centers around the country. The USPS is considering the purchase of three types of screening machines for screening packages: Machine A, Machine B, and Machine C. The objective is to maximize the total screening capacity in packages screened per day, given a budgetary allocation of $10 million. Machine A can process 200 packages per hour and costs $1.2 million. Machine A requires 1 postal clerk and can run for 18 hours per day. Machine B can process 150 packages per hour and costs $1.5 million. Machine B requires 2 postal clerks and can run for 16 hours per day. Machine C can process 180 packages per hour and costs $1.8 million. Machine C requires 2 postal clerks and can run for 20 hours per day. There are 100 available postal clerks per day, and the total number of machines must not exceed 30. Using Excel Solver, formulate this problem as an LP to find the number of machines to be purchased to maximize the screening capacity in packages screened per day.

Step by Step Solution

3.44 Rating (160 Votes )

There are 3 Steps involved in it

Step: 1

To formulate this problem as a Linear Programming LP model in Excel Solver you can follow thes... 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

Microeconomics

Authors: Dean Karlan, Jonathan Morduch

1st edition

978-0077332587, 007733258X, 978-0077332648, 77332644, 978-1259163531

More Books

Students also viewed these General Management questions

Question

find all matrices A (a) A = 13 (b) A + A = 213

Answered: 1 week ago