Question

In: Accounting

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

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

Month

Units

Shipped

Total Shipping

Expense

January

4

$ 1,800

February

6

$ 2,300

March

4

$ 1,700

April

5

$ 2,000

May

7

$ 2,300

June

8

$ 2,700

July

2

$ 1,200

Required:

  1. Using the high-low method, estimate a cost formula for shipping expense.
  2. Using the cost formula you derived above, what amount of total shipping expense would you expect to be incurred if 10 units will be shipped?
  3. What factors, other than the number of units shipped, do think are likely to affect the company's total shipping expense?

  1. Because of Covid-19, some companies around the world have chosen to minimize fixed capacity costs. However, every company has some costs to which it is committed. Distinguish between committed fixed costs and discretionary fixed costs. Give three examples for each.

Solutions

Expert Solution

A.

1.

Variable cost per unit = Highest cost - lowest cost / highest unit - lowest unit

Variable cost per unit = (2700 - 1200) / (8 - 2)

Variable cost per unit = 1500 / 6

Variable cost per unit = $250 per unit

Fixed cost = highest cost - variable cost per unit * highest unit

Fixed cost = 2700 - (250 * 8)

Fixed cost = 2700 - 2000

Fixed cost = $700

Cost formula = a + bx

Cost formula = fixed cost + variable cost per unit * no of units (x)

Cost formula = 700 + 250x

2.

Total shipping expense = 700 + 250x

Total shipping expense = 700 + 250 * 10

Total shipping expense = 700 + 2500

Total shipping expense = 3200

3.

The factors that are likely to affect the company's total shipping expense could be a lack of transportation or a sudden demand for an efficient labor.

B.

Committed fixed costs:

Committed fixed costs are referred to as those costs that cannot be eliminated from the budgeting process easily. These are the fixed costs that are necessary for the smooth operation of the business. For example; insurance, rent, depreciation.

Discretionary fixed costs:

Discretionary fixed costs are referred to as those costs that do not occur on a regular basis. These costs are incurred for a specific period of time or for a specific job. These can be eliminated easily and their elimination will not happen the functioning of the business. for example; advertising costs, research and development costs, charitable contributions.


Related Solutions

Revenue is recognized when shipped. Based on shipping dates, total revenue for 2018 is $1,372,637. The...
Revenue is recognized when shipped. Based on shipping dates, total revenue for 2018 is $1,372,637. The audit team has set overall materiality at $13,000. The total dollar volume of AR that was not approved was $13,726. Would you classify the authorization control deficiency identified above as material weakness, control deficiency or significant deficiency?
The Fime Corporation uses a standard costing system. The following data have been assembled for December:...
The Fime Corporation uses a standard costing system. The following data have been assembled for December: Actual direct labor-hours worked 5,300 hours Standard direct labor rate $ 8 per hour Labor efficiency variance $ 3,200 Unfavorable The standard hours allowed for December’s production is: Multiple Choice 4,500 hours 4,900 hours 5,300 hours 5,700 hours
Ellis Corporation prepares its master budget on a quarterly basis. The following data have been assembled...
Ellis Corporation prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparation of the master budget for the third quarter of 2019: As of June 30, 2019 (the end of the prior quarter), the company's general ledger showed the following account balances:                                                                                              Debits             Credits       Cash                                                                             $25,000                                    Accounts Receivable          75,000       Inventory                                                                       60,000       Plant and Equip (net)                                                    190,000       Accounts Payable                                                                                 $60,000       Short-term Notes Payable                                                                       25,000      ...
The following facts have been assembled to facilitate an analysis of an option to abandon a...
The following facts have been assembled to facilitate an analysis of an option to abandon a project currently being considered by Xiaomi Group ltd: Risk-free rate of return 8% Time until decision to abandon is taken 0.64 years PV of cash flows if the project is not abandoned Ksh.415 million Salvage value if abandoned Ksh.480 million The variance of the projects rate of return is being considered at different levels as follows: Var-1 3% Var-2 6% Var-3 9% Var-4 12%...
The following facts have been assembled to facilitate an analysis of an option to abandon a...
The following facts have been assembled to facilitate an analysis of an option to abandon a project currently being considered by Xiaomi Group ltd: Risk-free rate of return 8% Time until decision to abandon is taken 0.64 years PV of cash flows if the project is not abandoned Ksh.415 million Salvage value if abandoned Ksh.480 million The variance of the projects rate of return is being considered at different levels as follows: Var-1 3% Var-2 6% Var-3 9% Var-4 12%...
The following facts have been assembled to facilitate an analysis of an option to abandon a...
The following facts have been assembled to facilitate an analysis of an option to abandon a project currently being considered by Xiaomi Group ltd: Risk-free rate of return 8% Time until decision to abandon is taken 0.64 years PV of cash flows if the project is not abandoned Ksh.415 million Salvage value if abandoned Ksh.480 million The variance of the projects rate of return is being considered at different levels as follows: Var-1 3% Var-2 6% Var-3 9% Var-4 12%...
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: Month Number of Units Shipped Total Shipping Cost January 40 $2,950 February 75 3,650 March 25 2,250 April 35 1,850 May 30 2,300 June 55 3,250 July 50 3,000 Required: 1. Prepare a scattergraph of Odessa’s shipping cost and draw the line you believe best fits the data. 3. Using the high-low method, calculate Odessa’s total fixed shipping costs and...
Suppose the following data were collected relating the total number of crimes committed to the number...
Suppose the following data were collected relating the total number of crimes committed to the number of police officers and if the town is located in the Southwest. Use statistical software to find the regression equation. Is there enough evidence to support the claim that on average there are less crimes in the Southwest than in other regions of the country at the 0.050.05 level of significance? If yes, type the regression equation in the spaces provided with answers rounded...
The following inventory data have been established for the Thompson Company: Annual sales are 338,000 units...
The following inventory data have been established for the Thompson Company: Annual sales are 338,000 units and orders must be placed in multiples of 100 units. The purchase price per unit is KES 600 and carrying cost is 20% of the purchase price of goods. Fixed order cost is KES 4,800. Three days are required for delivery while one year has 300 working days. Required: How many orders should Thompson Company place each year? At what inventory level should an...
We have been given the history of shipping costs below. You have been asked to calculate...
We have been given the history of shipping costs below. You have been asked to calculate a linear trend line for this data. What is the intermediate solution for the value of b? (Your answer should be an integer) Week Costs 1 466965 2 433500 3 548436 4 557338
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT