Question

Estimating a cost function. The controller of the Javier Company is preparing the budget for 2018...

Estimating a cost function. The controller of the Javier Company is preparing the budget for 2018 and needs to estimate a cost function for delivery costs. Information regarding delivery costs incurred in the prior two months are:

Month

Miles Driven

Delivery Costs

August

11,600

$10,000

September

18,000

$13,200

Required:

1.   Estimate the cost function for delivery.

2.   Can the constant in the cost function be used as an estimate of fixed delivery cost per month? Explain.

Homework Answers

Answer #1

1.

Variable cost per mile = Difference in cost/Difference in activity

= (13,200 - 10,000)/(18,000 - 11,600)

= 3,200/6,400

= $0.5

Fixed cost = Highest activity cost - (Highest activity x Variable cost per mile)

= 13,200 - (18,000 x 0.5)

= 13,200 - 9,000

= $4,200

Cost function for delivery

Total cost = Fixed cost + Number of miles x Variable cost per mile

= 4,200 + 0.5 x Number of miles

2.

Yes, the constant in the cost function can be used as an estimate of fixed delivery cost per month.

Here, $4,200 is the fixed delivery cost per month since it is independent of the number of miles driven.

Know the answer?
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
Similar Questions
The controller of the Javier Company is preparing the budget for 2018 and needs to estimate...
The controller of the Javier Company is preparing the budget for 2018 and needs to estimate a cost function for delivery costs. Information regarding delivery costs incurred in the prior two months are: Months.   Miles Driven. Delivery Costs August 11,000 $26,000 Sept 15,000 $34,000 Estimate the cost function for delivery.
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $106,000 $137,000 $173,000 Manufacturing costs 45,000 59,000 62,000 Selling and administrative expenses 37,000 41,000 66,000 Capital expenditures _ _ 42,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $101,000 $126,000 $169,000 Manufacturing costs 42,000 54,000 61,000 Selling and administrative expenses 35,000 38,000 64,000 Capital expenditures _ _ 41,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget...
Cash Budget The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $139,000 $167,000 $231,000 Manufacturing costs 58,000 72,000 83,000 Selling and administrative expenses 49,000 50,000 88,000 Capital expenditures _ _ 55,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the...
Company Alpha has a contract with a delivery firm for delivering its products to their clients....
Company Alpha has a contract with a delivery firm for delivering its products to their clients. The information regarding the monthly delivery costs for the second semester is available below: Month Units delivered Delivery cost July 180 $590 August 300 $950 September 250 $820 October 200 $640 November 230 $700 December 270 $870 Total 1,430 $4,570 Required: Use the high-low method for estimating the cost function for monthly delivery costs for Company Alpha. After reviewing the estimated cost function using...
The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the...
The controller of Bridgeport Housewares Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: September October November Sales $121,000 $146,000 $204,000 Manufacturing costs 51,000 63,000 73,000 Selling and administrative expenses 42,000 44,000 78,000 Capital expenditures _ _ 49,000 The company expects to sell about 10% of its merchandise for cash. Of sales on account, 70% are expected to be collected in the month following the sale and...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and...
Built-Tight is preparing its master budget for the quarter ended September 30, 2017. Budgeted sales and cash payments for product costs for the quarter follow: July August September Budgeted sales $ 60,000 $ 76,000 $ 52,000 Budgeted cash payments for Direct materials 16,960 14,240 14,560 Direct labor 4,840 4,160 4,240 Factory overhead 21,000 17,600 18,000 Sales are 30% cash and 70% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet includes...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash $ 75,000 Accounts receivable 140,000 Inventory 66,500 Plant and equipment, net of depreciation 227,000 Total assets $ 508,500 Liabilities and Stockholders’ Equity Accounts payable $ 88,000 Common stock 311,000 Retained earnings 109,500 Total liabilities and stockholders’ equity $ 508,500 Exercise 8-12...
Colerain Corporation is a merchandising company that is preparing a budget for the third quarter of...
Colerain Corporation is a merchandising company that is preparing a budget for the third quarter of the calendar year. The company’s balance sheet as of June 30 is shown below: COLERAIN CORPORATION Balance Sheet June 30 Assets Cash $ 92,000 Accounts receivable 138,000 Inventory 64,000 Plant and equipment, net of depreciation 320,000 Total assets $ 614,000 Liabilities and Shareholders’ Equity Accounts payable $ 73,000 Common shares 420,000 Retained earnings 121,000 Total liabilities and shareholders’ equity $ 614,000 Colerain’s managers have...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash $ 83,000 Accounts receivable 126,000 Inventory 69,750 Plant and equipment, net of depreciation 220,000 Total assets $ 498,750 Liabilities and Stockholders’ Equity Accounts payable $ 81,000 Common stock 348,000 Retained earnings 69,750 Total liabilities and stockholders’ equity $ 498,750 Exercise 8-12...