Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mastering 21st Century Enterprise Risk Management

Authors: Gregory M Carroll

1st Edition

1483510441, 9781483510446

More Books

Students also viewed these Accounting questions