Question
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: Budgeted unit sales...
Weller Company's budgeted unit sales for the upcoming fiscal year are provided below: Budgeted unit sales 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter 22,000 23,000 20,000 20,000 The company's variable selling and administrative expense per unit is $2.10. Fixed selling and administrative expenses include advertising expenses of $15,000 per quarter, executive salaries of $41,000 per quarter, and depreciation of $21,000 per quarter. In addition, the company will make insurance payments of $4,000 in the first quarter and $4,000 in the third quarter. Finally, property taxes of $6,400 will be paid in the second quarter. Required: Prepare the company's selling and administrative expense budget for the upcoming fiscal year. (Round "Per Unit" answers to 2 decimal places.) Year Weller Company Selling and Administrative Expense Budget 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted unit sales Variable selling and administrative expense per unit Variable selling and administrative expense Fixed selling and administrative expenses: Advertising Executive salaries Insurance Property taxes Depreciation Total fixed selling and administrative expenses Total selling and administrative expenses Less: Depreciation Cash disbursements for selling and administrative expenses
Answers
Solution
WELLER COMPANY SELLING AND ADMINISTRATIVE EXPENSE BUDGET Quarter 1 Quarter 2 Quarter 3 Quarter 4 Total Budgeted Unit sales 22000 23000 20000 20000 85000 variable Selling and Administrative expenses $ 46,200.00* $ 48,300.00 $ 42,000.00 $ 42,000.00 $ 178,500.00 Fixed Selling and Administrative expenses Advertising Expense $ 15,000.00 $ 15,000.00 $ 15,000.00 $ 15,000.00 $ 60,000.00 Executive Salaries $ 41,000.00 $ 41,000.00 $ 41,000.00 $ 41,000.00 $ 164,000.00 Depreciation $ 21,000.00 $ 21,000.00 $ 21,000.00 $ 21,000.00 $ 84,000.00 Insurance $ 4,000.00 $ 4,000.00 $ 8,000.00 Property taxes $ 6,400.00 $ 6,400.00 Total Fixed Selling and Administrative expenses $ 81,000.00 $ 83,400.00 $ 81,000.00 $ 77,000.00 $ 322,400.00 Total Selling and Administrative expenses $ 127,200.00 $ 131,700.00 $ 123,000.00 $ 119,000.00 $ 500,900.00 Less: Non cash expense (depreciation) $ 21,000.00 $ 21,000.00 $ 21,000.00 $ 21,000.00 $ 84,000.00 Cash Disbursement for selling and administrative expenses $ 106,200.00 $ 110,700.00 $ 102,000.00 $ 98,000.00 $ 416,900.00 *22000 x 2.10
Similar Solved Questions
2 answers
I need to unscramble these math words icarlafto untoegrnc enitmelgen
i need to unscramble these math words icarlaftountoegrncenitmelgen...
1 answers
A ray of light is incident normally on a glass plate 6.00 cm thick and of...
A ray of light is incident normally on a glass plate 6.00 cm thick and of refractive index n = 1.29 If the plate is turned through an angle of 74.0° about an axis perpendicular to the ray, what is the increase in the distance the ray travels in the glass? (nair = 1.00)...
1 answers
2 Bob's lawn-mowing service is a profit-maximizing, competitive firm. Bob mows lawns for $27 each. His...
2 Bob's lawn-mowing service is a profit-maximizing, competitive firm. Bob mows lawns for $27 each. His total cost each day is $280, of which $30 is a fixed cost. He mows 10 lawns a day. What can you say about Bob's short-run decision regarding shutdown and his long-run decision regarding exi...
1 answers
Write down 5 different foods that would each individually meet your DRI for vitamin C. Include...
Write down 5 different foods that would each individually meet your DRI for vitamin C. Include portion sizes and total amount of vitamin C in each food item....
1 answers
Required information SB Angle Max Industries produces a product... [The following information applies to the questions...
Required information SB Angle Max Industries produces a product... [The following information applies to the questions displayed below.] Angle Max Industries produces a product which goes through two operations, Assembly and Finishing, before it is ready to be shipped. Next year’s expected cos...
1 answers
ABC’s stock is expected to distribute a dividend of € 1.00 next year with dividends increasing...
ABC’s stock is expected to distribute a dividend of € 1.00 next year with dividends increasing for years 2, 3 and 4 by 5% per year. Thereafter dividends are expected to grow by a fixed rate every year. The ROE and plowback (retention) rate after year 4 are expected to be 5% and 25% respec...
1 answers
With detailed explanation please. Note on homework solutions: In order to receive full credit for homework...
With detailed explanation please. Note on homework solutions: In order to receive full credit for homework solutions, your work needs to be presented clearly, neatly, and completely. Answers should have units (when applicable) and be given to no more than three significant figures. 1. A block of mas...
1 answers
2. Let's now use Excel to simulate rolling two 6-sided dice and finding the minimum of...
2. Let's now use Excel to simulate rolling two 6-sided dice and finding the minimum of both dice. • Create a new Excel sheet in your document. Click on cell Al, then click on the function icon f. and select Math&Trig, then select RANDBETWEEN. In the dialog box, enter 1 for bottom and en...
1 answers
Please answer all three questions. Please make sure your answers are correct! Thanks! All information needed...
Please answer all three questions. Please make sure your answers are correct! Thanks! All information needed to answer the question is with in the text. 7) Refer to the images of the synaptic terminals at two different temperatures to answer the question. following 19°C 25°C na You are t...
1 answers
A transformer has 460 turns in the primary coil and 180 in the secondary coil. 1)by...
A transformer has 460 turns in the primary coil and 180 in the secondary coil. 1)by what factor does it change the current? IsIp =...
1 answers
Calculator Print item Loanstar had 50 units in beginning inventory before starting 1.000 units and completing...
Calculator Print item Loanstar had 50 units in beginning inventory before starting 1.000 units and completing 750 units. The beginning work in process twentory consisted of $3,000 in materials and $4,000 in conversion costs before $6,450 of materials and $11,660 of conversion costs were added during...
1 answers
Problem 4. (25 points) An optical wave of TM polarization is incident from water (n-1.33) to...
Problem 4. (25 points) An optical wave of TM polarization is incident from water (n-1.33) to air. At the water-air boundary, reflection and transmission happens. (a) What is the critical angle for total internal reflection? (b) What is the phase change at the critical angle for total internal reflec...
1 answers
How many distinct monochlorinated products can result when 2-methylpropane is subjected to free radical chlorination? A)...
How many distinct monochlorinated products can result when 2-methylpropane is subjected to free radical chlorination? A) 1 B) 2 C) 3 D) 4 E) 5 Please explain...
2 answers
The following activities occur at Greenwich Corporation, a company that manufactures a variety of products. a....
The following activities occur at Greenwich Corporation, a company that manufactures a variety of products. a. Receive raw materials from suppliers. b. Manage parts inventories. C. Do rough milling work on products. d. Interview and process new employees in the personnel department. e. Design new pr...