Income Statement                                        October            November        December          January   Sales                               300,000             450,000           250,000             200,000 Cost of Good Sold          210,000               315,000         175,000            140,000 Gross Margin                90,000                   135,000         75,000              60,000 Operating expense Marketing expense       39,500             60,000               31,000                25,500 Admin expense             22,500              26,000              20,500                 19,000 Total Operating Exp      62,000               86,000            51,500                 44,500 Net Operating Income   28,000              49,000            23,500                 15,500 Includes depreciation each month of 10,000    Other Cash, October 1                                                             26,000 Merchandise inventory, October 1                                 42,000 Accounts payable, September 30                                   63,000 August sales ($)                                                           100,000 September sales ($)                                                      150,000 Percentage of total sales in cash                                       0.2 Percentage of total sales on credit                                      0.8 Inventory purchases paid in the month of purchase           0.5 Inventory purchases paid in the month following the month of purchase    0.5           Dividends                                                                                                 24,500 Land purchase                                                                                             8,000 Monthly  interest rate and minimum ending cash balance         .01 of 20,000      Credit sales collected in the month of sale                                                 0.3      Credit sales collected in the first month following the month of sale          0.6      Credit sales collected in the second month following the month of sale      0.1      Desired ending inventory (percentage of cost of merchandise to be sold next month)             0.12      Dividends increase                                                                                                                    0.5      Monthly  interest rate and minimum ending cash balance increase                              0.015 of 25,000   Required: complete merchandise purchase budget                                                                                October             November          December            Quarter Budgeted cost of goods sold                           Add desired ending      merchandise inventory Total needs Less beginning merchandise      inventory Required inventory purchases

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question
Income Statement

                                       October            November        December          January  

Sales                               300,000             450,000           250,000             200,000

Cost of Good Sold          210,000               315,000         175,000            140,000

Gross Margin                90,000                   135,000         75,000              60,000

Operating expense

Marketing expense       39,500             60,000               31,000                25,500

Admin expense             22,500              26,000              20,500                 19,000

Total Operating Exp      62,000               86,000            51,500                 44,500

Net Operating Income   28,000              49,000            23,500                 15,500

Includes depreciation each month of 10,000   

Other
Cash, October 1                                                             26,000
Merchandise inventory, October 1                                 42,000
Accounts payable, September 30                                   63,000
August sales ($)                                                           100,000
September sales ($)                                                      150,000
Percentage of total sales in cash                                       0.2
Percentage of total sales on credit                                      0.8
Inventory purchases paid in the month of purchase           0.5
Inventory purchases paid in the month following the month of purchase    0.5          
Dividends                                                                                                 24,500
Land purchase                                                                                             8,000
Monthly  interest rate and minimum ending cash balance         .01 of 20,000
     Credit sales collected in the month of sale                                                 0.3
     Credit sales collected in the first month following the month of sale          0.6
     Credit sales collected in the second month following the month of sale      0.1
     Desired ending inventory (percentage of cost of merchandise to be sold next month)             0.12
     Dividends increase                                                                                                                    0.5
     Monthly  interest rate and minimum ending cash balance increase                              0.015 of 25,000

 

Required: complete merchandise purchase budget

                                                                               October             November          December            Quarter

Budgeted cost of goods sold                          
Add desired ending
     merchandise inventory
Total needs
Less beginning merchandise
     inventory
Required inventory purchases
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Would the quarter total for desired ending inventory be 16,800 or the total of all 3 months?

The same question for begining inventory, would it be 42,000 or 21,000?

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Financial Statements
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.
Similar questions
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education