2) Lines Company is a retailer that sells a single product. The company's inventories, production, and sales in units for the next three months have been budgeted as follows: Beginning inventory Merchandise purchases Sales Ending inventory September 44,500 3,000 37,500 10,000 October 10,000 60,000 60,000 10,000 November December 10,000 10,000 70,000 35,000 70,000 40,000 10,000 5,000

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Topic Video
Question
2) Lines Company is a retailer that sells a single product. The company's inventories,
production, and sales in units for the next three months have been budgeted as follows:
Beginning inventory
Merchandise purchases
Sales
Ending inventory
September
44,500
3,000
37,500
10,000
October
10,000
60,000
60,000
10,000
November December
10,000
10,000
70,000
35,000
70,000
40,000
10,000
5,000
Units are sold for $12 each. Thirty percent of all sales are paid for in the month of sale and
the balance is paid for in the followin month.
Merchandise is purchased for $7 per unit. Forty percent of purchases are paid for in the
month of the purchase and the remainder is paid for in the month following purchase.
Marketing and administrative expenses are expected to total $140,000 each month. Forty-
five percent of these expenses will be paid in the month in which they are incurred and the
balance will be paid in the following month.
Cash at September 30 totaled $90,000. A payment of $250,000 for the purchase of
equipment is scheduled for November, and a dividend of $150,000 is to be paid in
December. Ignore depreciation for purposes of preparing the schedules.
a. Prepare a cash collections budget for October, November, and December.
b. Prepare a cash disbursements budget including merchandise purchases and marketing
and administrative expenses for October, November, and December
c.
Prepare a cash budget for October, November, and December. There is no minimum
required ending cash balance.
Transcribed Image Text:2) Lines Company is a retailer that sells a single product. The company's inventories, production, and sales in units for the next three months have been budgeted as follows: Beginning inventory Merchandise purchases Sales Ending inventory September 44,500 3,000 37,500 10,000 October 10,000 60,000 60,000 10,000 November December 10,000 10,000 70,000 35,000 70,000 40,000 10,000 5,000 Units are sold for $12 each. Thirty percent of all sales are paid for in the month of sale and the balance is paid for in the followin month. Merchandise is purchased for $7 per unit. Forty percent of purchases are paid for in the month of the purchase and the remainder is paid for in the month following purchase. Marketing and administrative expenses are expected to total $140,000 each month. Forty- five percent of these expenses will be paid in the month in which they are incurred and the balance will be paid in the following month. Cash at September 30 totaled $90,000. A payment of $250,000 for the purchase of equipment is scheduled for November, and a dividend of $150,000 is to be paid in December. Ignore depreciation for purposes of preparing the schedules. a. Prepare a cash collections budget for October, November, and December. b. Prepare a cash disbursements budget including merchandise purchases and marketing and administrative expenses for October, November, and December c. Prepare a cash budget for October, November, and December. There is no minimum required ending cash balance.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

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

can you also explain what part is a. b. and c. please

Solution
Bartleby Expert
SEE SOLUTION
Follow-up Question

for cash sales what number did you times with 30%

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Accounting for Merchandise Inventory
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