Spencer Company sells lamps and other lighting fixtures. The purchasing department manager prepared the following inventory purchases budget. Spencer's policy is to maintain an ending inventory balance equal to 15 percent of the following month's cost of goods sold. April's budgeted cost of goods sold is $81,000. Required a. Complete the inventory purchases budget by filling in the missing amounts. Inventory Purchases Budget
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.
Jaydip
![Spencer Company sells lamps and other lighting fixtures. The purchasing department
manager prepared the following inventory purchases budget. Spencer's policy is to
maintain an ending inventory balance equal to 15 percent of the following month's cost
of goods sold. April's budgeted cost of goods sold is $81,000.
Required
a. Complete the inventory purchases budget by filling in the missing amounts.
Inventory Purchases Budget
Budgeted cost of goods sold
Plus: Desired ending inventory
Inventory needed
Less: Beginning inventory
Required purchases (on account)
Cost of goods sold
January February March
$
$
$
52,000 56,000 62,000
8,400
Ending inventory
60,400
7,800
$
b. Determine the amount of cost of goods sold the company will report on its first
quarter pro forma income statement.
52,600
c. Determine the amount of ending inventory the company will report on its pro forma
balance sheet at the end of the first quarter.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F304cab53-69d8-448e-af5d-3fde593b2018%2F9a46a0e7-36dd-43d5-aa8e-fd7971a92fe1%2Fa1b2dp_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
![Cornerstones of Cost Management (Cornerstones Ser…](https://www.bartleby.com/isbn_cover_images/9781305970663/9781305970663_smallCoverImage.gif)
![Managerial Accounting: The Cornerstone of Busines…](https://www.bartleby.com/isbn_cover_images/9781337115773/9781337115773_smallCoverImage.gif)
![Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337912020/9781337912020_smallCoverImage.jpg)
![Financial And Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781337902663/9781337902663_smallCoverImage.jpg)
![Principles of Cost Accounting](https://www.bartleby.com/isbn_cover_images/9781305087408/9781305087408_smallCoverImage.gif)