Explore BrainMass

Explore BrainMass

    Strongbad Boxing Inc. Budgeting

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

    Strongbad Boxing Inc. has the following unit sales of boxing gloves for the year 2002: 1st quarter 50,000, 2nd quarter 45,000, 3rd quarter 60,000, and 4th quarter 40,000. The selling price per unit (a pair) is $50. Credit sales are 30% of total sales.

    Desired ending inventory is 20% of next quarters expected sales. The fourth quarters ending inventory is 7000 units. Beginning inventory for the first quarter is 8000 units.

    Direct materials per unit are 3 square feet. Desired ending inventory for direct materials is 30% of the amount needed for production in the next quarter. The fourth quarters ending inventory is 30,000 square feet. Beginning inventory for the first quarter is 28,000 square feet. The cost per square foot is $3.00.

    Direct labor per unit is 5 hours. Direct labor cost per hour is $4.00.

    Please prepare the following budgets from the information above:
    Sales Budget
    Production Budget
    Direct Materials Budget
    Direct Labor Budget

    © BrainMass Inc. brainmass.com June 4, 2020, 2:04 am ad1c9bdddf

    Solution Summary

    Your tutorial lays out the process in excel (attached) and is now a template you can use for all similar problems. Click in cells to see computations.