Question

In: Accounting

The following are budgeted data: Sales (units )Production (units) April 15,000 18,000 May 20,000 19,000 June...

The following are budgeted data:

Sales (units )Production (units)

April 15,000 18,000

May 20,000 19,000

June 18,000 16,000

Two pounds of material are required for each finished unit. The inventory of materials at the end of each month should equal 20% of the following month's production needs.

Purchases of raw materials for May should be:

36,800 pounds

39,200 pounds

52,000 pounds

38,000 pounds

Solutions

Expert Solution

Answer : 36800 pounds

=>

Material used in May 19000*2pounds 38000 pounds
+ Closing bal of Material required (16000*2)*20% +6400
- Opening bal of Material available i.e April's closing balance of Material (19000*2)*20% -7600
Purchases of raw materials for May = 36800 pounds

Related Solutions

Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500...
Estimated sales January February March April May Total Coffee sales (units) 15,000 16,000 18,000 17,500 14,500 Your friend, Chris Coffee, has been running a successful coffee shop for the last couple of years. He has asked you to put together a cash budget. His regular accountant was too busy to help, but told Chris his depreciation expense was going to be $9,000 per year, using the straight-line method. He has supplied you with the following information (above) to help you...
Detmer Enterprises has the following budgeted sales: Budgeted Sales in Units June 6,800 units July 5,100...
Detmer Enterprises has the following budgeted sales: Budgeted Sales in Units June 6,800 units July 5,100 units August 4,400 units September 3,700 units Past experience has shown that the ending finished goods inventory for each month should be equal to 25% of the next month's expected sales in units. Additionally, it is known that every unit produced requires four direct labor hours to make and direct laborers are paid $15 per hour. Assume that Detmer pays 65% of its direct...
Detmer Enterprises has the following budgeted sales: Budgeted Sales in Units June 6,800 units July 5,100...
Detmer Enterprises has the following budgeted sales: Budgeted Sales in Units June 6,800 units July 5,100 units August 4,400 units September 7,300 units Past experience has shown that the ending finished goods inventory for each month should be equal to 20% of the next month's expected sales in units. Additionally, it is known that every unit produced requires four direct labor hours to make and direct laborers are paid $15 per hour. Assume that Detmer pays 65% of its direct...
Sticky Wickets manufactures Cricket Bats. In May 2010 the budgeted sales and production were 19,000 bats...
Sticky Wickets manufactures Cricket Bats. In May 2010 the budgeted sales and production were 19,000 bats and the standard cost card is as follows:                                                                                                              Std Cost                                          Std Cost Material (2kgs @ $5/kg)                                                                         10 Labour (3 hrs at $12/hr)                                                                         36 Overheads (3 hrs @ $1/hr)                                                                     3 Marginal Cost                                                                                                                                                  49 Selling Price                                                                                                                                                    68 Contribution                                                                                                                                                     19 Total fixed costs in the period were budgeted at $100,000 and were absorbed on the basis of labour hours worked. In May 2010 the following results...
XYZ Company has budgeted production of Item #123 for April, May, and June of 2,400, 3,200,...
XYZ Company has budgeted production of Item #123 for April, May, and June of 2,400, 3,200, and 2,800 units, respectively. XYZ Company currently pays a standard rate of $3 per foot for raw material A and $5 per sheet for raw material B. Each unit produced requires 4 feet of raw material A and 2 sheets of raw material B. Each unit produced also requires 30 minutes of cutting direct labor time at a standard rate of $16 per hour...
The following information is budgeted for Plumbing Limited for next quarter: April ($) May ($) June...
The following information is budgeted for Plumbing Limited for next quarter: April ($) May ($) June ($) Sales 110,000 130,000 180,000 Merchandise purchases 85,000 92,000 105,000 Selling and administrative expenses 50,000 50,000 50,000 All sales at the company are on credit: 40% are collected in the month of sale, 58% in the month following the sale, and the remaining 2% are uncollectible. Merchandise purchases are paid in full the month following the month of purchase. The selling and administrative expenses...
Kubin Company’s relevant range of production is 15,000 to 19,000 units. When it produces and sells...
Kubin Company’s relevant range of production is 15,000 to 19,000 units. When it produces and sells 17,000 units, its average costs per unit are as follows:    Average Cost per Unit Direct materials $ 7.60 Direct labor $ 4.60 Variable manufacturing overhead $ 2.10 Fixed manufacturing overhead $ 5.60 Fixed selling expense $ 4.10 Fixed administrative expense $ 3.10 Sales commissions $ 1.60 Variable administrative expense $ 1.10 Required: 1. For financial accounting purposes, what is the total amount of...
Kubin Company’s relevant range of production is 15,000 to 19,000 units. When it produces and sells...
Kubin Company’s relevant range of production is 15,000 to 19,000 units. When it produces and sells 17,000 units, its average costs per unit are as follows:    Average Cost per Unit Direct materials $ 7.60 Direct labor $ 4.60 Variable manufacturing overhead $ 2.10 Fixed manufacturing overhead $ 5.60 Fixed selling expense $ 4.10 Fixed administrative expense $ 3.10 Sales commissions $ 1.60 Variable administrative expense $ 1.10 Required: 1. Assume the cost object is units of production: a. What...
Kubin Company’s relevant range of production is 15,000 to 19,000 units. When it produces and sells...
Kubin Company’s relevant range of production is 15,000 to 19,000 units. When it produces and sells 17,000 units, its average costs per unit are as follows:    Amount per Unit Direct materials $ 7.60 Direct labor $ 4.60 Variable manufacturing overhead $ 2.10 Fixed manufacturing overhead $ 5.60 Fixed selling expense $ 4.10 Fixed administrative expense $ 3.10 Sales commissions $ 1.60 Variable administrative expense $ 1.10 Required: 1. What is the incremental manufacturing cost incurred if the company increases...
Using the following budgeted information for production of 9,000 and 15,000 units, prepare a flexible budget...
Using the following budgeted information for production of 9,000 and 15,000 units, prepare a flexible budget for 18,000 units. Production 9,000 units 15,000 units Expense A $14,400 $24,000 Expense B   22,000   22,000 Expense C   43,000   43,000 Total expenses $? 2. The production cost for a waterproof phone case is $6 per unit and fixed costs are $24,000 per month. How much is the favorable or unfavorable variance if 5,600 units were produced for a total of $57,100? Enter the amount...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT