Questions
A receiving operator for a large grocery store is analyzing her operations. Trucks arrive to the...

A receiving operator for a large grocery store is analyzing her operations. Trucks arrive to the loading dock at an average rate of four per hour for each day. The cost of operating a truck is estimated to be $75 per hour. Trucks are met by a two-person crew, the crew can unload the truck in an average of 9 minutes. The payroll associated with each crew member is $18/hour. It is possible to install new equipment to help the crew operate more efficiently, decreasing the unloading time from 9 minutes to 7 minutes per truck. Rental of this equipment would increase the daily cost of the operation by $200 per day. Assume each day is an 8-hour shift. Should the new equipment be installed?

a) Consider the performance of the crew before the new equipment is installed. On average, how many trucks are in the system (to the nearest 0.01 trucks) given the arrival and service rates?

b) Consider the performance of the crew before the new equipment is installed. On average, how many hours (to the nearest 0.01 hours) does each truck spend in the system given the arrival and service rates?

c) Consider the performance of the crew before the new equipment is installed. Basing your cost on the number of trucks in the system, what is the total system cost (to the nearest dollar) per day (crew cost and truck cost)?

d) Consider the performance of the crew after the new equipment is installed. On average, how many trucks (to the nearest 0.01 trucks) are in the system given the arrival and the new service rate?

e) Consider the performance of the crew after the new equipment is installed. On average, how many hours (to the nearest 0.01 hours) does each truck spend in the system given the arrival and the new service rate?

f) Consider the performance of the crew after the new equipment is installed. Basing your cost on the number of trucks in the system, what is the total system cost (to the nearest dollar) per day (crew cost and truck cost)? g) Based on your cost analysis - is it worth it to install the new equipment?

In: Statistics and Probability

Waterways puts much emphasis on cash flow when it plans for capital investments. The company chose...

Waterways puts much emphasis on cash flow when it plans for capital investments. The company chose its discount rate of 7% based on the rate of return it must pay its owners and creditors. Using that rate, Waterways then uses different methods to determine the best decisions for making capital outlays.

This year Waterways is considering buying five new backhoes to replace the backhoes it now has. The new backhoes are faster, cost less to run, provide for more accurate trench digging, have comfort features for the operators, and have 1-year maintenance agreements to go with them. The old backhoes are working just fine, but they do require considerable maintenance. The backhoe operators are very familiar with the old backhoes and would need to learn some new skills to use the new backhoes.
The following information is available to use in deciding whether to purchase the new backhoes.

Old Backhoes New Backhoes
Purchase cost when new $88,300 $197,795
Salvage value now $42,500
Investment in major overhaul needed in next year $55,130
Salvage value in 8 years $14,900 $92,000
Remaining life 8 years 8 years
Net cash flow generated each year $29,800 $43,500

(a) Evaluate in the following ways whether to purchase the new equipment or overhaul the old equipment. (Hint: For the old machine, the initial investment is the cost of the overhaul. For the new machine, subtract the salvage value of the old machine to determine the initial cost of the investment.)

(1) Using the net present value method for buying new or keeping the old

(2) Using the payback method for each choice. (Hint: For the old machine, evaluate the payback of an overhaul.) (Round answers to 2 decimal places, e.g. 1.25)

(3) Comparing the profitability index for each choice. (Round answers to 2 decimal places, e.g. 1.25)

(4) Calculate the internal rate of return factor for the new and old blackhoes. (Round answers to 5 decimal places, e.g. 5.27647.)

(5) Comparing the internal rate of return for each choice to the required 7% discount rate.


.

In: Finance

Modify StudentLinkedList class by adding the following methods: printStudentList: print by calling and printing “toString” of...

Modify StudentLinkedList class by adding the following methods:

printStudentList: print by calling and printing “toString” of every object in the linkedList. Every student object to be printed in a separate line.

 deleteStudentByID(long id): delete student object from the list whose ID is matching with the passed parameter.

 sortListByID(): sort the linkedlist according to students IDs.

 findMarksAverage(): find the average of all marks for all students in the list.

 findMinMark(int markIndex): find the student with the minimum mark in a specific index:

o 0: Quizzes

o 1: Midterm Exam

o 2: Final Exam

import java.util.LinkedList;

public class StudentLinkedList {

public static void main(String[] args) {

LinkedList linkedlist = new LinkedList();

linkedlist.add(new Student("Ahmed Ali", 20111021, 18, 38, 38));

linkedlist.add(new Student("Sami Kamal", 20121021, 17, 39, 35));

linkedlist.add(new Student("Salem Salim", 20131021, 20, 40, 40));

linkedlist.add(new Student("Rami Mohammed", 20111031, 15, 35, 30));

linkedlist.add(new Student("Kim Joe", 20121024, 12, 32, 32));

linkedlist.addFirst(new Student("Hadi Ali", 20111025, 19, 38, 39));

linkedlist.addLast(new Student("Waleed Salim", 20131025, 10, 30, 30));

linkedlist.set(0, new Student("Khalid Ali", 20111027, 15, 30, 30));

linkedlist.removeFirst(); linkedlist.removeLast();

linkedlist.add(0, new Student("John Don", 20131025, 11, 31, 31));

linkedlist.remove(2);

}

class Student{

private String name;

private Long ID;

private int [] marks = new int [3];

public Student(String name, long ID, int quizzes, int mid, int fin) {

this.name = name; this.ID = ID;

marks[0] = quizes;

marks[1] = mid;

marks[2] = fin;

}

public String getName() {

return name;

}

public Long getID() {

return ID;

}

public int[] getMarks() {

return marks;

}

@Override public String toString() { String temp = "student: " + "name = " + name + ", ID = " + ID + ", marks = {" + marks[0] + ", " + marks[1] + ", " + marks[2] + "}"; return temp; }

}

In: Computer Science

This question uses the "Morphine" data set, available on Canvas. As usual, you have been randomly...

This question uses the "Morphine" data set, available on Canvas. As usual, you have been randomly assigned one of 10 versions of this data. Your version is 3.

2.3          M_S

3.5          M_S

1.1          M_S

8.1          M_S

2.4          M_S

1.9          M_S

4.8          M_S

8.6          M_S

3              M_M

11.6        M_M

12.5        M_M

4.8          M_M

9.4          M_M

10           M_M

12.5        M_M

19.4        M_M

13.4        S_S

6.1          S_S

14.8        S_S

5.2          S_S

20.2        S_S

1.6          S_S

8.9          S_S

20.3        S_S

27.1        S_M

19           S_M

35.4        S_M

20           S_M

25.7        S_M

17.5        S_M

25.4        S_M

17           S_M

24.4        M_M(new)

26.6        M_M(new)

38.8        M_M(new)

31.1        M_M(new)

20.4        M_M(new)

33.4        M_M(new)

25.6        M_M(new)

29.5        M_M(new)

1. Use Analyze / Fit Y by X to tell JMP what your predictor and response variables are. Then select Means / ANOVA from the drop down menu. Report the values of the following statistics:

a. SSG (JMP calls this "Treatment sum of squares"):

b. SSE:

c. MSG:

d. MSE:

e. The test statistic that tests H0:μM_S = μM_M = μS_S = μS_M = μM_M new:

2. Based on the result of this analysis, we can say (select all that apply):

We reject H0 and conclude that all group means are equal

We reject H0 and conclude that all group means differ from one another

We reject H0 and conclude that at least one group mean differs from the rest

The test statistic is bigger than we'd expect it to be if all group means were equal

The test statistic is smaller than we'd expect it to be if all group means were equal

The test statistic is about what we'd expect it to be if all group means were equal

The average between group variation is large relative to the average within group variation

The average between group variation is small relative to the average within group variation

The average between group variation is not very different from the average within group variation

3. From the "Oneway Analysis" drop down menu, select Compare Means / Each Pair, Student's t.

a. Select the pairwise comparisons that are significant, using a comparison-wise error rate of α=0.05

μM_S - μM_M

μM_S - μS_S

μM_S - μS_M

μM_S - μM_M(new)

μM_M - μS_S

μM_M - μS_M

μM_M - μM_M(new)

μS_S - μS_M

μS_S - μM_M(new)

μS_M - μM_M(new)

In: Statistics and Probability

Consider the following article and answer the questions that follows: "Globalisation has raised questions in terms...

Consider the following article and answer the questions that follows: "Globalisation has raised questions in terms of emerging volatility, uncertainty, rise in poverty, and inequality in economic status of people in developing countries. Globalisation has raised questions in terms of emerging volatility, uncertainty, rise in poverty, and inequality in economic status of people in developing countries. It is said that globalisation is a hallow gift for the developing world and an award for rich countries from the WTO—hence a painful gap is visible between haves and have nots. However, globalisation is not a recent phenomenon; it started since the dawn of colonisation, including of India, when traders of the British Empire took away raw materials like cotton and jute for production in Lancashire and the same returned to India in the form of fine fabrics. Because India was a colony of Britain, this trade was imposed upon us. The same process was taking shape in the colonies of Portugal and Spain, especially in Africa. But this form of trade changed after independence of India and other countries, and since then, a new turn took place in the structure of global trade—a kind of distortion of global trade on account of cut-throat competition that was followed by the forming of regional trading blocks such as the European Economic Community and European Free Trade Association, Latin American Free Trade Association, Andean Group, ASEAN, and COMECON. We can call this movement regional globalisation, which partially related to the whole world in terms of trade and technology. Later on, these regional trading blocks started intervening among each other’s trade, shifting their professional labour and technology. Following the birth of the WTO came professionalised globalisation—the age we are living in today. Of course, globalisation offers advantages such as production-scale efficiency, innovative technology, efficient utilisation of labour, net of tax price equalisation, and equalisation of productive world savings and investment resources. In fact, the WTO provided incentives to free flow of investment, technical knowledge, professionals and consumers. However, globalisation has facilitated both investing and withdrawing funds at such speed that even financial growth finds it hard to keep up with the frequency of volatility in financial markets. Take the example of Intel. The company has been making its microchips faster while lowering the cost per chip to gain market share at an accelerated rate. It’s nothing but expelling rivals to retain competitiveness and achieving monopolisation. Intel also moved most of its manufacturing capacities from the West to countries like Malaysia, Ireland, Israel, Turkey, North Korea and China, giving the company access to cheap and trained labour, and making it geographically close to its major markets. In India, globalisation is leading to growth of a new generation of young and rich, and then there are millions of rural and urban poor—and this inequality is growing. The rich are becoming preoccupied with their own advancement, given global complexities, the poor are in a state of existential poverty. A step to improve the excessively low poverty line in India is to base it on a “nutritious” food security line, and then include education, sanitation, permanent housing and so on as part of the criteria. Considering the size of India and her economic growth, poverty differs greatly from one state to another, so poverty lines should be adapted to each state and updated regularly. India is also infamous for child labour and underpayment. Solving this issue requires a different approach for towns and cities (factories) and for rural areas (agriculture). For the last few years, India has not been able to attract substantial foreign capital, its exports have slowed, and agriculture and manufacturing are registering muted growth. If a major part of the population remains poor and is denied opportunities to become self-sufficient, the impact would be felt across the country and the results could be destabilising. Yet another unrest is seen among retired citizens. Public expenditure on pensions and healthcare could double by 2040. So, India has to focus on two issues—slowing of population growth and increasing employment opportunities by augmenting agricultural and industrial production. Agricultural sector would need better irrigation resources, fertilisers and mechanisation. India also lacks skilled staff in sectors like manufacturing, transport and financial. The government is working to reduce inequality and is extending its forces to unite the scattered countries into one universe of peace and productivity." Evaluate the following statement : "Globalisation has raised questions"?? Ofcourse Globalisation offers advantages . Explain using examples of globalised advantages? Identify and provide a detailed of any two drivers of globalisation discussed above?

In: Economics

Question 1 Global Health focuses on: A. Health issues that transcend national boundaries B. Development and...

Question 1

Global Health focuses on:

A.

Health issues that transcend national boundaries

B.

Development and implementation of solutions which often require global cooperation

C.

Health equity among nations

D.

All of the above

Question 2

In 2015, the maternal mortality ratio was the highest in:

A.

Sub-Saharan Africa

B.

South Asia

C.

Middle East and N. Africa

D.

Latin America and Caribbean

Question 3

Which one of these is NOT a reform enacted by the WHO after the Ebola outbreak:

A.

Establishment of the Health Emergencies Programme

B.

Establishment/support of an emergency contingency fund

C.

Establishment/support of a global health emergency workforce

D.

Creation of a global health committee within the UN Security Council

Question 4

The ____ is responsible for administering the International Health Regulations (IHR) the only internationally-agreed set of rules governing the timely and effective response to outbreaks and other health emergencies that may spread beyond the borders of an affected country.

A.

Bill and Melinda Gates Foundation

B.

CDC

C.

WHO

D.

None of the above

Question 5

According to the video on the social determinants of health, the great health inequalities which exist between and within countries is mostly due to lack of access to health care.

True

False

Question 6

In this week’s reading on Ebola, Mackey concludes that complex global health challenges should be borne by the WHO alone.

True

False

Question 7

Which one of the following is NOT a social determinant of health established by the WHO’s Commission on the Social Determinants of Health:

A.

social gradient

B.

social exclusion

C.

stress

D.

social media

Question 8

The Millenium Development Goals and the Sustainable Development Goals have which goal in common:

A.

End poverty

B.

Affordable and clean energy

C.

Responsible consumption and production

D.

A and C

Question 9

One of the major global health challenges facing the world today is antimicrobial resistance.

True

False

Question 10

In the 21st century, famines have increased in the world and are at the highest peak since:

1945

1957

1998

None of the above

Question 11

In Sierra Leone one out of every ____________mothers has a lifetime risk of dying from childbirth-related issues.

A.

100

B.

545

C.

17

D.

65

Question 12

Which one of these is a specific cause of pregnancy related morbidity and leads to the woman being stigmatized, as shown in the documentary on Sierra Leone:

A.

anemia

B.

hemorrhage

C.

obstetric fistula

D.

pregnancy-related hypertension

In: Nursing

C++ Develop program in C++ using arrays of characters, subscript operator, the cstring library, and functions...

C++

Develop program in C++ using arrays of characters, subscript operator, the cstring library, and functions with arguments. Create programs with small functions where main goes to a series of functions where the real work takes place. Don’t use global variables and don’t use break within a loop (unless working with a switch statement). Functions can’t have more than 30 statements of code, not including comments, blank lines, or variable definitions. Don’t use a return in the middle of the loop

Most words in the English language are based on words from ancient Greek and Latin. Breaking down a word and understanding its root can really help in understanding the meaning of more complex words. A root can be at the beginning, middle, or end of a word. A root of a word has no prefix or suffix – think of it as the most basic part of a word. Common prefix and suffix added to roots are things like:

