Question:

Neptune Transport Company makes per carriers, the Cat-allac. It is made of plastic with metal doors. Information for the product for the month of October is given in the following tables:

Input Prices

Direct Materials

Plastic $4.5 per pound

Metal $ 3 per pound

Direct Manufacturing Labor $11 per direct manufacturing labor hours Manufacturing Overhead Rate $20.5 per direct manufacturing labor hours

Input Quantities per unit of output

Cal-allac

Direct Materials

Plastic 5 Pounds

Metal 1 Pounds

Direct Manufacturing Labor 3 Hours

Inventory Information, direct materials

Plastic Metal

Beginning inventory 200 Pounds 75 Pounds

Target ending inventory 280 Pounds 80 pounds

Cost of beginning inventory $940 $240

Production & Inventory Information, finished goods

Cal-allac

Units of finished goods to be produced 520

Units of finished goods to be sold 500

Target ending inventory in units 50

Beginning inventory in units 30

Beginning inventory in dollars $3,150

Other Information:

Current Assets $160,000

Long-Term Assets 340,000

Budgeted operating income 10,000

Markup Percentage on Full Cost 11.63%

Instructions:

Prepare for the month of October.

1. Revenues budget

2. Production budget in units

3. Direct material usage budget and direct material purchases budget

4. Direct manufacturing labor cost budget

5. Manufacturing overhead cost budgets for each of the three activities

6. Budgeted unit cost of ending finished goods inventory and ending inventories

budget

7. Cost of goods sold budget

8. Nonmanufacturing costs budget

9. Budgeted income statement (ignore income taxes)

10. Determine budgeted unit cost of ending finished goods inventory. (3)

11. Calculate Neptunes rate of return on investment. Compute the selling price for Cal-allac if Neptune charge 60% mark-up on its unit product cost. (1+2)

12. Assume that apart from direct materials, direct labor and 50% of itsMOH cost, other variable costs that Neptune incur per unit is $ 31.25. Calculate Neptunes mark-up percentage on variable cost per unit (3).

13. What questions might the CEO ask the management team when reviewing the budget? Should the CEO set stretch targets? Explain briefly.

14.. How does preparing the budget help the management team better manage the company?