View the step-by-step solution to:

AC556 Week 3 Problem Production Budgets Note: It is expected that this problem will be complete using an Excel spreadsheet using formulas. Please see...

This question was answered on Jan 24, 2013. View the Answer
Budgeting Assignment - please see attachment
AC556 Week 3 Problem Production Budgets Note: It is expected that this problem will be complete using an Excel spreadsheet using formulas. Please see the Excel Tutorial that is available under the course home tab. The Hale Company finished their sales projections for the coming year. The company produces one product. Part of next year’s sales projections are as follows: July August September October November Projected Sales in units 100,000 125,000 156,000 165,000 185,000 The budget committee has also compiled the following information on inventories: Raw materials Work-in-Process Finished Goods Ending Balance, June 22,000 lbs None 13,000 units Desired ending levels (monthly) 5% of next month’s production needs None 12% of next month’s sales Engineering has developed the following standards upon which the production budgets will be developed: Item Standard Materials usage 5 lbs per unit Material price per pound $1.50 per pound Labor usage 0.4 hours per unit Labor rate $30 per hour Machine hours 3 machine hours per unit The Hale Company uses a modified allocation method for allocating overhead costs. The rates that will be used in the coming year are as follows: Overhead item Allocation rate Utilities $0.50 per machine hour Inspection $10 per unit produced Factory supplies $2 per unit produced Depreciation $35,000 per month Supervision $12,000 per month Required: Prepare the following production budgets for July, August, and September for the Hale Company: 1. Production budget 2. Materials purchase budget 3. Direct labor budget 4. Overhead budget For the quarter (quarter totals only), prepare the: 5. Cost of goods manufactured budget
Background image of page 1
Sign up to view the entire interaction

Top Answer

The way to approach this... View the full answer

8423143.xlsx

Hale Company - Budgets
July
100,000 Aug
125,000 Sep
156,000 July
100,000
15,000
115,000
(13000)
102,000 Aug
125,000
18,720
143,720
(15,000)
128,720 Sep
156,000
19,800
175,800
(18,720)
157,080...

This question was asked on Jan 22, 2013 and answered on Jan 24, 2013.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

-

Educational Resources
  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
  • -

    Flashcards

    Browse existing sets or create your own using our digital flashcard system. A simple yet effective studying tool to help you earn the grade that you want!

    Browse Flashcards