Budget Problem, Managerial Accounting

Assignment Help:
BUDGET PROBLEM
The Budget Director of Dave, Inc. with the assistance of the Controller, Production Manager and the Sales Manager has gathered the following data for use in developing the Budgeted Income Statement for 2012. The Company produces and sells two products: Batting Helmets and Football Helmets. Both products use two types of materials: Plastic and Foam Lining and they both go through a Molding Department and then through an Assembly Department before they are ready for sale.
Assume that there is no Work-Process-Inventory.
1. Estimated Sales : 25,800 Batting Helmets at $ 40 each and 54,100 Football Helmets at $ 75 each
2. Raw materials inventories at January 1st: Plastic – 9,500 pounds and Foam lining - 4,700 pounds
3. Finished Goods inventories at January 1st:
Batting Helmets – 2,450 at $ 21 each and Football Helmets – 3,900 at $ 40 each
4. Desired raw material inventory at December 31st: Plastic – 11,400 pounds and Foam lining -
4,500 pounds
5. Desired inventory at December 31st:
Batting Helmets – 2,400 at $ 21 each and Football Helmets - 3,500 at $ 40 each
6. Direct materials used in production:
Batting Helmet – Plastic – 1.40 pounds per unit and Foam lining - .60 pounds per unit
Football Helmet – Plastic – 3.20 pounds per unit and Foam lining – 1.20 pounds per unit
7. Cost of direct materials: Plastics - $ 6.50 per pound and Foam lining - $ 3.00 per pound
8. Direct labor used in production:
Batting Helmets - .16 hour in Molding at $14 per hour and .40 hour in Assembly at $12 per hour Football Helmets - .25 hour in Molding and .60 hour in Assembly (same rates)
9. Budgeted Factory Labor Overhead:
Indirect factory wages - $ 250,000 Depreciation on plant and equipment - $ 63,000 Utilities - $ 24,000 Insurance and property taxes - $ 9,700
10. Budgeted Operating Expenses:
Sales salaries expense - $ 505,700; Advertising Expense - $ 350,800; Office Salaries Expense – $ 145,800; Depreciation Expense Office Equipment - $ 6,200; Telephone Expense Selling - $ 4,700;Telephone Expense Administrative - $ 900; Travel Expense Selling - $ 42,100; Office Supplies Expense - $ 4,000; and Miscellaneous Administrative Expenses - $ 5,000.
11. Budgeted Other income and expenses:
Interest Revenue - $ 12,500 Interest Expense - $ 15,700
12. Budgeted income tax rate – 40%
REQUIRED:
Prepare a Budgeted Income Statement for 2012 with supporting schedules. Please refer to Exhibits 8 to 15 in your text on pages 986 to 994. Project is due by May 13, 2013

Related Discussions:- Budget Problem

Cash planning, Firms need cash to invest in inventory, receivables and fixe...

Firms need cash to invest in inventory, receivables and fixed assets and to create payments for operating expenses, so as to increase earnings and sales and make sure the smooth ru

Example of credit period, M/s ABC has an existing sales of Rs.50 lakhs and ...

M/s ABC has an existing sales of Rs.50 lakhs and permits a credit period of 30 days to its customers.  The firm cost of capital is 10% and the ratio of variable cost to sales is 85

Investments carried as trading securities, a)    Does Ford report any inves...

a)    Does Ford report any investments carried as trading securities, available-for-sale securities, or held-to-maturity securities? If so, go over their significance to both the b

What is budgetary control, What is Budgetary control Budgetary control...

What is Budgetary control Budgetary control is the process of determining various budgeted figures for the enterprises for the future period and then comparing the budgeted fi

Questions., how long will it take to get answers after question are submitt...

how long will it take to get answers after question are submitted

Homework, IF net income totaled $18,000 for one year, beginning assets were...

IF net income totaled $18,000 for one year, beginning assets were $100.000 and ending assets were $140,000, then Return on Assets for the year as a percentage will be?

Factory layout-jit features, Factory Layout The first stage of implemen...

Factory Layout The first stage of implementing the JIT manufacturing techniques is to rearrange the factory floor away from the batch production functional layout towards a pro

Periodic system and a perpetual system, Your manager has informed you that ...

Your manager has informed you that the company is trying to determine if it should use a periodic system or a perpetual system in accounting for the inventory. He wants you to spea

Collection float, Collection float considers to the gap among the times, pa...

Collection float considers to the gap among the times, payment is made through the customer/debtor and the time while funds are obtainable for use in the company's bank account. In

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd