This looks like a lot but I only need to know the solutions to a through d please:
a. The desired ending inventory on schedule 2
b. The desired ending inventory on schedule 3
c. Variable overhead rate on schedule 5
d. Variable overhead rate on schedule 6
Below is the original problem & all of the completed schedules. Thank you!
a. The desired ending inventory on schedule
2
Desired Ending Inventory for finished goods is 20% of next month's
sales i.e. Desired Ending Inventory for
January = 20% of February Sales units i.e. 20% of 10500 = 2100
units
February = 20% of March Sales units i.e. 20% of 13000 = 2600
units
March = 20% of April Sales units i.e. 20% of 16000 = 3200 units
b. The desired ending inventory on schedule
3
Desired Ending Inventory for Material is 30% of next month's
production needs, Desired Ending Inventory for
Part K29
January = 30% of February Production needs i.e. 30% of 22000 = 6600
units
February = 30% of March Production needs i.e. 30% of 27200 = 8160
units
March = 30% of April Production needs i.e. 30% of (16500 x 2) =
9900 units
* Production for April = 16000 (sales units) + (18500 x 20%)
(Ending Inventory) - 3200 (Beginning Inventory) = 16500 units
Part C30
January = 30% of February Production needs i.e. 30% of 33000 = 9900
units
February = 30% of March Production needs i.e. 30% of 40800 = 12240
units
March = 30% of April Production needs i.e. 30% of (16500 x 3) =
14850 units
* Production for April = 16000 (sales units) + (18500 x 20%)
(Ending Inventory) - 3200 (Beginning Inventory) = 16500 units
c. Variable overhead rate on schedule 5
Variable Overhead rate is per direct labor hour
= $1.00 (Supplies) + $0.20 (Power) + $1.10 (Maintenance) + $1.60
(Other) = $3.90 per direct labor hour
d. Variable overhead rate on schedule 6
Variable Overhead rate is per unit sold
= $1.40 (Commission) + $3.60 (Commission) + $1.60 (Other) = $6.60
per unit sold
This looks like a lot but I only need to know the solutions to a through...
Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below. January 10,000 February 10,500 March 13,100 April 16,000 May 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: Finished goods inventory on January 1 is 900 units. The desired ending inventory for each...
Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below. January 10,000 February 10,600 March 13,300 April 16,000 May 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: Finished goods inventory on January 1 is 900 units. The desired ending inventory for each...
Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below. January 10,000 February 10,600 March 13,500 April 16,000 May 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: Finished goods inventory on January 1 is 900 units. The desired ending inventory for each...
Operating Budget, Comprehensive Analysis Ponderosa, Inc., produces wiring harness assemblies used in the production of semi-trailer trucks. The wiring harness assemblies are sold to various truck manufacturers around the world. Projected sales in units for the coming five months are given below. January 10,000 February 10,600 March 13,300 April 16,000 May 18,500 The following data pertain to production policies and manufacturing specifications followed by Ponderosa: Finished goods inventory on January 1 is 900 units. The desired ending inventory for each...
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: January 40,000 February 50,000 March 60,000 April 60,000 May 62,000 The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: Finished goods inventory on January 1 is 32,000 units, each costing $166.06. The desired ending inventory for each...
Operating Budget, Comprehensive Analysis Allison Manufacturing produces a subassembly used in the production of jet aircraft engines. The assembly is sold to engine manufacturers and aircraft maintenance facilities. Projected sales in units for the coming 5 months follow: January 40,000 February 50,000 March 60,000 April 60,000 May 62,000 The following data pertain to production policies and manufacturing specifications followed by Allison Manufacturing: 1 a. Finished goods inventory on January 1 is 32,000 units, each costing $166.06. The desired ending inventory...
Projected sales in units for the coming 5 months follow: January 40,000 February 50,000 March 60,000 April 60,000 May 62,000 Finished goods inventory on January 1 is 32,000 units, each costing $166.06. The desired ending inventory for each month is 80% of the next month's sales. The data on materials used are as follows: Direct Material Per-Unit Usage DM Unit Cost ($) Metal 10 lbs. 8 Components 6 5 Inventory policy dictates that sufficient materials be on hand at the...
Budgeted income statement and supporting budgets for three months Bellaire Inc. gathered the following data for use in developing the budgets for the first quarter (January, February, March) of its fiscal year: a. Estimated sales at $125 per unit: January 25,000 units February 30,000 units March 45,000 units April 50,000 units b. Estimated finished goods inventories: January 1 2,000 units January 31 10% of next month’s sales February 28 10% of next month’s sales March 31 10% of next month’s...
Budgeted income statement and supporting budgets for three months Bellaire Inc. gathered the following data for use in developing the budgets for the first quarter (January, February, March) of its fiscal year: a. Estimated sales at $125 per unit: January 25,000 units February 30,000 units March 45,000 units April 50,000 units b. Estimated finished goods inventories: January 1 2,000 units January 31 10% of next month’s sales February 28 10% of next month’s sales March 31 10% of next month’s...
I think I have A & B correct but I'm so lost. The attached screenshots after the question are the templates I'm using. Any help is very appreciated. Business Decision Case The sales department of Donovan Manufacturing, Inc. has completed the following sales forccast for the months of January through March 20X1 for its only two products: 50,000 units of J to be sold at $90 each and 30,000 units of K to be sold at $70 each. The desired...