Question: John often sells various items on eBay for extra cash. He is attempting to mail one of his recently sold items at the post office.

John often sells various items on eBay for extra cash. He is attempting to mail one of his recently sold items at the post office. He has a pouch of stamps left over from previous mailings and he desires to use those to mail the package while minimizing the total number of stamps affixed to the package. The post office has measured and weighed the package and determined that the cost to mail the package will be $4.27. He has the following stamp quantities and denominations in his pouch: 6 @ 56 cents, 4 @ 2 cents, 2 @ 58 cents, 5 @ 1 cent, and 3 @ $2.00.

Solve this as an IP problem to minimize the number of stamps used by John. Please solve this in excel using LP solver, show all the excel formular with objective coefficients, optimal solution, constraint, target cost, etc.

If you unable to directly perform computations in Excel or provide an Excel file through this text-based interface or cannot create an Excel file with these specific values, PLEASE DON'T ANSWER WITH TEXT OR guide me on how to set up and solve this as an Integer Programming (IP) problem in Excel using its Solver tool. It's not able to understand and follow the GUIDE.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

John often sells various items on eBay for extra cash. He is attempting to mail one of his recently sold items at the post office. He has a pouch of stamps left over from previous mailings and he...

Question 4 : ( worth 5 4 points ) John often sells varlous Items on eBay for extra cash. He is attempting to mail one of his recently sold items at the post office. He has a pouch of stamps left over...

Question 4 : ohn often sells various items on eBay for extra cash. He is attempting to mail one of his recently sold items at the post office. He has a pouch of stamps left over from previous...

Evaluation and Control in Strategic Management Evaluation and control information consists of performance data and activity reports (gathered in Step 3 in Figure 11-1). If undesired performance...

There are two problems due this week (each worth 35 points) as follows. Case 5-1David L. Miller: Portrait of a White-Collar Criminal (page 144). In comprehensive paragraphs, answerrequirements 1?6....

hi. I'm stuck with a report whose Chic Paints Ltd. and I am finding difficulty to answer some questions such as the organisations accounting system requirements including hardware and software...

Standard ratio analysis distinguishes between four categories of ratios. Describe how ratios in each category indicate strength or weakness in the underlying firms performance.

Berea Resources is planning a $75 million capital expenditure program for the coming year. Next year, Berea expects to report to the IRS earnings of $40 million after interest and taxes. The company...

In an equipment replacement decision, the cost of the old equipment is a ( n )

Which of the following are problems with identifying users of ABC? Multiple select question. ABC means different things to different organizations. Organizations will announce the discontinuance of...

developing thick cultural analysis grounded in interaction situations such as international joint ventures;

advancing understanding of the interaction processes of cultures, within power relations, that give rise to successful and unsuccessful hybrid forms of managing through cross-vergence of cultures;

breaking out of previously conceived and investigated cultural dimensions, to develop new concepts that are more helpful in overcoming pejorative assumptions about cultures outside Western traditions;