Construct a material usage and purchases budget of the Bara Enterprise.

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter7: Inventory Cost Flow Assumptions (fifolifo)
Section: Chapter Questions
Problem 9R: Click the Chart sheet tab. On the screen is a column chart showing ending inventory costs. During a...
icon
Related questions
icon
Concept explainers
Question

Construct a material usage and purchases budget of the Bara Enterprise. 

(a) Bara Enterprise manufactures product Alpha. The following information is for the year
2021:
Table 2: Finished Goods Data for the Product Alpha
Amount
Estimated sales
Perak
Details
Kelantan
Price per unit
Expected closing stock
Opening stock
Details
Additional information:
Opening stock
Expected closing stock
Cost per unit
Table 3: Raw Materials Data
20,000 units
40,000 units
RM16.00
6,000 units
4,000 units
Material A
20,000 units
30,000 units
RM2.00
Material B
25,000 units
40,000 units
RM4.00
Each unit of product Alpha required 4 units of Material A and 2 units of Material B.
Transcribed Image Text:(a) Bara Enterprise manufactures product Alpha. The following information is for the year 2021: Table 2: Finished Goods Data for the Product Alpha Amount Estimated sales Perak Details Kelantan Price per unit Expected closing stock Opening stock Details Additional information: Opening stock Expected closing stock Cost per unit Table 3: Raw Materials Data 20,000 units 40,000 units RM16.00 6,000 units 4,000 units Material A 20,000 units 30,000 units RM2.00 Material B 25,000 units 40,000 units RM4.00 Each unit of product Alpha required 4 units of Material A and 2 units of Material B.
Expert Solution
steps

Step by step

Solved in 3 steps with 2 images

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
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning