Estimate the total cost in the next month

Reference no: EM133020657

Question: The following data relating to units shipped and total shipping expense have been assembled by YORK, a wholesaler of large, custom-built air-conditioning units for commercial buildings:

Month ....... Total Shipped units ...... Shipping Expenses
1 January ...........9....................................... $ 4,500
2 February .........18....................................... $ 5,750
3 March ..............12 .......................................$ 4,250
4 April ................15....................................... $ 5,000
5 May .................21....................................... $ 5,750
6 June .................24....................................... $ 6,750
7 July ....................6 ........................................$ 3,000

a. Use the high-low method to find the cost formula for shipping expense :

-Shipping Expenses =

b. Use the regression method (Graph x/y) to find the cost formula for shipping expense :

-Shipping Expenses =

c. Estimate the total cost in the next month if the number of shipped units is expected to be 11

-Using High-Low Method:
-Using Regression analysis (Graph X/Y):

Reference no: EM133020657

Questions Cloud

Post the entries to the general ledger accounts : Prepare journal entries to record the above transactions and Post the entries to the General Ledger accounts.

Identify the personal safety of customers : Question 1: Based on the below situations, identify where the personal safety of customers/colleagues may be threatened, appropriate action that should be taken

Compensation and benefits management : Post a current article related to compensation and benefits management. Post a link to your article and write a minimum of two paragraphs relating to the articl

What is the yield to maturity : The bonds have an 11% annual coupon payment, a $1,000 face value, and 10 years left until maturity. What is the yield to maturity

Estimate the total cost in the next month : Estimate the total cost in the next month if the number of shipped units - Use the high-low method to find the cost formula

Thoughts on negotiating in various situations : What are your thoughts on negotiating in various situations, and the skills needed?

Leisure experience obtained through outdoor recreation : Does technology increase or decrease the leisure experience obtained through outdoor recreation?

Explain why patient confidentiality is important : Explain why patient confidentiality is important in healthcare and Reflect on your research. Share one example of a breach in patient confidentiality

What are the basic tenets of the flat-world perspective : 1. How is the government considered an international business? 2. What are the basic tenets of the flat-world perspective?

User Account

All Pages