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
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
Transcribed Image Text: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
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
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