Prepare the production budget

Assignment Help Accounting Basics
Reference no: EM131560000

Question 1 - Production and Related Budgets

Acclaim Kitchen Furnishings Company manufactures vinyl kitchen settings. The budget committee is preparing budgets for production, materials, and labor for the year ended June 30, 2012.

The forecast sales in units by quarter are:

July, August & September, 2011

(1st Quarter)

4,500 units

October, November & December, 2011

(2nd Quarter)

2,750 units

January, February & March, 2012

(3rd Quarter)

3,500 units

April, May & June, 2012

(4th Quarter)

2,500 units

July, August & September, 2012

(1st Quarter)

3,000 units

An ending inventory balance of direct materials (vinyl and steel and timber tops kits) to equal to 15% of the next quarter's production requirements is maintained. The ending balance of finished goods has to equal to 20% of the next quarter's forecast sales. The projected direct material and finished goods inventory balances as at July 1, 2011 were:

Vinyl - 2,650 feats

Steel and timber tops kits - 400 units

Finished goods - 900 units

The direct materials and labor requirements to produce one unit of vinyl kitchen setting are as follows:

Direct material / labor

Quantity Required

Labor Cost

Cutting

1.5 hour

$8.50 per hour

Assembly

2 hour

$10 per hour

Vinyl

6 feet

$6 per feet

Tabular steel and timber top kit

1 unit

$32 per unit

Required:

a) Prepare the production budget in units for the first three quarters of 2011/2012.

b) Prepare the direct materials budget for the first three quarters of 2011/2012,

c) Prepare the direct labor budget for the first three quarters of 2011/2012.

Question 2 - Direct Labor Budget

Dalby Manufacturing Ltd aims to have a monthly ending inventory balance equals to 55% of projected sales of the following month. The ending inventory balance on July 31 was 600 units. Projected sales for August, September, and October were 1,000, 1,500 and 800 units respectively. Labor requirements to produce each unit are as follows:

 

Time required (hrs)

Rate per hour

Assembler

3.0

$0

Welder

2.6

$12

Finisher

4.0

$8

Required: Prepare a direct labor budget (in hours and dollars) for the month of August and September 2012.

Reference no: EM131560000

Questions Cloud

Contain the true parameter value : For a 94% confidence interval for a population, e.g., the population mean, of all possible confidence intervals, how many will contain the true parameter value?
How might you separately counsel both the parent and child : A parent is at his or her wit's end over a seeming lack of ambition and drive in his 8-year-old son has come to you for help.
Perform the significance test : Perform the significance test. (Use a = 0.01. Round your test statistic to two decimal places and your P-value to four decimal places.)
How it may be a useful orientation for program evaluation : Discuss how it may be a useful orientation for program evaluation in your field and your personal program evaluation needs.
Prepare the production budget : Acclaim Kitchen Furnishings Company manufactures vinyl kitchen settings. Prepare the production budget in units for the first three quarters of 2011/2012
Identify memories of masculinity and femininity in family : Identify memories of masculinity and femininity in your family, peers, authority figures, and role models from childhood through adolescence.
Sample of books consisting of the ages : Go to a local library; collect a sample of books consisting of the ages of book (based on copyright dates).
What will the predicted spending on medicare : SPENDING ON MEDICARE Based on the current eligibility requirement, a study conducted in 2004 showed that federal spending on entitlement programs, particularly.
Confidence interval for the proportion : A medical researcher wants to construct a 99% confidence interval for the proportion of knee replacement surgeries that result in complications.

Reviews

Write a Review

Accounting Basics Questions & Answers

  What is the cost-benefit outcomes of section 404 of the

what is the cost-benefit outcomes of section 404 of the sarbanes-oxley act? what types of society wide benefits are

  Explain the strengths and weaknesses of approach

Offer an example of workers who have prevented their companies from offshoring their positions and explain the strengths and weaknesses of their approach.

  Dugan sales had the following transactions for jackets in

dugan sales had the following transactions for jackets in 2013 its first year of operations jan 20 purchased 80 units

  Samson wholesale beverage company regularly factors its

samson wholesale beverage company regularly factors its accounts receivable with the milpitas finance company. on april

  Pell manufacturing is preparing its direct labor budget

pell manufacturing is preparing its direct labor budget for may. projections for the month are that 33400 units are to

  How does method affect balance sheet and income statement

How does each method affect the balance sheet and the income statement? What do I mean when I say that inventory costing methods are not related to the physical flow of inventory? Please give an example.

  Magnitude of signal output voltage

If the emitter current source I is 200 μA, what is re of the half-circuit? For a load resistance of 10 kΩ n each collector, what is the half-circuit gain? What magnitude of signal output voltage would you expect at each collector? Between the two ..

  Prepare the amortization table on the investment in bond

Prepare the amortization table on the investment in bond. Prepare the entries on the investment in bond on 1/1/06, the interest revenue and the amortization of the premium on 12/31/07.

  Preparation of sales budget

Assuming that the trend of sales indicated in part (1) is to continue in 2009, compute the unit sales volume to be used for preparing the sales budget for the year ending December 31, 2009. Place your answer in a columnar table similar to that in ..

  Materials price and quantity variances

The What If part of the assignment will help you determine whether you have correctly used cell referencing in your spreadsheets. Change your date in the heading to: "For the Year Ended December 31, 2017.

  Palmiero purchased a patent from vania co for 1127800 on

answer the questions asked about each of the factual situations. if answer is zero please enter 0. do not leave any

  Yola company manufactures a product with standards for

yola company manufactures a product with standards for direct labour of 4 direct labour-hour per unit at a cost of 12

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