Question: Answer the following: On the table select the data in the sum of amounts column and sort from highest to lowest. Job # Sum of

Answer the following:

On the table select the data in the sum of amounts column and sort from highest to lowest.

Job # Sum of AMOUNT
1008 334
1011 292
1020 720
1021 249
1022 576
1025 451
1026 574
1029 21422
1030 1584
1031 1826
1044 996
1048 410
1049 1512
1050 360
1051 332
1052 648
1055 1848
1060 615
1065 1848
1070 376
1080 2940
1081 1737
1099 502
2011 342.4
2012 376
2021 290.5
2022 504
2025 451
2026 594.5
2029 2324
2120 1008
2129 672
2221 754
2230 864
2231 1535.5
2244 1411
2248 328
2249 1848
2250 324
2251 747
2252 432
2255 2772
2260 557.6
2265 2856
2270 350.8
2280 2898
2281 1107
2299 460
3008 334
3011 292
3020 720
3021 207.5
3022 576
3025 410
3026 574
3029 2075
3030 1584
3031 1826
3044 996
3048 410
3049 1512
3050 360
3051 332
3052 648
3055 1848
3060 615
3065 1940
3070 376
3080 2940
3081 1025
3099 502
3129 672
3181 712
4011 342.4
4012 376
4021 290.5
4022 504
4025 451
4026 594.5
4029 2324
4120 1008
4129 672
4221 754
4230 864
4231 1535.5
4244 1411
4248 328
4249 1848
4250 324
4251 747
4252 432
4255 2772
4260 557.6
4265 2856
4270 350.8
4280 3024
4281 1107
4299 460
Grand Total 117379.1

Which job number generated the highest contribution margin?

Which job number generated the lowest contribution margin?

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 Accounting Questions!

Q:

To prepare for the meeting, create a summary of the yields of each bond by completing the table shown in Exhibit 13. 2. Remember that the YTM of each bond is assumed to be the required rate of return...

Q:

INSTRUCTIONS: 1. Add a sheet to the worksheet and rename sheet Pivot table 1. On sheet which is now called Pivot table 1, go to cell A1 then "insert" "pivot table" using the data range provided on...

Q:

I need the Excel worksheet and answers. please, help me. 1. Add a sheet to the worksheet and rename sheet Pivot table 1. On sheet which is now called Pivot table 1, go to cell A1 then "insert" "pivot...

Q:

I need the Excel worksheet and answers. please, help me. 1. Add a sheet to the worksheet and rename sheet Pivot table 1. On sheet which is now called Pivot table 1, go to cell A1 then "insert" "pivot...

Q:

I need the Excel worksheet and answers. Help me. 1. Add a sheet to the worksheet and rename sheet Pivot table 1. On sheet which is now called Pivot table 1, go to cell A1 then "insert" "pivot table"...

Q:

INSTRUCTIONS: 1. Add a sheet to the worksheet and rename sheet. Pivot table 1. On sheet which is now called Pivot table 1, go to cell A1 then "insert" "pivot table" using the data range provided on...

Q:

Type or paste question here INSTRUCTIONS: 1. Add a sheet to the worksheet and rename sheet Pivot table 1. On sheet which is now called Pivot table 1, go to cell A1 then "insert" "pivot table" using...

Q:

Site X Site Y Respondent # Rank by # Desserts Rank by # Meals # Meals Out per Month 5 15 24 16 4 19 8 12 7 20 0 6 12 # Desserts Out per Month 4 5 3 1 12 9 9 1 1 18 14 5 1 1 0 0 4 0 1 1 1 1 11 11 0 3...

Q:

1. Add a sheet to the worksheet and rename sheet Pivot table 1. On sheet which is now called Pivot table 1, go to cell A1 then "insert" "pivot table" using the data range provided on the data sheet...

Q:

1. Add a sheet to the worksheet and rename sheet Pivot table 1. On sheet which is now called Pivot table 1, go to cell A1 then "insert" "pivot table" using the data range provided on the data sheet...

Q:

INSTRUCTIONS: 1. Add a sheet to the worksheet and rename sheet Pivot table 1. On sheet which is now called Pivot table 1, go to cell A1 then "insert" "pivot table" using the data range provided on...

Q:

A merry-go-round accelerating uniformly from rest achieves its operating speed of 2.5 rpm in 5 revolutions. What is the magnitude of its angular acceleration?

Q:

Alum co manufactures aluminum sheets and aluminum bars. The maximum production capacity is estimated at either 800 sheets or 600 bars per day. The maximum daily demand is 550 sheets and 580 bars. The...

Q:

Which of the following physical damage losses would be covered under a personal auto policy? a . A thief rips out the expensive CD player built into the dash of Marvin's sport - utility vehicle. b ....

Q:

10) For a bond that pays cash interest (i.e., not a zero coupon bond), YTM is (a) always equal to the coupon rate (b) always equal to the current yield (c) is always less than the coupon rate (d) can...

Q:

6-16 What are the main advantages and disadvantages of having multiple databases in a distributed architecture? Explain. The Lego Group, which is headquartered in Billund, Denmark, is one of the...

Q:

5. Give some examples of problems that would have occurred at American Water if its data were not clean? American Water, founded in 1886, is the largest public water utility in the United States....

Q:

6-5 It has been said there is no bad data, just bad management. Discuss the implications of this statement.