Ask Question
28 April, 11:07

Ramos Co. provides the following sales forecast and production budget for the next four months:

April May June July

Sales (units) 500 580 530 600

Budgeted production (units) 442 570 544 540

The company plans for finished goods inventory of 160 units at the end of June. In addition, each finished unit requires 5 pounds of direct materials and the company wants to end each month with direct materials inventory equal to 30% of next month's production needs. Beginning direct materials inventory for April was 720 pounds. Direct materials cost $2 per pound. Each finished unit requires 0.50 hours of direct labor at the rate of $20 per hour. The company budgets variable overhead at the rate of $24 per direct labor hour and budgets fixed overhead of $8,400 per month.

Prepare a direct materials budget for April, May, and June.

+1
Answers (1)
  1. 28 April, 13:58
    0
    Instructions are below.

    Explanation:

    Giving the following information:

    Budgeted production (units):

    April = 442

    May = 570

    June = 544

    July = 540

    The company plans for a finished goods inventory of 160 units at the end of June.

    Each finished unit requires 5 pounds of direct materials.

    The company wants to end each month with direct materials inventory equal to 30% of next month's production needs.

    Beginning direct materials inventory for April was 720 pounds.

    Direct materials cost $2 per pound.

    To calculate the direct material required for each month, we need to use the following formula:

    Direct material budget (in pounds) = production + ending inventory - beginning inventory

    Budgeted direct material in pounds and dollars:

    April:

    Direct material for production = 442*5 = 2,210 pounds

    Ending inventory = (570*5) * 0.3 = 855

    Beginning inventory = (720)

    Total pounds = 2,345

    Total cost = 2,345*2 = $4,690

    May:

    Direct material for production = 570*5 = 2,850 pounds

    Ending inventory = (544*5) * 0.3 = 816

    Beginning inventory = (855)

    Total pounds = 2,811

    Total cost = 2,811*2 = $5,622

    June:

    Direct material for production = 544*5 = 2,720 pounds

    Ending inventory = (540*5) * 0.3 = 810

    Beginning inventory = (816)

    Total pounds = 2,714

    Total cost = 2,714*2 = $5,428

    July:

    Direct material for production = 540*5 = 2,700 pounds

    Beginning inventory = (810)

    Total pounds = 1,890

    Total cost = 1,890*2 = $3,780
Know the Answer?
Not Sure About the Answer?
Find an answer to your question ✅ “Ramos Co. provides the following sales forecast and production budget for the next four months: April May June July Sales (units) 500 580 ...” in 📘 Business if you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers