Purchase Solution

Perpetual & Periodic Inventory System

Not what you're looking for?

Ask Custom Question

Blue Demon Company has the following inventory, purchases and sales data for the month of June 2008.

Inventory: June 1 400 units @ $4.00 $1,600
Purchases:
June 10 1,000 units @ $4.50 4,500
June 20 800 units @ $4.75 3,800
June 30 600 units @ $5.00 3,000
Sales:
June 15 1,000 units Sales Price $8 each
June 25 800 units Sales Price $8 each

The physical inventory count on June 30 shows 1,000 units on hand

Required: Show all calculations

1.Calculate the cost of goods available for sale
2.Under the periodic inventory system, determine the cost of inventory on hand at June 30 and the cost of goods sold for June under
a. first-in, first-out (FIFO) method
b. last-in, first-out (LIFO) method
c. average cost method
3.Under the perpetual inventory system, determine the cost of inventory on hand at June 30 and the cost of goods sold for June under
a. first-in, first-out (FIFO) method
b. last-in, first-out (LIFO) method
c. average cost method
4.Prepare a table showing the financial statement effects of these Inventory Costing Methods under the periodic system and the perpetual system.
a. Income Statement -
i. Sales
ii. Cost of Goods Sold
iii. Gross Margin
b. Balance Sheet
i. Merchandise Inventory

Suggested example of Table:
Income Statement: Periodic
FIFO Periodic
LIFO Periodic
Weighted Average Perpetual
FIFO Perpetual
LIFO Perpetual
Moving Average
Sales
Cost of Goods Sold
Gross Margin

Balance Sheet:
Inventory

Show your calculations. Below is a suggested format. .

Cost of Goods Available for sale:

Date # and $ Total
Inventory:
Purchases:

Total cost of goods available for sale

Periodic System

FIFO Method:

Ending Inventory in $:

Date Units Unit Cost Total Cost

Cost of Goods Sold in $:

LIFO Method:

Ending Inventory in $:

Date Units Unit Cost Total Cost

Cost of Goods Sold in $:

Average Cost Method:

Ending Inventory in $:

Cost of Goods Sold in $:

Perpetual Inventory System:

FIFO Method:

Date Purchases Sales Balance

Ending Inventory:

Cost of Goods Sold:

Perpetual Inventory System Continued

LIFO Method:

Date Purchases Sales Balance

Ending Inventory:

Cost of Goods Sold:

Average Cost Method:

Date Purchases Sales Balance

Ending Inventory:

Cost of Goods Sold:

Purchase this Solution

Solution Summary

The solution computes cost of goods sold under perpertual & periodic inventory system using FIFO, LIFO & Average Cost Method.

Purchase this Solution


Free BrainMass Quizzes
Operations Management

This quiz tests a student's knowledge about Operations Management

Managing the Older Worker

This quiz will let you know some of the basics of dealing with older workers. This is increasingly important for managers and human resource workers as many countries are facing an increase in older people in the workforce

Transformational Leadership

This quiz covers the topic of transformational leadership. Specifically, this quiz covers the theories proposed by James MacGregor Burns and Bernard Bass. Students familiar with transformational leadership should easily be able to answer the questions detailed below.

Basic Social Media Concepts

The quiz will test your knowledge on basic social media concepts.

Business Ethics Awareness Strategy

This quiz is designed to assess your current ability for determining the characteristics of ethical behavior. It is essential that leaders, managers, and employees are able to distinguish between positive and negative ethical behavior. The quicker you assess a person's ethical tendency, the awareness empowers you to develop a strategy on how to interact with them.