The Dermaniaga Company has the following information available: Table 3: Total Monthly Sales Month      Sales (RM) June                68,000 July                 72,000 August            74,000 September     76,000 October          78,000 Additional information: Sales price per unit is RM200 and the finished goods inventory level is 25% of the next month's unit sales. 5 kilograms of materials are required for each unit produced and the cost is RM50/kg. Inventory levels for materials equal 40% of the needs for the next month. Desired ending inventory for September is 157 kilograms of materials. Beginning inventory for July was 138 kilograms of materials. Each unit requires 0.8 hours of direct labor and the average wage rate is RM12 per hour. Required: 1. Analyze a production budget for July, August, September and the quarter in total. 2. Analyze a direct materials purchases budget in kilograms and Ringgit Malaysia for July, August, September and in total for the quarter. 3. Construct a direct labor budget in hours and total cost for July, August and September and in total for the quarter.

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter7: Budgeting
Section: Chapter Questions
Problem 1PB: Lens & Shades sells sunglasses for $37 each and is estimating sales of 21,000 units in January and...
icon
Related questions
Question

The Dermaniaga Company has the following information available:

Table 3: Total Monthly Sales

Month      Sales (RM)
June                68,000
July                 72,000
August            74,000
September     76,000
October          78,000

Additional information:

Sales price per unit is RM200 and the finished goods inventory level is 25% of the next month's unit sales. 5 kilograms of materials are required for each unit produced and the cost is RM50/kg. Inventory levels for materials equal 40% of the needs for the next month. Desired ending inventory for September is 157 kilograms of materials. Beginning inventory for July was 138 kilograms of materials. Each unit requires 0.8 hours of direct labor and the average wage rate is RM12 per hour.

Required:

1. Analyze a production budget for July, August, September and the quarter in total.

2. Analyze a direct materials purchases budget in kilograms and Ringgit Malaysia for July, August, September and in total for the quarter.

3. Construct a direct labor budget in hours and total cost for July, August and September and in total for the quarter.

4. Explain the difference between sales forecast and sales budget.

Expert Solution
steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Inventory Management
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
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
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