  • Prefixes: un, anti making words like unclear, antibody
  • Suffixes: able, or tion, making words like solvable or solution.
  • There are others

Find the root of a word, so there is a better chance of understanding the meaning of the word.

Help the user find the root of a word by removing the affixes (both prefixes and suffixes). Limit the number of prefixes and suffixes to just 3 each that will be removed. Enter those from the user rather than hard-coding them.

Once the six affixes are supplied, the program should let the user enter in a sentence and get rid of all of the prefixes and suffixes to show what the sentence would be like in the most basic form. Words can be no longer than 20 characters and sentences no longer than 200 characters. Work word by word or process the entire sentence all at once.

    1. Sentences may have capital letter. A capitalized word or one all in upper case should be handled the same as one with lower case letters. Maybe write a function to turn everything read in into the same case to avoid long conditionals.
    1. Realize that sentence may have punctuation. These will not be part of the root of a word and should be removed.
  • read into an array of characters.
  • prompt the user for any input requested. Make sure it is clear from your prompts what the user is expected to do.
  • Use the cstring library with strlen to know when to stop processing the array of characters. strlen should not be in the conditional expression. Consider using it prior to a loop and storing the results of strlen in a variable.
  • Don’t use any global variables in this program!
  • Don’t use the string class – instead use arrays of characters with cstrings
  • Make sure to use C++’s I/O (iostream library) for your input and output.
  • functions must be written

In: Computer Science

Consider the following scenario: Kellogg’s distribution of cereal products to customers in Guatemala is coordinated through...

Consider the following scenario: Kellogg’s distribution of cereal products to customers in Guatemala is coordinated through Crowley Maritime Corporation, a U.S.-owned and operated third-party logistics company (3PL) with a distribution centre in Guatemala City, Guatemala. Orders for the Latin America region were consolidated, and aggregate orders were placed with Kerry Inc. in Gridley, Il. Kerry Inc. shipped consolidated orders, palletized and labelled by distributor, by intermodal to Mexico City, at which point trailers with orders for distributors in countries south of Mexico were moved over the road. Crowley’s general manager in Guatemala City advised Kellogg’s head office personnel in Battle Creek, Michigan that they had identified approximately 140 pallets of salmonella-contaminated cereal products still in wholesale inventory in Guatemala. Unfortunately, despite FDA recommendations for disposal, government officials in Guatemala, upon learning of the recall through their government Facebook account, had contacted Crowley and insisted that no contaminated food products be disposed of in Guatemala. Furthermore, since the contaminated products had been shipped from the United States, Guatemalan authorities insisted that the contaminated products be returned to the U.S. for disposal. Kellogg’s Supply Chain Manager had already spoken with their freight forwarder and customs broker regarding arrangements to return the contaminated products to the U.S. Mexican authorities would not allow the contaminated products to transit through Mexico, which left marine transport as the only economically viable option to ship the contaminated products from Guatemala to the U.S. Kellogg’s customs broker had placed a call to US Customs and Border Protection (CBP) for advice since the returning goods would be labelled “CONTAMINATED – Not for Resale – Goods returned for disposal only”. Since the returning shipment would not be subjected to the same level of scrutiny as a commercial shipment, CBP expressed concerns that someone might target the shipment for smuggling or terrorism reasons. As a result, CBP stated they would only allow the shipment to enter the US if the origin port was compliant with the International Ship and Port Facility Security Code (ISPS) and the Container Security Initiative (CSI).

c) Identify and describe the relevant cargo security programs that are involved in the reverse logistics scenario described above For example:

i) In which security programs would membership likely benefit Crowley, Kellogg’s USA, and Kerry Inc.? Why? (5 points)

ii) What would the Harmonized Code, and rate of duty, be when returning these goods to the US? Provide the appropriate reference. (5 points)

In: Operations Management

Task CPP Some information on the Internet may be encrypted with a simple algorithm known as...

Task CPP

Some information on the Internet may be encrypted with a simple algorithm known as rot13, which rotates each character by 13 positions in the alphabet. A rot13 cryptogram is a message or word in which each letter is replaced with another letter.

  • rot13 is an example of symmetric key encryption.

For example, the string

    the bird was named squawk

might be scrambled to form

    cin vrjs otz ethns zxqtop

Details and Requirements

  1. The test driver file lab3.cpp contains an incomplete implementation of the cipher as defined as the class Rot13.

  2. To allow user input a string, you need to override the stream extraction operator >> for the Rot13 class. The class contains the string field text that must be filled with the input text.

  3. The input string may only contain Latin lowercase letters and spaces. Write the method valid that checks if the input satisfies the above condition.
    • If the input contains valid characters then the method returns true value, otherwise it returns false.
  4. Write the method encrypt that encodes the input string using rot13 cipher. The encryption procedure replaces every occurrence of the character with the character 13 steps forward in the alphabet (in a circular way) . For example, a with n , b with o , and x with k, and so on.
    • Spaces are not scrambled.
    • You can transform characters to numbers which would allow to perform rotation transformation using addition/subtraction operations.
    • You can find numerical codes for letters in ASCII Table
  5. To output encrypted text on the screen, you need to override the stream insertion operator << for the Rot13 class.

Instructions

  • Use the file lab3.cpp which contains the testing driver code.
  • Implement Rot13 missing methods, so the program can be executed.
  • Test your program with the provided test input cases.

lab3.cpp

#include <iostream>
#include <string>
#include <iomanip>
using namespace std;


class Rot13 {
friend ostream& operator<<(ostream&, const Rot13&);
friend istream& operator>>(istream&, Rot13&);

string text;
public:
Rot13();
bool valid();
void encrypt();
};

bool Rot13::valid() {
}

void Rot13::encrypt() {
}

ostream& operator<<(ostream& out, const Rot13& c) {
}

istream& operator>>(istream& in, Rot13& c) {
}

/*
Please enter the text: ABCDEFGHIJKLMNOPQRSTUVWXYZ
Invalid input!
Please enter the text: slkgjskjg akjf Adkfjd fsdfj
Invalid input!
Please enter the text: abcdefghijkl mnopqrst uvwxyz
Encoded text: "nopqrstuvwxy zabcdefg hijklm"
*/
int main() {
Rot13 cipher;

cout << "Please enter the text: ";
cin >> cipher;
if (!cipher.valid()) {
cout << "Invalid input!" << endl;
return 1;
}
cipher.encrypt();
cout << "Encoded text: " << cipher << endl;
return 0;
}

In: Computer Science

1. Muna Hsu is an assistant hospitality manager at the Icehouse Arena, home to the Springfield...

