Sales Budget Unit Sales 0.1 Multiply Sales price 0.9 Total Sales Rev Type of Sale Cash Sales 0.10 Credit Sales 0.90 roduction Budget Unit Sales (cases) 0.12 Plus: Desired Ending inventory Total needed Less: Beginning inventory # of units to produce DirectMateral budge Silk s to be produced (from production budg ultiply by:Quanity of DM needed per unit Quantity needed for production Plus: Desired ending inventory of DM Total quantity needed Less: Beginning inventory of DM Quantity to purchase Multiply by: Costper pound Total costof DMourchases 1.75 $11 2.2 Direct Material budget-Vicose fabric s to be produced (from production budge ultiply by:Quanity of DM needed per unit Quantity needed for production Plus: Desired ending inventory of DM Total quantity needed Less: Beginning inventory of DM Quantity to purchase Multiply by: Costper pound Total costof DM ourchases DirectLabor Budget Units (cases) to be produced Multiply by: Directlabor hours per unit Total hours required Multiply by: Directlabor cost per unit Total directlabor cost MOH Budget Cases to be produced Variable MOH cost Indirect materials Indirect labor- Variable portion JULY Utilities- Variable portion Total Variable MOH Fixed MOH cost 667.00 $735 490,245.00 $ 49,024.50 441,220.50 490,245.00 JULY JULY JULY JULY 55 667 $ 83 750 695 695 1.75 1,216 183 1,399 220 1,179 $25.00 29,473 695 2 1,529 169 1,511 $11 16,616.16 1,698 187 AUGUST 690.00 $735 507,150.00 50,715.00 54,941.25 71,846.25 456,435.00 494,471.25 646,616.25 507,150.00 549412.50 718,462.50 AUGUST AUGUST SEPTEMBER OCTOBER NOVEMBER 690 $ 90 780 83 697 1,220 697 1.75 1,423 AUGUST 203 AUGUST 1,240 $25.00 30,989 183 1,533 188 697 2 1,721 169 SEPTEMBER OCTOBER NOVEMBER 1,552 $11 17,073.98 747.50 977.50 $735 $735 549,412.50 718,462.50 748 $ 117 865 90 775 775 1.75 1,356 SEPTEMBER OCTOBER 262 1,618 203 1415 $25.00 35,386 775 2 1,705 242 1,947 188 978 $ 138 1,116 1,759 $11 19,351.42 117 998 998 1.75 1,747 266 2,013 262 1,751 $25.00 43,771 998 2 2,196 245 2,441 242 1,150.00 $735 845,250.00 2,199 $11 24,189.44 84,525.00 760,725.00 845,250.00 1,150 1,150 138 1,012 NOVEMBER 1,012 1.75 1,771 1,771 0 266 1,505 $25.00 37,625 1,012 2 2,226 2,226 245 1,981 $11 21,795.40 SEPTEMBER OCTOBER NOVEMBER SEPTEMBER OCTOBER NOVEMBER

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

Need help finding the Direct labor budget & MOH budget. I attached what i have so far. 

**4. Direct Labor Requirement for Jackets**

Each jacket necessitates 12 hours of direct labor. The company utilizes a series of drawing, cutting, and sewing machines that are specifically set up to optimize production efficiency. The direct labor cost is $25 per hour. *Objective: Prepare a Direct Labor Budget.*

**5. Budget for Indirect Materials and Mixed Costs**

The budget for indirect materials, such as shoulder pads, stitching threads, buttons, labels, and packaging, is $35.50 per jacket. Indirect labor and utilities are considered mixed costs. The variable costs include $20.00 per jacket for indirect labor and $5.50 per jacket for utilities. Additionally, the fixed costs per month include: 
- Indirect Labor: $25,000
- Utilities: $2,200
- Other Costs: $22,000

*Objective: Prepare a Manufacturing Overhead Budget.*
Transcribed Image Text:**4. Direct Labor Requirement for Jackets** Each jacket necessitates 12 hours of direct labor. The company utilizes a series of drawing, cutting, and sewing machines that are specifically set up to optimize production efficiency. The direct labor cost is $25 per hour. *Objective: Prepare a Direct Labor Budget.* **5. Budget for Indirect Materials and Mixed Costs** The budget for indirect materials, such as shoulder pads, stitching threads, buttons, labels, and packaging, is $35.50 per jacket. Indirect labor and utilities are considered mixed costs. The variable costs include $20.00 per jacket for indirect labor and $5.50 per jacket for utilities. Additionally, the fixed costs per month include: - Indirect Labor: $25,000 - Utilities: $2,200 - Other Costs: $22,000 *Objective: Prepare a Manufacturing Overhead Budget.*
**Sales Budget**

|               | JULY     | AUGUST   | SEPTEMBER | OCTOBER  | NOVEMBER |
|---------------|----------|----------|-----------|----------|----------|
| Unit Sales    | 667.00   | 690.00   | 747.50    | 977.50   | 1,150.00 |
| x Multiply/Sales Price | $735    | $735     | $735       | $735     | $735     |
| Sales Revenue | 490,245.00 | 507,150.00 | 549,412.50 | 718,462.50 | 845,250.00 |

*Type of Sale*

- **Cash Sales (0.10)**
  - JULY: $49,024.50
  - AUGUST: $50,715.00
  - SEPTEMBER: $54,941.25
  - OCTOBER: $71,846.25
  - NOVEMBER: $84,525.00
  
- **Credit Sales (0.90)**
  - JULY: $441,220.50
  - AUGUST: $456,435.00
  - SEPTEMBER: $494,471.25
  - OCTOBER: $646,616.25
  - NOVEMBER: $760,725.00
  
- **Total Sales**
  - JULY: $490,245.00
  - AUGUST: $507,150.00
  - SEPTEMBER: $549,412.50
  - OCTOBER: $718,462.50
  - NOVEMBER: $845,250.00

**Production Budget**

|               | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER |
|---------------|------|--------|-----------|---------|----------|
| Unit Sales (cases) | $667  | $690   | $748       | $978     | $1,150   |
| Plus: Ending Inventory | 83   | 90     | 117       | 138     | 138      |
| **Total Needed**     | 750  | 780    | 865       | 1,116   | 1,150    |
| Less: Beginning Inventory | 55   | 83     | 90        | 117     | 138
Transcribed Image Text:**Sales Budget** | | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | |---------------|----------|----------|-----------|----------|----------| | Unit Sales | 667.00 | 690.00 | 747.50 | 977.50 | 1,150.00 | | x Multiply/Sales Price | $735 | $735 | $735 | $735 | $735 | | Sales Revenue | 490,245.00 | 507,150.00 | 549,412.50 | 718,462.50 | 845,250.00 | *Type of Sale* - **Cash Sales (0.10)** - JULY: $49,024.50 - AUGUST: $50,715.00 - SEPTEMBER: $54,941.25 - OCTOBER: $71,846.25 - NOVEMBER: $84,525.00 - **Credit Sales (0.90)** - JULY: $441,220.50 - AUGUST: $456,435.00 - SEPTEMBER: $494,471.25 - OCTOBER: $646,616.25 - NOVEMBER: $760,725.00 - **Total Sales** - JULY: $490,245.00 - AUGUST: $507,150.00 - SEPTEMBER: $549,412.50 - OCTOBER: $718,462.50 - NOVEMBER: $845,250.00 **Production Budget** | | JULY | AUGUST | SEPTEMBER | OCTOBER | NOVEMBER | |---------------|------|--------|-----------|---------|----------| | Unit Sales (cases) | $667 | $690 | $748 | $978 | $1,150 | | Plus: Ending Inventory | 83 | 90 | 117 | 138 | 138 | | **Total Needed** | 750 | 780 | 865 | 1,116 | 1,150 | | Less: Beginning Inventory | 55 | 83 | 90 | 117 | 138
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
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