2. Complete the following: Merchandise Purchases Budget Budgeted cost of goods sold Add desired ending inventory Total needs: Less beginning inventory Required purchases *$70,000.sales x 70% = $49,000. t$80,000 X 70% X 20% = $11,200. January February March Quarter $49,000* 11,200 60,200 9,800 $50,400
2. Complete the following: Merchandise Purchases Budget Budgeted cost of goods sold Add desired ending inventory Total needs: Less beginning inventory Required purchases *$70,000.sales x 70% = $49,000. t$80,000 X 70% X 20% = $11,200. January February March Quarter $49,000* 11,200 60,200 9,800 $50,400
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
100%
Please explain how to calculate “Less Beginning Inventory” for February & March.
![2. Complete the following:
Merchandise Purchases Budget
Budgeted cost of goods sold
Add desired ending inventory.
Total needs:
Less beginning inventory.
Required purchases
*$70,000.sales x 70% = $49,000.
$80,000 × 70% × 20% = $11,200.
January February March Quarter.
$49,000*
11,200t
60,200
9,800
$50,400](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F75fb4f79-5bfb-4902-85d2-e1edc76b1d17%2F1f18d771-235e-4a37-adc0-9f6a1dede3d4%2Fe7si9x_processed.jpeg&w=3840&q=75)
Transcribed Image Text:2. Complete the following:
Merchandise Purchases Budget
Budgeted cost of goods sold
Add desired ending inventory.
Total needs:
Less beginning inventory.
Required purchases
*$70,000.sales x 70% = $49,000.
$80,000 × 70% × 20% = $11,200.
January February March Quarter.
$49,000*
11,200t
60,200
9,800
$50,400
![The following data relate to the operations of Picanuy Corporation, a wholesale distributor of
consumer goods:
a.
b.
C.
d.
e.
f.
g.
h.
Current assets as of December 31:
Cash.
Accounts receivable
Inventory..
Buildings and equipment, net.
Accounts payable
Capital stock..
Retained earnings.
$6,000
$36,000
$9,800
$110,885
$32,550.
$100,000.
$30,135
The gross margin is 30% of sales. (In other words, cost of goods sold is 70% of sales.)
Actual and budgeted sales data are as follows:
December (actual).
January.
February..
March..
April
$60,000
$70,000
$80,000
$85,000
$55,000.
Sales are 40% for cash and 60% on credit. Credit sales are collected in the month following
sale. The accounts receivable at December 31 are the result of December credit sales.
Each month's ending inventory should equal 20% of the following month's budgeted cost of
goods sold.
One-quarter of a month's inventory purchases is paid for in the month of purchase; the other
three-quarters is paid for in the following month. The accounts payable at December 31 are
the result of December purchases of inventory.
Monthly expenses are as follows: commissions, $12,000; rent, $1,800; other expenses (exclud-
ing depreciation), 8% of sales. Assume that these expenses are paid monthly. Depreciation is
$2,400 for the quarter and includes depreciation on new assets acquired during the quarter.
Equipment will be acquired for cash: $3,000 in January and $8,000 in February.
Management would like to maintain a minimum cash balance of $5,000 at the end of each
month. The company has an agreement with a local bank that allows the company to borrow
in increments of $1,000 at the beginning of each month, up to a total loan balance of $50,000.
The interest rate on these loans is 1% per month, and for simplicity, we will assume that inter-
est is not compounded. The company would, as far as it is able, repay the loan plus accumu-
lated interest at the end of the quarter.
moth](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F75fb4f79-5bfb-4902-85d2-e1edc76b1d17%2F1f18d771-235e-4a37-adc0-9f6a1dede3d4%2Fatf5exg_processed.jpeg&w=3840&q=75)
Transcribed Image Text:The following data relate to the operations of Picanuy Corporation, a wholesale distributor of
consumer goods:
a.
b.
C.
d.
e.
f.
g.
h.
Current assets as of December 31:
Cash.
Accounts receivable
Inventory..
Buildings and equipment, net.
Accounts payable
Capital stock..
Retained earnings.
$6,000
$36,000
$9,800
$110,885
$32,550.
$100,000.
$30,135
The gross margin is 30% of sales. (In other words, cost of goods sold is 70% of sales.)
Actual and budgeted sales data are as follows:
December (actual).
January.
February..
March..
April
$60,000
$70,000
$80,000
$85,000
$55,000.
Sales are 40% for cash and 60% on credit. Credit sales are collected in the month following
sale. The accounts receivable at December 31 are the result of December credit sales.
Each month's ending inventory should equal 20% of the following month's budgeted cost of
goods sold.
One-quarter of a month's inventory purchases is paid for in the month of purchase; the other
three-quarters is paid for in the following month. The accounts payable at December 31 are
the result of December purchases of inventory.
Monthly expenses are as follows: commissions, $12,000; rent, $1,800; other expenses (exclud-
ing depreciation), 8% of sales. Assume that these expenses are paid monthly. Depreciation is
$2,400 for the quarter and includes depreciation on new assets acquired during the quarter.
Equipment will be acquired for cash: $3,000 in January and $8,000 in February.
Management would like to maintain a minimum cash balance of $5,000 at the end of each
month. The company has an agreement with a local bank that allows the company to borrow
in increments of $1,000 at the beginning of each month, up to a total loan balance of $50,000.
The interest rate on these loans is 1% per month, and for simplicity, we will assume that inter-
est is not compounded. The company would, as far as it is able, repay the loan plus accumu-
lated interest at the end of the quarter.
moth
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
![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
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![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
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education