HOW WAS THE ADD: CLSOING STOCK CALCULATED?
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
TAal Oak
Oak Sh
shelving
requiset p. u (feet)
Add :
hess -
Particulars
Oct 22
No. of display cupboards 2,333
Dak
wood
Cost
Shelving
-Closing
• Opening
Budget
shelving
required (feet)
stock
stock
wood 69,990
per foot
Total cost of oak
wood
shelving purchased
Wood.
30
Total dak shelving wood 70,121
purchased ( feet)
et
Nov 22
3,427
$350,605
30
102,810
10,281
14,007
14,766
(10,150) (102,81) (14,007)
106,536
140,829
$5
Dec 22 Jan 23
4669
4922
30
$532,680
30
140,070
$5
$704,145
147,660](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F3fc3ef53-ef76-4c8f-9c49-6c2ebf0a14b7%2Fbeb222ce-8220-4272-8c6f-6e4e7ed89eed%2Fjls5uy_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
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](https://content.bartleby.com/qna-images/question/3fc3ef53-ef76-4c8f-9c49-6c2ebf0a14b7/42a5775c-6a0d-4ee8-a03e-a259b435f278/idlxkdj1_thumbnail.jpeg)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Accounting](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
![Accounting Information Systems](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
![Horngren's Cost Accounting: A Managerial Emphasis…](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
![Intermediate Accounting](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
![Financial and Managerial Accounting](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)