Accounting

PROBLEM 1

– Compute a predetermined overhead rate.

– Prepare schedules of cost of goods manufactured and cost of goods sold.

– Compute underapplied or overapplied overhead cost to close the balance in Manufacturing Overhead to the appropriate accounts.

PLEASE ANSWER HOW TO GET EACH HIGHLIGHTED YELLOW CELL. I HAVE TO ANSWER USING THE FORMULA SO CAN YOU PLEASE SHOW YOUR WORK USING EXCEL SPREADSHEET.

THANK YOU!!

PROBLEM 2

– Compute the equivalent units of production using the weighted-average method.

– Compute the cost per equivalent unit using the weighted-average method.

– Assign costs to units using the weighted-average method.

– Prepare a cost reconciliation report.

PLEASE ANSWER HOW TO GET EACH HIGHLIGHTED YELLOW CELL. I HAVE TO ANSWER USING THE FORMULA SO CAN YOU PLEASE SHOW YOUR WORK USING EXCEL SPREADSHEET.

THANK YOU!