Purchase Solution

Gerrad Manufacturing: Production, direct materials, and dire

Not what you're looking for?

Ask Custom Question

has projected sales of its product for the next six months as follows:

January 300 units

February 700 units

March 1,000 units

April 900 units

May 400 units

June 300 units

The finished product requires 3 pounds of raw material and 10 hours of direct labor. Gerrad tries to maintain a Finished Goods ending inventory equal to the next two months of sales and a Raw Material ending inventory equal to one-half of the current month's production needs. January's beginning inventories are expected to conform to company policy.

a. Prepare a production budget for February, March, and April.
b. Prepare a forecast of the units and cost of raw material that will be required for February, March, and April. The expected cost per pound of raw material is expected to be $2 in February, $2.30 in March, and $2.40 in April.
c. Prepare a direct labor budget (assuming a $12 per hour rate) for February, March, and April.

Purchase this Solution
Solution Summary

Your tutorial is in Excel (see attached). Click in cells to see computations. The format is now a guideline for any other budget problems.

Solution provided by:
Carol Sargent, PhD
Education
  • BSc, University of Virginia
  • MSc, University of Virginia
  • PhD, Georgia State University
Recent Feedback
  • "hey just wanted to know if you used 0% for the risk free rate and if you didn't if you could adjust it please and thank you "
  • "Thank, this is more clear to me now."
  • "Awesome job! "
  • "ty"
  • "Great Analysis, thank you so much"
Purchase this Solution
Free BrainMass Quizzes
Marketing Management Philosophies Quiz

A test on how well a student understands the basic assumptions of marketers on buyers that will form a basis of their marketing strategies.

SWOT

This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.

Marketing Research and Forecasting

The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.

Social Media: Pinterest

This quiz introduces basic concepts of Pinterest social media

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

View More Free Quizzes
Related BrainMass Solutions

  • Braemar Saddlery: Under and Over Applied Overhead

    Direct materials and direct labor are charged to production at actual cost. Factory overhead is applied to production at the predetermined rate of 150 percent of the actual direct labor cost.

  • Budgeting

    Scarborough Corporation Direct Materials Purchases Budget (in quantities) for 2007 Direct Materials A B C Direct materials to be used in production Thingone (budgeted production of 65,000 units

  • Variance analysis

    direct materials used in production , the actual price per pound of direct materials purchased and direct materials price variance.

  • Job Costing and Process Costing

    What are the source documents for direct materials, direct labor, and manufacturing overhead costs assigned to this job? 2. What is the predetermined manufacturing overhead rate? 3 What are the total cost and the unit cost of the completed job?

  • Revised performance report

    Direct materials and direct labor are charged to production at actual cost. Factory overhead is applied to production at the predetermined rate of 150 percent of the actual direct labor cost.

  • Components of master budget

    The Manufacturing Overhead Budget :The manufacturing overhead budget lists all production costs other than direct materials and direct labor. Manufacturing overhead costs should be broken down by cost behavior for budgeting purposes.

  • Multiple Choice

    The budget for May called for production of 9,000 units. Actual output for the month was 8,500 units with total direct materials cost of $127,500 and total direct labor cost of $77,775.

  • Manufacturing costs and budgeting

    Manufacturing Overhead -Costs that are indirectly associated with manufacturing the product (includes all manufacturing costs except direct materials and direct labor) 2.

  • Wayne's Company: What is the amount of cost of goods manufac

    Direct labor cost incurred $200,400 Direct labor-hours 24,900 Actual manufacturing overhead cost incurred $131,600 Direct materials purchases $165,200 Wayne applies manufacturing overhead cost to jobs based on direct labor-hours, and the

View More Related Solutions