Problem 17 - Accounting

Question

The controller of Swiss Ceramics Inc. wishes to prepare a cost of goods sold budget for June. The controller assembled the following information for constructing the cost of goods sold budget: \begin{tabular}{lrrrr} Direct materials: & Enamel & Paint & Porcelain & Total \\ \hline Total direct materials purchases budgeted for June & \(\$ 33,840\) & \(\$ 5,340\) & \(\$ 118,980\) & \(\$ 158,160\) \\ Estimated inventory, June 1, 2010 & 1,150 & 2,800 & 4,330 & 8,280 \\ Desired inventory, June 30, 2010 & 2,400 & 2,050 & 6,000 & 10,450 \end{tabular} Use the preceding information to prepare a cost of goods sold budget for June 2010 .

Step-by-Step Solution

Answer

The cost of goods sold budget should account for material usage based on opening/closing inventory, material purchases, plus simulated other costs.

Step 1: Calculate the Cost of Direct Materials Used

First, calculate the cost of direct materials that will actually be used in production. Start by finding out how much enamel, paint, and porcelain needs to be available for production in June by adding the desired June 30 inventory to the cost of materials used in production. Then, subtract the June 1 inventory from this total to find the cost of direct materials required for production. For Enamel:\[\text{Enamel Required} = 2,400 + (\text{Material used during June}) - 1,150\]Since we are only given the purchase amount, assume purchases cover usage and calculate as follows:\[\text{Enamel Usage} = (33,840 - 2,400*\text{Rate}) + (1,150*\text{Rate})\] We must consistently resolve calculations correct further steps.

Step 2: Determine Total Direct Materials Cost

Calculate the total amount of each material that was used by subtracting the beginning inventory from the sum of purchases and the end inventory. This will give the actual consumption value.Total Direct Materials Used for Enamel, Paint, and Porcelain:\[\text{Total Direct Materials} = \begin{bmatrix} \text{Enamel} & 33,840 \ \text{Paint} & 5,340 \ \text{Porcelain} & 118,980 \ \text{Total} & 158,160 \ \end{bmatrix}\] (Assumed as total usage based on estimated turnover calculation).

Step 3: Add Direct Labor and Manufacturing Overhead

Next, we will assume the direct labor and manufacturing overhead costs in order to complete the cost of goods sold calculation, as these need a pre-defined value that we currently don't have. For a more precise budget, these figures are necessary.Assumed variable manufacturing costs provide approximate hint:\[\text{Direct Labor and Manufacturing Overhead} = \text{(estimated amount)}\] to include in calculations.

Step 4: Compile the Cost of Goods Sold Budget

Compile the total cost of goods sold by summing the costs of direct materials used, direct labor, and manufacturing overhead costs. Then adjust for opening and closing stock. Since the direct labor and other overheads aren't given, we must assume or simulate expected turnover based on past revenue patterns or other data.This results in the total cost:\[\text{Total Cost of Goods Sold in June} = \text{Sum (Including Standard assumptions for labor & overhead)}\]

Key Concepts

Direct Materials Calculation

When preparing a cost of goods sold budget, one of the first steps is to calculate the direct materials required. This involves understanding how much material needs to be used in production and ensuring there's enough in inventory to meet production needs.
Begin by determining the total amount of direct materials required for production. This is done by adding the desired ending inventory to the amount slated for production use.

• For example, suppose you need 2,400 units of enamel as ending inventory and begin with 1,150 units. You can calculate the materials required by considering the purchases needed to meet the ending inventory.
• Subsequently, subtract the starting inventory from the total to find the purchase amount necessary. This ensures that you meet both production and inventory requirements without excess waste.

It's essential to have accurate records and manage the material flow efficiently to protect resources and control costs.

Direct Labor Costs

Direct labor costs are another crucial element in the cost of goods sold. These are the wages incurred for employees directly involved in the production process. Making accurate predictions regarding labor expenses helps in budgeting effectively. To calculate labor costs, first identify the number of hours needed for production. This involves assessing past production levels and adjusting for any expected increases or decreases in output.

• Determine the total labor hours by multiplying the number of units planned for production by the average time needed to produce one unit.
• Next, multiply the labor hours by the hourly wage rate to find the total direct labor cost.

By having an accurate labor cost estimation, businesses can optimize staffing and avoid unexpected expenses. Incorporating labor scheduling to cover peak production times and minimize overtime is key in controlling costs.

Manufacturing Overhead

In budgeting for manufacturing overhead, we consider all the indirect costs involved in production. These can include utilities, rent, and costs related to operating machinery. Understanding overhead costs is important because they impact the final cost of goods sold. To allocate overhead efficiently, break down these costs into fixed and variable types. Fixed costs remain consistent regardless of production levels, such as rent or salaries of permanent staff.

• Variable costs, however, may change with production volume, such as supplies or energy usage. Estimating these can be done by examining historical data and adjusting for seasonal or expected changes.
• The final step involves allocating these overhead costs to each unit of product, thus ensuring they are included in the cost calculations.

With accurate overhead estimates, businesses can ensure profitability despite variations in production.

Inventory Management

Effective inventory management is critical for a successful cost of goods sold budget. This process involves overseeing the flow of goods from purchase to the final sale, ensuring that inventory levels meet production without overstocking. To maintain optimal inventory levels, one must accurately predict future requirements and manage purchases accordingly. This can be achieved by understanding historical usage patterns and expected production schedules.

• Employ techniques like Economic Order Quantity (EOQ) and Just-In-Time (JIT) to minimize inventory costs while meeting production needs. EOQ determines the ideal order quantity that minimizes total cost, combining order and holding costs.
• JIT, on the other hand, reduces waste by receiving goods only as they are needed in the production process.

By applying these strategies, businesses can maintain smooth production processes, reduce carrying costs, and limit the risk of obsolescence.