Question

In: Accounting

“The Manager has projected the following costs corresponding to sales of 14,000 and 16,000 for the...

  1. “The Manager has projected the following costs corresponding to sales of 14,000 and 16,000 for the next month’s operation.

Cost Items

Number of Units

14,000

16,000

Materials

£7,000

£8,000

Labour

£16,800

£19,200

Electricity

£11,580

£12,520

Rent

£8,900

£8,900

Advertising

£14,920

£16,480

Depreciation

£60,000

£60,000

Required:

Identify if the costs are fixed, variable or semi-variable. Provide mathematical proof to justify your answers.”

Solutions

Expert Solution

Before we bifurcate fixed, variable and semi variable costs, let us first briefly try to understand what each of the cost really mean.

Fixed costs: These costs do not change with change in production. Ex: Rent, etc

Variable costs: These costs change proportionately with change in production. If production is zero then variable costs are also zero. Ex: Direct material, Direct labour, etc.

Semi-variable costs: These costs are partly fixed and partly variable. Ex: Electricity charges,etc

Solution:

1) Material: Due to increase of 2000 units of production, material cost increased by 8000-7000=1000 pounds

Increase in material cost per unit=1000 pounds/2000 units= 0.5 pounds

At 14000 units of production, material cost = 14000 units*0.5pounds=7000 pounds

At 16000 units of production, material cost = 16000 units*0.5pounds=8000 pounds

We can observe that cost per unit is same at different production capacities.

If cost per unit remains the same at different production capacities, then it is a variable cost.

2) Labour: Due to increase of 2000 units of production, labour cost increased by 19200-16800=2400 pounds

Increase in labour cost per unit= 2400 pounds/2000 units= 1.2 pounds

At 14000 units of production, labour cost = 14000 units*1.2pounds=16800 pounds

At 16000 units of production, labour cost = 16000 units*1.2pounds=19200 pounds

Since cost per unit is same at different production capacities, it is a variable cost.

3) Electricity: Due to increase of 2000 units of production, electricity cost increased by 12520-11580=940 pounds

Increase in electricity cost per unit= 940 pounds/2000 units= 0.47 pounds

At 14000 units of production, electricity cost should be= 14000 units*0.47pounds=6580 pounds

But actually electricity charges at 14000 units of production are 11580 pounds.

Difference = 11580-6580= 5000 pounds

Cost per unit at 14000 units of production=11580/14000=0.827 pounds

Cost per unit at 16000 units of production=12520/16000=0.783 pounds

Cost per unit is not same at different production capacities.

By this we can understand that electricity is neither fixed nor variable. It is semi-variable.

Fixed part is 5000 pounds. Variable part is 0.47 pounds per unit.

4) Rent: Due to increase of 2000 units of production, rent increased by 0.

Cost per unit at 14000 units of production=8900/14000=0.636 pounds

Cost per unit at 16000 units of production=8900/16000=0.556 pounds

Cost per unit is not same at different production capacities.

Hence it is not a variable cost.It is not a semi varaible cost either because increase in cost due to increase in production is zero. It is a fixed cost.

(Note: Cost per unit for fixed costs always decrease with increase in production)

5) Advertising: Due to increase of 2000 units of production, advertising cost increased by 16480-14920=1560 pounds

Increase in advertising cost per unit= 1560 pounds/2000 units= 0.78 pounds

At 14000 units of production, advertising cost should be= 14000 units*0.78pounds=10920 pounds

But actually advertising charges at 14000 units of production are 14920 pounds.

Difference = 14920-10920= 4000 pounds

Cost per unit at 14000 units of production=14920/14000=1.066 pounds

Cost per unit at 16000 units of production=16480/16000=1.03 pounds

Cost per unit is not same at different production capacities.

By this we can understand that advertising charges are neither fixed nor variable. It is semi-variable.

Fixed part is 4000 pounds. Variable part is 0.78 pounds per unit.

6) Depreciation: Due to increase of 2000 units of production, depreciation increased by 0.

Cost per unit at 14000 units of production=60000/14000=4.286 pounds

Cost per unit at 16000 units of production=60000/16000=3.75 pounds

Cost per unit is not same at different production capacities.

Hence it is not a variable cost.It is not a semi varaible cost either because increase in cost due to increase in production is zero. It is a fixed cost.

Please upvote my answer if you have liked it. It keeps me going :-)


Related Solutions

“The Manager has projected the following costs corresponding to sales of 14,000 and 16,000 for the...
“The Manager has projected the following costs corresponding to sales of 14,000 and 16,000 for the next month’s operation. Cost Items Number of Units 14,000 16,000 Materials £7,000 £8,000 Labour £16,800 £19,200 Electricity £11,580 £12,520 Rent £8,900 £8,900 Advertising £14,920 £16,480 Depreciation £60,000 £60,000 Required: Identify if the costs are fixed, variable or semi-variable. Provide mathematical proof to justify your answers.”
ABC Company has the following projected sales: Month      Sales Jan         $5,000 Feb         $14,000...
ABC Company has the following projected sales: Month      Sales Jan         $5,000 Feb         $14,000 Mar         $27,000 Apr         $56,000 14% of the sales are collected in the same month. 26% of the sales are collected after one month, 42% of the sales are collected after two months, and the remainder are collected after three month. What is the amount of the April collections? Enter your answer rounded off to two decimal points. Do not enter $ or...
Graham Potato Company has projected sales of $13,200 in September, $16,000 in October, $23,200 in November,...
Graham Potato Company has projected sales of $13,200 in September, $16,000 in October, $23,200 in November, and $19,200 in December. Of the company's sales, 25 percent are paid for by cash and 75 percent are sold on credit. Experience shows that 40 percent of accounts receivable are paid in the month after the sale, while the remaining 60 percent are paid two months after. Determine collections for November and December.    Also assume Graham’s cash payments for November and December...
ABC Company’s budgeted sales for June, July, and August are 12,000, 16,000, and 14,000 units, respectively....
ABC Company’s budgeted sales for June, July, and August are 12,000, 16,000, and 14,000 units, respectively. ABC requires 30% of the next month’s budgeted unit sales as finished goods inventory each month. Budgeted ending finished goods inventory for May is 3,600 units. Each unit that ABC Company produces uses 3 pounds of raw material. ABC requires 25% of the next month’s budgeted production as raw material inventory each month. Required: Calculate the number of pounds of raw material to be...
A proposed new investment has projected sales of $585,000. Variable costs are 44 percent of sales,...
A proposed new investment has projected sales of $585,000. Variable costs are 44 percent of sales, and fixed costs are $187,000; depreciation is $51,000. Prepare a pro forma income statement assuming a tax rate of 21 percent. What is the projected net income? (Input all amounts as positive values.)  Sales Variable costs Fixed costs Depreciation EBT Taxes Net income
a) A proposed new investment has projected sales of $950,000. Variable costs represent 60% of sales,...
a) A proposed new investment has projected sales of $950,000. Variable costs represent 60% of sales, and fixed costs are $210,000; depreciation is $102,000. What is the projected operating cash flow assuming a tax rate of 35%.    5pts         b) Consider the following income statement:                                                                         Sales                                                        $687,500                                    Operating Costs                                         343,860                                     Depreciation                                              110,000                                     Net Operating Profit                                       ?                                     Taxes (35%)                                                    ?                                     Net Profit                                                         ?             Fill in the missing numbers and then calculate the operating...
A project has a projected sales price of $99 a unit, variable costs per unit of...
A project has a projected sales price of $99 a unit, variable costs per unit of $58, annual fixed costs of $238,000, and annual depreciation of $139,000. The tax rate is 22 percent. What is the contribution margin for an analysis using sales units of 12,800? Multiple Choice $27.06 $38.97 $22.41 $41.00 $42.64
A proposed new project has projected sales of $198,900, costs of $100,620, and depreciation of $7,020....
A proposed new project has projected sales of $198,900, costs of $100,620, and depreciation of $7,020. The tax rate is 24 percent. Calculate operating cash flow using the four different approaches. The EBIT approach The bottom-up approach The top-down approach The tax-shield approach
A proposed new project has projected sales of $171,700, costs of $86,860, and depreciation of $6,060....
A proposed new project has projected sales of $171,700, costs of $86,860, and depreciation of $6,060. The tax rate is 22 percent. Calculate operating cash flow using the four different approaches. The EBIT approach The bottom-up approach The top-down approach The tax-shield ppproach
A proposed new project has projected sales of $219,000, costs of $96,000, and depreciation of $26,000....
A proposed new project has projected sales of $219,000, costs of $96,000, and depreciation of $26,000. The tax rate is 23 percent. Calculate operating cash flow using the four different approaches.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT