Question
Excel assignment In I4:I24, use the Man Hours provided along with the information on overheads in the Information sheet, to calculate the manufacturing overhead for
Excel assignment
In I4:I24, use the Man Hours provided along with the information on overheads in the Information sheet, to calculate the manufacturing overhead for each job.
I have the man hrs for each column in the excel and the information:
i have the budgeted MOH WHICH it is 71500 and budgeted direct labour hr which is 7500
also labour and material costs are given per job in the excel table
how to get the overhead cost and the total cost for each job
please help
for first column for example
job 1:
Man Hourly 200
labour cost 4,6940
material cost 17,4908
budgeted MOH WHICH it is 71500
budgeted direct labour hr which is 7500
find the overhead cost and total cost for each job 1
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started