Your company is considering an expansion and preparing budgets with and without the expanded activities. You...

Your company is considering an expansion and preparing budgets with and without the expanded activities. You have been asked to predict the cost of shipping at several different activity levels. You believe pounds shipped is a good cost driver and you have gathered historical data from the last 6 accounting periods, as summarized in the following table: Total cost of shipping Number of pounds shipped Period 1 93740 25000 Period 2 75040 19500 Period 3 82350 22400 Period 4 82260 21300 Period 5 76800 19900 Period 6 89700 23800 You choose to use the High-Low method of estimating the fixed and variable components of a mixed cost. 1. What is the variable cost per pound? (Round to the nearest penny)

2. What is the fixed cost per period for shipping? (Round to the nearest dollar)

3. Use your results to predict the total cost of shipping in period 7 if 50000 pounds are expected.

Solutions

Expert Solution

Period 1                               93740    25000
Period 2                               75040    19500
Period 3                               82350    22400
Period 4                               82260    21300
Period 5                               76800    19900
Period 6                               89700    23800

Answer 1.

Highest Cost of Shipping = $93,740
Highest Number of pounds shipped = 25,000

Lowest Cost of Shipping = $75,040
Lowest Number of pounds shipped = 19,500

Variable Cost per pound = (Highest Cost of Shipping - Lowest Cost of Shipping) / (Highest Number of pounds shipped - Lowest Number of pounds shipped)
Variable Cost per pound = ($93,740 - $75,040) / (25,000 - 19,500)
Variable Cost per pound = $3.40

Variable cost per pound = $3.40

Answer 2.

Highest Cost of Shipping = $93,740
Highest Number of pounds shipped = 25,000
Variable Cost per pound = $3.40

Fixed Costs = Highest Cost of Shipping - Highest Number of pounds shipped * Variable Cost per pound
Fixed Costs = $93,740 - 25,000 * $3.40
Fixed Costs = $8,740

Fixed cost per period for shipping = $8,740

Answer 3.

Number of pounds shipped = 50,000
Fixed Cost per period for shipping = $8,740
Variable cost per pound = $3.40

Total Cost = Number of pounds shipped * Variable cost per pound + Fixed Cost per period for shipping
Total Cost = 50,000 * $3.40 + $8,740
Total Cost = $178,740

Estimated cost of shipping 50,000 pounds is $178,740

ekkarill92 answered 1 year ago

Next > < Previous

Related Solutions

A company expanded into a new market in 2010. The expansion required an investment of $100...

A company expanded into a new market in 2010. The expansion required an investment of $100 in fixed assets per year for seven years (starting 2011). However, at the end of 2015, the company decided to terminate the project and sell off the fixed assets in place. Assume 30% tax rate and zero starting value of fixed assets. All fixed assets were depreciated following the MACRS schedule shown below. How much was the depreciation tax shield in year 2015? Year...

Your mining company is considering an expansion of operations into iron ore. Your engineers surveyed a...

Your mining company is considering an expansion of operations into iron ore. Your engineers surveyed a particular piece of land (the survey costs $200,000) and concluded the following: • You can extract 100,000 tons of iron ore per year. • There are 2 million tons of iron ore underneath this land (hint: 20 years' cash flows) As you dig deeper, the operating cost to extract the ore will increase. So assume that costs will grow by 6.5 percent per year....

Your mining company is considering an expansion of operations into iron ore. Your engineers surveyed a...

Your mining company is considering an expansion of operations into iron ore. Your engineers surveyed a particular piece of land three weeks ago (the survey cost $25,000) and concluded the following: • You can extract 1,000 tons of iron ore per year. • There are 4,000 tons of iron ore underneath this land. Once all the ore has been extracted, the project will cease to produce any revenues. • The price of ore will remain constant for the next 4...

Your mining company is considering an expansion of operations into iron ore. Your engineers surveyed a...

Your mining company is considering an expansion of operations into iron ore. Your engineers surveyed a particular piece of land three weeks ago (the survey cost $45,000) and concluded the following: You can extract 2,500 tons of iron ore per year. There are 10,000 tons of iron ore underneath this land. Once all the ore has  been extracted, the project will cease to produce any revenues. The price of ore will remain constant for the next 4 years. Currently ore...

You are the finance manager of your company. Your company is planning for capacity expansion and...

You are the finance manager of your company. Your company is planning for capacity expansion and need to borrow RM850,000 from a local bank. The offered term loan will be amortised in 9 years with a nomimal interest rate of 7.2% p.a. compounded monthly. The final payment will be at the end of Year 9. 1-Based on your working on an amortisation table, how much principal and interest would have your company paid after the first four months of payments?...

A： You are the finance manager of your company. Your company is planning for capacity expansion...

A： You are the finance manager of your company. Your company is planning for capacity expansion and need to borrow RM850,000 from a local bank. The offered term loan will be amortised in 9 years with a nomimal interest rate of 7.2% p.a. compounded monthly. The final payment will be at the end of Year 9. 1.Based on your working on an amortisation table, how much principal and interest would have your company paid after the first four months of...

You are the finance manager of your company. Your company is planning for capacity expansion and...

You are the finance manager of your company. Your company is planning for capacity expansion and need to borrow RM850,000 from a local bank. The offered term loan will be amortised in 9 years with a nominal interest rate of 7.2% p.a. compounded monthly. The final payment will be at the end of Year 9. 1.Based on your working on an amortisation table, how much principal and interest would have your company paid after the first four months of payments?...

Your company is considering an expansion into a new product line. The project cash flows are...

Your company is considering an expansion into a new product line. The project cash flows are as follows: Year. Project A 0. -$60,000 1. 44,000 2. 20,000 3. 14,000 The required return for this project is 10% What is the NPV? What is the IRR? What is the payback period? What is the PI?

Your company is considering an expansion into a new product line. The project cash flows are...

Your company is considering an expansion into a new product line. The project cash flows are as follows: Year Project A 0 -$60,000 1 44,000 2 20,000 3 14,000 The required return for this project is 10%. A.) What is the NPV for the project? B.) What is IRR for the project? C.) What is the payback period for the project? D. What is the Profitability Index (PI) for the project?

Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter an...

Milo Company manufactures beach umbrellas. The company is preparing detailed budgets for the third quarter and has assembled the following information to assist in the budget preparation a. The Marketing Department has estimated sales as follows for the remainder of the year (in units): 21,000 7,500 8,000 31,000 72,ee8 41,000 October July August September November December The selling price of the beach umbrellas is $11 per unit b. All sales are on account. Based on past experience, sales are collected In the following pattern: 38%...

Subjects