Question: how do you put this in excel with solver? Finance Senator Porkbarrel habitually overdraws his three bank accounts, at the Congressional Integrity Bank, Citizens' Trust,

how do you put this in excel with solver?
how do you put this in excel with solver? Finance Senator Porkbarrel

Finance Senator Porkbarrel habitually overdraws his three bank accounts, at the Congressional Integrity Bank, Citizens' Trust, and Checks R Us. There are no penalties because the overdrafts are subsidized by the taxpayer. The Senate Ethics Committee tends to let slide irregular banking activities as long as they are not flagrant. At the moment (due to Congress' preoccupation with a Supreme Court nominee), a total overdraft of up to $10,000 will be overlooked. Porkbarrel's conscience makes him hesitate to overdraw accounts at banks whose names include expressions like "integrity" and "citizens' trust." The effect is that his overdrafts at the first two banks combined amount to no more than one-quarter of the total. On the other hand, the financial officers at Integrity Bank, aware that Senator Porkbarrel is a member of the Senate Banking Committee, "suggest" that he overdraw at least $2500 from their bank. Find the amount he should overdraw from each bank in order to avoid investigation by the Ethics Committee and overdraw his account at Integrity by as much as his sense of guilt will allow. X= Amount of Money He Overdraws his Congressional Integrity Bank Accour A (Format Y= Amount of Money He Overdraws his Citizens Trust Bank Account = A. Z= Amount of Money He Overdraws his Checks R Us Bank Account =

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 Accounting Questions!

Q:

\f