!st Part Done,,,need help with the 2nd part!
Sales were 20,000 units in June 2014. Forecasted sales in units are as follows: July, 19,000; August, 21,000; September, 20,000; October, 24,000. The product’s selling price is $17.50 per unit and its total product cost is $14.35 per unit. 2. The June 30 finished goods inventory is 14,700 units. 3. Going forward, company policy calls for a given month’s ending finished goods inventory to equal 70% of the next month’s expected unit sales. 4. The June 30 raw materials inventory is 4,375 units. The budgeted September 30 raw materials inventory is 1,980 units. Raw materials cost $8 per unit. Each finished unit requires 0.50 units of raw materials. Company policy calls for a given month’s ending raw materials inventory to equal 20% of the next month’s materials requirements. 5. Each finished unit requires 0.50 hours of direct labor at a rate of $16 per hour. 6. Overhead is allocated based on direct labor hours. The predetermined variable overhead rate is $1.35 per direct labor hour. Depreciation of $20,000 per month is treated as fixed factory overhead. 7. Monthly general and administrative expenses include $12,000 administrative salaries and 0.9% monthly interest on the long-term note payable. 8. Sales representatives’ commissions are 10% of sales and are paid in the month of the sales. The sales manager’s monthly salary is $3,750 per month. 9. The company expects 30% of sales to be for cash and the remaining 70% on credit. Receivables are collected in full in the month following the sale (none are collected in the month of the sale). 10. All raw materials purchases are on credit, and no payables arise from any other transactions. One month’s raw materials purchases are fully paid in the next month. 11. Dividends of $20,000 are to be declared and paid in August. 12. Income taxes payable at June 30 will be paid in July. Income tax expense will be assessed at 35% in the quarter and paid in October. 13. Equipment purchases of $100,000 are budgeted for the last day of September.
Answers:
|
Company Peyton |
||||
|
|
||||
|
(a) Sales Budget for The Quarter Ending on Sep-14 |
||||
|
Particular |
Jul-14 |
Aug-14 |
Sep-14 |
Total |
|
Forecasted Sales Units |
21000 |
20000 |
60000 |
|
|
Selling Price/ unit ($) |
17.5 |
17.5 |
||
|
Total Gross Sales ($) |
332500 |
367500 |
350000 |
1050000 |
|
Company Peyton |
||||
|
(c) Production Budget for The Quarter Ending on Sep-14 |
||||
|
Particular |
Jul-14 |
Aug-14 |
Sep-14 |
Total |
|
19000[FS3] |
21000 |
20000 |
60000 |
|
|
(+) Planned Closing Stock ( 70 % of next month sales) |
14000 |
16800 |
||
|
(-) Planned Opening Stock |
14700 |
14700 |
14000 |
|
|
Budgeted Production ( units) |
19000 |
20300 |
22800 |
62100 |
|
Company Peyton |
||||
|
(e) Manufacturing Budget for The Quarter Ending on Sep-14 |
||||
|
Particular |
Jul-14 |
Aug-14 |
Sep-14 |
Total |
|
Budgeted Production ( units) |
20300 |
22800 |
62100 |
|
|
Raw Material Required @ 0.50 units for per unit of finisged goods |
9500 |
10150 |
11400 |
31050 |
|
Raw Material Cost @ $8 per unit (a) |
76000 |
81200 |
91200 |
248400 |
|
Direct Labor required @ 0.5 hr for per unit of finished goods |
9500 |
10150 |
11400 |
|
|
Direct Labor Cost @ $16 per hour (b) |
152000 |
162400 |
182400 |
496800 |
|
Variable Overhead rate @ $1.35 per labor hour ( C ) |
12825 |
13702.5 |
15390 |
41917.5 |
|
Fixed Factory Overhead ( Depreciation) (d) |
20000 |
20000 |
20000 |
|
|
Total Manufacturing Cost |
260825 |
277302.5 |
308990 |
787117.5 |
|
Company Peyton |
||||
|
(g) Selling Expense Budget for The Quarter Ending on Sep-14 |
||||
|
Particular |
Jul-14 |
Aug-14 |
Sep-14 |
Total |
|
Sales Revenue |
367500 |
350000 |
1050000 |
|
|
Sales Commission @ 10 % of [FS7] Sales (a) |
33250 |
36750 |
35000 |
105000 |
|
Sales Manager Salary (b) |
3750 |
3750 |
3750 |
11250 |
|
Selling Expense |
37000 |
40500 |
38750 |
116250 |
|
Company Peyton |
||||
|
(i) General and Administrative Expense Budget for The Quarter Ending on Sep-14 |
||||
|
Particular |
Jul-14 |
Aug-14 |
Sep-14 |
Total |
|
Monthly Administrative Salaries |
12000 |
12000 |
12000 |
36000 |
|
Interest on Long Term Note Payable @ 0.9% (300000 X 0.9%) |
2700 |
2700 |
2700 |
8100 |
|
Dividend |
20000 |
20000 |
||
|
Taxes Payable |
10000 |
10000 |
||
|
Interest on Short Term Notes Payable |
240 |
240 |
||
|
Total |
24940 |
34700 |
14700 |
74340 |
[FS2]18.00 Please review the other months
[FS7]12% Please review the other months
Part 2..Need Help!
a) Discuss the initial budget process, the variances, and potential reasons for the variances. b) Determine changes you think the company should make based on the variance analysis. What will the changes accomplish? c) What are the ethical considerations of the changes you have selected? Why are you recommending these particular changes? d) Decide whether you continue buying a particular component of one of your products or making the product in-house. Develop a recommendation on the “make” or “buy” decision for the given component. What factors did you consider? e) What are the ethical considerations of your decision? What implications could this decision have? f) Describe how your decision was reached. How will this impact the efficiencies of your operation? g) What suggestions would you make for nonfinancial performance measures that the company should adopt? What are the pros and cons of each? h) What are the ethical considerations of your suggestions? Explain the significance of each.


0 comments