The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 402 Weeks Ago, 1 Day Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
Alden Company has decided to use a contribution format income statement for internal planning purposes. The company has analyzed its expenses and has developed the following cost formulas:
Â
| Cost | Cost Formula | |
| Cost of goods sold | $26 per unit sold | |
| Advertising expense | $176,000 per quarter | |
| Sales commissions | 8% of sales | |
| Administrative salaries | $86,000 per quarter | |
| Shipping expense | ? | |
| Depreciation expense | $56,000 per quarter | |
Â
|
Management has concluded that shipping expense is a mixed cost, containing both variable and fixed cost elements. Units sold and the related shipping expense over the last eight quarters are given below: |
Â
| Quarter | Units Sold | Shipping Expense |
| Year 1: | Â | Â |
| First | 22,000 | $166,000 |
| Second | 24,000 | $181,000 |
| Third | 29,000 | $223,000 |
| Fourth | 25,000 | $186,000 |
| Year 2: | Â | Â |
| First | 23,000 | $176,000 |
| Second | 26,000 | $191,000 |
| Third | 34,000 | $238,000 |
| Fourth | 31,000 | $214,000 |
Â
|
Management would like a cost formula derived for shipping expense so that a budgeted contribution format income statement can be prepared for the next quarter. |
Â
| Required: | |
| 1. |
Using the high-low method, estimate a cost formula for shipping expense based on the data for the last eight quarters above. (Omit the "$" sign in your response.) |
Â
| Y = $ + $ X |
Â
| 2. |
In the first quarter of Year 3, the company plans to sell 27,000 units at a selling price of $56 per unit. Prepare a contribution format income statement for the quarter. (Input all amounts as positive values except losses which should be indicated by a minus sign. Omit the "$" sign in your response.) |
Â
| Alden Company Budgeted Income Statement For the First Quarter of Year 3 |
||
| (Click to select) Sales Advertising expense Sales commissions Depreciation expense Shipping expense Cost of goods sold | Â | $ |
| Variable expenses: | Â | Â |
| (Click to select) Cost of goods sold Depreciation expense Sales commissions Advertising expense Administrative salaries Shipping expense | $ | Â |
| (Click to select) Sales commissions Administrative salaries Advertising expense Depreciation expense Cost of goods sold Shipping expense | Â | Â |
| (Click to select) Depreciation expense Shipping expense Advertising expense Administrative salaries Cost of goods sold Sales commissions | Â | Â |
| Â | Â | |
| Total variable expenses | Â | Â |
| Â | Â | |
| (Click to select) Gross Margin Contribution margin Net operating loss Net operating income | Â | Â |
| Fixed expenses: | Â | Â |
| (Click to select) Depreciation expense Administrative salaries Advertising expense Cost of goods sold Shipping expense Sales commissions | Â | Â |
| (Click to select) Sales commissions Shipping expense Depreciation expense Administrative salaries Advertising expense Cost of goods sold | Â | Â |
| (Click to select) Cost of goods sold Advertising expense Administrative salaries Shipping expense Depreciation expense Sales commissions | Â | Â |
| (Click to select) Sales commissions Cost of goods sold Shipping expense Advertising expense Administrative salaries Depreciation expense | Â | Â |
| Â | Â | |
| Total fixed expenses | Â | Â |
| Â | Â | |
| (Click to select) Contribution margin Net operating income Gross Margin Net operating loss | Â | $ |
n here
Hel-----------lo -----------Sir-----------/Ma-----------dam-----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------and----------- ac-----------qui-----------sit-----------ion----------- of----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n.P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll