Question: Please solve the solution in the Excel and the way of the formula in a complete way I just don't understand problem 5, I hope

Please solve the solution in the Excel and the way of the formula in a complete way I just don't understand problem 5, I hope you solve the problem 5 in a Excel so that I can understand. T

Please solve the solution in the Excel and the

According to the budget, the company is planned to operate at a normal capacity of 300 days @ 7 working hours per day. The amount of assets used in the Workshop Department is Rp. 60.000.000, while the amount of assets invested in the Spareparts Shop Department is Rp. 28.000.000, Estimated purchase price of materials and spare parts is Rp. 23.800.000, Investment return rates (ROI) expected in the fiscal year is 25%. Direct Expense in workshop department: o Direct labor wages: Rp31.500.000 . (10 x 300 days x 7 hours) @ Rp 1.500/hours o Health Benefits: . 10 person x 12 months x Rp50.000,- Rp 6.000.000 o Welfare Benefits: Rp 3.000.000 10 person x 12 months x Rp25.000,- Indirect Expense in workshop department: o Wages Expense Rp11.600.000 o Fixed Asset Depreciation Expense 2.200.000 o Insurance Expense 650.000 o Electric Expense 800.000 o Water expense 400.000 o Fixed Asset Repair Expense 350.000 o Other expenses 500.000 Based on the problems above, determine the mark up percentage from direct labor expense! Problem 5 Based from question number 4, determine the selling price for service maintenance in Workshop Department i in one job, Gangnam Company needs mechanics for 1 hour and elictrician for 1,5 hours

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!