17. Bahama Co. budgets factory overhead (FO) cost split into four activities: fabrication, painting, assembly, and inspecting. Bahama plans to manufacture four products in the following quantities: A: 500 units; B: 900 units; C: 750; and C: 650 units.

Determine the Budgeted Factory Overhead cost (Activity Cost Pool) for each of the four factory activities (make up your own numbers; use the format below):

Activity Cost Pool

Activity Factory Overhead Cost Activity Base

Fabrication $?????? Direct Labor (DL) hours

Painting $?????? Machine (mach.) Hours

Assembly $?????? Number of Parts

Inspecting $?????? Number of Inspections

Total $???????

Determine activity-base usage (product specifications) for each of the four products (make up your own numbers; use the format below):

Activity A B C D

Fabrication ???? DL hrs. ???? DL hrs. ???? DL hrs. ???? DL hrs.

Painting ??? mach. hrs. ??? mach. hrs. ??? mach. hrs. ??? mach. hrs.

Assembly ??? parts ??? parts ??? parts ??? parts

Inspecting ?? insp. ?? insp. ?? insp. ?? insp.

Instructions:

a) Determine your Budgeted Factory Overhead (FO) cost and Activity-base usage data in the format above (make up your own numbers).

b) Calculate the Activity FO rates for each activity.

c) Total Factory Overhead cost applied to A using Activity-Based Costing (ABC) is:

d) Total Factory Overhead cost applied to B using Activity-Based Costing (ABC) is:

e) Total Factory Overhead cost applied to C using Activity-Based Costing (ABC) is:

f) Total Factory Overhead cost applied to D using Activity-Based Costing (ABC) is:

[PLEASE SHOW ALL THE CALULATIONS]