Question

The tolowing data relating to units shipped and total shipping expense have been assembled by Archer Company, a wholesaler of large, custom-built air-conditloning units for commercial buildings Total Units Month Shipped January Februay March Apri May June July 1,900 $2.400 1,800 $2,100 $2.400 $3,400 $1,300
Required: 1a. Prepare a scatter graph using the data given above. (Plot cost on the vertical axis and activity on the horizontal axis.) Instructions: 1. On the graph below, use the point tool jan) to plot the shipping expense for the month of January. 2. Repeat the same process for the plotter tools (feb, mar, apr, may, june, July). 3. To enter exact coordinates, click on the point and enter the values of x and y 4. To remove a point from the graph, click on the point and select delete option 4500 4000 500- 2500 2000 may 000- Units Shipped
1b. Is there an approximately linear relationship between shipping expense and the number of units shipped? O No O Yes 2. Using the high-low method, estimate the cost formula for shipping expense. Units Shipping Expense Shipped High activity level Low activity level Change per unit Variable cost element Fixed cost 4. What factors, other than the number of units shipped, are likely to affect the companys shipping expense? (You may select more than one answer, Single click the box with the question mark to produce a check mark for a correct answers and double click the box with the question mark to ampty the box for a wrong answers.) 2 囝 Trade discounts given to repeat customers Datarce raveled weight of the units shipped Express shipping to meet a deadline Sales
0 0
Add a comment Improve this question Transcribed image text
Answer #1
Units shipped Shipping Expense
2 $1,300
3 $1,900
4 $1,800
5 $2,100
6 $2,400
7 $2,400
8 $3,400
1b Yes, there is approximate Linear Relationship
Units shipped Shipping Expense
High Activity Level 8 $3,400 3400=a+b*8
Low Activity Level 2 $1,300 1300=a+b*2
Change 6 $2,100 (3400-1300)=b*(8-2)
Variable Cost element $350 per Unit 6b=2100
Fixed cost $600 b=(2100/6)= 350
3400=a+350*8
4 Other factors likely to affect shipping expenses: a=3400-2800=600 600
Distance TraveShipping Expense $4,000 $3,500 $3,000 $2,500- $2,000 $1,500 $1,000 $500 $0 Shipping Expense 4 siled
Weight of units shipped
Express Shipping to    meet deadline
Add a comment
Know the answer?
Add Answer to:
The tolowing data relating to units shipped and total shipping expense have been assembled by Archer...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • The following data relating to units shipped and total shipping expense have been assembled by Archer...

    The following data relating to units shipped and total shipping expense have been assembled by Archer Company, a manufacturer of large, custom-built air-conditioning units for commercial buildings: Units Shipped Month January February March April May June Total Shipping Expense $ 5,020 3,480 4,240 3,430 1.940 8.110 1,660 July Required: 1. Estimate a cost formula for shipping expense using the high-low method. Y= + x 2. Not available in Connect 3. What factors, other than the number of units shipped, are...

  • The following data relating to units shipped and total shipping expense have been assembled by Archer...

    The following data relating to units shipped and total shipping expense have been assembled by Archer Company, a manufacturer of large, custom-built air-conditioning units for commercial buildings: Month Units Shipped Total Shipping Expense   January 10 $ 5,650           February 7 4,080           March 7 3,980       April 5 3,150           May 4 2,510           June 18 8,820         July 3 2,220         Required: 1. Estimate a cost formula for shipping expense using the high-low method. y=...

  • Required Information [The following information applies to the questions displayed below) Archer Company is a wholesaler...

    Required Information [The following information applies to the questions displayed below) Archer Company is a wholesaler of custom-built alr-conditioning units for commercial buildings. It gathered the following monthly data relating to units shipped and total shipping expense: Units Shipped Month January February March April May Total Shipping Expense $ 2,400 $ 2,900 $ 2,300 $ 2.600 $ 2,900 $ 3.900 $ 1,800 June als Required: 1-a. Prepare a scattergraph using the data given above. Plot cost on the vertical axis...

  • Required: 1-a. Prepare a scattergraph using the data given above. Plot cost on the vertical axis...

    Required: 1-a. Prepare a scattergraph using the data given above. Plot cost on the vertical axis and activity on the horizontal axis. Instructions: 1. On the graph below, use the point tool (January) to plot units shipped on the horizontal axis and the shipping expense on the vertical axis. 2. Repeat the same process for the plotter tools (February to July). 3. To enter exact coordinates, click on the point and enter the values of x and y. 4. To...

  • 4. What factors, other than the number of units shipped, are likely to affect the company’s...

    4. What factors, other than the number of units shipped, are likely to affect the company’s shipping expense? (You may select more than one answer. Single click the box with the question mark to produce a check mark for a correct answer and double click the box with the question mark to empty the box for a wrong answer. Any boxes left with a question mark will be automatically graded as incorrect.) Required information Exercise 6A-4 High-Low Method; Scattergraph Analysis...

  • Archer Company is a wholesaler of custom-built air-conditioning units for commercial buildings. It gathered the following...

    Archer Company is a wholesaler of custom-built air-conditioning units for commercial buildings. It gathered the following monthly data relating to units shipped and total shipping expense: Month Units Shipped Total Shipping Expense January 2 $ 2,200 February 5 $ 2,700 March 3 $ 2,100 April 4 $ 2,400 May 6 $ 2,700 June 7 $ 3,700 July 1 $ 1,600 Using the high-low method, estimate the cost formula for shipping expense. Variable shipping expense: (per unit) Fixed shipping expense: (per...

  • what is variable expense?? fixed shipping expense is correct *note* variable expense is not $25 or...

    what is variable expense?? fixed shipping expense is correct *note* variable expense is not $25 or $250 pter 6 Graded Homework i Required information [The following information applies to the questions displayed below.] commercial Archer Company is a wholesaler of custom-built air-conditioning units for monthly data relating to units shipped and total shipping expense: buildings. It gathered the following Units Shipped Month January February March April May June July Total Shipping Expense $ 1,800 $ 2.300 $1,700 $ 2, eee...

  • what is the variable shipping expense? its not 250 or 2.50 Required information The following information...

    what is the variable shipping expense? its not 250 or 2.50 Required information The following information applies to the questions displayed below.] art 1 of 2 Archer Company is a wholesaler of custom-built air-conditioning units for commercial buildings. It gathered the following monthly data relating to units shipped and total shipping expense: Units Shipped eBook Month January February March April Total Shipping Expense $ 1.800 $ 2,300 $1,700 $ 2,000 $ 2,300 $ 2,700 $ 1,200 Print References June July...

  • The Lakeshore Hoter's guest-days of occupancy and custodial supplies expense over the last seven months were:...

    The Lakeshore Hoter's guest-days of occupancy and custodial supplies expense over the last seven months were: Month March April May June July August Guest-Days of Supplies Expense S 13,100 s12,600 15,100 11,000 16,600 18,600 17,800 15,100 7,500 7,000 9,500 13,000 12,000 9,500 Guest-days is a measure of the overall activity at the hotel. For example, a guest who stays at the hotel for three days is counted as three guest-days Required: 1. Using the high-low method, estimate a cost formula...

  • Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped...

    Odessa, Inc., manufactures one model of computer desk. The following data are available regarding units shipped and total shipping costs: Number Total of Units Shipping Cost Month Shipped 3500 2.500 February 75 March 45 June July 80 4.000 50 3,450 Required: 1. Prepare a scattergraph of Odessa's shipping cost and draw the line you believe best fits the data. Instructions: 1. Use the point tool (7 points) to plot each Units Shipped / Total cost combination. 2. To enter exact...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
Active Questions
ADVERTISEMENT