The jackets require two direct materials: silk fabric and viscose fabric for lining. Silk Silk fabric is purchased by the yard. 1.75 yards of silk fabric are required for each jacket produced. Management desires to have materials on hand at the end of each month equal to 15 percent of the following month's jacket production needs. Use the @ROUND function to round to the nearest whole number the number of yards 1 of silk desired in ending inventory. The beginning inventory of silk fabric, July 2023, is expected to be 220 yards. Silk fabric is expected to cost $25.00 per yard. Use the @ROUND function to round to the nearest whole number the number of yards of silk to purchase (DM to purchase). (NOTE: budgeted production in October is required in order to complete the direct materials budget for September.) Viscose for lining Viscose fabric is purchased by the roll of 10 yards. 2.2 yards of viscose fabric are required for each jacket produced. Management desires to have viscose fabric on hand at the end of each month equal to 11 percent of the following month's production needs. Use the @ROUND function to round to the nearest whole number the number of viscose yards desired in ending inventory. The beginning inventory, July 2023, is expected to be 187 yards. The roll of 10 yards is expected to cost $110. Use the @ROUND function to round to the nearest whole number the number of viscose fabric yards to purchase (DM to purchase). (NOTE: budgeted production in October is required to complete the direct materials budget for September.) Prepare a Direct Materials budget. Also, because two direct materials are required for production - silk and viscose fabric - you will need a separate schedule for each direct material.
The jackets require two direct materials: silk fabric and viscose fabric for lining. Silk Silk fabric is purchased by the yard. 1.75 yards of silk fabric are required for each jacket produced. Management desires to have materials on hand at the end of each month equal to 15 percent of the following month's jacket production needs. Use the @ROUND function to round to the nearest whole number the number of yards 1 of silk desired in ending inventory. The beginning inventory of silk fabric, July 2023, is expected to be 220 yards. Silk fabric is expected to cost $25.00 per yard. Use the @ROUND function to round to the nearest whole number the number of yards of silk to purchase (DM to purchase). (NOTE: budgeted production in October is required in order to complete the direct materials budget for September.) Viscose for lining Viscose fabric is purchased by the roll of 10 yards. 2.2 yards of viscose fabric are required for each jacket produced. Management desires to have viscose fabric on hand at the end of each month equal to 11 percent of the following month's production needs. Use the @ROUND function to round to the nearest whole number the number of viscose yards desired in ending inventory. The beginning inventory, July 2023, is expected to be 187 yards. The roll of 10 yards is expected to cost $110. Use the @ROUND function to round to the nearest whole number the number of viscose fabric yards to purchase (DM to purchase). (NOTE: budgeted production in October is required to complete the direct materials budget for September.) Prepare a Direct Materials budget. Also, because two direct materials are required for production - silk and viscose fabric - you will need a separate schedule for each direct material.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Topic Video
Question
Need help finding the Direct Materials budget. I included a photo of what i have so far.
Transcribed Image Text:**Sales Budget**
| | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER |
|---------------------|--------|--------|-----------|---------|----------|
| Unit Sales | 667.00 | 690.00 | 747.50 | 977.50 | 1,150.00 |
| Multiply: Sales Price | $735 | $735 | $735 | $735 | $735 |
| **Total Sales Revenue** | **$490,245.00** | **$507,150.00** | **$549,412.50** | **$718,462.50** | **$845,250.00** |
**Type of Sale**
| | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER |
|---------------------|----------|----------|------------|-----------|------------|
| Cash Sales (0.10) | $49,024.50 | $50,715.00 | $54,941.25 | $71,846.25 | $84,525.00 |
| Credit Sales (0.90) | $441,220.50 | $456,435.00 | $494,471.25 | $646,616.25 | $760,725.00 |
---
**Production Budget**
| | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER |
|---------------------|--------|--------|-----------|---------|----------|
| Unit Sales (cases) | $667 | $690 | $748 | $978 | $1,150 |
| Plus: Desired Ending Inventory | 83 | 90 | 117 | 138 | |
| **Total Needed** | 750 | 780 | 865 | 1,116 | 1,150 |
| Less: Beginning Inventory | 55 | 83 | 90 | 117 | 138 |
| **# of Units to Produce** | 695 | 697 | 775 | 998 | 1,012 |
---
**Direct Material Budget**
| | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER |
|---------------------|--------|--------|-----------|
Transcribed Image Text:The jackets require two direct materials: silk fabric and viscose fabric for lining.
**Silk**
Silk fabric is purchased by the yard. 1.75 yards of silk fabric are required for each jacket produced. Management desires to have materials on hand at the end of each month equal to 15 percent of the following month's jacket production needs. Use the @ROUND function to round to the nearest whole number the number of yards of silk desired in ending inventory. The beginning inventory of silk fabric, July 2023, is expected to be 220 yards. Silk fabric is expected to cost $25.00 per yard. Use the @ROUND function to round to the nearest whole number the number of yards of silk to purchase (DM to purchase). (NOTE: budgeted production in October is required in order to complete the direct materials budget for September.)
**Viscose for lining**
Viscose fabric is purchased by the roll of 10 yards. 2.2 yards of viscose fabric are required for each jacket produced. Management desires to have viscose fabric on hand at the end of each month equal to 11 percent of the following month's production needs. Use the @ROUND function to round to the nearest whole number the number of viscose yards desired in ending inventory. The beginning inventory, July 2023, is expected to be 187 yards. The roll of 10 yards is expected to cost $110. Use the @ROUND function to round to the nearest whole number the number of viscose fabric yards to purchase (DM to purchase). (NOTE: budgeted production in October is required to complete the direct materials budget for September.)
**Prepare a Direct Materials budget.** Also, because two direct materials are required for production – silk and viscose fabric – you will need a separate schedule for each direct material.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Knowledge Booster
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
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education