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.

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter8: Budgeting For Planning And Control
Section: Chapter Questions
Problem 15E: Palmgren Company produces consumer products. The sales budget for four months of the year is...
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.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT