Question

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.

Prepare a production budget for January and February 2017.

FUQUA COMPANY
Production Budget

                                                                      For the Quarter Ending February 28, 2017For the Month Ending January 31, 2017For the Two Months Ending February 28, 2017

January

February

                                                                      Total Cost of Direct Materials PurchasesTotal Materials RequiredBeginning Finished Goods InventoryDirect Materials PurchasesDesired Pounds in Ending Materials InventoryUnits To Be ProducedBeginning Direct MaterialsTotal Required UnitsRequired Production UnitsCost Per PoundDesired Ending Finished Goods InventoryDirect Material Pounds Per UnitTotal Pounds Needed for ProductionExpected Unit Sales

                                                                      AddLess:                                                                       Desired Ending Finished Goods InventoryTotal Pounds Needed for ProductionCost Per PoundTotal Materials RequiredBeginning Direct MaterialsDesired Pounds in Ending Materials InventoryExpected Unit SalesDirect Materials PurchasesTotal Cost of Direct Materials PurchasesRequired Production UnitsTotal Required UnitsBeginning Finished Goods InventoryDirect Material Pounds Per UnitUnits To Be Produced

                                                                      Beginning Direct MaterialsDirect Material Pounds Per UnitTotal Required UnitsBeginning Finished Goods InventoryDirect Materials PurchasesTotal Pounds Needed for ProductionRequired Production UnitsTotal Cost of Direct Materials PurchasesDesired Ending Finished Goods InventoryDesired Pounds in Ending Materials InventoryUnits To Be ProducedExpected Unit SalesCost Per PoundTotal Materials Required

                                                                      AddLess:                                                                       Total Required UnitsTotal Materials RequiredTotal Pounds Needed for ProductionDirect Material Pounds Per UnitBeginning Finished Goods InventoryBeginning Direct MaterialsUnits To Be ProducedExpected Unit SalesDesired Pounds in Ending Materials InventoryRequired Production UnitsTotal Cost of Direct Materials PurchasesCost Per PoundDirect Materials PurchasesDesired Ending Finished Goods Inventory

                                                                      Direct Materials PurchasesTotal Cost of Direct Materials PurchasesTotal Pounds Needed for ProductionTotal Required UnitsDirect Material Pounds Per UnitDesired Ending Finished Goods InventoryDesired Pounds in Ending Materials InventoryCost Per PoundBeginning Finished Goods InventoryUnits To Be ProducedExpected Unit SalesTotal Materials RequiredRequired Production UnitsBeginning Direct Materials

eTextbook and Media

  

  

Prepare a direct materials budget for January 2017.

FUQUA COMPANY
Direct Materials Budget

                                                                      For the Month Ending January 31, 2017For the Two Months Ending February 28, 2017For the Quarter Ending February 28, 2017

January

                                                                      Total Pounds Needed for ProductionTotal Materials RequiredRequired Production UnitsDesired Ending Finished Goods InventoryDirect Material Pounds Per UnitBeginning Finished Goods InventoryBeginning Direct MaterialsCost Per PoundTotal Cost of Direct Materials PurchasesTotal Required UnitsDirect Materials PurchasesDesired Pounds in Ending Materials InventoryExpected Unit SalesUnits To Be Produced

                                                                      Total Materials RequiredTotal Pounds Needed for ProductionCost Per PoundDirect Material Pounds Per UnitTotal Required UnitsBeginning Finished Goods InventoryExpected Unit SalesDesired Ending Finished Goods InventoryUnits To Be ProducedTotal Cost of Direct Materials PurchasesRequired Production UnitsDesired Pounds in Ending Materials InventoryDirect Materials PurchasesBeginning Direct Materials

                                                                      Units To Be ProducedTotal Pounds Needed for ProductionCost Per PoundDirect Material Pounds Per UnitDirect Materials PurchasesExpected Unit SalesDesired Pounds in Ending Materials InventoryTotal Materials RequiredRequired Production UnitsTotal Cost of Direct Materials PurchasesDesired Ending Finished Goods InventoryBeginning Finished Goods InventoryBeginning Direct MaterialsTotal Required Units

                                                                      AddLess:                                                                       Total Materials RequiredDesired Ending Finished Goods InventoryTotal Required UnitsTotal Cost of Direct Materials PurchasesRequired Production UnitsExpected Unit SalesTotal Pounds Needed for ProductionUnits To Be ProducedDesired Pounds in Ending Materials InventoryBeginning Finished Goods InventoryDirect Material Pounds Per UnitCost Per PoundBeginning Direct MaterialsDirect Materials Purchases

                                                                      Cost Per PoundDirect Materials PurchasesBeginning Finished Goods InventoryDesired Ending Finished Goods InventoryDirect Material Pounds Per UnitRequired Production UnitsTotal Required UnitsExpected Unit SalesTotal Pounds Needed for ProductionUnits To Be ProducedTotal Cost of Direct Materials PurchasesBeginning Direct MaterialsTotal Materials RequiredDesired Pounds in Ending Materials Inventory

                                                                      AddLess:                                                                       Beginning Finished Goods InventoryTotal Cost of Direct Materials PurchasesUnits To Be ProducedDesired Ending Finished Goods InventoryRequired Production UnitsBeginning Direct MaterialsDirect Materials PurchasesDirect Material Pounds Per UnitTotal Required UnitsTotal Pounds Needed for ProductionTotal Materials RequiredExpected Unit SalesCost Per PoundDesired Pounds in Ending Materials Inventory

                                                                      Desired Pounds in Ending Materials InventoryBeginning Direct MaterialsTotal Pounds Needed for ProductionTotal Materials RequiredBeginning Finished Goods InventoryExpected Unit SalesUnits To Be ProducedCost Per PoundRequired Production UnitsDirect Materials PurchasesTotal Cost of Direct Materials PurchasesDesired Ending Finished Goods InventoryDirect Material Pounds Per UnitTotal Required Units

                                                                      Total Required UnitsTotal Pounds Needed for ProductionTotal Cost of Direct Materials PurchasesTotal Materials RequiredDesired Ending Finished Goods InventoryRequired Production UnitsBeginning Finished Goods InventoryUnits To Be ProducedDirect Materials PurchasesExpected Unit SalesBeginning Direct MaterialsDesired Pounds in Ending Materials InventoryDirect Material Pounds Per UnitCost Per Pound

$

                                                                      Required Production UnitsTotal Required UnitsDesired Ending Finished Goods InventoryDesired Pounds in Ending Materials InventoryBeginning Finished Goods InventoryTotal Materials RequiredTotal Cost of Direct Materials PurchasesDirect Material Pounds Per UnitBeginning Direct MaterialsUnits To Be ProducedCost Per PoundTotal Pounds Needed for ProductionDirect Materials PurchasesExpected Unit Sales

$

Homework Answers

Answer #1

Answer is given below

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
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...
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 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...
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,...
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...
Hill Industries had sales in 2019 of $6,800,000 and gross profit of $1,100,000. Management is considering...
Hill Industries had sales in 2019 of $6,800,000 and gross profit of $1,100,000. Management is considering two alternative budget plans to increase its gross profit in 2020. Plan A would increase the selling price per unit from $8.00 to $8.40. Sales volume would decrease by 10% from its 2019 level. Plan B would decrease the selling price per unit by $0.50. The marketing department expects that the sales volume would increase by 100,000 units. At the end of 2019, Hill...
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...
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...
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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT