Question: Please answer these 2 questions into Excel and also the way of the formula so that I can understand it and give beautiful comment if

Please answer these 2 questions into Excel and also the way of the formula so that I can understand it and give beautiful comment if the answer and the way make me understand. Thanks
Gangnam Company is a car repair shop. Gangnam Company's manager is considering to determine the selling price for repair services for the coming fiscal year. The company has 2 departments: Workshop and Spareparts Shop. The company employs 6 mechanics and 4 electricians in the Workshop Department 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: - (10 x 300 days x 7 hours) @ Rp 1.500/hours Rp31.500.000 o Health Benefits: . 10 person x 12 months x Rp50.000,- Rp 6.000.000 o Welfare Benefits: . 10 person x 12 months x Rp25.000,- Rp 3.000.000 Indirect Expense in workshop department: Rp11.600.000 o Wages Expense 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 if 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
Get step-by-step solutions from verified subject matter experts
