The worksheet Base Data in the Excel file Credit Risk Data provides information about 425 bank customers who had applied for loans. The data include the purpose of the loan, checking and savings account balances, number of months as a customer of the bank, months employed, gender, marital status, age, housing status and number of years at current residence, job type, and credit-risk classification by the bank.1. Use the COUNTIF function to determine (1) how many customers applied for new-car, usedcar, business, education, small-appliance, and furniture loans and (2) the number of customers with checking account balances less than $500.2. Modify the spreadsheet using IF functions to include new columns, classifying the checking and savings account balances as low if the balance is less than $250, medium if between $250 but less than $2000, and high otherwise.

Intronix uses copy editors, computer graphics specialists, and java programmers to produce ads for magazines and the internet. the average new ad for magazines typically requires 180 hours of a copy editor's time and 135 hours of a computer graphics specialist's time, whereas ads produced for the internet require 35 hours of copy editor time, 195 hours of computer graphics time, and 60 hours of a java programmer's time. lassie food, a dog food manufacturer, has hired intronix to produce ads in the next four week. although currently it considers magazine ads 3 times more valuable than internet ads, it still wishes to have at least 2 of each produced within the next four weeks. intronix has assigned up to 3 copy editors, 4 computer graphics specialists, and 1 java programmer, each committed to work up to 70 hours per week on the project. how many of each type of ad should be produced to maximize the overall value to lassie foods

On analyzing her company’s goods transport route, simone found that they could reduce transport costs by a quarter if they merged different transport routes. what role (job) does simone play at her company? simone is at her company.

Tri fecta, a partnership, had revenues of $369,000 in its first year of operations. the partnership has not collected on $45,000 of its sales and still owes $39,500 on $155,000 of merchandise it purchased. there was no inventory on hand at the end of the year. the partnership paid $27,000 in salaries. the partners invested $48,000 in the business and $23,000 was borrowed on a five-year note. the partnership paid $2,070 in interest that was the amount owed for the year and paid $9,500 for a two-year insurance policy on the first day of business. compute net income for the first year for tri fecta.