A new set of financial managers are hired to Holland Company, a manufacturing-concern entity that produces Product A. The financial managers are now planning the operations for 2022. They are currently doing the sales and production budget of the entity. Upon inspecting the financial records of the entity, they found at that each unit of Product A utilizes three kinds of materials – Material X, Material Y, and Material Z. To produce each unit of Product A, three units of Material X, 2 units of Material Y, and 4 units of Material Z are needed. It also needs 2.5 direct labor hours to manufacture each unit. Factory overhead is applied at 50% of direct labor costs. As the usual practice, the entity is preparing the budget on a quarterly basis. For the 4th quarter of 2021, the entity was able to sell 120000 units of Product A at an average price of P400 per unit. Because the new set of financial managers are confident that the company can do more, they are targeting to increase units sold by 10000 for the first quarter of 2022, and additional 15000 units for the succeeding quarters. They are also planning to increase selling price by 5 percent every quarter. Upon inspecting the December 31, 2021 records, they found out the level of inventories of the raw materials are as follows: 20,500 units of Material X, 14,600 of Material Y, and 16,700 of Material Z. They are planning to always maintain raw materials inventory equivalent to 30% of the next quarter’s material requirements. The financial managers also want to maintain finished goods inventory level equivalent to 20% of the next quarter’s planned units sold. Looking at the market price of the resources to produce Product A, the following prices are observed: Material X Material Y Material Z Direct Labor Hour P25.50 P67.20 P88 P99.50 Required: 1. Compute the required level of production for each quarter of 2022. 2. Compute the required units of each material to be purchased for each quarter of 2022 3. Compute the amount to be spent for purchasing each kind of material for each quarter of 2022. 4. Compute the estimated amount to be spent on direct labor each quarter.
A new set of financial managers are hired to Holland Company, a manufacturing-concern entity that produces Product A. The financial managers are now planning the operations for 2022. They are currently doing the sales and production budget of the entity. Upon inspecting the financial records of the entity, they found at that each unit of Product A utilizes three kinds of materials – Material X, Material Y, and Material Z. To produce each unit of Product A, three units of Material X, 2 units of Material Y, and 4 units of Material Z are needed. It also needs 2.5 direct labor hours to manufacture each unit. Factory overhead is applied at 50% of direct labor costs. As the usual practice, the entity is preparing the budget on a quarterly basis. For the 4th quarter of 2021, the entity was able to sell 120000 units of Product A at an average price of P400 per unit. Because the new set of financial managers are confident that the company can do more, they are targeting to increase units sold by 10000 for the first quarter of 2022, and additional 15000 units for the succeeding quarters. They are also planning to increase selling price by 5 percent every quarter. Upon inspecting the December 31, 2021 records, they found out the level of inventories of the raw materials are as follows: 20,500 units of Material X, 14,600 of Material Y, and 16,700 of Material Z. They are planning to always maintain raw materials inventory equivalent to 30% of the next quarter’s material requirements. The financial managers also want to maintain finished goods inventory level equivalent to 20% of the next quarter’s planned units sold. Looking at the market price of the resources to produce Product A, the following prices are observed: Material X Material Y Material Z Direct Labor Hour P25.50 P67.20 P88 P99.50 Required: 1. Compute the required level of production for each quarter of 2022. 2. Compute the required units of each material to be purchased for each quarter of 2022 3. Compute the amount to be spent for purchasing each kind of material for each quarter of 2022. 4. Compute the estimated amount to be spent on direct labor each quarter.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
A new set of financial managers are hired to Holland Company, a manufacturing-concern entity that produces Product A. The financial managers are now planning the operations for 2022. They are currently doing the sales and production budget of the entity.
Upon inspecting the financial records of the entity, they found at that each unit of Product A utilizes three kinds of materials – Material X, Material Y, and Material Z. To produce each unit of Product A, three units of Material X, 2 units of Material Y, and 4 units of Material Z are needed. It also needs 2.5 direct labor hours to manufacture each unit. Factory overhead is applied at 50% of direct labor costs.
As the usual practice, the entity is preparing the budget on a quarterly basis. For the 4th quarter of 2021, the entity was able to sell 120000 units of Product A at an average price of P400 per unit. Because the new set of financial managers are confident that the company can do more, they are targeting to increase units sold by 10000 for the first quarter of 2022, and additional 15000 units for the succeeding quarters. They are also planning to increase selling price by 5 percent every quarter.
Upon inspecting the December 31, 2021 records, they found out the level of inventories of the raw materials are as follows: 20,500 units of Material X, 14,600 of Material Y, and 16,700 of Material Z. They are planning to always maintain raw materials inventory equivalent to 30% of the next quarter’s material requirements.
The financial managers also want to maintain finished goods inventory level equivalent to 20% of the next quarter’s planned units sold.
Looking at the market price of the resources to produce Product A, the following prices are observed:
Material X Material Y Material Z
Direct Labor Hour
P25.50 P67.20 P88 P99.50
Required:
1. Compute the required level of production for each quarter of 2022.
2. Compute the required units of each material to be purchased for each quarter of 2022
3. Compute the amount to be spent for purchasing each kind of material for each quarter of
2022.
4. Compute the estimated amount to be spent on direct labor each quarter.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 5 steps with 6 images
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