HOW WAS THE ADD: CLSOING STOCK CALCULATED?

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%

The display cupboards require two direct materials: oak shelving wood and hickory
plywood backing board.
Oak shelving wood:
Thirty (30) feet of 12x1 oak shelving wood are required for each cupboard produced.
Management desires to have materials on hand at the end of each month equal to 10
percent of the following month's cupboard production needs. The beginning
inventory of oak wood, October 2022, was 10,150 feet of wood. Oak wood is
expected to cost $5.00 per foot.
Hickory plywood backing board:
Hickory plywood backing board is purchased by the sheet and 2 backing boards can
be cut from each sheet. Management desires to have plywood on hand at the end of
each month equal to 15 percent of the following month's production needs. The
beginning inventory of plywood, October 2022, was 100 sheets. Hickory plywood is
expected to cost $45 per sheet. (Note, budgeted production in January is required in
order to complete the direct materials budget for December. Also, use the @ROUND
function to round up to the nearest whole number the number of sheets of plywood
to purchase – “DM quantities to purchase”).

QUESTION: HOW WAS THE ADD: CLSOING STOCK CALCULATED?

**Direct Materials Budget for Oak Shelving Wood**

**Particulars:**

| **Details**                            | **Oct 22** | **Nov 22** | **Dec 22** | **Jan 23** |
|----------------------------------------|------------|------------|------------|------------|
| **No. of Display Cupboards**           | 2,333      | 3,427      | 4,669      | 4,922      |
| **Oak Shelving Wood Required Per Unit (feet)** | 30         | 30         | 30         | 30         |
| **Total Oak Shelving Wood Required (feet)**    | 69,990     | 102,810    | 140,070    | 147,660    |
| **Add: Closing Stock**                 | 10,281     | 14,007     | 14,766     | -          |
| **Less: Opening Stock**                | (10,150)   | (10,281)   | (14,007)   | -          |
| **Total Oak Shelving Wood Purchased (feet)**   | 70,121     | 106,536    | 140,829    | -          |
| **Cost Per Foot**                      | $5         | $5         | $5         | $5         |
| **Total Cost of Oak Shelving Wood Purchased** | $350,605   | $532,680   | $704,145   | -          |

**Explanation:**

1. **Number of Display Cupboards**: Represents the quantity planned for production in each month.
2. **Oak Shelving Wood Required Per Unit**: The fixed quantity of wood required per cupboard (30 feet).
3. **Total Oak Shelving Wood Required**: Calculated by multiplying the number of cupboards by the wood required per unit.
4. **Closing Stock**: Wood inventory planned to retain at the end of the month.
5. **Opening Stock**: The existing stock at the beginning of the month.
6. **Total Oak Shelving Wood Purchased**: The actual amount needed to be purchased, factoring in opening and closing stock.
7. **Cost Per Foot**: Cost incurred for each foot of wood.
8. **Total Cost of Oak Shelving Wood Purchased**: Calculated by multiplying the total feet purchased by the cost per foot. 

This budget allows for efficient inventory management
Transcribed Image Text:**Direct Materials Budget for Oak Shelving Wood** **Particulars:** | **Details** | **Oct 22** | **Nov 22** | **Dec 22** | **Jan 23** | |----------------------------------------|------------|------------|------------|------------| | **No. of Display Cupboards** | 2,333 | 3,427 | 4,669 | 4,922 | | **Oak Shelving Wood Required Per Unit (feet)** | 30 | 30 | 30 | 30 | | **Total Oak Shelving Wood Required (feet)** | 69,990 | 102,810 | 140,070 | 147,660 | | **Add: Closing Stock** | 10,281 | 14,007 | 14,766 | - | | **Less: Opening Stock** | (10,150) | (10,281) | (14,007) | - | | **Total Oak Shelving Wood Purchased (feet)** | 70,121 | 106,536 | 140,829 | - | | **Cost Per Foot** | $5 | $5 | $5 | $5 | | **Total Cost of Oak Shelving Wood Purchased** | $350,605 | $532,680 | $704,145 | - | **Explanation:** 1. **Number of Display Cupboards**: Represents the quantity planned for production in each month. 2. **Oak Shelving Wood Required Per Unit**: The fixed quantity of wood required per cupboard (30 feet). 3. **Total Oak Shelving Wood Required**: Calculated by multiplying the number of cupboards by the wood required per unit. 4. **Closing Stock**: Wood inventory planned to retain at the end of the month. 5. **Opening Stock**: The existing stock at the beginning of the month. 6. **Total Oak Shelving Wood Purchased**: The actual amount needed to be purchased, factoring in opening and closing stock. 7. **Cost Per Foot**: Cost incurred for each foot of wood. 8. **Total Cost of Oak Shelving Wood Purchased**: Calculated by multiplying the total feet purchased by the cost per foot. This budget allows for efficient inventory management
Expert 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

The display cupboards require two direct materials: oak shelving wood and hickory
plywood backing board.
Oak shelving wood:
Thirty (30) feet of 12x1 oak shelving wood are required for each cupboard produced.
Management desires to have materials on hand at the end of each month equal to 10
percent of the following month's cupboard production needs. The beginning
inventory of oak wood, October 2022, was 10,150 feet of wood. Oak wood is
expected to cost $5.00 per foot.
Hickory plywood backing board:
Hickory plywood backing board is purchased by the sheet and 2 backing boards can
be cut from each sheet. Management desires to have plywood on hand at the end of
each month equal to 15 percent of the following month's production needs. The
beginning inventory of plywood, October 2022, was 100 sheets. Hickory plywood is
expected to cost $45 per sheet. (Note, budgeted production in January is required in
order to complete the direct materials budget for December. Also, use the @ROUND
function to round up to the nearest whole number the number of sheets of plywood
to purchase – “DM quantities to purchase”).

 

What are the calculations for this budget?

Direct Materials
Budget
History Plywood Packing Board
Oct 22
Particulars
No. of display cupboards
Packing board per sheet
No. of Packing Boards
liquised (sheel
2333
2
1167
Add
stock
Closing
hess :- Opening stock
No. of Packing boards
purchased (sheet)
lost per sheet
Total cost of packing $59,559
board (sheets).
1324
$45
257
(100)
Nov 22
3427
2
1714
350
Dec 22 Jan23
4922
4669
2
2335
369
(350)
1807
2353
$45
$45
$81,299 $105,906
2
2461
Transcribed Image Text:Direct Materials Budget History Plywood Packing Board Oct 22 Particulars No. of display cupboards Packing board per sheet No. of Packing Boards liquised (sheel 2333 2 1167 Add stock Closing hess :- Opening stock No. of Packing boards purchased (sheet) lost per sheet Total cost of packing $59,559 board (sheets). 1324 $45 257 (100) Nov 22 3427 2 1714 350 Dec 22 Jan23 4922 4669 2 2335 369 (350) 1807 2353 $45 $45 $81,299 $105,906 2 2461
Solution
Bartleby Expert
SEE SOLUTION
Similar questions
  • SEE MORE 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