Question

I Header Foter Page Text Box WordA Number s, and improvements, choose Check for Updates. Type your response here: Calculation of expenses as % of total sales Jan- Feb- Mar- Apr- 1Ma Jun- Jul- Aug- Sept Oct- Nov-Deo- 14 14 14 14 y-14 14 14 14 -14 1414 14 actu actu actu actu actu actu Sales actu actu actu actu actu Revenu al a ala Inventor 32 30 35 32 32 30 32 37 28 32 32 32 Supplies 5 6 5 5 857 3 4 5 55 COGS 57 56 55 57 58 60 59 66 52 58 57 57 Operatin expense Salaries 20.0 19.5 18.3 17.1 17.0 17.1 17.0 15.9 16.7 16.6 16.4 15.3 Advertisi 0.62 0 0 00 0 0 0.54 1.48 1.6 1.53 1.27 Utilities 1.21 1.25 1.05 0.93 0.94 1.06 1.21 1.54 1.31 0.83 0.900/9 2 Insuranc 2.37 2.25 2.17 2.07 2.02 2.04 2.02 199 1.96 1.95 1.94 1.93 Repairs .25 0ー0ー0.05 0% 0.99 1.0619ー0 0ー0.36 13 24.4 23.0 21.5 20.8 20.0 21.2 21.3 20.0 21.5 21 21 19.6 TOE Income- 15.0 15.4 15.7 15.0 14.7 14% 14.3 11.9 16.8 14.7 T15- 15 Interest 1.95 1.85 1.78 1.70 1.66 1.68 1.66 1.63 1.61 1.6 1.601.59 7 taxes 5 0 5 5o 5 0 expense
Usiig the data above, determine which expenses relate to sales and which ones do not. Use this dge to do the following: in 400 words, explain how you might use this information to budget expenses for the next year Mar- 14 Apr-14 Aug Sep-Oct Nov Dec- Jan-14 Feb-14 14 Jun-14 Jul-14 14 14 14 Actuai Atu Acua Actu Actuat Actut nctut Actul ctutl Atual Actul Actul 57,00 56,45 57,02 5730 57,64 57,99 58,34 Product 1 48267 50,680 52708 55,3433 56,433 6 12,42 12,79 13,43 13,51 13,59 13,67 12,06 Product 2 10,214 10,72511,154 11,711 3 11,9420 Product 3 5,845 6,1376,3836,386 6,388 6,324 6,577 6,774 6,778 6,782 6,788 6,829 Total Sales 64326 67.542 244 44 454 699 Direct 452 S8 515944 3 848 Expenses 24,14 22.410 5 13,58 24,14 28,33 21,70 24,94 25,08 25,23 Invento 20,58420,263 24,585 23,501 5 15,09 19,91 15,s0 16,3615,67 15,77 Labor 12,86513,508 10,3 4,688 218,675 o3 3 8 5lo 18,675 0 3,216 4,0533,5123,672 6,036 3,735S 2,298 3,1013,8973,919 3,942 43,76 Total Cost of Goods 36,66637,824 38,634 41,861 3 Operating Expenses 44,51 50,54 40,30 45,20 44,67 44,94 44,820 7 12,88 12,84 12,25 12,95 12,96 12,85 12,10 12,879 13,179 12,879 12,579 2,7805 400 500 410 1,150 1,250 1,200 1,000 841 685 910 1,180 1,020 60710 745 740 710 795 1,522 1522 1,522 1,522 1,522 21,522 1,522 1,522 Insurance 1,522 160 40 741 800 280 100 Total Operating Expenses 15,741 15,11 16,07 15,36 16,64 16,38 16,56 15,46 15,542 15,141 15,326 4 15.838 7 EBIT 719 610 579 691 880 11,09 10,82 13,02 1145 11, 79 11,86 10,458 7 9,114 Taxes 10,402 11,063 11,053 2 252 252 252 1,252 1,252 252 1,252
Prepariig a Budget Using the data above, determine which expenses relate to sales and which ones do not. Use this knowledge to do the following: in 400 words, explain how you might use this information to budget expenses for the next year Type your response here s)
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Ans: Expense is related to sales when it increases or decreases with increase or decrease with sales.

Cost Related to sales or not Reason
Direct Cost ( Inventory, Labor and Supplies) It is related with sales This cost took place to convert inventory in to finished goods. So this cost always considered as related to sales.
Salaries It is not related with sales As it does not increase or decreases with increase or decrease with sales. This salaries may be paid to administrative staff.
Advertisement It is not related with sales As it does not increase or decreases with increase or decrease with sales. In some of the month it doesn't even occur.
Utilities It is not related with sales As it does not increase or decreases with increase or decrease with sales. for eg. March 2014 sales is $70,244 utilities cost is $740 and in April there is increase in sales to $73,440 but utilities cost reduce to $640
Insurance It is not related with sales It is type of fixed expenses which incur throughout the period with same amount
Repairs It is not related with sales As it does not increase or decreases with increase or decrease with sales. In some of the month it doesn't even occur.
Income tax It is related with sales As the sales increases or decreases Income tax increases and decreases. In the given case the Income tax rate is 35%.
Interest Expenses It is not related with sales It is kind of fixed payment irrespective of sales.

This bifurcation of cost in relation to sales help us in preparing budget for next year by allocation of cost as variable,fixed and semi fixed which help us to determine the desired sales we have to achieve to earn the desired contribution to meet the non sales related cost and to earn a desired profit .

Add a comment
Know the answer?
Add Answer to:
I Header Foter Page Text Box WordA Number s, and improvements, choose Check for Updates. Type...
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. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT