1. Sales budget Create a sales budget for the 1st quarter that shows expected sales revenue for January, February, and March and total sales revenue for the quarter. Sales in units are expected to be: 9,000 November: March: December: 9,500 11,500 13,500 January: February: 11,000 April: 9,800 May: 12,500 Selling price/unit is expected to be $21/unit. 2. Cash collections budget Cash sales are generally 10% and credit sales are generally 90%. Credit sales are typically collected: 20% in the month of sale, 60% in the following month after the month of sale, 15% 2 months after the month of sale and 5% are never collected. What is the cash collections budget for January, February, and March and for the quarter? 3. Production budget The company plans to have ending inventory each month of 12% of the following month's expected sales. What is the production budget for January, February, and March and for the 1st quarter? 4. DM budget 4.5 pounds of DM is needed per unit at a cost of $3 per pound. Ending inventory of DM should be 18% of next month's production needs. What is the total cost of DM for January, February, and March and for the 1st quarter?

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
Question

Questions 3 and 4 only 

Format all numbers as accounting with the last line of each budget including dollar signs where applicable. Do not
round given numbers but round all answers to the nearest dollar (no decimals). Make the quarterly total for each
budget bold and a larger font. Use at least one color. Add grid lines. Put budgets on one tab in the order below with
the months and quarterly totals lined up.
1. Sales budget
Create a sales budget for the 1st quarter that shows expected sales revenue for
January, February, and March and total sales revenue for the quarter. Sales in units are expected to be:
November:
9,000
March:
December: 9,500
11,500
13,500
January:
February:
11,000
April:
9,800
May:
12,500
Selling price/unit is expected to be $21/unit.
2. Cash collections budget Cash sales are generally 10% and credit sales are generally 90%. Credit sales
are typically collected: 20% in the month of sale, 60% in the following month after the month of sale, 15% 2
months after the month of sale and 5% are never collected. What is the cash collections budget for January,
February, and March and for the quarter?
3. Production budget
The company plans to have ending inventory each month of 12% of the
following month's expected sales. What is the production budget for January, February, and March and for
the 1st quarter?
4. DM budget
4.5 pounds of DM is needed per unit at a cost of $3 per pound. Ending
inventory of DM should be 18% of next month's production needs. What is the total cost of DM for January,
February, and March and for the 1st quarter?
Transcribed Image Text:Format all numbers as accounting with the last line of each budget including dollar signs where applicable. Do not round given numbers but round all answers to the nearest dollar (no decimals). Make the quarterly total for each budget bold and a larger font. Use at least one color. Add grid lines. Put budgets on one tab in the order below with the months and quarterly totals lined up. 1. Sales budget Create a sales budget for the 1st quarter that shows expected sales revenue for January, February, and March and total sales revenue for the quarter. Sales in units are expected to be: November: 9,000 March: December: 9,500 11,500 13,500 January: February: 11,000 April: 9,800 May: 12,500 Selling price/unit is expected to be $21/unit. 2. Cash collections budget Cash sales are generally 10% and credit sales are generally 90%. Credit sales are typically collected: 20% in the month of sale, 60% in the following month after the month of sale, 15% 2 months after the month of sale and 5% are never collected. What is the cash collections budget for January, February, and March and for the quarter? 3. Production budget The company plans to have ending inventory each month of 12% of the following month's expected sales. What is the production budget for January, February, and March and for the 1st quarter? 4. DM budget 4.5 pounds of DM is needed per unit at a cost of $3 per pound. Ending inventory of DM should be 18% of next month's production needs. What is the total cost of DM for January, February, and March and for the 1st quarter?
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Knowledge Booster
Budgeting
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
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