Paint LLC

Critical Thinking: Cost of Production (50 points)

Paint More LLC has organized a new division to manufacture and sell specialty paint. The division’s monthly costs are shown below:

Manufacturing costs:

Variable costs per unit:

Direct materials

$12

Variable manufacturing overhead

$1

Fixed manufacturing overhead costs (total)

$100,000

Selling and administrative costs:

Variable

7% of sales

Fixed (total)

$31,000

Because the production is highly automated, the company includes its labor costs in its fixed manufacturing overhead. The gallons of paint sell for $68 each. During September, the first month of operations, the following activity was recorded: Units produced 5,000 Units sold 4,000 Submit an Excel document which each tab labeled by item number that demonstrates the following:

1. Compute the unit product cost under:

a. Absorption costing

b. Variable costing

2. Prepare an absorption costing income statement for September

3. Prepare a contribution format income statement for September using variable costing

Provide your answers in an Excel spreadsheet, clearly organized. Check spelling and formatting for readability.