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

  Make the flowchart of the above business processes

create the flowchart of the above business processes. The assignment will be completed in 2 parts:1. AS-IS Model2.TO-BE Model once feedback is given from Professor after completing Part 1 (AS-IS Model)

  Baxter aviation database

ER diagram for the Baxter Aviation database

  Calculate canonical cover for set of functional dependencies

Calculate a canonical cover for above set of functional dependencies (show each step of your derivation with an explanation).

  Write down responsibilities of database administrator

Write down the responsibilities of the database administrator (DBA)? Could you outline tasks that he/she has to perform, and what could be consequences if these matters are not handled?

  Which is not a factor to consider in software evaluation

Which is not a factor to consider in software evaluation?

  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.

  Triggers important in database systems

What are triggers used for, and why are they important in database systems? Provide an example of a situation where a trigger would be appropriate.

  Which is not a factor to consider in software evaluation

Peer reviewers are the key participants in which activity?

  Design tables in 3nf various codes for at least three fields

Create tables in 3NF. As you create the database, include different codes for at least three of the fields. Use sample data to populate fields for at least three records in each table.

  Mark the words as index entries behavior and favorable

Mark the following words in the document as index entries: behavior (four instances), favorable (five instances), and impression (eight instances).

  Use contemporary case tools in process and data modeling

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

  Explain data for each candidate of eight constituencies

supplies % of votes each candidate is likely to receive, based on popularity rating. Actual number of votes received is that percentage of General votes. You should enter data for each candidate in each of the eight constituencies.

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