Question: Duo Co. has the following processing standards for its clerical employees: Number of hours per 1,000 papers processed ........ 150 Normal number of papers processed

Duo Co. has the following processing standards for its clerical employees:

Number of hours per 1,000 papers processed ........ 150

Normal number of papers processed per year........ 1,500,000

Wage rate per 1,000 papers ............... $1,200

Total standard variable cost (including labor)

of processing 1,500,000 papers .............$2,700,000

Fixed costs per year ................... $ 150,000

The following information pertains to the 1,200,000 papers processed during the year:

Total cost ........$1,995,000

Labor cost .......$1,710,000

Labor hours ........ 190,000


Required

Prepare an Excel spreadsheet that can be used to compute for Duo Co. the following:

1. Expected total cost for the year to process 1,200,000 papers, assuming standard performance.

2. Labor rate variance for the year.

3. Labor efficiency variance for the year.

Step by Step Solution

3.46 Rating (178 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

1 Master budget Total variable cost 2700000 Total number of papers to be processed 1500000 Total sta... View full answer

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

Document Format (1 attachment)

Excel file Icon

249-B-M-L-O-M (1093).xlsx

300 KBs Excel File

Students Have Also Explored These Related Management Leadership Questions!