The company desires to have finished goods inventory on hand at the end of each month equal to 15 percent of the following month's budgeted unit sales. On September 30, 2022, there were 450 display cupboards on hand. (Note, an estimate of sales in January is required in order to complete the production budget for December). Prepare a Production budget.

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
100%

The DecorIdeas Company manufactures hand-crafted natural wood display
cupboards. Currently the company makes only one size of display cupboard, which is
60-inch height, 48-inch width, and 19-inch depth; and has 6 shelves. The final
product consists of a routed, sanded, assembled, and stained oak wood cupboard.
Direct materials include oak shelving wood and hickory plywood backing board.
Other materials, such as wood screws, sand paper, stain, wood glue, and packaging,
are treated as indirect materials. DecorIdeas is preparing budgets for the fourth
quarter ending December 31, 2022.
For each requirement below prepare budgets by month for October, November, and
December, and a total budget for the quarter. The previous year’s sales (2021/22) for
the corresponding period were:
October
November
December
January
February
2,000
2,800
4,000
4,400
3,600
display cupboards
display cupboards
display cupboards
display cupboards
display cupboards
The company expects the above volume of display cupboard sales to increase by 15%
for the period October 2022 – February 2023. The budgeted selling price for 2022 is
$785.00 per display cupboard. The company expects 5% of its sales to be cash
(COD) sales. The remaining 95% of sales will be made on credit. Prepare a Sales
Budget for DecorIdeas.
2. The company desires to have finished goods inventory on hand at the end of each
month equal to 15 percent of the following month's budgeted unit sales. On
September 30, 2022, there were 450 display cupboards on hand. (Note, an estimate of
sales in January is required in order to complete the production budget for
December). Prepare a Production budget.

**Transcription for Educational Website**

---

**Sales Budget**

This section provides an overview of the Sales Budget from October to February, including the unit sales, unit price, and sales revenue for each month and quarter.

- **Unit Sales**: 
  - October: 2,300
  - November: 3,220
  - December: 4,600
  - Quarter Total: 10,120
  - January: 5,060
  - February: 4,140

- **Unit Price**: $785 for all months listed.

- **Sales Revenue**:
  - October: $1,805,500.00
  - November: $2,527,700.00
  - December: $3,611,000.00
  - Quarter Total: $7,944,200.00
  - January: $3,972,100.00
  - February: $3,249,900.00

- **Cash Sale (5%)**:
  - October: $90,275.00
  - November: $126,385.00
  - December: $180,550.00
  - Quarter Total: $397,210.00
  - January: $198,605.00
  - February: $162,495.00

- **Credit Sale (95%)**:
  - October: $1,715,225.00
  - November: $2,401,315.00
  - December: $3,430,450.00
  - Quarter Total: $7,546,990.00
  - January: $3,773,495.00
  - February: $3,087,405.00

**Production Budget**

This section outlines the Production Budget, specifying unit sales and inventory requirements.

- **Unit Sales** are repeated as recorded in the sales budget across the months: October, November, December.

- **Desired Ending Inventory**, **Total Needed**, and **Beginning Inventory** are listed but have no numerical values provided for October, November, December, Quarter, January, and February. These fields are intended for further input and analysis of inventory planning and management processes. 

---

This detailed overview helps in understanding and planning financial and operational strategies within a business's budgeting process.
Transcribed Image Text:**Transcription for Educational Website** --- **Sales Budget** This section provides an overview of the Sales Budget from October to February, including the unit sales, unit price, and sales revenue for each month and quarter. - **Unit Sales**: - October: 2,300 - November: 3,220 - December: 4,600 - Quarter Total: 10,120 - January: 5,060 - February: 4,140 - **Unit Price**: $785 for all months listed. - **Sales Revenue**: - October: $1,805,500.00 - November: $2,527,700.00 - December: $3,611,000.00 - Quarter Total: $7,944,200.00 - January: $3,972,100.00 - February: $3,249,900.00 - **Cash Sale (5%)**: - October: $90,275.00 - November: $126,385.00 - December: $180,550.00 - Quarter Total: $397,210.00 - January: $198,605.00 - February: $162,495.00 - **Credit Sale (95%)**: - October: $1,715,225.00 - November: $2,401,315.00 - December: $3,430,450.00 - Quarter Total: $7,546,990.00 - January: $3,773,495.00 - February: $3,087,405.00 **Production Budget** This section outlines the Production Budget, specifying unit sales and inventory requirements. - **Unit Sales** are repeated as recorded in the sales budget across the months: October, November, December. - **Desired Ending Inventory**, **Total Needed**, and **Beginning Inventory** are listed but have no numerical values provided for October, November, December, Quarter, January, and February. These fields are intended for further input and analysis of inventory planning and management processes. --- This detailed overview helps in understanding and planning financial and operational strategies within a business's budgeting process.
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

How is the desired closing inventory calculated?

Solution
Bartleby Expert
SEE SOLUTION
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.
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