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

  Design scheme for determining wine bottle which poisoned

Design a scheme for determining exactly which one of the wine bottles was poisoned in just one month's time while expending O(logn) taste testers.

  Database to keeps track of students in university

University XYZ needs a database that keeps track of students, what classes they taken and the grades for each of the classes.

  Dimensions and attributes in a star schema model

Explain the use of facts, dimensions and attributes in a star schema model. Explain the use of facts, dimensions and attributes in a star schema model.

  Could a relation be stored as a sequential file

Suppose a sequential file contains 50,000 records, and 5 milliseconds are required to interrogate an entry. How long should we expect to wait when retrieving a record from the middle of the file?

  Use contemporary case tools in process and data modeling

Discuss the requirements needed to build a database for the scheduling process.

  Create a database.

Create a database.

  Draw an e-r diagram

Draw an E-R Diagram and draw an E-R Diagram for Student Information System.

  An active database in pl-sql

Did the corresponding lines for invoices 1001 and 1008 in table LINE get deleted automatically? Can you explain why?

  Provide an entity relationship model

Provide an Entity Relationship Model (ERM) that will describe the data structure that will store all data elements and analyze the university's requirements and provide a proposal to organize all the required data elements.

  Diagram and determine the possible iterative steps

Determine the steps in the development of an effective Entity Relationship Model (ERM) Diagram and determine the possible iterative steps / factors that one must consider in this process with consideration of the HR core functions and responsibili..

  Draw relational schema and show functional dependencies

Draw relational schema and show functional dependencies Comprehensive schema that shows existing PK and all functional, partial and transitive dependencies Detailed schema that shows existing PK and most functional, partial and transitive dependen..

  Create the database using three tables

Create the database using three tables: one for student information, one for advisor information, and one for department information.

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