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

What is fixed budget, What is Fixed budget The fixed budget is prepare...

What is Fixed budget The fixed budget is prepared for a given level of activity the budget is prepared before the beginning of the financial year. If the financial year starts

Planning, Planning A business must plan for its success. What do w...

Planning A business must plan for its success. What do we understand by business planning? It is about thinking in advance -- to decide on a course of the action to reach

Industrial Grinders, accepted#Regarding the Overhead costs, these are alloc...

accepted#Regarding the Overhead costs, these are allocated based on Direct Labor;

The more competitive bid, Hornsby Manufacturing has four categories of ove...

Hornsby Manufacturing has four categories of overheads. The four categories and the expected overhead costs for each category for next year are as follows:   Maintenance  $140,000

MOH Cost Help, During the year the company worked a total of 145,900 machin...

During the year the company worked a total of 145,900 machine-hours on all jobs and incurred actual manufacturing overhead costs of $1,305,346. What is the amount of underapplied o

Explain short term budgets, Explain Short term budgets Short term budge...

Explain Short term budgets Short term budgets: these budgets are generally for one or two years and are in the form of monetary terms. The consumer's good industries like su

Activity ratio, Accounting ratios that determine a firm's ability to conver...

Accounting ratios that determine a firm's ability to convert various accounts within their balance sheets into sales or cash. Companies will usually try to shift their productio

Open account, Open Account Credit sales are usually on open account tha...

Open Account Credit sales are usually on open account that implies which the seller ships the goods to the buyer and afterward sends the bill invoice. Consignment In th

Investing surplus cash, The requirement for working capital fluctuates acco...

The requirement for working capital fluctuates according the level of inventory, production, debtors and creditors etc. The working capital needs are not uniform during the year be

Ilustrate the debt equity ratio, Debt equity ratio Meaning: this rati...

Debt equity ratio Meaning: this ratio establishes a relationship among long term debts and share holders funds. Objective: the objective of computing this ratio is to me

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