Question: Assitance is needed. Pls include formula 90540 1 Segment Country Product Discount B Units Sold Manufactu Sale Price Gross Sales Discounts Sales : COGS Profit

Assitance is needed. Pls include formula

Assitance is needed. Pls include formula 90540 1

90540 1 Segment Country Product Discount B Units Sold Manufactu Sale Price Gross Sales Discounts Sales : COGS Profit Month Number Month Nar Year 2 Governmer Canada Carretera None 1618.5 3 20 32370 0 32370 16185 16185 1 January 2014 3 Governmer Germany Carretera None 1321 3 20 26420 0 26420 13210 13210 1 January 2014 4 Midmarket France Carretera None 2178 3 15 32670 o 32670 21780 10890 6 June 2014 5 Midmarket Germany Carretera None 888 3 15 13320 0 13320 8880 4440 6 June 2014 6 Midmarket Mexico Carretera None 2470 3 15 37050 0 37050 24700 12350 6 June 2014 7 Governmer Germany Carretera None 1513 3 350 529550 0 529550 393380 136170 12 December 2014 8 Midmarket Germany Montana None 921 5 5 15 13815 0 13815 9210 4605 3 March 2014 9 Channel Pa Canada Montana None 2518 5 12 30216 0 30216 7554 22662 6 June 2014 10 Governmer France Montana None 1899 5 20 37980 0 37980 18990 18990 6 June 2014 11 Channel Pa Germany Montana None 1545 5 12 18540 0 18540 4635 13905 6 June 2014 12 Midmarket Mexico Montana None 2470 5 15 37050 0 37050 24700 12350 6 June 2014 13 Enterprise Canada Montana None 2665.5 5 125 333187.5 0333187.5 319860 13327.5 7 July 2014 14 Small Busir Mexico Montana None 958 5 300 287400 0 287400 239500 47900 8 August 2014 15 Governmer Germany Montana None 2146 5 7 15022 0 15022 10730 4292 9 September 2014 16 Enterprise Canada Montana None 345 5 5 125 43125 0 0 43125 41400 1725 10 October 2013 17 Midmarket United Stat Montana None 615 5 15 9225 0 9225 6150 3075 12 December 2014 18 Governmer Canada Paseo None 292 10 20 5840 0 5840 2920 2920 2 February 2014 19 Midmarket Mexico Paseo None 974 10 15 14610 0 14610 9740 4870 2 February 2014 20 Channel Pa Canada Paseo None 2518 10 12 30216 0 30216 7554 22662 6 June 2014 21 Governmer Germany Paseo None 1006 10 350 352100 0 352100 261560 6 June 2014 22 Channel Pa Germany Paseo None 367 10 12 4404 0 4404 1101 3303 7 July 2014 23 Governmer Mexico Paseo None 883 10 7 6181 0 6181 4415 1766 8 August 2014 24 Midmarket France Paseo None 549 10 15 8235 0 8235 5490 2745 9 September 2013 25 Small Busir Mexico Paseo None 788 10 300 236400 0 236400 197000 39400 9 September 2013 26 Midmarket Mexico Paseo None 2472 10 15 37080 0 37080 24720 12360 9 September 2014 27 Governmer United Stat Paseo None 1143 10 7 8001 0 8001 5715 2286 10 October 2014 28 Governmer Canada Paseo None 1725 10 350 603750 0 603750 448500 155250 11 November 2013 29 Channel Pa United Stat Paseo None 912 10 12 10944 0 10944 2736 8208 11 November 2013 30 Midmarket Canada Paseo None 2152 10 15 32280 0 32280 21520 10760 12 December 2013 31 Governmer Canada Paseo None 1817 10 20 36340 0 36340 18170 18170 12 December 2014 32 Governmer Germany Paseo None 1513 10 350 529550 0 529550 393380 136170 12 December 2014 33 Governmer Mexico Velo None 1493 120 7 10451 0 10451 7465 2986 1 January 2014 34 Enterprise France Velo None 1804 120 125 225500 0 225500 216480 9020 2 February 2014 35 Channel Pa Germany Velo None 2161 120 12 25932 o 25932 6483 19449 3 March 2014 36 Governmer Germany Velo None 1006 120 350 352100 0 0 352100 261560 90540 6 June 2014 37 Channel Pa Germany Velo None 1545 120 12 18540 0 18540 4635 13905 6 June 2014 38 Enterprise United Stat Velo None 2821 120 125 352625 0 352625 338520 14105 8 August 2014 39 Enterprise Canada Velo None 345 120 125 43125 0 43125 41400 1725 10 October 2013 40 Small Busir Canada VTT None 2001 250 300 600300 0 600300 500250 100050 2 February 2014 41 Channel Pa Germany VTT None 2838 250 12 34056 0 34056 8514 25542 4 April 2014 42 Midmarket France VTT None 2178 250 15 32670 0 32670 21780 10890 6 June 2014 6. 7. On average, what is the price of widgets sold in Imperial? (1 point) How many different widgets are sold in Butte, Ventura and Yuba? (1 point) What is the difference between the total costs of widgets in Stanilaus and Orange? (1 point) What is the price range for widgets? (1 point) 8. 9. 90540 1 Segment Country Product Discount B Units Sold Manufactu Sale Price Gross Sales Discounts Sales : COGS Profit Month Number Month Nar Year 2 Governmer Canada Carretera None 1618.5 3 20 32370 0 32370 16185 16185 1 January 2014 3 Governmer Germany Carretera None 1321 3 20 26420 0 26420 13210 13210 1 January 2014 4 Midmarket France Carretera None 2178 3 15 32670 o 32670 21780 10890 6 June 2014 5 Midmarket Germany Carretera None 888 3 15 13320 0 13320 8880 4440 6 June 2014 6 Midmarket Mexico Carretera None 2470 3 15 37050 0 37050 24700 12350 6 June 2014 7 Governmer Germany Carretera None 1513 3 350 529550 0 529550 393380 136170 12 December 2014 8 Midmarket Germany Montana None 921 5 5 15 13815 0 13815 9210 4605 3 March 2014 9 Channel Pa Canada Montana None 2518 5 12 30216 0 30216 7554 22662 6 June 2014 10 Governmer France Montana None 1899 5 20 37980 0 37980 18990 18990 6 June 2014 11 Channel Pa Germany Montana None 1545 5 12 18540 0 18540 4635 13905 6 June 2014 12 Midmarket Mexico Montana None 2470 5 15 37050 0 37050 24700 12350 6 June 2014 13 Enterprise Canada Montana None 2665.5 5 125 333187.5 0333187.5 319860 13327.5 7 July 2014 14 Small Busir Mexico Montana None 958 5 300 287400 0 287400 239500 47900 8 August 2014 15 Governmer Germany Montana None 2146 5 7 15022 0 15022 10730 4292 9 September 2014 16 Enterprise Canada Montana None 345 5 5 125 43125 0 0 43125 41400 1725 10 October 2013 17 Midmarket United Stat Montana None 615 5 15 9225 0 9225 6150 3075 12 December 2014 18 Governmer Canada Paseo None 292 10 20 5840 0 5840 2920 2920 2 February 2014 19 Midmarket Mexico Paseo None 974 10 15 14610 0 14610 9740 4870 2 February 2014 20 Channel Pa Canada Paseo None 2518 10 12 30216 0 30216 7554 22662 6 June 2014 21 Governmer Germany Paseo None 1006 10 350 352100 0 352100 261560 6 June 2014 22 Channel Pa Germany Paseo None 367 10 12 4404 0 4404 1101 3303 7 July 2014 23 Governmer Mexico Paseo None 883 10 7 6181 0 6181 4415 1766 8 August 2014 24 Midmarket France Paseo None 549 10 15 8235 0 8235 5490 2745 9 September 2013 25 Small Busir Mexico Paseo None 788 10 300 236400 0 236400 197000 39400 9 September 2013 26 Midmarket Mexico Paseo None 2472 10 15 37080 0 37080 24720 12360 9 September 2014 27 Governmer United Stat Paseo None 1143 10 7 8001 0 8001 5715 2286 10 October 2014 28 Governmer Canada Paseo None 1725 10 350 603750 0 603750 448500 155250 11 November 2013 29 Channel Pa United Stat Paseo None 912 10 12 10944 0 10944 2736 8208 11 November 2013 30 Midmarket Canada Paseo None 2152 10 15 32280 0 32280 21520 10760 12 December 2013 31 Governmer Canada Paseo None 1817 10 20 36340 0 36340 18170 18170 12 December 2014 32 Governmer Germany Paseo None 1513 10 350 529550 0 529550 393380 136170 12 December 2014 33 Governmer Mexico Velo None 1493 120 7 10451 0 10451 7465 2986 1 January 2014 34 Enterprise France Velo None 1804 120 125 225500 0 225500 216480 9020 2 February 2014 35 Channel Pa Germany Velo None 2161 120 12 25932 o 25932 6483 19449 3 March 2014 36 Governmer Germany Velo None 1006 120 350 352100 0 0 352100 261560 90540 6 June 2014 37 Channel Pa Germany Velo None 1545 120 12 18540 0 18540 4635 13905 6 June 2014 38 Enterprise United Stat Velo None 2821 120 125 352625 0 352625 338520 14105 8 August 2014 39 Enterprise Canada Velo None 345 120 125 43125 0 43125 41400 1725 10 October 2013 40 Small Busir Canada VTT None 2001 250 300 600300 0 600300 500250 100050 2 February 2014 41 Channel Pa Germany VTT None 2838 250 12 34056 0 34056 8514 25542 4 April 2014 42 Midmarket France VTT None 2178 250 15 32670 0 32670 21780 10890 6 June 2014 6. 7. On average, what is the price of widgets sold in Imperial? (1 point) How many different widgets are sold in Butte, Ventura and Yuba? (1 point) What is the difference between the total costs of widgets in Stanilaus and Orange? (1 point) What is the price range for widgets? (1 point) 8. 9

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!

financial SUBDOMAINS: 325.4 COMMUNICATING EFFECTIVELY IN ORGANIZATIONS 326.1 MANAGING INTERNAL COST & CONTROLLING FINANCES 326.2 MANAGING CAPITAL & FINANCIAL ASSETS 326.4 MANAGING ENTERPRISE RISK &...

The data is out of 200 cells but I reduced it. Please include formulas and description of what is done. B. Product (10 points). Go to the 'Products' worksheet to see the data 1. In how many countries...

Please help need. Need help answering questions on these two assignements Instructions: Using the company information provided below, complete the short-term cash flow forecast in following tab in...

Pls, answer the multiple choice in the "Questions''. Others files just help to solve it. Absorption Costing Direct Materials Direct Labor Variable Overhead Fixed Overhead Total $ Sales Price per unit...

The Company is seeking to raise approximately BWP 57,037,800 through external sources tofinance the development of its operations and start up. Vendor Expert (Pty) Ltd is registered asa privately...

Assignment: Brief 2: Portal Corporation Purpose To assess your ability to: define and illustrate a cost object distinguish between direct costs and indirect costs explain variable costs and fixed...

Please see the attached file for the fifty multiple choice questions. 1. A precondition for effective capital budgeting requires having: A) B) C) D) 2. A clearly defined mission A well-defined...

I've attached the assignment as a word file, thanks! You can use the class readings for this week's assignments. c05MerchandisingOperationsandtheMultiple-StepIncomeStatement.qxd 8/14/10 2:14 PM Page...

I've attached the question as a word file as well as the class text to help with the assignment. Thanks! c05MerchandisingOperationsandtheMultiple-StepIncomeStatement.qxd 8/14/10 2:14 PM Page 226...

Comrade( the production of hamburgers The average total cost (ATC) and average fixed cost (AFC) Cl producing hamburgers are illustrated in the graph to the right. Use the four-point curve drawing...

-5 -2 -7 2 Given the following matrices A = -3 and B = 7 %3D -8 -6 -3 -15 8 Determine: a) A + B= b) A - B= c) B- A=

Which of the following is NOT an example of FDI? US - based IBM deciding to build a new computer manufacturing facility in Scotland next year. Us - bated themett - Packard buning a soltware compony...

What is an example of constructive feedback? provide reference