Collected these information from Bell Telecom Company (Egypt) producing 3 products "E","F", and "G" for the year 2022: First: Sales: - Estimated sales "E" 11,000,000 EGP "F" 8,400,000 EGP - Sales price/unit 440 EGP 420 EGP Second: Production and Inventory (finished goods): Total estimated sales units for product (E) will allocate for first quarter, second quarter, third quarter, and fourth quarter by equally. "G" 7,380,000 EGP 410 EGP - For calculating of ending inventory of Finished Goods (F.G.) of product (E), 1/4 of sales units of the next quarter are used except the fourth quarter 4/4 of sales units of the same quarter. - Ending inventory of Finished Goods (F.G.) for first quarter = 1250 units for product (E). - Beginning inventory of Finished Goods (F.G.) for first quarter = 2300 units for product (E). - Ending inventory of Finished Goods (F.G.) for product (F) and (G) 1/4 of sales units. - Inventory 31/12/2021 for product (F) and (G) are 1600 and 1100 units, respectively.
Collected these information from Bell Telecom Company (Egypt) producing 3 products "E","F", and "G" for the year 2022: First: Sales: - Estimated sales "E" 11,000,000 EGP "F" 8,400,000 EGP - Sales price/unit 440 EGP 420 EGP Second: Production and Inventory (finished goods): Total estimated sales units for product (E) will allocate for first quarter, second quarter, third quarter, and fourth quarter by equally. "G" 7,380,000 EGP 410 EGP - For calculating of ending inventory of Finished Goods (F.G.) of product (E), 1/4 of sales units of the next quarter are used except the fourth quarter 4/4 of sales units of the same quarter. - Ending inventory of Finished Goods (F.G.) for first quarter = 1250 units for product (E). - Beginning inventory of Finished Goods (F.G.) for first quarter = 2300 units for product (E). - Ending inventory of Finished Goods (F.G.) for product (F) and (G) 1/4 of sales units. - Inventory 31/12/2021 for product (F) and (G) are 1600 and 1100 units, respectively.
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
Related questions
Question
PREPARE THE FOOLOWING
1- PRODUCTION BUDGET
2-SALES BUDGET
Transcribed Image Text:Collected these information from Bell Telecom Company (Egypt) producing 3 products
"E","F", and "G" for the year 2022:
First: Sales:
- Estimated sales "E" 11,000,000 EGP "F" 8,400,000 EGP
- Sales price/unit 440 EGP
420 EGP
Second: Production and Inventory (finished goods):
Total estimated sales units for product (E) will allocate for first quarter, second quarter,
third quarter, and fourth quarter by equally.
"G" 7,380,000 EGP
410 EGP
- For calculating of ending inventory of Finished Goods (F.G.) of product (E), 1/4 of sales
units of the next quarter are used except the fourth quarter 4/4 of sales units of the same
quarter.
- Ending inventory of Finished Goods (F.G.) for first quarter = 1250 units for product (E).
- Beginning inventory of Finished Goods (F.G.) for first quarter = 2300 units for product (E).
- Ending inventory of Finished Goods (F.G.) for product (F) and (G) 1/4 of sales units.
- Inventory 31/12/2021 for product (F) and (G) are 1600 and 1100 units, respectively.
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 1 steps
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