Seroja Sdn. Bhd. manufactures customized equipment for local market. The budgeted data for the month of February 2019 were as follows: Machining Department Finishing Department Manufacturing overhead RM40,000 RM65,000 Direct labour hours 2,000 hours 10,000 hours Machine hours 4,000 hours 5,700 hours During the month, an order was received from Mr. Eric to manufacture an equipment for his personnel use. The job is known as Job E and the data pertaining to the job were as follows: Machining Department Finishing Department Direct material RM2,800 RM1,200 Direct labour hours 500 hours 50 hours Machine hours 300 hours 200 hours Wage rate per hour RM2.50 RM3.20 Additional information about Job E: Manufacturing overhead is absorbed based on machine hour for Machining department and direct labour hour for Finishing department. Administrative expenses incurred for Job E was 15% of prime cost The company set the profit margin of 25% on total cost for Job E. At the end of the month the actual data were obtained as follows: Machining Department Finishing Department Manufacturing overhead RM35,000 RM72,000 Direct labour hours 1,650 hours 9,800 hours Machine hours 3,700 hours 6,200 hours Required: Calculate overhead absorption rate for both departments using: Single rate (assuming the company uses direct labour hour as absorption basis). Departmental rate Prepare the job cost sheet of Job E by showing the prime cost, total production cost and total cost. Calculate the selling price of Job E.
Master Budget
A master budget can be defined as an estimation of the revenue earned or expenses incurred over a specified period of time in the future and it is generally prepared on a periodic basis which can be either monthly, quarterly, half-yearly, or annually. It helps a business, an organization, or even an individual to manage the money effectively. A budget also helps in monitoring the performance of the people in the organization and helps in better decision-making.
Sales Budget and Selling
A budget is a financial plan designed by an undertaking for a definite period in future which acts as a major contributor towards enhancing the financial success of the business undertaking. The budget generally takes into account both current and future income and expenses.
Seroja Sdn. Bhd. manufactures customized equipment for local market. The budgeted data for the month of February 2019 were as follows:
|
|
Machining Department |
Finishing Department |
|
Manufacturing overhead |
RM40,000 |
RM65,000 |
|
Direct labour hours |
2,000 hours |
10,000 hours |
|
Machine hours |
4,000 hours |
5,700 hours |
During the month, an order was received from Mr. Eric to manufacture an equipment for his personnel use. The job is known as Job E and the data pertaining to the job were as follows:
|
|
Machining Department |
Finishing Department |
|
Direct material |
RM2,800 |
RM1,200 |
|
Direct labour hours |
500 hours |
50 hours |
|
Machine hours |
300 hours |
200 hours |
|
Wage rate per hour |
RM2.50 |
RM3.20 |
Additional information about Job E:
- Manufacturing overhead is absorbed based on machine hour for Machining department and direct labour hour for Finishing department.
- Administrative expenses incurred for Job E was 15% of prime cost
- The company set the profit margin of 25% on total cost for Job E.
At the end of the month the actual data were obtained as follows:
|
|
Machining Department |
Finishing Department |
|
Manufacturing overhead |
RM35,000 |
RM72,000 |
|
Direct labour hours |
1,650 hours |
9,800 hours |
|
Machine hours |
3,700 hours |
6,200 hours |
Required:
- Calculate overhead absorption rate for both departments using:
- Single rate (assuming the company uses direct labour hour as absorption basis).
- Departmental rate
- Prepare the
job cost sheet of Job E by showing the prime cost, total production cost and total cost.
- Calculate the selling price of Job E.
- Based on your answer in a. ii) above, calculate over or under absorption of overhead for each department.
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
