A sales budget is given below for one of the products manufactured by the Key Company. 27,000 units 42,000 units 67,000 units 47,000 units 37,000 units 31,000 units January February March April May June The inventory of finished goods at the end of each month should equal 20% of the next month's sales. However, on December 31 the inished goods inventory totaled only 5,400 units. Each unit of product requires three specialized electrical switches. Since the production of these specialized switches by Key's suppliers is sometimes irregular, the company has a policy of maintaining an ending ventory at the end of each month equal to 30% of the next month's production needs. This requirement had been met on January 1 of the current year.

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

hh

A sales budget is given below for one of the products manufactured by the Key Company:
January
February
March
27,000 units
42,000 units
67,000 units
47,000 units
37,000 units
31,000 units
April
May
June
The inventory of finished goods at the end of each month should equal 20% of the next month's sales. However, on December 31 the
finished goods inventory totaled only 5,400 units. Each unit of product requires three specialized electrical switches. Since the
production of these specialized switches by Key's suppliers is sometimes irregular, the company has a policy of maintaining an ending
inventory at the end of each month equal to 30% of the next month's production needs. This requirement had been met on January 1
of the current year.
Required:
a. Prepare a budget showing the required production each month for January, February, March, and April.
b. Prepare a budget showing the quantity of switches to be purchased each month for January, February, and March.
Complete this question by entering your answers in the tabs below.
Required A
Prepare a budget showing the required production each month for January, Februrch, and April.
Note: Do not round your intermediate calculations. Round your final answers to th
urest whole number.
January
February
Required B
Budgeted sales (units)
Total needs
Required production in units
0
0
Required A
0
March
0
0
Required B >
0
Transcribed Image Text:A sales budget is given below for one of the products manufactured by the Key Company: January February March 27,000 units 42,000 units 67,000 units 47,000 units 37,000 units 31,000 units April May June The inventory of finished goods at the end of each month should equal 20% of the next month's sales. However, on December 31 the finished goods inventory totaled only 5,400 units. Each unit of product requires three specialized electrical switches. Since the production of these specialized switches by Key's suppliers is sometimes irregular, the company has a policy of maintaining an ending inventory at the end of each month equal to 30% of the next month's production needs. This requirement had been met on January 1 of the current year. Required: a. Prepare a budget showing the required production each month for January, February, March, and April. b. Prepare a budget showing the quantity of switches to be purchased each month for January, February, and March. Complete this question by entering your answers in the tabs below. Required A Prepare a budget showing the required production each month for January, Februrch, and April. Note: Do not round your intermediate calculations. Round your final answers to th urest whole number. January February Required B Budgeted sales (units) Total needs Required production in units 0 0 Required A 0 March 0 0 Required B > 0
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Budgeting
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
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