Question

In: Finance

Information about Roboto, a product sold by Roberts, Inc. is as follows: Each unit requires four...

Information about Roboto, a product sold by Roberts, Inc. is as follows:

Each unit requires four pounds of material X37. Roberts is planning raw materials needs for the second quarter. Inventory requirements are as follows:

a.

The finished goods inventory on hand at the end of each month must be equal to 6,000 units plus 26% of the next month’s sales. The finished goods inventory on March 31 is budgeted based on this requirement.

b.

The raw materials inventory on hand at the end of each month must be equal to one-half of the following month’s production needs for raw materials. The raw materials inventory on March 31 for material X37 is budgeted based on this requirement.

c. The company maintains no work in process inventories.
A sales budget for Roboto for the second and third quarters of the year follows.
Budgeted Sales
in Units
April 47,000             
May 57,000             
June 77,000             
July 42,000             
August 27,000             
September 17,000             
Required:
.

Prepare a production budget for Roboto for the months April, May, June and July.

.

Prepare a direct materials budget showing the quantity of material X37 to be purchased for April, May, June and for the quarter in total.

Solutions

Expert Solution

Production budget
April May June July
Sales 47000 57000 77000 42000
Closing stock 20820 26020 16920 6000
Less: Opening stock 18220 20820 26020 16920
49600 62200 67900 31080
Closing stock
April May June July August
Sales 47000 57000 77000 42000 27000
Fixed qty 6000 6000 6000 6000
26% of sales (Next month) 14820 20020 10920 0
20820 26020 16920 6000
Oprning stock
April May June July August
Sales 47000 57000 77000 42000 27000
Fixed qty 6000 6000 6000 6000
26% of sales 12220 14820 20020 10920
18220 20820 26020 16920
Material budget
April May June
Sales 47000 57000 77000
Closing stock 28500 38500 21000
Less: Opening stock 23500 28500 38500
52000 67000 59500
Closing stock
April May June July
Sales 47000 57000 77000 42000
0.5 of sales (Next month) 28500 38500 21000
Oprning stock
April May June July
Sales 47000 57000 77000 42000
0.5 of sales 23500 28500 38500
Material budget
QTR
Sales 181000
Closing stock 21000
Less: Opening stock 23500
178500
Closing stock
July
Sales 42000
0.5 of sales (Next month) 21000
Oprning stock
April
Sales 47000
0.5 of sales 23500

Related Solutions

Information about Roboto, a product sold by Roberts, Inc. is as follows: Each unit requires five...
Information about Roboto, a product sold by Roberts, Inc. is as follows: Each unit requires five pounds of material X37. Roberts is planning raw materials needs for the second quarter. Inventory requirements are as follows:    a. The finished goods inventory on hand at the end of each month must be equal to 7,000 units plus 33% of the next month’s sales. The finished goods inventory on March 31 is budgeted based on this requirement. b. The raw materials inventory...
Roberts Corporation makes one product and has provided the following information: a.    Each unit of finished...
Roberts Corporation makes one product and has provided the following information: a.    Each unit of finished goods requires 3 pounds of raw materials. The raw materials cost $5.00 per pound. b.   The direct labor wage rate is $24.00 per hour. Each unit of finished goods requires 2.8 direct labor-hours. c.    Manufacturing overhead is entirely variable and is $11.00 per direct labor-hour. d.   The variable selling and administrative expense per unit sold is $3.80. The fixed selling and administrative        expense...
Dodd Company makes and sells a single product. Each finished unit requires four pounds of direct...
Dodd Company makes and sells a single product. Each finished unit requires four pounds of direct materials. The budgeted units to be produced for the third quarter of the current year are given below: Budgeted Units to be Produced July 26,000 units August 21,000 units September 33,000 units The company wants to maintain monthly ending inventories of direct materials equal to 35% of the next month's production needs. The cost of the direct materials is $1.75 per pound. Calculate the...
A product, sold seasonably, yields a net profit of b dollars for each unit sold and...
A product, sold seasonably, yields a net profit of b dollars for each unit sold and a net loss of l dollars for each unit left unsold when the season ends. The number of units of the product that are ordered at a specific department store during any season is a random variable having probability mass function p(i), i ≥ 0. If s is the total number of units stocked, find the expected profit for this product as a function...
Stefani Company has gathered the following information about its product. Direct materials: Each unit of product...
Stefani Company has gathered the following information about its product. Direct materials: Each unit of product contains 3.20 pounds of materials. The average waste and spoilage per unit produced under normal conditions is 0.10 pounds. Materials cost $1 per pound, but Stefani always takes the 1.00% cash discount all of its suppliers offer. Freight costs average $0.40 per pound. Direct labor. Each unit requires 2.90 hours of labor. Setup, cleanup, and downtime average 0.20 hours per unit. The average hourly...
Stefani Company has gathered the following information about its product. Direct materials: Each unit of product...
Stefani Company has gathered the following information about its product. Direct materials: Each unit of product contains 3.90 pounds of materials. The average waste and spoilage per unit produced under normal conditions is 0.20 pounds. Materials cost $ 2 per pound, but Stefani always takes the 1.00 % cash discount all of its suppliers offer. Freight costs average $ 0.45 per pound. Direct labor. Each unit requires 2.60 hours of labor. Setup, cleanup, and downtime average 0.20 hours per unit....
Stefani Company has gathered the following information about its product. Direct materials: Each unit of product...
Stefani Company has gathered the following information about its product. Direct materials: Each unit of product contains 4.20 pounds of materials. The average waste and spoilage per unit produced under normal conditions is 0.70 pounds. Materials cost $1 per pound, but Stefani always takes the 2.00% cash discount all of its suppliers offer. Freight costs average $0.45 per pound. Direct labor. Each unit requires 1.60 hours of labor. Setup, cleanup, and downtime average 0.20 hours per unit. The average hourly...
Miller Corporation is a manufacturer with four product lines. Below is some financial information about each...
Miller Corporation is a manufacturer with four product lines. Below is some financial information about each of the four product lines. Product Segment Booyas Widgets Humdrums Loonies Total Sales to nonaffiliates $10,000 $30,000 $35,000 $15,000 $90,000 Intersegment sales 2,000 6,000    8,000 16,000 32,000 Total revenue $12,000 $36,000 $43,000 $31,000 $122,000 Operating profit (loss) 1,000 6,000 (1,000) 8,000 14,000 Identifiable assets 10,000 15,000 60,000 80,000 165,000             Using all the tests below, determine which of the product segments are reportable...
The Jerry Company produces product X. Each product sells for RM20.00. Unit costs are as follows:...
The Jerry Company produces product X. Each product sells for RM20.00. Unit costs are as follows: RM Direct material 3.90 Direct labour 1.40 Variable factory overhead 2.10 Variable selling and administrative expenses 1.60 Total fixed factory overhead is RM70,000 per year and total fixed selling and administrative expense is RM100,000. During the recent year, 20,000 units were sold. Required: a) Calculate the variable cost per unit, total fixed cost and the contribution margin per unit. b) Calculate the breakeven point...
Information regarding the selling prices and unit costs of three products is as follows: Product F...
Information regarding the selling prices and unit costs of three products is as follows: Product F G H Selling price $ 70 $ 50 $ 80 Variable costs $ 30 $ 20 $ 35 Fixed costs $ 10 $ 7 $ 7 Machine time (minutes) 10 5 5 Fixed costs are applied to the products on the basis of direct labor hours. Due to the amount of machine time available, the company cannot produce all the units demanded. The only...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT