Explore BrainMass
Share

Preparing Budgets

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Safe and Bright Inc produces outside doors for installation on homes. The following information was gathered to prepare budgets for the upcoming year beginning Jan 1:
Sales force in units...........................................................................5,500 doors
Finished goods inventory Jan 1......................................................... 620 doors
Targe finished good inventory Dec 31............................................... 480 doors
Raw materials inventory-steel Jan 1.................................................. 40,000 pounds
Target inventory-steel Dec 31............................................................ 80,000 pounds
Raw material inventory-glass Jan 1.....................................................6,000 sq feet
Target inventory-glass Dec 31............................................................ 4,000 sq feet
Budgeted purchase price-steel.............................................................$4 per pound
Budgeted purchase price-glass........................................................... $2 per sq foot
The manufacture of each door requires 20 pounds of steel and 6 square feet of glass.

A-prepare the production schedule in units for Safe and Bright.
B-using the production schedule develop the direct materials purchase budgets for steel and glass.
C-why might Safe and Bright target level of steel inventory be higher than last years ending balance and its target level of glass inventory be lower than last years ending balance?

© BrainMass Inc. brainmass.com October 25, 2018, 7:46 am ad1c9bdddf
https://brainmass.com/business/business-math/preparing-budgets-514838

Solution Preview

Please see attachment.

PREPARING BUDGETS
Safe and Bright Inc. produces outside doors for installation on homes. The following information was gathered to prepare budgets for the upcoming year beginning Jan 1:
Sales force in units...........................................................................5,500 doors
Finished goods inventory Jan 1......................................................... 620 doors
Target finished good inventory Dec 31............................................... 480 doors
Raw materials ...

Solution Summary

The solution prepares budgets for the produces outside.

$2.19
See Also This Related BrainMass Solution

Nascar Company: Prepare a production budget for transmissions

Nascar Company manufactures an innovative automobile transmission for electric cars. Management predicts that ending inventory for the first quarter will be 37,500 units. The following unit sales of the transmissions are expected during the rest of the year: second quarter, 225,000 units; third quarter, 262,500 units; and fourth quarter, 237,500 units. Company policy calls for the ending inventory of a quarter to equal 20% of the next quarterâ??s budgeted sales. Prepare a production budget for both the second and third quarters that shows the number of transmissions to manufacture.

View Full Posting Details