Question

In: Accounting

The Mullins Company finished their sales projections for the coming year. The company produces one product....

The Mullins Company finished their sales projections for the coming year. The company produces one product. Part of next year's sales projections are as follows.

Projected Sales in Units

July 150,000
August 170,000
September 164,000
October 180,000
November 205,000

The budget committee has also completed the following information on inventories.

Raw Materials

Ending Balance, June, 25,000 lbs

Desired ending levels (monthly 5% of next month's production needs)

Work-In-Progress

None

Finished Goods Inventory

Ending Balance, June, 14,000 units

Desired ending levels: 15% of next month's sales

The Engineering Department has developed the following standards upon which the production budgets will be developed.

Item Standard
Material usage 4 pounds per unit
Material price per pound $1.80 per pound
Labor usage 0.4 hours per unit
Labor rate $35 per hour
Machine hours 3 machine hours per unit

The Mullins Company uses a modified allocation method for allocating overhead costs. The rates that will be used in the coming year are as follows.

Overhead Item Allocation Rate
Utilities $0.60 per machine hour
Inspection $11 per unit produced
Factory supplies $3 per unit produced
Depreciation $40,000 per month
Supervision $15,000 per month

Prepare the following production budgets for July, August, and September for the Mullins Company.

  1. Production Budget
  2. Materials Purchases Budget
  3. Direct Labor Budget
  4. Overhead Budget
  5. Manufactured Budget (for the quarter, quarter totals only)

Solutions

Expert Solution


Related Solutions

Lee Enterprises and Jackson Distributors are considering a merger. Projections for the coming year for the...
Lee Enterprises and Jackson Distributors are considering a merger. Projections for the coming year for the companies operating independently are as follows: Lee Enterprises: EBIT = $200,000 Change in Working Capital = $20,000 Capital Spending = $30,000 Depreciation Expense = $20,000 Jackson Distributors: EBIT = $450,000 Change in Working Capital = $45,000 Capital Spending = $75,000 Depreciation Expense = $50,000 Before the merger, the firms have the same cost of capital of 14% and the same expected perpetual growth rate...
This Company produces a single product. Sales for the current year are 25,000 units. Relevant data:...
This Company produces a single product. Sales for the current year are 25,000 units. Relevant data: Selling price/unit 130 Variable cost/unit 80 Fixed costs 1,300,000 a) What is their net income for the current year? b) Compute their breakeven point in sales units. c) Marketing Director believes that unit sales would increase by 20% if the price were cut by 10%. Should they take this action? Explain. d) Production Manager is considering outsourcing the production of some parts. This would...
Rojin Company prepared the following budget information for the coming year: Product A Product B Product...
Rojin Company prepared the following budget information for the coming year: Product A Product B Product C Total   Sales $300,000 $200,000$ 100,000 $600,000   Variable expenses 75,000 90,000 57,000 222,000   Contribution margin $225,000 $110,000 $43,000 $378,000   Fixed expense   200,000 Operating income $178,000 The budget assumes the sale of 20,000 units of A, 100,000 units of B, and 80,000 units of C. When answering the following ensure you round to the nearest dollar - do not enter any pennies or decimals.: What...
ABC Company limited produces coat racks. The projected sales for the first quarter of the coming...
ABC Company limited produces coat racks. The projected sales for the first quarter of the coming year and the beginning and ending inventory data are as follows: Sales 100,000 units Unit price SAR 15 Beginning inventory 8,000 units Targeted ending inventory 12,000 units The coat racks are molded and then painted. Each rack requires four pounds of metal, which cost SAR 2.50 per pound. The beginning inventory of materials is 4,000 pounds. ABC Company Limited wants to have 6,000 pounds...
Eastern Chemical Company produces three products. The operating results of the current year are: Product Sales...
Eastern Chemical Company produces three products. The operating results of the current year are: Product Sales Quantity Target Price Actual Price Difference A 1,900.00 $ 302.00 $ 303.00 $ 1.00 B 9,500.00 314.60 272.60 (42.00 ) C 950.00 219.50 327.00 $ 107.50 The firm sets the target price of each product at 150% of the product’s total manufacturing cost. It appears that the firm was able to sell Product C at a much higher price than the target price of...
Eastern Chemical Company produces three products. The operating results of the current year are: Product Sales...
Eastern Chemical Company produces three products. The operating results of the current year are: Product Sales Quantity Target Price Actual Price Difference A 1,550.00 $ 295.00 $ 296.00 $ 1.00 B 7,750.00 307.60 265.60 (42.00 ) C 775.00 212.50 320.00 $ 107.50 The firm sets the target price of each product at 150% of the product’s total manufacturing cost. It appears that the firm was able to sell Product C at a much higher price than the target price of...
Wallaby Company produces a single product. Sales for the current year are 25,000 units. Relevant data:...
Wallaby Company produces a single product. Sales for the current year are 25,000 units. Relevant data: Selling price/unit 130 Variable cost/unit 80 Fixed costs 1,300,000 a) What is Wallaby's net income for the current year? b) Compute Wallaby's breakeven point in sales units. c) Marketing Director believes that unit sales would increase by 20% if the price were cut by 10%. Should Wallaby take this action? Explain. d) Production Manager is considering outsourcing the production of some parts. This would...
The sales budget for your company in the coming year is based on a quarterly growth...
The sales budget for your company in the coming year is based on a quarterly growth rate of 10 percent with the first-quarter sales projection at $225.9 million. In addition to this basic trend, the seasonal adjustments for the four quarters are 0, −$16.9, −$8.9, and $21.9 million, respectively. Generally, 50 percent of the sales can be collected within the quarter and 45 percent in the following quarter; the rest of the sales are bad debt. The bad debts are...
The EG Company produces and sells one product. The following data refer to the year just...
The EG Company produces and sells one product. The following data refer to the year just completed:   Beginning inventory 0   Units produced 34,100   Units sold 28,100   Sales price per unit $ 452   Selling and administrative expenses:   Variable per unit $ 23   Fixed (total) $ 393,400   Manufacturing costs:   Direct materials cost per unit $ 208   Direct labor cost per unit $ 58   Variable manufacturing overhead cost per unit $ 38   Fixed manufacturing overhead $ 716,100 Assume that direct labor is a...
The EG Company produces and sells one product. The following data refer to the year just...
The EG Company produces and sells one product. The following data refer to the year just completed:   Beginning inventory 0   Units produced 28,600   Units sold 27,300   Sales price per unit $ 495   Selling and administrative expenses:   Variable per unit $ 23   Fixed (total) $ 382,200   Manufacturing costs:   Direct materials cost per unit $ 279   Direct labor cost per unit $ 52   Variable manufacturing overhead cost per unit $ 36   Fixed manufacturing overhead $ 629,200 Assume that direct labor is a...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT