Find the number of books the library should buy

Assignment Help Operation Management

Reference no: EM131876468

You need this solved with Excel and work shown if Microsoft Excel steps don't fully explain everything. If possible, please use Excel Solver plugin.

If that doesn't work please use Microsoft to solve using reduced echelon form , system of equations and using Pivots.

Problem is...

The public library budgeted for fiction, nonfiction, and reference books as follows:

Purchase 500 books each month at a total cost of $19,500.

They purchased 50 more fiction than reference books. The average cost of fiction books is $30, of nonfiction is $40, and of reference is $50.

(a) Find the number of books the library should buy in each category.

(b) Because the library cannot buy a negative number of books, use the solution to find the maximum and minimum number in each category

Reference no: EM131876468

Questions Cloud

What will the permissions string look like for octal values : How will you save the complete listing of all files and directories in the system? What will the permissions string look like for these octal values?

In what ways can forecasters reduce the negative consequence : What are some of the negative consequences of "politics" on forecasting? In what ways can forecasters reduce the negative consequences.

How would you deal with the given situation : You are the Director of Security at Grey Corporation. Grey Corporation is a large multi-national company. Black Corporation is one of Grey's suppliers.

What are two advantage of encrypting data stored in database : What are two advantages of encrypting data stored in the database? Suggest a scheme for the secure storage of passwords.

Find the number of books the library should buy : Because the library cannot buy a negative number of books, use the solution to find the maximum and minimum number in each category

What is the purpose of having separate categories for index : What is the purpose of having separate categories for index authorization and resource authorization?

What is a gray market : What is a gray market? What products are commonly influenced by gray markets? How do gray-market sales affect international firms and their distribution channel

What and how are those assessments characterized : The needs assessment is a valuable tool used to facilitate the management of continuous change taking place in today's organizations.

Write an sql expression to define the given views : write an SQL expression to define the view containing the account numbers and customer names for all accounts at the Deer Park branch.

User Account

All Pages