Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

please show work!! Milden Company is a distributor who wants to start using a co

ID: 2328908 • Letter: P

Question

please show work!!

Milden Company is a distributor who wants to start using a contribution format income statement for planning purposes. The company has analyzed its expenses and developed the following cost formulas Cost Cost of good sold Advertising expense Sales commissions Shipping expense Administrative salaries Insurance expense Depreciation expense Cost Formula $28 per unit sold $178,000 per quarter 6% of sales $88,000 per quarter $9,800 per quarter $58,000 per quarter Because shipping expense is a mixed cost, the company needs to estimate the variable shipping expense per unit sold and the fixed shipping expense per quarter using the following data Shipping Units Sold Quarter Year 1: Expense First Second Third Fourth 24,000 168,000 $183,000 $ 225,000 $188,000 26,000 31,000 27,000 Year 2: First Second Third Fourth 25,000 28,000 38,400 178,000 $193,000 240,000 35,400216,000

Explanation / Answer

1) Variable cost per unit sold = Change in cost/Change in unit sold

= (240000-168000)/(38400-24000)

Variable cost per unit sold = 5 per unit sold

Fixed cost = 168000-(24000*5) = 48000

Y = 48000+5X

2) Contribution format income statement:

Sales (31000*58) 1798000 Less; Variable expense Cost of goods sold (31000*28) 868000 Sales commission (1798000*6%) 107880 Shipping expense (31000*5) 155000 Total variable expense 1130880 Contribution margin 667120 Fixed expense Advertising expense 178000 Shipping expense 48000 Administrative expense 88000 Insurance expense 9800 Depreciation expense 58000 Total fixed expense 381800 Net operating income 285320