Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March 20,000 April 22,000 19,500 18,000 May June Wright maintains an ending inventory for each month in the amount of two and one-half times the expected sales in the following month. The ending inventory for February (March's beginning inventory) reflects this policy. Materials cost $7 per unit and are paid for in the month after production. Labor cost is $11 per unit and is paid for in the month incurred. Fixed overhead is $19,000 per month. Dividends of $21,400 are to be paid in May. The firm produced 19,000 units in February. Complete a production schedule and a summary of cash payments for March, April, and May. Remember that production in any one month is equal to sales plus desired ending inventory minus beginning inventory. Note: Input all amounts as positive values except Beginning inventory values under Production Schedule which should be entered with a minus sign. Leave no cells blank be certain to enter 0 wherever required. Projected unit sales Desired ending inventory Total units required Beginning inventory Units to be produced Units produced Material cost Labor cost Fixed overhead Dividends Total cash payments Wright Lighting Fixtures Production Schedule March April Cash Payments February March May April June May
Wright Lighting Fixtures forecasts its sales in units for the next four months as follows: March 20,000 April 22,000 19,500 18,000 May June Wright maintains an ending inventory for each month in the amount of two and one-half times the expected sales in the following month. The ending inventory for February (March's beginning inventory) reflects this policy. Materials cost $7 per unit and are paid for in the month after production. Labor cost is $11 per unit and is paid for in the month incurred. Fixed overhead is $19,000 per month. Dividends of $21,400 are to be paid in May. The firm produced 19,000 units in February. Complete a production schedule and a summary of cash payments for March, April, and May. Remember that production in any one month is equal to sales plus desired ending inventory minus beginning inventory. Note: Input all amounts as positive values except Beginning inventory values under Production Schedule which should be entered with a minus sign. Leave no cells blank be certain to enter 0 wherever required. Projected unit sales Desired ending inventory Total units required Beginning inventory Units to be produced Units produced Material cost Labor cost Fixed overhead Dividends Total cash payments Wright Lighting Fixtures Production Schedule March April Cash Payments February March May April June May
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
Transcribed Image Text:Wright Lighting Fixtures forecasts its sales in units for the next four months as follows:
20,000
22,000
19,500
18,000
March
April
May
June
Wright maintains an ending inventory for each month in the amount of two and one-half times the expected sales in the following
month. The ending inventory for February (March's beginning inventory) reflects this policy. Materials cost $7 per unit and are paid for
in the month after production. Labor cost is $11 per unit and is paid for in the month incurred. Fixed overhead is $19,000 per month.
Dividends of $21,400 are to be paid in May. The firm produced 19,000 units in February.
Complete a production schedule and a summary of cash payments for March, April, and May. Remember that production in any one
month is equal to sales plus desired ending inventory minus beginning inventory.
Note: Input all amounts as positive values except Beginning inventory values under Production Schedule which should be entered
with a minus sign. Leave no cells blank be certain to enter O wherever required.
Projected unit sales
Desired ending inventory
Total units required
Beginning inventory
Units to be produced
Units produced
Material cost
Labor cost
Fixed overhead
Dividends
Total cash payments
Wright Lighting Fixtures
Production Schedule
March
April
Cash Payments
February
March
May
April
June
May
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 4 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