Question: IBS LMS Question 3 Refer the tables given below(Table1 and Table 2) to answer the following questions. Not yet answered Marked out of Write the

IBS LMS Question 3 Refer the tables given

IBS LMS Question 3 Refer the tables given below(Table1 and Table 2) to answer the following questions. Not yet answered Marked out of Write the function to calculate the output shown in output table i.e. 5.00 Q1 Number of Shirt white sold in Feb in USA P Flag question Q2 Total Sales Revenue of Shirt white sold Q3 Average sales revenue of UK Q4 Sales by Nancy Freehafer Q5 Total sales in USA in Feb Table 1 Month Product Country Jan Shirt white USA Sales Revenue Sales Representative $546.00 Mariya Sergienko $519.00 Mariya Sergienko Jan Shirt blue UK Feb Shirt white USA $492.00 Andrew Cencini Feb Shirt blue USA $559.00 Nancy Freehafer Feb Pant white UK $591.00 Jan Kotas Feb Shirt white USA $535.00 Jan Kotas Mar Shirt yellow USA $468.00 Anne Larsen Apr Shirt blue USA $568.00 Anne Larsen Table 2 (Output Table) 2 Q1 Number of Shirt white sold in Feb in USA Q2 Total Sales Revenue of Shirt white sold 1573 555 Q3 Average sales revenue of UK 559 Q4 Sales by Nancy Freehafer Q5 Total sales in USA in Feb 1586 7 A B I IBS LMS Question 3 Refer the tables given below(Table1 and Table 2) to answer the following questions. Not yet answered Marked out of Write the function to calculate the output shown in output table i.e. 5.00 Q1 Number of Shirt white sold in Feb in USA P Flag question Q2 Total Sales Revenue of Shirt white sold Q3 Average sales revenue of UK Q4 Sales by Nancy Freehafer Q5 Total sales in USA in Feb Table 1 Month Product Country Jan Shirt white USA Sales Revenue Sales Representative $546.00 Mariya Sergienko $519.00 Mariya Sergienko Jan Shirt blue UK Feb Shirt white USA $492.00 Andrew Cencini Feb Shirt blue USA $559.00 Nancy Freehafer Feb Pant white UK $591.00 Jan Kotas Feb Shirt white USA $535.00 Jan Kotas Mar Shirt yellow USA $468.00 Anne Larsen Apr Shirt blue USA $568.00 Anne Larsen Table 2 (Output Table) 2 Q1 Number of Shirt white sold in Feb in USA Q2 Total Sales Revenue of Shirt white sold 1573 555 Q3 Average sales revenue of UK 559 Q4 Sales by Nancy Freehafer Q5 Total sales in USA in Feb 1586 7 A B

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

The management team of Wickersham Brothers Incorporated is preparing its annual financial statements. The statements are complete except for the statement of cash flows. The completed comparative...

Question 3 Refer the tables given below(Table1 and Table 2) to answer the following questions. Not yet answered Marked out of 5.00 Write the function to calculate the output shown in output table...

Information Flag question Information text InFigure 2you may find a scatter plot with 10 points and 3 lines. Three of the points are marked by the letters a, b, and c. The lines are marked by the...

v moodle.uleth. + Apple Google Search | Perlego U ECON-1010-N-Fall 2023: E3 U E3 (page 15 of 17) Dashboard UofL Question 35 Time left 2:29:40 If Canada imposes a tariff on imported cars, the price of...

A company with 700000 outstanding common shares declares a dividend of 0.085 baisa per share on January 20 the payment date being on February 20. Identify the a/c credited on January 20. Oa. Retained...

The following data represents the weekly sales revenue {$000) of a sample of cafes. 33.2 13.0 16.8 5.1 14.8 18.1 14.1 20.0 8.1 13.7 19.6 13.2 30.6 6.0 18.9 23.7 5.4 12.5 32.8 30.0 19.8 10.0 11.1 12.5...

Answer the following questions? Y 100 0.84 1.6 11. Calculate total factor productivity for both countries. Keep data as it given to you. 12. Calculate per capita income for both countries. Express...

-stion 2 Refer the table given below to answer the following questions. yet wered Write the function to calculate the following: rked out of 00 a. Total no. of product sold in Paper sub-category Flag...

Consider; What month (and year) is summarized? What was the unemployment rate for that month? How does that rate compare with the rate in the previous month? What were the unemployment rates for...

Two bonds are available for purchase in the financial markets. The first bond is a two-year, $1,000 bond that pays an annual coupon of 10 percent. The second bond is a two-year, $1,000, zero-coupon...

On May 1 of this year, Ellsworth and Company established a Petty Cash Fund. The following petty cash transactions took place during the month: May 1 Cashed check no. 956 for $ 150 to establish a...

Bio - Piasma Corporation is growing at 3 th per yeac. it is al - equity - financed and has total assets of $ 1 . 8 milion. is retum on equity is 1 9 % . its plowbeck ratio is 4 2 % . a . What is the...

Determine the major differences between U.S. GAAP and IFRS disclosure reporting requirements related to each separately reportable operating segment. Next, give your opinion as to whether either U.S....