1. Muna Hsu is an assistant hospitality manager at the Icehouse Arena, home to the Springfield Sharks (the town’s amateur hockey team.) Muna is summarizing two years of sales data from her food vendors. Since each stand supports a different section of the arena, Muna will need to coordinate and consolidate sales data on multiple worksheets. Break the external link that exists in the worksheet, so that the formulas in cells B4, B5, B6, and B7 of the Vendor Information worksheet are replaced with static values. Then switch to the Vendor Information worksheet. 2. Muna wants to update the links in her workbook, so that she’ll be able to quickly pull up the Vendor pricing plans for the 2019-2020 season. In cell B9, create a hyperlink to the Icehouse Arena Vendor Refreshment Price listing for 2019-2020 season as described below: a. The hyperlink should link to the Support_NP_EX16_6a_VendorPrices1920.docx file, available on the SAM website. b. The hyperlink should use 2019-2020 Vendor Refreshment Prices as the text to display. c. The hyperlink should use Click here to view the Vendor Refreshment Price listing for the 2019-2020 season. as the ScreenTip text. 3. Edit the hyperlink Icehouse Arena website in cell B10 as described below: a. The hyperlink should use Icehouse Arena Vendor Website as the display text. b. The hyperlink should use Click here to access the Icehouse Arena Vendor website. as the ScreenTip text. 4. Muna now wishes to give a consistent look and feel to the worksheets submitted by each of the vendor stands. Group the North, East, and South worksheets together and then make the following formatting updates: a. Change the font size in the merged range A1:I1 to 28 pt. b. Apply the Heading 3 cell style to the merged range A2:I2. c. Bold the values in the range A5:A10. d. Apply the Accounting number format with zero decimal places and $ as the symbol to the range B5:I10. (Hint: Depending how you complete this step, the number format for this range may display as Custom.) Do not ungroup the worksheets. 5. With the North, East, and South worksheets still grouped, update the worksheet as described below: a. In cell A7, edit the text to read Shark Bites (instead of Pepperoni Bite). b. In cell A9, edit the text to read Pizza Frenzy (instead of Pizza). Do not ungroup the worksheets. 6. With the North, East, and South worksheets still grouped, select the range B11:H11. Using the AutoSum button, enter a formula using the SUM function that totals the sales for each month of the hockey season (shown in the range B5:H10). Ungroup the worksheets and then check to confirm that the formatting and formulas from steps 4-6 are present in all three worksheets. 7. Muna wants to create a copy of the formatted South worksheet to use for the West section of the arena’s sales data. Create a copy of the South worksheet between the South worksheet and the Consolidated Sales worksheet then update the worksheet as described below: a. Rename the copied worksheet using West as the name. b. In the merged range A2:I2, edit the text to read Feeding Frenzy (instead of Shark Tooth). c. Clear the contents of the range B5:H10. 8. Muna now wishes to consolidate the data from each of the vendor stands. Switch to the Consolidated Sales worksheet. In cell A5, enter a formula without using a function that references cell A5 in the North worksheet. Copy the formula from cell A5 to the range A6:A10 without copying the formatting. 9. In cell B5, enter a formula using the SUM function, 3-D references, and grouped worksheets that totals the values from cell B5 in the North:West worksheets. Copy the formula from cell B5 to the range B6:B10 without copying the formatting. Then copy the formulas and the formatting from the range B5:B10 to the range C5:H10. 10. Muna wants to compare the sales from the 2019-2020 season to the 2018-2019 season and needs to include the missing data. Open the support file Support_NP_EX16_6a_1819VendorSales.xlsx. Switch back to the NP_EX16_6a_FirstLastName_2.xlsx workbook and go to the Consolidated Sales worksheet. Create external references in the Consolidated Sales worksheet to the sales information found in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook as described below: a. Using external cell references, link cell J5 in the Consolidated Sales worksheet to cell H5 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. b. Using external cell references, link cell J6 in the Consolidated Sales worksheet to cell H6 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. c. Using external cell references, link cell J7 in the Consolidated Sales worksheet to cell H7 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. d. Using external cell references, link cell J8 in the Consolidated Sales worksheet to cell H8 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. e. Using external cell references, link cell J9 in the Consolidated Sales worksheet to cell H9 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. f. Using external cell references, link cell J10 in the Consolidated Sales worksheet to cell H10 in the Consolidated Sales 2018-2019 worksheet in the Support_NP_EX16_6a_1819VendorSales.xlsx workbook. g. Do not break the links.

vendor information

Springfield Sharks
Stand Manager Stand Name Extension
North Loki Mylosky Fins' Wake X642
East Sara Ryons Final Bite X643
South Jacob Caron Shark Tooth X678
West Kevin Staszowski Feeding Frenzy x694

North file

Springfield Sharks
Fins' Wake
October November December January February March April Total
Shark Dog 45750 30960 36045 60435 52470 36270 43913 305843
Nacho Wave                      24,775                      32,490                      40,740                      37,620                      40,830                      34,050                      19,275                   229,780
Pepperoni Bite                      31,195                      67,014                      30,447                      41,922                      44,931                      50,286                      24,608                   290,403
Popcorn                      20,983                      61,809                      81,180                      74,778                      28,050                      80,355                      51,425                   398,580
Pizza                      29,970                      29,448                      42,156                      26,172                      48,420                      42,876                      15,060                   234,102
Soda                      17,160                      22,032                      17,460                      22,032                      23,346                      10,836                      33,765                   146,631
Total $                             -

East file

Springfield Sharks
Final Bite
October November December January February March April Total
Shark Dog 54637.5 47280 21750 34560 85470 24030 45750 313477.5
Nacho Wave                      36,125                      51,885                      54,495                      22,410                      19,800                      52,335                      30,550                   267,600
Pepperoni Bites                      40,078                      16,218                      37,944                        7,599                      60,435                      75,327                      31,153                   268,753
Popcorn                      41,718                      27,456                      35,880                      17,355                      17,667                      18,837                      27,005                   185,918
Pizza                      22,830                      65,880                      33,480                      37,440                      26,520                      85,140                      36,780                   308,070
Soda                      24,345                      13,650                        4,980                      42,480                      22,500                      37,380                      21,585                   166,920
Total $                             -

South

Springfield Sharks
Shark Tooth
October November December January February March April Total
Shark Dog 41625 94170 88860 53700 93270 40290 51562.5 463477.5
Nacho Wave                      24,625                      46,800                      30,015                      15,750                      35,865                      26,550                      16,150                   195,755
Pepperoni Bites                      31,535                      55,335                      14,382                      67,881                      45,645                      74,256                      61,370                   350,404
Popcorn                      16,995                      37,050                        4,719                      33,852                      46,917                      38,025                      45,678                   223,236
Pizza                      32,460                      79,620                      81,060                        8,160                      47,940                      61,800                      40,110                   351,150
Soda                      34,860                        4,170                      39,420                      26,250                      29,400                        7,020                      19,380                   160,500
Total $                             -

Consolidated sales

Springfield Sharks
2018-2020 Consolidated Sales
October November December January February March April Total 2018-2019 Totals
$                          -  
                             -  
                             -  
                             -  
                             -  
                             -  
Total $                             - $                             - $                             - $                             - $                             - $                             - $                             - $                             - $                              -

Suppoort NPX16 6A 1819VENDORSALES.xls

Consolidated Sales 2018 2019

Springfield Sharks
2018-2019 Consolidated Sales
October November December January February March-April Total
Shark Dog $       176,096 $       215,513 $       183,319 $       185,869 $       289,013 $       302,269 $         1,352,077
Nacho Wave           107,762           163,969           156,563              94,725           120,619           223,638                 867,274
Pepperoni Bite           133,650           173,209           103,466           146,753           188,764           396,249             1,142,090
Popcorn           102,010           157,894           152,224           157,481           115,793           326,656             1,012,056
Pizza           109,985           218,685           195,870              89,715           153,600           352,208             1,120,063
Soda              97,747              49,815              77,325           113,453              94,058           162,458                 594,855
Total $       727,249 $      979,084 $       868,766 $       787,995 $      961,845 $   1,763,476 $         6,088,415

support NP EX16 vendorprices1920.docx

Springfield Sharks

Vendor Prices 2019 – 2020

Fins’ Wake

Final Bite

Shark Tooth

Feeding Frenzy

Shark Dog

$5.99

$6.50

$5.99

$6.50

Nacho Wave

$4.99

$4.50

$5.50

$4.50

Shark Bites

$6.50

$5.99

$5.99

$6.50

Popcorn

$3.99

$4.99

$4.50

$3.50

Pizza Frenzy

$5.99

$6.50

$4.99

$4.50

Soda

$4.50

$4.99

$4.50

$5.25

In: Accounting