Laker Company reported the following January purchases and sales data for its only product. The Company uses a periodic inventory system. For specific identification, ending inventory consists of 232 units, where 180 are from the January 30 purchase, 5 are from the January 20 purchase, and 47 are from beginning inventory. Date Activities January 1 Beginning inventory January 10 Sales January 20 Purchase January 25 Sales January 30 Purchase Totals Units Acquired at Cost @ $ 6.00 156 units 76 units e $5.00 180 units @ $ 4.50 412 units = = $ 936 380 810 $ 2,126 Units sold at Retail 84 units @ 96 units @ 180 units $15.00 $ 15.00
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
![**Inventory Data Analysis for Educational Purposes**
**Introduction:**
Laker Company reported the following January purchases and sales data for its only product. The company uses a periodic inventory system. For specific identification, ending inventory consists of 232 units, where 180 are from the January 30 purchase, 5 are from the January 20 purchase, and 47 are from beginning inventory.
**Inventory Data Table:**
| Date | Activities | Units Acquired at Cost | Cost per Unit ($) | Total Cost ($) | Units Sold at Retail | Retail Price per Unit ($) |
|--------------|---------------------|------------------------|-------------------|----------------|----------------------|---------------------------|
| January 1 | Beginning Inventory | 156 units | $6.00 | $936 | | |
| January 10 | Sales | | | | 84 units | $15.00 |
| January 20 | Purchase | 76 units | $5.00 | $380 | | |
| January 25 | Sales | | | | 96 units | $15.00 |
| January 30 | Purchase | 180 units | $4.50 | $810 | | |
| **Totals** | | **412 units** | | **$2,126** | **180 units** | |
**Explanation of Data:**
- **Beginning Inventory (January 1):**
- Laker Company starts January with an inventory of 156 units, each costing $6.00, totaling $936.
- **Sales (January 10):**
- 84 units are sold at a retail price of $15.00 each.
- **Purchase (January 20):**
- The company purchases an additional 76 units at a cost of $5.00 each, totaling $380.
- **Sales (January 25):**
- Another 96 units are sold at a retail price of $15.00 each.
- **Purchase (January 30):**
- The company makes its final purchase of the month, acquiring 180 units at a cost of $4.50 each, totaling $810.
- **Summary Totals:**
- By the end of January, the company has acquired a total of](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F603fb863-551d-4e2c-baf1-38f56fb13d9e%2F6058a6b7-5a3a-48b5-9bda-307839ab5169%2Ffeh7wn7_processed.jpeg&w=3840&q=75)
![### Perpetual LIFO Inventory Management
This table demonstrates the perpetual inventory system using the Last-In, First-Out (LIFO) method for tracking inventory. Each date of transaction within January is considered, showing purchases, sales, and inventory balances.
#### Table Breakdown:
- **Headers:**
- Goods Purchased: # of units, Cost per unit
- Cost of Goods Sold: # of units sold, Cost per unit, Cost of Goods Sold
- Inventory Balance: # of units, Cost per unit, Inventory Balance
- **Data Entries:**
| Date | # of units | Cost per unit | # of units sold | Cost per unit | Cost of Goods Sold | # of units | Cost per unit | Inventory Balance |
|---------------|------------|---------------|-----------------|---------------|---------------------|------------|---------------|-------------------|
| January 1 | | | | | | 156 | $6.00 | $936.00 |
| January 10 | | | 84 | | | 156 | | |
| January 20 | 76 | $5.00 | | | | 120 | | |
| | | | | | | 76 | $5.00 | $380.00 |
| January 25 | | | | $5.00 | $0.00 | 120 | | |
| | | | 96 | | | 0 | | |
| January 30 | 180 | $4.50 | | | | 180 | | |
| | | | | | | 180 | $4.50 | $810.00 |
| Totals | | | | | $0.00 | | | $810.00 |
---
### Detailed Explanation of Graphs and Diagrams:
- **Goods Purchased:** This column shows the number of units purchased and their respective costs per unit. For instance, on January 20, 76 units were purchased at a cost of $5.00 per unit.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F603fb863-551d-4e2c-baf1-38f56fb13d9e%2F6058a6b7-5a3a-48b5-9bda-307839ab5169%2F4b72ep_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)