Question

Lowell Company makes and sells artistic frames for pictures. The controller is responsible for preparing the...

Lowell Company makes and sells artistic frames for pictures. The controller is responsible for preparing the master budget and has accumulated the following information for 2020.

January

February

March

April

May

Estimated unit sales 11,000 11,600 8,900 8,500 8,400
Sales price per unit $ 50.50 $ 48.40 $ 48.40 $ 48.40 $ 48.40
Direct labor hours per unit 2.2 2.2 1.7 1.7 1.7
Wage per direct labor hour $ 8 $ 8 $ 8 $ 9 $ 9


Lowell has a labor contract that calls for a wage increase to $ 9 per hour on April 1. New labor-saving machinery has been installed and will be fully operational by March 1.

Lowell expects to begin the year with 19,120 frames on hand and has a policy of carrying an end-of-month inventory of 100% of the following month’s sales, plus 70% of the second following month’s sales.

Prepare a production budget for Lowell Company by month and for the first quarter of the year.

LOWELL COMPANY
Production Budget

  For the Quarter Ending March 31, 2020For the Year Ending March 31, 2020March 31, 2020

Jan

Feb

Mar

Total

  Total Required UnitsBeginning Finished Goods UnitBeginning Direct MaterialsDirect Materials Per UnitDesired Ending Direct MaterialsRequired Production UnitsExpected Unit SalesDesired Ending Finished Goods UnitDirect Materials PurchasesTotal Materials Required

  AddLess:    Direct Materials Per UnitBeginning Direct MaterialsTotal Required UnitsDesired Ending Finished Goods UnitDesired Ending Direct MaterialsRequired Production UnitsBeginning Finished Goods UnitExpected Unit SalesTotal Materials RequiredDirect Materials Purchases

  Beginning Direct MaterialsBeginning Finished Goods UnitTotal Materials RequiredExpected Unit SalesRequired Production UnitsTotal Required UnitsDesired Ending Finished Goods UnitDirect Materials PurchasesDirect Materials Per UnitDesired Ending Direct Materials

  AddLess:    Beginning Direct MaterialsTotal Materials RequiredDesired Ending Finished Goods UnitDirect Materials Per UnitRequired Production UnitsTotal Required UnitsDesired Ending Direct MaterialsExpected Unit SalesBeginning Finished Goods UnitDirect Materials Purchases

  Desired Ending Direct MaterialsDirect Materials PurchasesExpected Unit SalesDirect Materials Per UnitBeginning Direct MaterialsBeginning Finished Goods UnitRequired Production UnitsDesired Ending Finished Goods UnitTotal Materials RequiredTotal Required Units

Prepare a direct labor budget for Lowell Company by month and for the first quarter of the year. The direct labor budget should include direct labor hours. (Round Direct labor hours per unit answers to 1 decimal place, e.g. 52.7.)

LOWELL COMPANY
Direct Labor Budget

  For the Quarter Ending March 31, 2020For the Year Ending March 31, 2020March 31, 2020

Jan

Feb

Mar

Total

  Direct Labor Cost Per HourBeginning Materials InventoryDirect Materials Per UnitTotal Materials RequiredTotal Direct Labor CostCost Per PoundDirect Materials PurchasesTotal Cost of Direct Materials PurchasesTotal Required Direct Labor HoursDirect Labor Time (Hours) Per UnitDesired Ending InventoryTotal Pounds Required for ProductionUnits to be Produced

  Total Required Direct Labor HoursTotal Pounds Required for ProductionDirect Labor Cost Per HourDesired Ending InventoryTotal Cost of Direct Materials PurchasesTotal Direct Labor CostTotal Materials RequiredDirect Materials Per UnitDirect Materials PurchasesUnits to be ProducedCost Per PoundBeginning Materials InventoryDirect Labor Time (Hours) Per Unit

  Direct Materials PurchasesUnits to be ProducedDirect Labor Cost Per HourDirect Labor Time (Hours) Per UnitDirect Materials Per UnitDesired Ending InventoryTotal Cost of Direct Materials PurchasesTotal Required Direct Labor HoursTotal Pounds Required for ProductionBeginning Materials InventoryCost Per PoundTotal Materials RequiredTotal Direct Labor Cost

  Total Materials RequiredCost Per PoundUnits to be ProducedDesired Ending InventoryTotal Pounds Required for ProductionTotal Required Direct Labor HoursBeginning Materials InventoryTotal Cost of Direct Materials PurchasesDirect Materials PurchasesTotal Direct Labor CostDirect Materials Per UnitDirect Labor Cost Per HourDirect Labor Time (Hours) Per Unit

$

$

$

  Desired Ending InventoryTotal Materials RequiredTotal Cost of Direct Materials PurchasesDirect Labor Cost Per HourCost Per PoundDirect Materials Per UnitTotal Direct Labor CostDirect Labor Time (Hours) Per UnitTotal Required Direct Labor HoursDirect Materials PurchasesBeginning Materials InventoryUnits to be ProducedTotal Pounds Required for Production

$

$

$

$

Homework Answers

Answer #1

Answer:a)-

Lowell Company
Production Budget
Particulars January Febuary March Total
Budgeted Unit sales 11000 11600 8900 31500
ADD:- Closing stock
100 % following month unit sales+70% of second following month's sales (11600*100%)+(8900*70%)=17830 (8900*100%)+(8500*70%)=14850 (8500*100%)+(8400*70%)=14380 47060
Less: Opening stock 19120 17830 14850 51800
Required production in units 9710 8620 8430 26760

b)-

Lowell Company
Direct Labor Budget
Particulars January Febuary March Total
Budgeted Production units (a) 9710 8620 8430 26760
Direct labor hours per unit (b) 2.2 2.2 1.7
Total direct labor hours (c=a*b) 21362 18964 14331 54657
Wage per direct labor hour (d) $8 $8 $8
Total direct labor in $ (e=c*d) 170896 151712 114648 437256
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Lowell Company makes and sells artistic frames for pictures. The controller is responsible for preparing the...
Lowell Company makes and sells artistic frames for pictures. The controller is responsible for preparing the master budget and has accumulated the following information for 2020. January February March April May Estimated unit sales 10,000 11,000 8,000 8,000 8,000 Sales price per unit $50.00 $47.00 $47.00 $47.00 $47.00 Direct labor hours per unit 2.0 2.0 1.5 1.5 1.5 Wage per direct labor hour $7 $7 $7 $8 $8 Lowell has a labor contract that calls for a wage increase to...
Lowell Company makes and sells artistic frames for pictures. The controller is responsible for preparing the...
Lowell Company makes and sells artistic frames for pictures. The controller is responsible for preparing the master budget and has accumulated the following information for 2017. January February March April May Estimated unit sales 10,400 11,000 8,700 8,000 8,500 Sales price per unit $50.90 $48.10 $48.10 $48.10 $48.10 Direct labor hours per unit 2.2 2.2 1.6 1.6 1.6 Wage per direct labor hour $8.00 $8.00 $8.00 $9.00 $9.00 Lowell has a labor contract that calls for a wage increase to...
Lowell Company makes and sells artistic frames for pictures. The controller is responsible for preparing the...
Lowell Company makes and sells artistic frames for pictures. The controller is responsible for preparing the master budget and has accumulated the following information for 2020. January February March April May Estimated unit sales 10,700 11,300 8,600 8,200 8,200 Sales price per unit $50.30 $48.10 $48.10 $48.10 $48.10 Direct labor hours per unit 2.4 2.4 1.5 1.5 1.5 Wage per direct labor hour $8 $8 $8 $9 $9 Lowell has a labor contract that calls for a wage increase to...
uqua Company’s sales budget projects unit sales of part 198Z of 10,700 units in January, 12,400...
uqua Company’s sales budget projects unit sales of part 198Z of 10,700 units in January, 12,400 units in February, and 13,500 units in March. Each unit of part 198Z requires 2 pounds of materials, which cost $5 per pound. Fuqua Company desires its ending raw materials inventory to equal 40% of the next month’s production requirements, and its ending finished goods inventory to equal 20% of the next month’s expected unit sales. These goals were met at December 31, 2016....
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data...
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 5,000; second quarter 6,900; third quarter 7,300. Ending raw materials inventory: 40% of the next quarter’s production requirements. Ending finished goods inventory: 25% of the next quarter’s expected sales units. Third-quarter production: 7,360 units. The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to...
Fuqua Company’s sales budget projects unit sales of part 198Z of 10,700 units in January, 12,200...
Fuqua Company’s sales budget projects unit sales of part 198Z of 10,700 units in January, 12,200 units in February, and 13,000 units in March. Each unit of part 198Z requires 3 pounds of materials, which cost $4 per pound. Fuqua Company desires its ending raw materials inventory to equal 40% of the next month’s production requirements, and its ending finished goods inventory to equal 20% of the next month’s expected unit sales. These goals were met at December 31, 2019....
Brief Exercise 22-04 Perine Company has 2,970 pounds of raw materials in its December 31, 2019,...
Brief Exercise 22-04 Perine Company has 2,970 pounds of raw materials in its December 31, 2019, ending inventory. Required production for January and February of 2020 are 4,500 and 5,700 units, respectively. 3 pounds of raw materials are needed for each unit, and the estimated cost per pound is $8. Management desires an ending inventory equal to 22% of next month’s materials requirements. Prepare the direct materials budget for January. PERINE COMPANY Direct Materials Budget choose the accounting period January...
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data...
On January 1, 2020, the Hardin Company budget committee has reached agreement on the following data for the 6 months ending June 30, 2020. Sales units: First quarter 5,400; second quarter 7,000; third quarter 7,600. Ending raw materials inventory: 40% of the next quarter’s production requirements. Ending finished goods inventory: 25% of the next quarter’s expected sales units. Third-quarter production: 7,840 units. The ending raw materials and finished goods inventories at December 31, 2019, follow the same percentage relationships to...
eWitt Industries has adopted the following production budget for the first 4 months of 2020. Month...
eWitt Industries has adopted the following production budget for the first 4 months of 2020. Month Units Month Units January 10,110 March 5,260 February 8,180 April 4,390 Each unit requires 5 pounds of raw materials costing $2 per pound. On December 31, 2019, the ending raw materials inventory was 10,110 pounds. Management wants to have a raw materials inventory at the end of the month equal to 20% of next month’s production requirements. Prepare a direct materials purchases budget by...
Paige Company estimates that unit sales will be 11,000 in quarter 1, 12,800 in quarter 2,...
Paige Company estimates that unit sales will be 11,000 in quarter 1, 12,800 in quarter 2, 15,000 in quarter 3, and 18,900 in quarter 4. Management desires to have an ending finished goods inventory equal to 25% of the next quarter’s expected unit sales. Prepare a production budget by quarters for the first 6 months of 2020. PAIGE COMPANY Production Budget choose the accounting period June 30, 2020For the Six Months Ending June 30, 2020For the Quarter Ending June 30,...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT