What amounts will be require for ordering supplies

Assignment Help Database Management System
Reference no: EM13330371

Refer to the medical supplies for Banjul case. Design a spreadsheet that will enable you to request the required funds from your team's finance officer, order supplies from the home office, and ensure dissemination of appropriate quantities to each village. Your final order to the home office should specify the number of packages required of each item.

a. The population figures will show that there are 3000 children, 2500 teenagers, 500 seniors, and 9000 other adults in the population. If there were no stock on hand, what amount would be required for ordering supplies?

b. using the parameters in (a), construct a graph showing how the amount required for the order would vary if the unit cost of a package of bandages rose by $0.25, $0.50, and so on, up to $3.00 per package.

c. Following up on (a), a check on stock shows an inventory of 124 packages of A-bandages, 16 packages of B-bandages, 82 packages of

C-bandages, 72 rolls of tape, and 4 hearing aids. What amounts will be require for ordering supplies?

Reference no: EM13330371

Questions Cloud

How to calculate the change in ph of rainwater : Calculate the change in pH of rainwater resulting from an increase in the Pressure of CO2 from 10^-3.5 atm to 10^-3.0 atm due to fossil fuel emissions
Determine the induced current in the inner loop : A small, 2.00-mm-diameter circular loop with R = 1.40×10?2? is at the center of a large 110-mm-diameter circular loop. What is the induced current in the inner loop
Spinning-weaving-printing-designing andquality control : ABC textile Company hasfive departments, spinning, weaving, printing, designing andquality control. Mr. Ali has been working in spinning departmentfor the last four years. Now he is in search of a new job becauseof the monotonous and rigid department..
Explain the formal charge on the indicated atom : What is the formal charge on the indicated atom in each of the following species? sulfur in SO2 nitrogen in N2H4 each oxygen atom in ozone, O3
What amounts will be require for ordering supplies : Design a spreadsheet that will enable you to request the required funds from your team's finance officer, order supplies from the home office, and ensure dissemination of appropriate quantities to each village.
The human reaction at operating a stop watch : The human reaction at operating a stop watch
Explain how you would obtain the standard molar entropy : The molar heat capacity of Cu(s) at 1 atm pressure has been measured over a range of temperatures from close to 0 K to 400 K. Describe how you would obtain the standard molar entropy of Cu(s) at 298 K.
Determine the leakage resistance : Capacitors won't hold a charge indefinitely; as time goes on, charge gradually migrates from the positive to the negative plate. What is the leakage resistance
Identify five indicators of a financial nature : Identify five indicators of a financial nature that may raise doubt on an entity's ability to continue as a going concern and what evidence should the auditor obtain with respect to management's plan about the various mitigating factors identified i..

Reviews

Write a Review

Database Management System Questions & Answers

  Explain evaluating a proposal for acquisition and sourcing

When evaluating a proposal for acquisition and sourcing, are there considerations that are unique in the case of an IT project versus a non-IT project

  Specify the foreign keys for schema

First, specify the foreign keys for this schema, stating any assumptions you make. Next, populate the relations with a few example tuples.

  How protocol ensures serializability and deadlock freedom

To lock any other vertex, the transaction must have visited all the parents of that vertex and must be having a lock on one of the parents of the vertex. Show that the protocol ensures serializability and deadlock freedom.

  Define basic entity relationship diagram colleges

E-R diagram - Basic Entity Relationship Diagram Colleges and universities must draw a clear connection between the requirements of the field for which the student is being prepared and the things required of the student as part of that preparation pr..

  Develop basic tools to expedite use of oracles dictionary

Write a script that provides all of the information in, and duplicates the formatting of, Oracle's SQL*Plus describe command. Additionally, the output should add the comments on the rows. Input: owner and table name. Output: columns for Name, Null..

  Discuss advantages and disadvantages of xml in application

XML is one of the base technologies around which many other technologies are developing. Describe an application used at work (or online) that is based on XML and discuss the advantages and disadvantages of XML in this application.

  How do these change with variation in the condence values

Looking at the predictive accuracy (Percent correct) results for tree learning on these data sets, has learning improved accuracy over the baseline ?

  List all the functional dependencies present in the relation

You must implement the entity relationship model provided in the model solution to Assignment 1. The model solution will be released on the course website approximately TWO (2) weeks after the Assignment 1 due date.

  Examine hard-to-obtain data from two separate databases

You are interested in examining some hard-to-obtain data from two separate databases. Each database comprises numerical values - so there are 2n values total

  How to create a biological database based on viruses

How to decide which attribute should be there in the table and schema? How to identify the primary keys, foreign keys, domain, E-R diagram and 20 Queries on the same database.

  Create a struct data structure for each file contained

Write a password protected console-based application, which enables you to create user accounts and specify the name of the file or directory to be shared with other users.

  When would creating an index reduce overall database perform

Indexing can affect the performance of a general-purpose database that has roughly equal numbers of fetches and changes. The decision to add an index can improve the performance of a system but can also degrade it.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd