Shredder Manufacturing has the following projected unit sales (at $18 per unit) for four months of operations: Month Unit Sales January 60,000 February 72,000 March 76,800 April 84,000 Twenty-five percent of the customers are expected to pay in the month of sale and take a 3 percent discount; 70 percent of the customers are expected to pay in the month following sale. The remaining 5 percent will never pay. It takes two pounds of raw material (costing $0.75 per pound) to produce a unit of product. In January, no raw material is in beginning inventories, but management wants to end each month with enough material for 20 percent of the next month’s production. (April’s production is assumed to be 81,600 units.) Shredder Manufacturing pays for 60 percent of its material purchases in the month of purchase and 40 percent in the following month. Each unit of product requires 0.5 hours of labor time. Labor is paid $15 per hour and is paid in the same month as worked. Overhead is estimated to be $2 per unit plus $60,000 per month (including depreciation of $28,800). Overhead costs are paid as incurred. Shredder will begin January with no Work in Process or Finished Goods Inventory. Inventory policy for these two accounts is set at zero ending WIP and 25 percent of the following month’s sales for FG. c. Prepare a purchases budget for January, February, and March.

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

Shredder Manufacturing has the following projected unit sales (at $18 per unit) for four months of operations:

Month Unit Sales
January 60,000
February 72,000
March 76,800
April 84,000

Twenty-five percent of the customers are expected to pay in the month of sale and take a 3 percent discount; 70 percent of the customers are expected to pay in the month following sale. The remaining 5 percent will never pay.


It takes two pounds of raw material (costing $0.75 per pound) to produce a unit of product. In January, no raw material is in beginning inventories, but management wants to end each month with enough material for 20 percent of the next month’s production. (April’s production is assumed to be 81,600 units.) Shredder Manufacturing pays for 60 percent of its material purchases in the month of purchase and 40 percent in the following month.


Each unit of product requires 0.5 hours of labor time. Labor is paid $15 per hour and is paid in the same month as worked. Overhead is estimated to be $2 per unit plus $60,000 per month (including depreciation of $28,800). Overhead costs are paid as incurred.


Shredder will begin January with no Work in Process or Finished Goods Inventory. Inventory policy for these two accounts is set at zero ending WIP and 25 percent of the following month’s sales for FG.

c. Prepare a purchases budget for January, February, and March.

 

**Production and Inventory Planning Table**

This table presents a comprehensive view of production and inventory elements over a span of three months (January, February, and March) along with the total values for these months. Below is a detailed breakdown of each element presented in the table:

1. **Production**: 
   - January: 0
   - February: 0
   - March: 0
   - Total: 0

2. **EI (Ending Inventory)**: 
   - January: 0 (Red Cross)
   - February: 0 (Red Cross)
   - March: 0 (Red Cross)
   - Total: 0 (Red Cross)

3. **Less BI (Beginning Inventory)**:
   - January: 0 (Green Check)
   - February: 0 (Red Cross)
   - March: 0 (Red Cross)
   - Total: 0 (Green Check)

4. **Units**: 
   - January: 0
   - February: 0
   - March: 0
   - Total: 0

5. **Pounds per unit**: 
   - January: 0
   - February: 0
   - March: 0
   - Total: 0

6. **Total lbs. (Total Pounds)**: 
   - January: 0
   - February: 0
   - March: 0
   - Total: 0

7. **Price per lb. (Price per Pound)**:
   - January: $0
   - February: $0
   - March: $0
   - Total: $0

8. **Purchases**:
   - January: $0
   - February: $0
   - March: $0
   - Total: $0

**Legend**:
- Green Check (✅): Indicates a verified or required number in the inventory starting balance.
- Red Cross (❌): Indicates an absence or zero value in the inventory ending balance. 

The table is structured to offer a clear, month-by-month analysis, ensuring that one can easily track and plan production and inventory activities. The use of checkmarks and crosses provides an additional layer of visual guidance to understand whether the values are available or missing.
Transcribed Image Text:**Production and Inventory Planning Table** This table presents a comprehensive view of production and inventory elements over a span of three months (January, February, and March) along with the total values for these months. Below is a detailed breakdown of each element presented in the table: 1. **Production**: - January: 0 - February: 0 - March: 0 - Total: 0 2. **EI (Ending Inventory)**: - January: 0 (Red Cross) - February: 0 (Red Cross) - March: 0 (Red Cross) - Total: 0 (Red Cross) 3. **Less BI (Beginning Inventory)**: - January: 0 (Green Check) - February: 0 (Red Cross) - March: 0 (Red Cross) - Total: 0 (Green Check) 4. **Units**: - January: 0 - February: 0 - March: 0 - Total: 0 5. **Pounds per unit**: - January: 0 - February: 0 - March: 0 - Total: 0 6. **Total lbs. (Total Pounds)**: - January: 0 - February: 0 - March: 0 - Total: 0 7. **Price per lb. (Price per Pound)**: - January: $0 - February: $0 - March: $0 - Total: $0 8. **Purchases**: - January: $0 - February: $0 - March: $0 - Total: $0 **Legend**: - Green Check (✅): Indicates a verified or required number in the inventory starting balance. - Red Cross (❌): Indicates an absence or zero value in the inventory ending balance. The table is structured to offer a clear, month-by-month analysis, ensuring that one can easily track and plan production and inventory activities. The use of checkmarks and crosses provides an additional layer of visual guidance to understand whether the values are available or missing.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Knowledge Booster
Cost volume profit (CVP) analysis
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.
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