In$/$takeAssignment$/$takeAssignmentMain$.$do$?$invoker$=$&takeAssignmentSessionLocator$=$assignment$-$take&inprogres...

D

Relaunch to upda

eBook

Ofifice $365$

Idris Inc. manufactures entry and dining room lighting fixtures. Five activities are used in manufacturing the fixtures. These activities and their associated budgeted activity costs and activity bases are as follows:

Budgeted

$\backslash$table$[[$Activity$,$Activity Cost,Activity Base$],[$Casting$,$$$317,130,$Machine hours$],[$Assembly$,219,200,$Direct labor hours$],[$Inspecting$,39,780,$Number of inspections$],[$Setup$,44,640,$Number of setups$],[$Materials handling,$54,000,$Number of loads$]]$

Corporate records were obtained to estimate the amount of activity to be used by the two products. The estimated activity$-$base usage quantities and units produced follow:

$\backslash$table$[[$Activity Base,Entry,Dining,Total$],[$Machine hours,$5,090,4,520,9,610],[$Direct labor hours,$4,380,6,580,10,960],[$Number of inspections,$1,780,560,2,340],[$Number of setups,$250,60,310],[$Number of loads,$850,230,1,080],[$Units produced,$10,200,5,100,15,300]]$

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.

Next

Submit Assignment for Grading

A

B

C

$4$

$5$ DATA

$6$ Actlvity

$7$ Casting

$8$ Assembly

$9$ Inspecting

$10$ Setup

$11$ Materials handling

$\backslash$table$[[$Budgeted Activity Cost$],[$$$317,130$